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??2015-09-21?11:15??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\
?????目錄???????????0??2015-09-21?10:45??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\
?????文件????????4440??2014-08-21?22:15??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\BLL.csproj
?????文件???????14590??2014-09-16?21:12??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Business.cs
?????文件???????14257??2014-11-15?09:55??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\BusinessDelevery.cs
?????文件????????7039??2014-08-20?21:38??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\BusinessStaffs.cs
?????文件????????1307??2013-07-30?00:28??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\ConvertData.cs
?????文件?????????868??2013-09-21?10:23??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\DatabaseOperation.cs
?????文件???????12011??2014-03-27?23:50??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Departments.cs
?????文件???????14895??2014-11-15?09:53??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Drugs.cs
?????文件????????8399??2013-09-26?23:12??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Folders.cs
?????文件????????5874??2014-05-09?18:31??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Functions.cs
?????文件????????8381??2014-07-15?19:31??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Hospitals.cs
?????文件????????8960??2014-08-05?14:38??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\InStoreCollections.cs
?????文件????????8622??2014-08-05?14:36??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\InStoreInvoice.cs
?????文件???????11072??2014-08-05?14:41??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\InStoreLists.cs
?????文件???????16880??2014-09-16?21:18??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\InStores.cs
?????文件?????????383??2013-07-07?16:30??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Interface_BLL.cs
?????文件????????2177??2013-08-02?00:10??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\LogDB.cs
?????文件????????2649??2013-09-26?23:14??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\MailAttachments.cs
?????文件???????19018??2013-08-26?00:24??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Mails.cs
?????文件???????13661??2014-03-24?21:30??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Modules.cs
?????文件????????9664??2014-05-28?17:23??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OrderLists.cs
?????文件????????9786??2014-07-20?23:06??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OrderListsMidShops.cs
?????文件???????16781??2014-09-16?21:05??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\Orders.cs
?????文件???????16837??2014-09-16?21:03??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OrdersMidShops.cs
?????文件???????15916??2014-09-16?21:00??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OutStore.cs
?????文件????????8968??2014-07-29?11:05??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OutStoreCollections.cs
?????文件????????8628??2014-07-25?14:56??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OutStoreInvoice.cs
?????文件???????11200??2014-07-31?14:42??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\OutStoreLists.cs
?????文件???????14697??2014-01-18?00:27??DX0055-ASP.NET醫(yī)藥ERP管理系統(tǒng)源碼\BLL\PageView.cs
............此處省略1622個(gè)文件信息