protected void Show_Shortdrug() { string sql = "SELECT a.shord_id,a.shord_dateord,a.shord_timeord,a.shord_usr1,b.drg_name,a.shord_intake,a.shord_freq,a.shord_medway,a.shord_comment,a.shord_dtactst "; sql += ", CASE a.shord_actst WHEN '00001' THEN '' WHEN '00002' THEN '停用' END As Status "; sql += "FROM shortterm_ordermgt a "; sql += "LEFT JOIN drug_list b ON a.shord_drug = b.drg_code "; sql += "WHERE a.shord_patic='" + Patient_ID.Text + "' "; sql += "AND a.shord_dateord='" + toDay + "' "; sql += "ORDER BY a.shord_dateord DESC, Status"; DataTable dt = db.Query(sql); Store istore1 = Grid_Short_Term.GetStore(); istore1.DataSource = db.GetDataArray(dt); istore1.DataBind(); dt.Dispose(); }
protected void Show_shortdrug() { DBMysql db = new DBMysql(); string sql; sql = "SELECT a.shord_dateord, a.shord_timeord,a.shord_usr1,b.drg_name,a.shord_intake,a.shord_freq,a.shord_medway,c.genst_desc,a.shord_dtactst, a.shord_usr2,a.shord_comment "; sql += "from shortterm_ordermgt a, drug_list b, general_setup c"; sql += " where a.shord_patic = '" + _PAT_IC + "'"; sql += " and a.shord_drug = b.drg_code "; sql += " and c.genst_ctg = 'ActiveStatus' "; sql += " and a.shord_actst = c.genst_code order by a.shord_id ASC"; DataTable dt = db.Query(sql); Store istore = Grid_Short_Term.GetStore(); istore.DataSource = db.GetDataArray_AddRowNum(db.Query(sql)); istore.DataBind(); }