前文《EFW框架Winform前端开发之强大的自定义控件库》中我们介绍了EFW框架中Winform系统中的自定义控件，本章使用自定义控件中的GridBoxCard控件开发了一个HIS系统的处方录入控件。做过HIS系统的都知道医生站系统是整个医院系统中比较复杂的模块，而处方录入又是医生站系统中最复杂的功能；处方控件就是把医生的纸质处方转换为电子处方，处方有关的数据源包括药品、项目、材料、用法、频次、嘱托等；处方控件功能包括新开、修改、换方、合租、删除等，还有其他功能看下图；
1.界面效果
2.如何使用处方录入控件
在代码中使用处方控件分为三步，首先建表，因为控件的使用依赖一些数据源，当然如果你的系统中已经有一套控件需要的表，那么建表这步可以省略；接着将控件拖入form界面上并设置相关属性；然后实现控件的接口IPrescripttionDbHelper；
1）控件依赖的表有如下，表的结构可以看实例中的脚本
2）界面上拖入处方控件并设置属性
3）TestPrescripttionDbHelper对象继承接口IPrescripttionDbHelper，并实现接口方法
TestPrescripttionDbHelper presHelper = new TestPrescripttionDbHelper();
prescriptionControl1.InitDbHelper(presHelper);
prescriptionControl1.LoadPatData(1, 101, "儿科", 201, "李医生");
public class TestPrescripttionDbHelper : IPrescripttionDbHelper
{
private AbstractDatabase oleDb;
public TestPrescripttionDbHelper()
{
oleDb = FactoryDatabase.GetDatabase();
}
#region IPrescripttionDbHelper 成员
private List<CardDataSourceDrugItem> GetDrugItemToDatabase(int type, int pageNo, int pageSize, string filter)
{
PageInfo page = new PageInfo(pageSize, pageNo);
page.KeyName = "StockID";
string strsql = "";
strsql = @"SELECT * FROM ViewBaseData_Med T WHERE (PyCode LIKE '%{0}%' OR PyCodeT LIKE '%{0}%' OR WbCode LIKE '%{0}%' OR WbCodeT LIKE '%{0}%' OR CName LIKE '%{0}%' OR TName LIKE '%{0}%')";
strsql = string.Format(strsql, filter);
strsql = SqlPage.FormatSql(strsql, page, oleDb);
DataTable dt = oleDb.GetDataTable(strsql);
List<CardDataSourceDrugItem> list_DrugItem = new List<CardDataSourceDrugItem>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceDrugItem mDrugItem = new CardDataSourceDrugItem();
mDrugItem.ItemId = ConvertDataExtend.ToInt32(dt.Rows[i]["StockID"], 0);
mDrugItem.ItemName = dt.Rows[i]["CName"].ToString();
mDrugItem.ItemName_Print = dt.Rows[i]["TName"].ToString();
mDrugItem.Standard = dt.Rows[i]["Spec"].ToString();
mDrugItem.Scale = "";//补偿比例
mDrugItem.StoreNum = ConvertDataExtend.ToDecimal(dt.Rows[i]["ActualQty"], 0);//库存量
mDrugItem.UnPickUnit = dt.Rows[i]["MiniUnit"].ToString();//包装单位(销售单位)
mDrugItem.SellPrice = ConvertDataExtend.ToDecimal(dt.Rows[i]["ClinPrice"], 0);//销售价格?
mDrugItem.BuyPrice = ConvertDataExtend.ToDecimal(dt.Rows[i]["WardPrice"], 0);//进价
//mDrugItem.ExecDeptName = dt.Rows[i][""].ToString();//执行科室?
mDrugItem.Pym = dt.Rows[i]["PyCode"].ToString();
mDrugItem.Wbm = dt.Rows[i]["WbCode"].ToString();
mDrugItem.Address = dt.Rows[i]["FacName"].ToString();//生产厂家
//mDrugItem.DoseUnitId = dt.Rows[i][""].ToString();//剂量单位
mDrugItem.DoseUnitName = dt.Rows[i]["DosUnit"].ToString();
mDrugItem.DoseConvertNum = ConvertDataExtend.ToDecimal(dt.Rows[i]["Dosage"], 0);//剂量对应包装单位系数
mDrugItem.ItemType = ConvertDataExtend.ToInt32(dt.Rows[i]["MatClass"], 0);//项目类型 0-所有 1-西药 2-中药 3-处方可开的物品 4-收费项目
//mDrugItem.StatItemCode = dt.Rows[i][""].ToString();//大项目代码
//mDrugItem.UnPickUnitId = dt.Rows[i][""].ToString();//包装单位ID
mDrugItem.ExecDeptId = ConvertDataExtend.ToInt32(dt.Rows[i]["DeptID"], 0);//执行科室ID?
mDrugItem.FloatFlag = ConvertDataExtend.ToInt32(dt.Rows[i]["RoundingMode"], 0);// dt.Rows[i][""].ToString();//按含量取整1 按剂量取整0
//mDrugItem.VirulentFlag = dt.Rows[i][""].ToString();//剧毒标识
//mDrugItem.NarcoticFlag = dt.Rows[i][""].ToString();//麻醉标识
mDrugItem.SkinTestFlag = ConvertDataExtend.ToInt32(dt.Rows[i]["SkinMethod"], 0);//皮试标识
//mDrugItem.RecipeFlag = dt.Rows[i][""].ToString();//处方标识
//mDrugItem.LunacyFlag = dt.Rows[i][""].ToString();//精神药品标识
//mDrugItem.CostlyFlag = dt.Rows[i][""].ToString();//贵重药品标识
mDrugItem.default_Usage_Amount = 0;//默认用量
mDrugItem.default_Usage_Id = 0;//默认用法
mDrugItem.default_Usage_Name = "";
mDrugItem.default_Frequency_Id = 0;//默认频次
mDrugItem.default_Frequency_Name = "";
list_DrugItem.Add(mDrugItem);
}
return list_DrugItem;
}
public List<CardDataSourceDrugItem> GetDrugItem(int type, int pageNo, int pageSize, string filter)
{
return GetDrugItemToDatabase(type, pageNo, pageSize, filter);
}
public CardDataSourceDrugItem GetDrugItem(int ItemId)
{
string strsql = @"SELECT TOP 1* FROM ViewBaseData_Med T
WHERE StockID={0}";
strsql = string.Format(strsql, ItemId);
DataTable dt = oleDb.GetDataTable(strsql);
List<CardDataSourceDrugItem> list_DrugItem = new List<CardDataSourceDrugItem>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceDrugItem mDrugItem = new CardDataSourceDrugItem();
mDrugItem.ItemId = ConvertDataExtend.ToInt32(dt.Rows[i]["StockID"], 0);
mDrugItem.ItemName = dt.Rows[i]["CName"].ToString();
mDrugItem.ItemName_Print = dt.Rows[i]["TName"].ToString();
mDrugItem.Standard = dt.Rows[i]["Spec"].ToString();
mDrugItem.Scale = "";//补偿比例
mDrugItem.StoreNum = ConvertDataExtend.ToDecimal(dt.Rows[i]["ActualQty"], 0);//库存量
mDrugItem.UnPickUnit = dt.Rows[i]["MiniUnit"].ToString();//包装单位(销售单位)
mDrugItem.SellPrice = ConvertDataExtend.ToDecimal(dt.Rows[i]["ClinPrice"], 0);//销售价格?
mDrugItem.BuyPrice = ConvertDataExtend.ToDecimal(dt.Rows[i]["WardPrice"], 0);//进价
//mDrugItem.ExecDeptName = dt.Rows[i][""].ToString();//执行科室?
mDrugItem.Pym = dt.Rows[i]["PyCode"].ToString();
mDrugItem.Wbm = dt.Rows[i]["WbCode"].ToString();
mDrugItem.Address = dt.Rows[i]["FacName"].ToString();//生产厂家
//mDrugItem.DoseUnitId = dt.Rows[i][""].ToString();//剂量单位
mDrugItem.DoseUnitName = dt.Rows[i]["DosUnit"].ToString();
mDrugItem.DoseConvertNum = ConvertDataExtend.ToDecimal(dt.Rows[i]["Dosage"], 0);//剂量对应包装单位系数
mDrugItem.ItemType = ConvertDataExtend.ToInt32(dt.Rows[i]["MatClass"], 0);//项目类型 0-所有 1-西药 2-中药 3-处方可开的物品 4-收费项目
//mDrugItem.StatItemCode = dt.Rows[i][""].ToString();//大项目代码
//mDrugItem.UnPickUnitId = dt.Rows[i][""].ToString();//包装单位ID
mDrugItem.ExecDeptId = ConvertDataExtend.ToInt32(dt.Rows[i]["DeptID"], 0);//执行科室ID?
mDrugItem.FloatFlag = ConvertDataExtend.ToInt32(dt.Rows[i]["RoundingMode"], 0);// dt.Rows[i][""].ToString();//按含量取整1 按剂量取整0
//mDrugItem.VirulentFlag = dt.Rows[i][""].ToString();//剧毒标识
//mDrugItem.NarcoticFlag = dt.Rows[i][""].ToString();//麻醉标识
mDrugItem.SkinTestFlag = ConvertDataExtend.ToInt32(dt.Rows[i]["SkinMethod"], 0);//皮试标识
//mDrugItem.RecipeFlag = dt.Rows[i][""].ToString();//处方标识
//mDrugItem.LunacyFlag = dt.Rows[i][""].ToString();//精神药品标识
//mDrugItem.CostlyFlag = dt.Rows[i][""].ToString();//贵重药品标识
mDrugItem.default_Usage_Amount = 0;//默认用量
mDrugItem.default_Usage_Id = 0;//默认用法
mDrugItem.default_Usage_Name = "";
mDrugItem.default_Frequency_Id = 0;//默认频次
mDrugItem.default_Frequency_Name = "";
list_DrugItem.Add(mDrugItem);
}
return list_DrugItem.Count > 0 ? list_DrugItem[0] : null;
}
public List<CardDataSourceUsage> GetUsage()
{
string strsql = @"SELECT ID,ChannelName,CName,EName,PYCode,WBCode,InputCode
FROM Clinic_Channel
WHERE DeleteFlag=0
ORDER BY OrderNum";
DataTable dt = oleDb.GetDataTable(strsql);
List<CardDataSourceUsage> list_Usage = new List<CardDataSourceUsage>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceUsage mUsage = new CardDataSourceUsage();
mUsage.UsageId = ConvertDataExtend.ToInt32(dt.Rows[i]["ID"], 0);
mUsage.UsageName = dt.Rows[i]["ChannelName"].ToString();
mUsage.Pym = dt.Rows[i]["PYCode"].ToString();
mUsage.Wbm = dt.Rows[i]["WBCode"].ToString();
//mUsage.Szm = dt.Rows[i]["ID"].ToString();
list_Usage.Add(mUsage);
}
return list_Usage;
}
public List<CardDataSourceFrequency> GetFrequency()
{
string strsql = @"SELECT ID,FrequencyName,CName,EName,NumCode,InputCode,ExecuteCode,DeleteFlag,PYCode,WBCode
FROM Clinic_Frequency
WHERE DeleteFlag = 0
ORDER BY OrderNum";
DataTable dt = oleDb.GetDataTable(strsql);
List<CardDataSourceFrequency> list_Frequency = new List<CardDataSourceFrequency>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceFrequency mFrequency = new CardDataSourceFrequency();
mFrequency.FrequencyId = Convert.ToInt32(dt.Rows[i]["ID"]);
mFrequency.Name = dt.Rows[i]["FrequencyName"].ToString();
mFrequency.Caption = dt.Rows[i]["ExecuteCode"].ToString();
int _execNum, _cycleDay;
CardDataSourceFrequency.Calculate(mFrequency.Caption, out _execNum, out _cycleDay);
mFrequency.ExecNum = _execNum;//执行次数
mFrequency.CycleDay = _cycleDay;//执行周期
mFrequency.Pym = dt.Rows[i]["InputCode"].ToString();
mFrequency.Wbm = dt.Rows[i]["InputCode"].ToString();
mFrequency.Szm = dt.Rows[i]["NumCode"].ToString();
list_Frequency.Add(mFrequency);
}
return list_Frequency;
}
public List<CardDataSourceEntrust> GetEntrust()
{
string strsql = @"SELECT ID, DeptCode,HelpCode, MsgContent,Uploader,WBCode,PYCode
FROM Clinic_Memo ";
DataTable dt = oleDb.GetDataTable(strsql);
List<CardDataSourceEntrust> list_entrust = new List<CardDataSourceEntrust>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceEntrust mentrust = new CardDataSourceEntrust();
mentrust.Id = Convert.ToInt32(dt.Rows[i]["ID"]);
mentrust.Name = dt.Rows[i]["MsgContent"].ToString();
mentrust.Pym = dt.Rows[i]["PYCode"].ToString();
mentrust.Wbm = dt.Rows[i]["WBCode"].ToString();
mentrust.Szm = "";
list_entrust.Add(mentrust);
}
return list_entrust;
}
public List<CardDataSourceUnit> GetUnit(int stockId, int type)
{
DataTable dt = oleDb.GetDataTable("xpGetDrugUnit", stockId, type);
List<CardDataSourceUnit> list_unit = new List<CardDataSourceUnit>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceUnit munit = new CardDataSourceUnit();
munit.UnitDicId = 0;
munit.UnitName = dt.Rows[i]["UnitName"].ToString();
munit.Pym = "";
munit.Wbm = "";
munit.Factor = Convert.ToDecimal(dt.Rows[i]["UnitFactor"]);
list_unit.Add(munit);
}
return list_unit;
}
public List<Prescription> GetPresTemplate(int type, int tplId)
{
string strsql = "";
strsql = @"SELECT TOP 100 A.GroupID,
A.FeeID,A.FeeName,A.FeeClass,
A.Dosage,A.DosageUnit,
A.Amount,A.Unit,
A.FrequencyID,C.FrequencyName AS FrequencyName,C.ExecuteCode,
A.ChannelID,B.CName AS ChannelName,
A.Days Num, A.Days,A.Memo
,D.ClinPrice,D.Spec,D.Dosage DoseConvertNum,D.MatClass,D.SkinMethod IsAst
FROM Clinic_SetMealDetail A
LEFT JOIN Clinic_Channel B ON A.ChannelID = B.ID
LEFT JOIN Clinic_Frequency C ON A.FrequencyID = C.ID
LEFT JOIN ViewBaseData_Med D ON A.FeeID=D.StockID
WHERE ListID = {0}
ORDER BY A.GroupID,A.OrderNum";
strsql = string.Format(strsql, tplId);
DataTable dt = oleDb.GetDataTable(strsql);
List<Prescription> list_Prescription = new List<Prescription>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Prescription mPres = new Prescription();
mPres.PresListId = 0;
mPres.PresHeadId = 0;
//mPres.OrderNo = i + 1;//行号
mPres.Item_Id = Convert.ToInt32(dt.Rows[i]["FeeID"]);
mPres.Item_Name = dt.Rows[i]["FeeName"].ToString();
mPres.Item_Type = type;//1西药 2中药 3项目材料
mPres.StatItem_Code = "";
mPres.Sell_Price = ConvertDataExtend.ToDecimal(dt.Rows[i]["ClinPrice"], 0);
mPres.Buy_Price = ConvertDataExtend.ToDecimal(dt.Rows[i]["ClinPrice"], 0);
mPres.Item_Price = ConvertDataExtend.ToDecimal(dt.Rows[i]["ClinPrice"], 0);
mPres.Standard = dt.Rows[i]["Spec"].ToString();
mPres.Usage_Amount = Convert.ToDecimal(dt.Rows[i]["Dosage"]);//剂量
mPres.Usage_Unit = dt.Rows[i]["DosageUnit"].ToString();//剂量单位
mPres.Usage_Rate = ConvertDataExtend.ToDecimal(dt.Rows[i]["DoseConvertNum"], 1);//剂量系数
mPres.Dosage = Convert.ToInt32(dt.Rows[i]["Num"]);//付数
mPres.Usage_Id = Convert.ToInt32(dt.Rows[i]["ChannelID"]);
mPres.Frequency_Id = Convert.ToInt32(dt.Rows[i]["FrequencyID"]);
mPres.Days = Convert.ToInt32(dt.Rows[i]["Days"]);
mPres.Amount = Convert.ToDecimal(dt.Rows[i]["Amount"].ToString());//发药数量
mPres.Unit = dt.Rows[i]["Unit"].ToString();//发药单位
mPres.Item_Amount = Convert.ToInt32(Convert.ToDecimal(dt.Rows[i]["Amount"]));//开药数量
mPres.Item_Unit = dt.Rows[i]["Unit"].ToString();//开药单位
mPres.Item_Rate = 1;//系数
mPres.Group_Id = Convert.ToInt32(dt.Rows[i]["GroupID"]);//分组组号
mPres.SkinTest_Flag = ConvertDataExtend.ToInt32(dt.Rows[i]["IsAst"], 0);//皮试
mPres.SelfDrug_Flag = 0;//自备
mPres.Entrust = dt.Rows[i]["Memo"].ToString();//嘱托
mPres.FootNote = "";
mPres.Tc_Flag = 0;//套餐
mPres.Usage_Name = dt.Rows[i]["ChannelName"].ToString();//用法名称
mPres.Frequency_Name = dt.Rows[i]["FrequencyName"].ToString();//频次名称
mPres.Frequency_Caption = dt.Rows[i]["ExecuteCode"].ToString();//频次名称
int _execNum, _cycleDay;
CardDataSourceFrequency.Calculate(dt.Rows[i]["ExecuteCode"].ToString(), out _execNum, out _cycleDay);
mPres.Frequency_ExecNum = _execNum;//执行次数
mPres.Frequency_CycleDay = _cycleDay;//执行周期
mPres.CalculateAmount(null);
list_Prescription.Add(mPres);
}
return list_Prescription;
//throw new NotImplementedException();
}
public Prescription GetPresTemplateRow(int type, int itemId)
{
CardDataSourceDrugItem durgItem = GetDrugItem(itemId);
if (durgItem == null)
throw new Exception("该项目已停用，不能开出！");
Prescription mPres = new Prescription();
mPres.Item_Id = ConvertDataExtend.ToInt32(durgItem.ItemId, -1);
mPres.Item_Name = ConvertDataExtend.ToString(durgItem.ItemName, "");
mPres.Item_Type = type;//Convert.ToInt32(durgItem.ItemType);//1西药 2中药 3项目材料
mPres.StatItem_Code = ConvertDataExtend.ToString(durgItem.StatItemCode, ""); ;
mPres.Sell_Price = durgItem.SellPrice;
mPres.Buy_Price = durgItem.BuyPrice;
mPres.Item_Price = durgItem.SellPrice;
mPres.Standard = durgItem.Standard;
mPres.Usage_Amount = durgItem.default_Usage_Id;//剂量
mPres.Usage_Unit = durgItem.DoseUnitName;//剂量单位
mPres.Usage_Rate = durgItem.DoseConvertNum;//剂量系数
if (mPres.IsHerb)
mPres.Dosage = 1;//付数
else
mPres.Dosage = 0;
mPres.Usage_Id = durgItem.default_Usage_Id;
mPres.Frequency_Id = durgItem.default_Frequency_Id;
mPres.Days = Convert.ToInt32(1);
//mPres.Amount = 0;//发药数量
mPres.Unit = durgItem.UnPickUnit;//发药单位
mPres.Item_Amount = Convert.ToInt32(1);//开药数量
mPres.Item_Unit = durgItem.UnPickUnit;//开药单位
mPres.Item_Rate = Convert.ToInt32(1);//系数
mPres.SkinTest_Flag = durgItem.SkinTestFlag;//皮试
mPres.SelfDrug_Flag = Convert.ToInt32(0);//自备
mPres.Entrust = "";//嘱托
mPres.FootNote = "";
mPres.Tc_Flag = 0;//套餐
mPres.Pres_Date = Convert.ToDateTime(DateTime.Now);
mPres.Usage_Name = durgItem.default_Usage_Name;//用法名称
mPres.Frequency_Name = durgItem.default_Frequency_Name;//频次名称
string _caption = "";
CardDataSourceFrequency freq = GetFrequency().Find(x => x.FrequencyId == mPres.Usage_Id);
if (freq != null)
_caption = freq.Caption;
//string _caption = CardDataSource.Tables["frequencydic"].Select("FrequencyId=" + mPres.Usage_Id)[0]["Caption"].ToString();
mPres.Frequency_Caption = _caption;//频次名称
int _execNum, _cycleDay;
CardDataSourceFrequency.Calculate(_caption, out _execNum, out _cycleDay);
mPres.Frequency_ExecNum = _execNum;//执行次数
mPres.Frequency_CycleDay = _cycleDay;//执行周期
mPres.IsFloat = true;//row["RoundingMode"]
mPres.Usage_Amount = mPres.Usage_Amount <= 0 ? 1 : mPres.Usage_Amount;
mPres.CalculateAmount(durgItem.UnPickUnit);//计算数量 和 金额
return mPres;
//throw new NotImplementedException();
}
public bool IsCostPres(List<Prescription> list)
{
if (list.Count == 0)
return false;
string strsql = @"select count(*) num from Clinic_PrescriptionDetail where ID IN({0}) AND IsCharged=1";
string Ids = null;
for (int i = 0; i < list.Count; i++)
{
if (Ids == null)
Ids = list[i].PresListId.ToString();
else
Ids += "," + list[i].PresListId.ToString();
}
strsql = string.Format(strsql, Ids);
object ret = oleDb.GetDataResult(strsql);
if (Convert.ToInt32(ret) > 0)
{
return true;
}
return false;
}
public bool IsDrugStore(Prescription pres)
{
if (pres.Item_Id > 0 && pres.IsDrug == true)
{
string strsql = @"SELECT top 1 ActualQty FROM ViewBaseData_Med WHERE StockID ={0}";
strsql = string.Format(strsql, pres.Item_Id);
object ret = oleDb.GetDataResult(strsql);
decimal qty = ret == DBNull.Value ? 0 : Convert.ToDecimal(ret);
if (pres.Amount > qty)
return false;
}
return true;
}
public bool IsDrugStore(List<Prescription> list, List<Prescription> errlist)
{
list = list.FindAll(x => x.IsDrug == true);
if (list.Count == 0)
{
return true;
}
string strsql = @"SELECT StockID,ActualQty FROM ViewBaseData_Med WHERE StockID IN ({0}) ";
string Ids = null;
for (int i = 0; i < list.Count; i++)
{
if (Ids == null)
Ids = list[i].Item_Id.ToString();
else
Ids += "," + list[i].Item_Id.ToString();
}
strsql = string.Format(strsql, Ids);
DataTable dt = oleDb.GetDataTable(strsql);
//errlist = new List<Entity.Prescription>();
for (int i = 0; i < list.Count; i++)
{
DataRow[] drs = dt.Select("StockID=" + list[i].Item_Id);
if (drs.Length == 0 || ConvertDataExtend.ToDecimal(drs[0]["ActualQty"], 0) < list[i].Amount)
{
errlist.Add(list[i]);
}
}
if (errlist.Count > 0)
return false;
return true;
}
public List<Prescription> GetPrescriptionData(int patListId, int presType)
{
string strsql = @"SELECT
b.ID ListID,b.PrescriptionID,b.FeeID,b.FeeName,b.Price,b.Spec,b.Dosage,b.DosageUnit,b.Factor,b.Num,b.ChannelID,b.FrequencyID,b.Days,b.Amount,b.Unit,b.PresAmount,b.PresAmountUnit,b.PresFactor ,b.GroupID,b.IsAst,b.IsTake,b.Memo
,b.ListNO,0 OrderNO,b.IsCharged,b.IsCancel
,c.ChannelName,d.FrequencyName,d.ExecuteCode
,1 RoundingMode
,b.DoctorID,b.DeptCode,'' PresDoctorName,'' PresDeptName
FROM Clinic_PrescriptionList a
LEFT JOIN Clinic_PrescriptionDetail b ON a.ID=b.PrescriptionID
LEFT JOIN Clinic_Channel AS c ON b.ChannelID = c.ID
LEFT JOIN Clinic_Frequency AS d ON b.FrequencyID = d.ID
WHERE a.PatientID={0} AND a.OrderClass={1} AND b.ID IS NOT NULL
ORDER BY b.ListNO,b.GroupID";
strsql = string.Format(strsql, patListId, presType);
DataTable dt = oleDb.GetDataTable(strsql);
//int _orderNo = 1;//行号
List<Prescription> list_Prescription = new List<Prescription>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Prescription mPres = new Prescription();
mPres.PresListId = Convert.ToInt32(dt.Rows[i]["ListID"]);
mPres.PresHeadId = Convert.ToInt32(dt.Rows[i]["PrescriptionID"]);
//mPres.OrderNo = i + 1;//行号
mPres.Item_Id = Convert.ToInt32(dt.Rows[i]["FeeID"]);
mPres.Item_Name = dt.Rows[i]["FeeName"].ToString();
mPres.Item_Type = 1;// Convert.ToInt32(dt.Rows[i]["ItemClass"]);//1西药 2中药 3项目材料
mPres.StatItem_Code = "";
mPres.Sell_Price = Convert.ToDecimal(dt.Rows[i]["Price"]);
mPres.Buy_Price = Convert.ToDecimal(dt.Rows[i]["Price"]);
mPres.Item_Price = Convert.ToDecimal(dt.Rows[i]["Price"]);
mPres.Standard = dt.Rows[i]["Spec"].ToString();
mPres.Usage_Amount = Convert.ToDecimal(dt.Rows[i]["Dosage"]);//剂量
mPres.Usage_Unit = dt.Rows[i]["DosageUnit"].ToString();//剂量单位
mPres.Usage_Rate = Convert.ToDecimal(dt.Rows[i]["Factor"]);//剂量系数
mPres.Dosage = Convert.ToInt32(dt.Rows[i]["Num"]); ;//付数
mPres.Usage_Id = Convert.ToInt32(dt.Rows[i]["ChannelID"]);
mPres.Frequency_Id = Convert.ToInt32(dt.Rows[i]["FrequencyID"]);
mPres.Days = Convert.ToInt32(dt.Rows[i]["Days"]);
mPres.Amount = Convert.ToDecimal(dt.Rows[i]["Amount"].ToString());//发药数量
mPres.Unit = dt.Rows[i]["Unit"].ToString();//发药单位
mPres.Item_Amount = Convert.ToInt32(Convert.ToDecimal(dt.Rows[i]["PresAmount"]));//开药数量
mPres.Item_Unit = dt.Rows[i]["PresAmountUnit"].ToString();//开药单位
mPres.Item_Rate = Convert.ToInt32(Convert.ToDecimal(dt.Rows[i]["PresFactor"]));//系数
mPres.Group_Id = Convert.ToInt32(dt.Rows[i]["GroupID"]);//分组组号
mPres.SkinTest_Flag = Convert.ToInt32(dt.Rows[i]["IsAst"]);//皮试
mPres.SelfDrug_Flag = Convert.ToInt32(dt.Rows[i]["IsTake"]);//自备
mPres.Entrust = dt.Rows[i]["Memo"].ToString();//嘱托
mPres.FootNote = "";
mPres.Tc_Flag = 0;//套餐
mPres.PresNo = Convert.ToInt32(dt.Rows[i]["ListNO"]);//方号
mPres.Dept_Id = 0;//执行科室
mPres.Pres_Dept = Convert.ToInt32(dt.Rows[i]["DeptCode"]);
mPres.Pres_DeptName = dt.Rows[i]["PresDeptName"].ToString();
mPres.Pres_Doc = Convert.ToInt32(dt.Rows[i]["DoctorID"]);
mPres.Pres_DocName = dt.Rows[i]["PresDoctorName"].ToString();
if (Convert.ToInt32(dt.Rows[i]["IsCancel"]) == 1)
mPres.Status = PresStatus.退费状态;
else if (Convert.ToInt32(dt.Rows[i]["IsCharged"]) == 1)
mPres.Status = PresStatus.收费状态;
else
mPres.Status = PresStatus.保存状态;
//mPres.Pres_Date = Convert.ToDateTime(dt.Rows[i]["chargedTime"]);
mPres.Usage_Name = dt.Rows[i]["ChannelName"].ToString();//用法名称
mPres.Frequency_Name = dt.Rows[i]["FrequencyName"].ToString();//频次名称
mPres.Frequency_Caption = dt.Rows[i]["ExecuteCode"].ToString();//频次名称
int _execNum, _cycleDay;
CardDataSourceFrequency.Calculate(dt.Rows[i]["ExecuteCode"].ToString(), out _execNum, out _cycleDay);
mPres.Frequency_ExecNum = _execNum;//执行次数
mPres.Frequency_CycleDay = _cycleDay;//执行周期
mPres.CalculateItemMoney();
list_Prescription.Add(mPres);
}
return list_Prescription;
}
public bool SavePrescriptionData(int patListId, List<Prescription> list, int presType)
{
List<string> sqllist = new List<string>();
string strsql = @"select ID from Clinic_PrescriptionList where PatientID ={0} AND OrderClass={1}";
strsql = string.Format(strsql, patListId, presType);
object ret = oleDb.GetDataResult(strsql);
int headId = ret == DBNull.Value ? 0 : Convert.ToInt32(ret);
if (headId == 0)//先插入处方头
{
strsql = @"INSERT INTO Clinic_PrescriptionList
( PatientID ,
OrderClass ,
OrderTime)
VALUES ( {0},{1},'{2}')";
strsql = string.Format(strsql, patListId, presType, DateTime.Now);
headId = oleDb.InsertRecord(strsql);
}
//先删除修改数据
strsql = @"DELETE FROM Clinic_PrescriptionDetail WHERE ID IN({0})";
string Ids = null;
for (int i = 0; i < list.Count; i++)
{
if (Ids == null)
Ids = list[i].PresListId.ToString();
else
Ids += "," + list[i].PresListId.ToString();
}
strsql = string.Format(strsql, Ids);
//MidDbHelper.ExecuteNonQuery(MidDbHelper.EmrHandle, strsql);
sqllist.Add(strsql);
for (int i = 0; i < list.Count; i++)
{
strsql = @"INSERT INTO Clinic_PrescriptionDetail(PrescriptionID ,ListNO ,GroupID ,FeeID ,FeeName ,Spec ,Dosage ,DosageUnit ,Factor ,ChannelID ,FrequencyID ,Num ,Amount ,Unit ,Price ,Days ,IsAst ,AstResult ,IsTake ,Memo ,IsCharged ,IsCancel,IsSend ,DoctorID ,DeptCode ,CostID ,FavorFee ,PresAmount ,PresAmountUnit ,PresFactor )
VALUES (
{0} --PrescriptionID
,{1}--ListNO
,{2} --GroupID
,{3} --FeeID
,'{4}' --FeeName
,'{5}'--Spec
,{6}--Dosage
,'{7}'--DosageUnit
,{8} ,{9} ,{10},{11} ,{12} --Amount
,'{13}' ,{14} ,{15} --Days
,{16}--IsAst
,'' --AstResult
,{17} ,'{18}' ,0 ,0 ,0,{19} --DoctorID
,'{20}' --DeptCode
,0 --CostID
,0 --FavorFee
,{21} --PresAmount
,'{22}'--PresAmountUnit
,{23}--PresFactor
)";
strsql = string.Format(strsql,
headId//0
, list[i].PresNo//1
, list[i].Group_Id
, list[i].Item_Id
, list[i].Item_Name
, list[i].Standard//5
, list[i].Usage_Amount, list[i].Usage_Unit, list[i].Usage_Rate//8
, list[i].Usage_Id, list[i].Frequency_Id, list[i].Dosage, list[i].Amount//12
, list[i].Unit, list[i].Sell_Price, list[i].Days//15
, list[i].SkinTest_Flag//16
, list[i].SelfDrug_Flag, list[i].Entrust, list[i].Pres_Doc//19
, list[i].Pres_Dept//20
, list[i].Item_Amount//21
, list[i].Item_Unit//22
, list[i].Item_Rate//23
);
sqllist.Add(strsql);
}
for (int i = 0; i < sqllist.Count; i++)
{
oleDb.DoCommand(sqllist[i]);
}
return true;
}
public bool DeletePrescriptionData(int presListId)
{
string strsql = @"DELETE FROM Clinic_PrescriptionDetail WHERE ID ={0} and IsCharged=0";
strsql = string.Format(strsql, presListId);
oleDb.DoCommand(strsql);
return true;
}
public bool DeletePrescriptionData(int patListId, int presType, int PresNo)
{
string strsql = @"DELETE FROM Clinic_PrescriptionDetail WHERE IsCharged=0
AND PrescriptionID IN(SELECT ID FROM Clinic_PrescriptionList WHERE PatientID={0} AND OrderClass={1})
AND ListNO={2}";
strsql = string.Format(strsql, patListId, presType, PresNo);
oleDb.DoCommand(strsql);
return true;
}
public bool UpdatePresNoAndGroupId(List<Prescription> data)
{
List<string> sqllist = new List<string>();
for (int i = 0; i < data.Count; i++)
{
string strsql = @"UPDATE Clinic_PrescriptionDetail SET ListNO={1},GroupID={2} WHERE ID={0}";
strsql = string.Format(strsql, data[i].PresListId, data[i].PresNo, data[i].Group_Id);
sqllist.Add(strsql);
}
for (int i = 0; i < sqllist.Count; i++)
{
oleDb.DoCommand(sqllist[i]);
}
return true;
}
public bool UpdatePresSelfDrugFlag(int presListId, int Flag)
{
string strsql = @"UPDATE Clinic_PrescriptionDetail SET IsTake={1} WHERE ID={0}";
strsql = string.Format(strsql, presListId, Flag);
oleDb.DoCommand(strsql);
return true;
}
#endregion
}View Code
总结：本章主要是扩展介绍EFW框架中的Winform系统自定义控件，利用框架中的自定义控件可以开发出相对复杂的业务功能，还有就是业务控件的设计思路，业务逻辑要完全独立于数据源，用接口的方式封装数据源的操作；
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
