protected void GetComboxData()
{
string sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='diagnosis' ";
DataTable dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_diagnosis, dt1, true, "NAME", "CODE");
cbo_diagnosis.Select(0);
sSQL = "SELECT hp2_code AS CODE, hp2_name AS NAME FROM hpack2_setup"; //透析器型號
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_mechine_model, dt1, true, "NAME", "CODE");
cbo_mechine_model.Select(0);
sSQL = "SELECT hp3_code AS CODE, hp3_name AS NAME FROM hpack3_setup"; //血管通路，目前沒用到
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_hpack3, dt1, true, "NAME", "CODE");
cbo_hpack3.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='dialysis_type' ";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_dialysis_type, dt1, true, "NAME", "CODE");
cbo_dialysis_type.Select(0);
//sSQL = "SELECT hp_code AS CODE, hp_subgrp AS NAME FROM h_type"; //舊程式使用h_type與FLEX使用不同資料表
sSQL = "SELECT pck_code AS CODE, pck_name AS NAME FROM package_setup";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_h_type, dt1, true, "NAME", "CODE");
cbo_h_type.Select(0);
// 取得肝素類型
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='heparin' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBox10, dt1, true, "NAME", "CODE");
SelectBox10.Select(0);
// 取得 EPO 資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectEPO' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxEPO, dt1, true, "NAME", "CODE");
SelectBoxEPO.Select(0);
// 取得左卡資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectLeftCard' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxLcard, dt1, true, "NAME", "CODE");
SelectBoxLcard.Select(0);
// 取得甲鈷銨資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectMecobalamin' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxMecobalamin, dt1, true, "NAME", "CODE");
SelectBoxMecobalamin.Select(0);
// 取得鐵劑資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectIron' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxIron, dt1, true, "NAME", "CODE");
SelectBoxIron.Select(0);
// 取得溉醇資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectCalcitriol' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxCalcitriol, dt1, true, "NAME", "CODE");
SelectBoxCalcitriol.Select(0);
// 取得透析液鈉資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectSodium' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxSodium, dt1, true, "NAME", "CODE");
SelectBoxSodium.Select(0);
// 取得透析液鉀資料
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectPotassium' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxPotassium, dt1, true, "NAME", "CODE");
SelectBoxPotassium.Select(0);
//Common.SetComboBoxValue(cbo_h_type, Request["hpack"].ToString(), true); //血管通路類型
//Common.SetComboBoxValue(cbo_hpack3, Request["hpack3"].ToString(), true); //血管通路
//Common.SetComboBoxValue(cbo_mechine_model, Request["mechine_model"].ToString(), true); //透析器型號
//txt_weight_before.Text = Request["patient_weight"].ToString(); //體重 added by jeffrey at 2015/11/19
//patient_weight.Text = Request["patient_weight"].ToString(); //體重
}
protected void GetComboxData()
{
string sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='diagnosis' ";
DataTable dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_diagnosis, dt1, true, "NAME", "CODE");
cbo_diagnosis.Select(0);
sSQL = "SELECT hp2_code AS CODE, hp2_name AS NAME FROM hpack2_setup"; //透析器型號
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_mechine_model, dt1, true, "NAME", "CODE");
cbo_mechine_model.Select(0);
sSQL = "SELECT hp3_code AS CODE, hp3_name AS NAME FROM hpack3_setup"; //血管通路，目前沒用到
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_hpack3, dt1, true, "NAME", "CODE");
cbo_hpack3.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='dialysis_type' ";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_dialysis_type, dt1, true, "NAME", "CODE");
cbo_dialysis_type.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='change_type' ";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_change_type, dt1, true, "NAME", "CODE");
cbo_change_type.Select(0);
//sSQL = "SELECT hp_code AS CODE, hp_subgrp AS NAME FROM h_type"; //舊程式使用h_type與FLEX使用不同資料表
sSQL = "SELECT pck_code AS CODE, pck_name AS NAME FROM package_setup";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_h_type, dt1, true, "NAME", "CODE");
cbo_h_type.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectEPO' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectBoxEPO, dt1, true, "NAME", "CODE");
SelectBoxEPO.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectCa' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectCheckbox3, dt1, true, "NAME", "CODE");
SelectCheckbox3.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectThinner' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectCheckbox4, dt1, true, "NAME", "CODE");
SelectCheckbox4.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='SelectOther' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(SelectCheckbox5, dt1, true, "NAME", "CODE");
SelectCheckbox5.Select(0);
dt1.Dispose();
Common.SetComboBoxValue(cbo_h_type, Request["hpack"].ToString(), true); //血管通路類型
Common.SetComboBoxValue(cbo_hpack3, Request["hpack3"].ToString(), true); //血管通路
Common.SetComboBoxValue(cbo_mechine_model, Request["mechine_model"].ToString(), true); //透析器型號
txt_weight_before.Text = Request["patient_weight"].ToString(); //體重 added by jeffrey at 2015/11/19
patient_weight.Text = Request["patient_weight"].ToString(); //體重
}
