//stockId 药品ID type 0.剂量单位 1.总量单位 public static List <CardDataSourceUnit> GetUnit(int stockId, int type) { if (PrescripttionDbHelper != null) { return(PrescripttionDbHelper.GetUnit(stockId, type)); } else { string strParam = String.Format("{0},{1},{2}", Common.CurrentHospital.HospitalID, stockId, type); DataTable dt = MidDbHelper.ExecuteDataTable(MidDbHelper.HisHandle, "xpGetDrugUnit", strParam); 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 <CardDataSourceUnit> GetUnit(int stockId, int type) { string strsql = @"select MiniUnit,PackUnit,DosUnit,PackAmount,Dosage from ViewBaseData_Med WHERE StockID=" + stockId; DataTable dtunit = oleDb.GetDataTable(strsql); List <CardDataSourceUnit> list_unit = new List <CardDataSourceUnit>(); if (type == 0)//剂量 { CardDataSourceUnit munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["DosUnit"].ToString(); munit.Pym = ""; munit.Wbm = ""; munit.Factor = Convert.ToDecimal(dtunit.Rows[0]["Dosage"]); list_unit.Add(munit); munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["MiniUnit"].ToString(); munit.Pym = ""; munit.Wbm = ""; munit.Factor = 1; list_unit.Add(munit); } else//总量 { CardDataSourceUnit munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["MiniUnit"].ToString(); munit.Pym = ""; munit.Wbm = ""; munit.Factor = 1; list_unit.Add(munit); munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["PackUnit"].ToString(); munit.Pym = ""; munit.Wbm = ""; munit.Factor = Convert.ToDecimal(dtunit.Rows[0]["PackAmount"]); list_unit.Add(munit); } return(list_unit); }
/// <summary> /// 单位 /// </summary> /// <param name="stockId">药品id</param> /// <param name="type">0剂型单位1总量单位</param> /// <returns>单位列表</returns> public List <CardDataSourceUnit> GetUnit(int stockId, int type) { Action <ClientRequestData> requestAction = ((ClientRequestData request) => { request.AddData(stockId); }); ServiceResponseData retData = InvokeWcfService("OPProject.Service", "PresManageController", "GetDrugItemTpl", requestAction); DataTable dtunit = retData.GetData <DataTable>(0); List <CardDataSourceUnit> list_unit = new List <CardDataSourceUnit>(); //剂量 if (type == 0) { CardDataSourceUnit munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["DoseUnitName"].ToString(); munit.Pym = string.Empty; munit.Wbm = string.Empty; munit.Factor = Convert.ToDecimal(dtunit.Rows[0]["DoseConvertNum"]); list_unit.Add(munit); munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["MiniUnitName"].ToString(); munit.Pym = string.Empty; munit.Wbm = string.Empty; munit.Factor = 1; list_unit.Add(munit); } else { //总量 int resolveFlag = Convert.ToInt32(dtunit.Rows[0]["ResolveFlag"]); if (resolveFlag == 1) { CardDataSourceUnit munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["MiniUnitName"].ToString(); munit.Pym = string.Empty; munit.Wbm = string.Empty; munit.Factor = 1; list_unit.Add(munit); munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["UnPickUnit"].ToString(); munit.Pym = string.Empty; munit.Wbm = string.Empty; munit.Factor = Convert.ToDecimal(dtunit.Rows[0]["MiniConvertNum"]); list_unit.Add(munit); } else { CardDataSourceUnit munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["UnPickUnit"].ToString(); munit.Pym = string.Empty; munit.Wbm = string.Empty; munit.Factor = Convert.ToDecimal(dtunit.Rows[0]["MiniConvertNum"]); list_unit.Add(munit); munit = new CardDataSourceUnit(); munit.UnitDicId = 0; munit.UnitName = dtunit.Rows[0]["UnPickUnit"].ToString(); munit.Pym = string.Empty; munit.Wbm = string.Empty; munit.Factor = Convert.ToDecimal(dtunit.Rows[0]["MiniConvertNum"]); list_unit.Add(munit); } } return(list_unit); }