/// <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()); } }
public decimal GetorderPrice(long orderid) { if (myQuery == null) { myQuery = new DbQuery(); } return(myQuery.GetPrice(orderid, FrmMdiMain.Jgbm)); }
/// <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); }