Exemple #1
0
        /// <summary>
        /// 加载药品
        /// </summary>
        /// <param name="wardcode"></param>
        public void ShowMedcine(string wardcode)
        {
            //根据部门编号查询该部门下面的药品信息
            string str = "SELECT MPRuleID, IsMedClass, MedCode, MedName,SeqNo " +
                         "FROM OrderMPRule WHERE WardCode = '" + wardcode + "' ORDER BY SeqNo";

            WardCode = wardcode;//部门编号
            try
            {
                //清空显示区域
                pnlMed1.Controls.Clear(); //高优先级区域
                pnlMed2.Controls.Clear(); //低优先级区域
                DS = DB.GetPIVAsDB(str);
                for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
                {
                    MedcineRow medcine;

                    //高优先级区域赋值
                    if (Convert.ToInt32(DS.Tables[0].Rows[i]["SeqNo"].ToString()) < 100000000)
                    {
                        medcine = new MedcineRow(pnlMed1);
                        medcine.SetMedcine(DS.Tables[0].Rows[i]);
                        pnlMed1.Controls.Add(medcine);
                    }

                    //低优先级区域赋值
                    else if (Convert.ToInt32(DS.Tables[0].Rows[i]["SeqNo"].ToString()) > 150000000)
                    {
                        medcine = new MedcineRow(pnlMed2);
                        medcine.SetMedcine(DS.Tables[0].Rows[i]);
                        pnlMed2.Controls.Add(medcine);
                    }
                }
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }