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