xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 16.85MB
    文件類型: .rar
    金幣: 1
    下載: 0 次
    發(fā)布日期: 2023-07-04
  • 語言: 其他
  • 標簽: net??

資源簡介

1、渠道銷售商在把藥品從廠商銷售到醫(yī)院時,需要管理大量的數(shù)據(jù),這些通常包括藥品從廠商采購數(shù)據(jù)、藥品銷售到商業(yè)公司的數(shù)據(jù),以及最后實際在醫(yī)院發(fā)生業(yè)務(wù)的數(shù)據(jù),這些數(shù)據(jù)非常繁雜,尤其對于業(yè)務(wù)量比較大的渠道銷售商來說,采用人工管理經(jīng)常會導致數(shù)據(jù)的不及時性、不正確性以及統(tǒng)計過程繁瑣性。通過有效地數(shù)據(jù)庫管理系統(tǒng)方便快捷地解決這些問題已經(jīng)顯得非常迫切。 2、通常,渠道銷售商銷售藥品的流程如圖1所示。數(shù)據(jù)庫管理系統(tǒng)將實現(xiàn)整個業(yè)務(wù)流程的數(shù)字化,通過強大的計算機管理系統(tǒng)來解決人工管理時所出現(xiàn)的問題。

資源截圖

代碼片段和文件信息

using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;
namespace?BLL
{
????public?class?Business
????{
????????public?string?ErrorMessage?=?““;//錯誤信息
????????//添加
????????public?int?Add(
????????out?int?ID
?????????int?DrugsID
?????????int?HospitalsID
?????????int?BoxNumber
?????????double?OutPrice
?????????string?OutTime
?????????int?SubShopsID
?????????string?Maker
?????????string?ExpireDate
?????????string?Remarks
????????)
????????{
????????????int?flag?=?0;
????????????try
????????????{
????????????????DAL.ExecuteProcedure?exec?=?new?DAL.ExecuteProcedure();
????????????????SqlParameter[]?parameters?=?{
new?SqlParameter(“@ID“?SqlDbType.Int32)
new?SqlParameter(“@DrugsID“?DrugsID)
new?SqlParameter(“@HospitalsID“?HospitalsID)
new?SqlParameter(“@BoxNumber“?BoxNumber)
new?SqlParameter(“@OutPrice“?OutPrice)
new?SqlParameter(“@OutTime“?OutTime.Trim())
new?SqlParameter(“@SubShopsID“?SubShopsID)
new?SqlParameter(“@Maker“?Maker.Trim())
new?SqlParameter(“@ExpireDate“?ExpireDate.Trim())
new?SqlParameter(“@Remarks“?Remarks.Trim())
?new?SqlParameter(“@Flag“SqlDbType.Int32)
};
????????????????parameters[0].Direction?=?ParameterDirection.Output;
????????????????parameters[10].Direction?=?ParameterDirection.ReturnValue;
????????????????flag?=?exec.run(“Pr_Business_Add“?parameters);
????????????????if?(flag?==?1)
????????????????{
????????????????????if?(Convert.ToInt32(parameters[10].Value)?==?10)
????????????????????{
????????????????????????ID?=?Convert.ToInt32(parameters[0].Value);
????????????????????}
????????????????????else
????????????????????{
????????????????????????ID?=?0;
????????????????????????flag?=?0;
????????????????????????this.ErrorMessage?=?“添加失敗,已存在同樣的數(shù)據(jù)!“;
????????????????????}
????????????????}
????????????????else
????????????????{
????????????????????ID?=?0;
????????????????????this.ErrorMessage?=?exec.ErrorMessage;
????????????????}
????????????}
????????????catch?(Exception?e)
????????????{
????????????????ID?=?0;
????????????????this.ErrorMessage?=?e.Message.ToString();
????????????}
????????????return?flag;
????????}
????????//更新
????????public?int?Update(
????????int?ID
?????????int?DrugsID
?????????int?HospitalsID
?????????int?BoxNumber
?????????double?OutPrice
?????????string?OutTime
?????????int?SubShopsID
?????????string?Maker
?????????string?ExpireDate
?????????string?Remarks
????????)
????????{
????????????int?flag?=?0;
????????????try
????????????{
????????????????DAL.ExecuteProcedure?exec?=?new?DAL.ExecuteProcedure();
????????????????SqlParameter[]?parameters?=?{
new?SqlParameter(“@ID“?ID)
new?SqlParameter(“@DrugsID“?DrugsID)
new?SqlParameter(“@HospitalsID“?HospitalsID)
new?SqlParameter(“@BoxNumber“?BoxNumber)
new?SqlParameter(“@OutPrice“?OutPrice)
new?SqlParameter(“@Ou

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????111616??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\BLL.dll

?????文件?????351744??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\BLL.pdb

?????文件?????110592??2012-05-30?17:11??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\CarlosAg.ExcelxmlWriter.dll

?????文件???????8192??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\DAL.dll

?????文件??????30208??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\DAL.pdb

?????文件??????72192??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\Tools.dll

?????文件?????204288??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\bin\Debug\Tools.pdb

?????文件???????4440??2014-08-21?22:15??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\BLL.csproj

?????文件??????14590??2014-09-16?21:12??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Business.cs

?????文件??????14257??2014-11-15?09:55??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\BusinessDelevery.cs

?????文件???????7039??2014-08-20?21:38??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\BusinessStaffs.cs

?????文件???????1307??2013-07-30?00:28??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\ConvertData.cs

?????文件????????868??2013-09-21?10:23??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\DatabaseOperation.cs

?????文件??????12011??2014-03-27?23:50??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Departments.cs

?????文件??????14895??2014-11-15?09:53??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Drugs.cs

?????文件???????8399??2013-09-26?23:12??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Folders.cs

?????文件???????5874??2014-05-09?18:31??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Functions.cs

?????文件???????8381??2014-07-15?19:31??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Hospitals.cs

?????文件???????8960??2014-08-05?14:38??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\InStoreCollections.cs

?????文件???????8622??2014-08-05?14:36??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\InStoreInvoice.cs

?????文件??????11072??2014-08-05?14:41??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\InStoreLists.cs

?????文件??????16880??2014-09-16?21:18??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\InStores.cs

?????文件????????383??2013-07-07?16:30??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Interface_BLL.cs

?????文件???????2177??2013-08-02?00:10??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\LogDB.cs

?????文件???????2649??2013-09-26?23:14??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\MailAttachments.cs

?????文件??????19018??2013-08-26?00:24??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Mails.cs

?????文件??????13661??2014-03-24?21:30??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\Modules.cs

?????文件???????1688??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件??????27331??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\obj\Debug\BLL.csprojResolveAssemblyReference.cache

?????文件?????111616??2015-08-12?10:42??醫(yī)藥ERP管理系統(tǒng)源碼(NET)\BLL\obj\Debug\BLL.dll

............此處省略1623個文件信息

評論

共有 條評論