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?=?““;//錯(cuò)誤信息
????????//添加
????????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

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-29?19:48??醫(yī)藥ERP\
?????目錄???????????0??2018-03-29?19:48??醫(yī)藥ERP\BLL\
?????目錄???????????0??2018-03-29?19:48??醫(yī)藥ERP\BLL\bin\
?????目錄???????????0??2018-03-29?19:48??醫(yī)藥ERP\BLL\bin\Debug\
?????文件??????111616??2017-12-20?21:33??醫(yī)藥ERP\BLL\bin\Debug\BLL.dll
?????文件??????429568??2017-12-20?21:33??醫(yī)藥ERP\BLL\bin\Debug\BLL.pdb
?????文件??????110592??2012-05-30?17:11??醫(yī)藥ERP\BLL\bin\Debug\CarlosAg.ExcelxmlWriter.dll
?????文件????????8192??2017-12-20?21:33??醫(yī)藥ERP\BLL\bin\Debug\DAL.dll
?????文件???????40448??2017-12-20?21:33??醫(yī)藥ERP\BLL\bin\Debug\DAL.pdb
?????文件???????72192??2017-12-20?21:33??醫(yī)藥ERP\BLL\bin\Debug\Tools.dll
?????文件??????247296??2017-12-20?21:33??醫(yī)藥ERP\BLL\bin\Debug\Tools.pdb
?????文件????????4440??2014-08-21?22:15??醫(yī)藥ERP\BLL\BLL.csproj
?????文件???????14590??2014-09-16?21:12??醫(yī)藥ERP\BLL\Business.cs
?????文件???????14257??2014-11-15?09:55??醫(yī)藥ERP\BLL\BusinessDelevery.cs
?????文件????????7039??2014-08-20?21:38??醫(yī)藥ERP\BLL\BusinessStaffs.cs
?????文件????????1307??2013-07-30?00:28??醫(yī)藥ERP\BLL\ConvertData.cs
?????文件?????????868??2013-09-21?10:23??醫(yī)藥ERP\BLL\DatabaseOperation.cs
?????文件???????12011??2014-03-27?23:50??醫(yī)藥ERP\BLL\Departments.cs
?????文件???????14895??2014-11-15?09:53??醫(yī)藥ERP\BLL\Drugs.cs
?????文件????????8399??2013-09-26?23:12??醫(yī)藥ERP\BLL\Folders.cs
?????文件????????5874??2014-05-09?18:31??醫(yī)藥ERP\BLL\Functions.cs
?????文件????????8381??2014-07-15?19:31??醫(yī)藥ERP\BLL\Hospitals.cs
?????文件????????8960??2014-08-05?14:38??醫(yī)藥ERP\BLL\InStoreCollections.cs
?????文件????????8622??2014-08-05?14:36??醫(yī)藥ERP\BLL\InStoreInvoice.cs
?????文件???????11072??2014-08-05?14:41??醫(yī)藥ERP\BLL\InStoreLists.cs
?????文件???????16880??2014-09-16?21:18??醫(yī)藥ERP\BLL\InStores.cs
?????文件?????????383??2013-07-07?16:30??醫(yī)藥ERP\BLL\Interface_BLL.cs
?????文件????????2177??2013-08-02?00:10??醫(yī)藥ERP\BLL\LogDB.cs
?????文件????????2649??2013-09-26?23:14??醫(yī)藥ERP\BLL\MailAttachments.cs
?????文件???????19018??2013-08-26?00:24??醫(yī)藥ERP\BLL\Mails.cs
?????文件???????13661??2014-03-24?21:30??醫(yī)藥ERP\BLL\Modules.cs
............此處省略1625個(gè)文件信息