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();
}
