Esempio n. 1
0
 /// <summary>
 /// 获得检验科室
 /// </summary>
 /// <returns></returns>
 public DataTable Getjydept(int jgbm)
 {
     try
     {
         if (myQuery == null)
         {
             myQuery = new DbQuery();
         }
         DataTable tb = new DataTable();
         tb = myQuery.GetDept(0, jgbm);
         //if (tb.Rows.Count == 0)
         //{
         //    //MessageBox.Show("错误,未能取得化验科室信息!");
         //    return tb;
         //}
         //add by zouchihua 2013-6-13 增加一个全部
         DataTable temp = tb.Clone();
         temp = FrmMdiMain.Database.GetDataTable(" select 0 id ,'全部' name");
         DataRow r;
         for (int i = 0; i < tb.Rows.Count; i++)
         {
             r         = temp.NewRow();
             r["id"]   = tb.Rows[i]["id"];
             r["name"] = tb.Rows[i]["name"];
             temp.Rows.Add(r);
         }
         return(temp);
     }
     catch {
         return(new DataTable());
     }
 }
Esempio n. 2
0
 public decimal GetorderPrice(long orderid)
 {
     if (myQuery == null)
     {
         myQuery = new DbQuery();
     }
     return(myQuery.GetPrice(orderid, FrmMdiMain.Jgbm));
 }
Esempio n. 3
0
        /// <summary>
        /// 获得化验项目
        /// </summary>
        /// <param name="deptID"></param>
        /// <param name="classType"></param>
        /// <returns></returns>
        public DataTable Gethyxm(long deptID, short classType, long myDept)
        {
            if (myQuery == null)
            {
                myQuery = new DbQuery();
            }
            DataTable tb = myQuery.GetItem(deptID, classType, 0, myDept);

            return(tb);
        }