protected void Show_Longdrug() { string sql = "SELECT a.lgord_id,a.lgord_dateord,a.lgord_timeord,a.lgord_usr1,b.drg_name,a.lgord_intake,a.lgord_freq,a.lgord_medway,a.lgord_comment,a.lgord_dtactst "; sql += ", CASE a.lgord_actst WHEN '00001' THEN '' WHEN '00002' THEN '停用' END As Status "; sql += "FROM longterm_ordermgt a "; sql += "LEFT JOIN drug_list b ON a.lgord_drug=b.drg_code "; sql += "WHERE a.lgord_patic='" + Patient_ID.Text + "' "; sql += "ORDER BY a.lgord_dateord DESC, Status"; DataTable dt = db.Query(sql); Store istore1 = Grid_Long_Term.GetStore(); istore1.DataSource = db.GetDataArray(dt); istore1.DataBind(); dt.Dispose(); }
protected void Show_longdrug() { DBMysql db = new DBMysql(); string sql; //old sql = "SELECT a.lgord_dateord, a.lgord_timeord,a.lgord_usr1,b.drg_name,a.lgord_intake,a.lgord_freq,c.genst_desc,a.lgord_dtactst, a.lgord_usr2,a.lgord_comment "; sql = "SELECT a.lgord_dateord, a.lgord_timeord,a.lgord_usr1,b.drg_name,a.lgord_intake,a.lgord_freq,a.lgord_medway,c.genst_desc,a.lgord_dtactst, a.lgord_usr2,a.lgord_comment "; sql += "from longterm_ordermgt a, drug_list b, general_setup c"; sql += " where a.lgord_patic = '" + _PAT_IC + "'"; sql += " and a.lgord_drug = b.drg_code "; sql += " and c.genst_ctg = 'ActiveStatus' "; sql += " and a.lgord_actst = c.genst_code order by a.lgord_id ASC"; DataTable dt = db.Query(sql); Store istore = Grid_Long_Term.GetStore(); istore.DataSource = db.GetDataArray_AddRowNum(db.Query(sql)); istore.DataBind(); }