Пример #1
0
        //根据药品ID,获取药品数据
        public static CardDataSourceDrugItem GetDrugItem(int ItemId)
        {
            if (PrescripttionDbHelper != null)
            {
                return(PrescripttionDbHelper.GetDrugItem(ItemId));
            }
            else
            {
                string strsql = @"SELECT top 1 * FROM hisdb..View_DrugAndFeeList WHERE StockID={0}";
                strsql = string.Format(strsql, ItemId);

                DataTable dt = MidDbHelper.ExecuteDataTable(MidDbHelper.HisHandle, strsql);

                //DataTable dt = HIS_FeeList.GetDrugAndFeeListFromMid(0, filter);

                List <CardDataSourceDrugItem> list_DrugItem = new List <CardDataSourceDrugItem>();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    CardDataSourceDrugItem mDrugItem = new CardDataSourceDrugItem();
                    mDrugItem.ItemId         = Convert.ToInt32(dt.Rows[i]["StockID"]);
                    mDrugItem.ItemName       = dt.Rows[i]["CName"].ToString();
                    mDrugItem.ItemName_Print = dt.Rows[i]["TName"].ToString();
                    mDrugItem.Standard       = dt.Rows[i]["Spec"].ToString();

                    mDrugItem.Scale      = dt.Rows[i]["Competence"].ToString();        //补偿比例
                    mDrugItem.StoreNum   = Convert.ToDecimal(dt.Rows[i]["ActualQty"]); //库存量
                    mDrugItem.UnPickUnit = dt.Rows[i]["MiniUnit"].ToString();          //包装单位(销售单位)
                    mDrugItem.SellPrice  = Convert.ToDecimal(dt.Rows[i]["ClinPrice"]); //销售价格?
                    mDrugItem.BuyPrice   = Convert.ToDecimal(dt.Rows[i]["WardPrice"]); //进价
                    //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 = Convert.ToDecimal(dt.Rows[i]["Dosage"]); //剂量对应包装单位系数
                    mDrugItem.ItemType       = Convert.ToInt32(dt.Rows[i]["MatClass"]); //项目类型 0-所有 1-西药 2-中药  3-处方可开的物品 4-收费项目
                    //mDrugItem.StatItemCode = dt.Rows[i][""].ToString();//大项目代码
                    //mDrugItem.UnPickUnitId = dt.Rows[i][""].ToString();//包装单位ID
                    mDrugItem.ExecDeptId = Convert.ToInt32(dt.Rows[i]["DeptID"]); //执行科室ID?
                    mDrugItem.FloatFlag  = 1;                                     // dt.Rows[i][""].ToString();//按含量取整1 按剂量取整0
                    //mDrugItem.VirulentFlag = dt.Rows[i][""].ToString();//剧毒标识
                    //mDrugItem.NarcoticFlag = dt.Rows[i][""].ToString();//麻醉标识
                    mDrugItem.SkinTestFlag = Convert.ToInt32(dt.Rows[i]["SkinMethod"]);//皮试标识
                    //mDrugItem.RecipeFlag = dt.Rows[i][""].ToString();//处方标识
                    //mDrugItem.LunacyFlag = dt.Rows[i][""].ToString();//精神药品标识
                    //mDrugItem.CostlyFlag = dt.Rows[i][""].ToString();//贵重药品标识
                    mDrugItem.default_Usage_Amount   = Convert.ToDecimal(dt.Rows[i]["BASEDos"]); //默认用量
                    mDrugItem.default_Usage_Id       = Convert.ToInt32(dt.Rows[i]["UsgID"]);     //默认用法
                    mDrugItem.default_Usage_Name     = dt.Rows[i]["ChannelName"].ToString();
                    mDrugItem.default_Frequency_Id   = Convert.ToInt32(dt.Rows[i]["FcyID"]);     //默认频次
                    mDrugItem.default_Frequency_Name = dt.Rows[i]["FrequencyName"].ToString();

                    list_DrugItem.Add(mDrugItem);
                }
                return(list_DrugItem[0]);
            }
        }
        /// <summary>
        /// 获取药品信息
        /// </summary>
        /// <param name="itemId">药品Id</param>
        /// <returns>药品实体模型</returns>
        public CardDataSourceDrugItem  GetDrugItem(int itemId)
        {
            Action <ClientRequestData> requestAction = ((ClientRequestData request) =>
            {
                request.AddData(itemId);
            });
            ServiceResponseData           retData       = InvokeWcfService("OPProject.Service", "PresManageController", "GetDrugItemTpl", requestAction);
            DataTable                     dt            = retData.GetData <DataTable>(0);
            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]["ItemID"], 0);
                mDrugItem.ItemName       = dt.Rows[i]["ItemName"].ToString();
                mDrugItem.ItemName_Print = dt.Rows[i]["ItemName"].ToString();
                mDrugItem.Standard       = dt.Rows[i]["Standard"].ToString();

                mDrugItem.Scale        = string.Empty;                                              //补偿比例
                mDrugItem.StoreNum     = ConvertDataExtend.ToDecimal(dt.Rows[i]["StoreAmount"], 0); //库存量
                mDrugItem.UnPickUnit   = dt.Rows[i]["UnPickUnit"].ToString();                       //包装单位(销售单位)
                mDrugItem.SellPrice    = ConvertDataExtend.ToDecimal(dt.Rows[i]["UnitPrice"], 0);   //销售价格?
                mDrugItem.BuyPrice     = ConvertDataExtend.ToDecimal(dt.Rows[i]["InPrice"], 0);     //进价
                mDrugItem.ExecDeptName = dt.Rows[i]["ExecDeptName"].ToString();                     //执行科室?
                mDrugItem.Pym          = dt.Rows[i]["Pym"].ToString();
                mDrugItem.Wbm          = dt.Rows[i]["Wbm"].ToString();
                mDrugItem.Address      = dt.Rows[i]["Address"].ToString();//生产厂家
                //mDrugItem.DoseUnitId = dt.Rows[i][""].ToString();//剂量单位
                mDrugItem.DoseUnitName   = dt.Rows[i]["DoseUnitName"].ToString();
                mDrugItem.DoseConvertNum = ConvertDataExtend.ToDecimal(dt.Rows[i]["DoseConvertNum"], 0);//剂量对应包装单位系数
                int statID      = ConvertDataExtend.ToInt32(dt.Rows[i]["StatID"], 0);
                int itemClass   = ConvertDataExtend.ToInt32(dt.Rows[i]["ItemClass"], 0);
                int itemClassId = GetItemType(itemClass, statID);
                mDrugItem.ItemType     = itemClassId;                                                        //项目类型 0-所有 1-西药 2-中药  3-处方可开的物品 4-收费项目
                mDrugItem.StatItemCode = statID.ToString();                                                  //大项目代码
                //mDrugItem.UnPickUnitId = dt.Rows[i][""].ToString();//包装单位ID
                mDrugItem.ExecDeptId             = ConvertDataExtend.ToInt32(dt.Rows[i]["ExecDeptId"], 0);   //执行科室ID?
                mDrugItem.FloatFlag              = ConvertDataExtend.ToInt32(dt.Rows[i]["FloatFlag"], 0);    // dt.Rows[i][""].ToString();//按含量取整1 按剂量取整0
                mDrugItem.VirulentFlag           = ConvertDataExtend.ToInt32(dt.Rows[i]["VirulentFlag"], 0); //剧毒标识
                mDrugItem.NarcoticFlag           = ConvertDataExtend.ToInt32(dt.Rows[i]["NarcoticFlag"], 0); //麻醉标识
                mDrugItem.SkinTestFlag           = ConvertDataExtend.ToInt32(dt.Rows[i]["SkinTestFlag"], 0); //皮试标识
                mDrugItem.RecipeFlag             = ConvertDataExtend.ToInt32(dt.Rows[i]["RecipeFlag"], 0);   //处方标识
                mDrugItem.LunacyFlag             = ConvertDataExtend.ToInt32(dt.Rows[i]["LunacyFlag"], 0);   //精神药品标识
                mDrugItem.CostlyFlag             = ConvertDataExtend.ToInt32(dt.Rows[i]["CostlyFlag"], 0);   //贵重药品标识
                mDrugItem.default_Usage_Amount   = 0;                                                        //默认用量
                mDrugItem.default_Usage_Id       = 0;                                                        //默认用法
                mDrugItem.default_Usage_Name     = string.Empty;
                mDrugItem.default_Frequency_Id   = 0;                                                        //默认频次
                mDrugItem.default_Frequency_Name = string.Empty;
                list_DrugItem.Add(mDrugItem);
            }

            return(list_DrugItem.Count > 0 ? list_DrugItem[0] : null);
        }
        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);
        }
        /// <summary>
        /// 获取药品信息
        /// </summary>
        /// <param name="type">处方类型</param>
        /// <param name="pageNo">页号</param>
        /// <param name="pageSize">页面大小</param>
        /// <param name="filter">过滤条件</param>
        /// <returns>药品列表</returns>
        public List <CardDataSourceDrugItem> GetDrugItem(int type, int pageNo, int pageSize, string filter)
        {
            // 全部 = 0, 西药与中成药 = 1, 中草药 = 2, 收费项目 = 3
            int statId = 100;

            if (type == 1)
            {
                statId = 100;
            }
            else if (type == 2)
            {
                statId = 102;
            }
            else if (type == 3)
            {
                statId = 0;
            }

            List <CardDataSourceDrugItem> list_DrugItem = new List <CardDataSourceDrugItem>();

            if (dtDrugItems == null || dtDrugItems.Rows.Count == 0)
            {
                Action <ClientRequestData> requestAction = ((ClientRequestData request) =>
                {
                    request.AddData(type);
                    request.AddData(statId);
                    request.AddData(SelectedDrugRoomID);
                });
                ServiceResponseData retdata = InvokeWcfService("OPProject.Service", "PresManageController", "GetShowCardData", requestAction);
                dtDrugItems = retdata.GetData <DataTable>(0);
            }

            //过滤处方数据
            DataTable dt = FilterPresData(type, statId);

            DataView dv = dt.DefaultView;

            dv.RowFilter = "Pym like '%" + filter + "%' or Wbm like '%" + filter + "%' or ItemName like '%" + filter + "%'";
            dt           = dv.ToTable();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                CardDataSourceDrugItem mDrugItem = new CardDataSourceDrugItem();
                mDrugItem.ItemId         = ConvertDataExtend.ToInt32(dt.Rows[i]["ItemID"], 0);
                mDrugItem.ItemName       = dt.Rows[i]["ItemName"].ToString();
                mDrugItem.ItemName_Print = dt.Rows[i]["ItemName"].ToString();
                mDrugItem.Standard       = dt.Rows[i]["Standard"].ToString();
                mDrugItem.PresFactor     = ConvertDataExtend.ToInt32(dt.Rows[i]["MiniConvertNum"], 1);
                mDrugItem.Scale          = string.Empty;                                              //补偿比例
                mDrugItem.StoreNum       = ConvertDataExtend.ToDecimal(dt.Rows[i]["StoreAmount"], 0); //库存量
                mDrugItem.UnPickUnit     = dt.Rows[i]["UnPickUnit"].ToString();                       //包装单位(销售单位)
                mDrugItem.PresFactor     = ConvertDataExtend.ToInt32(dt.Rows[i]["MiniConvertNum"], 1);
                mDrugItem.MiniUnit       = dt.Rows[i]["MiniUnitName"].ToString();
                mDrugItem.SellPrice      = ConvertDataExtend.ToDecimal(dt.Rows[i]["UnitPrice"], 0); //基本单位价格?
                mDrugItem.BuyPrice       = ConvertDataExtend.ToDecimal(dt.Rows[i]["InPrice"], 0);   //进价
                mDrugItem.ExecDeptName   = dt.Rows[i]["ExecDeptName"].ToString();                   //执行科室?
                mDrugItem.ExecDeptId     = ConvertDataExtend.ToInt32(dt.Rows[i]["ExecDeptId"], 0);
                mDrugItem.StatItemCode   = dt.Rows[i]["StatID"].ToString();
                mDrugItem.Pym            = dt.Rows[i]["Pym"].ToString();
                mDrugItem.Wbm            = dt.Rows[i]["Wbm"].ToString();
                mDrugItem.Address        = dt.Rows[i]["Address"].ToString();//生产厂家
                //mDrugItem.DoseUnitId = dt.Rows[i][""].ToString();//剂量单位
                mDrugItem.DoseUnitName   = dt.Rows[i]["DoseUnitName"].ToString();
                mDrugItem.DoseConvertNum = ConvertDataExtend.ToDecimal(dt.Rows[i]["DoseConvertNum"], 0);//剂量对应包装单位系数
                int statID      = ConvertDataExtend.ToInt32(dt.Rows[i]["StatID"], 0);
                int itemClass   = ConvertDataExtend.ToInt32(dt.Rows[i]["ItemClass"], 0);
                int itemClassId = GetItemType(itemClass, statID);
                mDrugItem.ItemType     = itemClassId;                                                        //项目类型 0-所有 1-西药 2-中药  3-处方可开的物品 4-收费项目
                mDrugItem.StatItemCode = statID.ToString();                                                  //大项目代码
                //mDrugItem.UnPickUnitId = dt.Rows[i][""].ToString();//包装单位ID
                mDrugItem.ExecDeptId             = ConvertDataExtend.ToInt32(dt.Rows[i]["ExecDeptId"], 0);   //执行科室ID?
                mDrugItem.FloatFlag              = ConvertDataExtend.ToInt32(dt.Rows[i]["FloatFlag"], 0);    // dt.Rows[i][""].ToString();//按含量取整1 按剂量取整0
                mDrugItem.VirulentFlag           = ConvertDataExtend.ToInt32(dt.Rows[i]["VirulentFlag"], 0); //剧毒标识
                mDrugItem.NarcoticFlag           = ConvertDataExtend.ToInt32(dt.Rows[i]["NarcoticFlag"], 0); //麻醉标识
                mDrugItem.SkinTestFlag           = ConvertDataExtend.ToInt32(dt.Rows[i]["SkinTestFlag"], 0); //皮试标识
                mDrugItem.RecipeFlag             = ConvertDataExtend.ToInt32(dt.Rows[i]["RecipeFlag"], 0);   //处方标识
                mDrugItem.LunacyFlag             = ConvertDataExtend.ToInt32(dt.Rows[i]["LunacyFlag"], 0);   //精神药品标识
                mDrugItem.CostlyFlag             = ConvertDataExtend.ToInt32(dt.Rows[i]["CostlyFlag"], 0);   //贵重药品标识
                mDrugItem.default_Usage_Amount   = 0;                                                        //默认用量
                mDrugItem.default_Usage_Id       = 0;                                                        //默认用法
                mDrugItem.default_Usage_Name     = string.Empty;
                mDrugItem.default_Frequency_Id   = 0;                                                        //默认频次
                mDrugItem.default_Frequency_Name = string.Empty;
                mDrugItem.ResolveFlag            = ConvertDataExtend.ToInt32(dt.Rows[i]["ResolveFlag"], 0);
                list_DrugItem.Add(mDrugItem);
            }

            return(list_DrugItem);
        }
        public Prescription.Controls.Entity.Prescription GetPresTemplateRow(int type, int itemId)
        {
            CardDataSourceDrugItem durgItem = GetDrugItem(itemId);

            if (durgItem == null)
            {
                throw new Exception("该项目已停用,不能开出!");
            }
            Prescription.Controls.Entity.Prescription mPres = new Prescription.Controls.Entity.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();
        }
        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, delegate(string sql)
            {
                int toltal        = 0;
                SqlDataReader sdr = oleDb.GetSqlDataReader(sql);
                if (sdr.Read())
                {
                    toltal = (int)sdr.GetValue(0);
                }
                sdr.Close();
                return(toltal);
            });
            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);
        }