protected void GetComboxData()
{
string sSQL = "SELECT hp2_code AS CODE, hp2_name AS NAME FROM hpack2_setup WHERE hp2_status='Y'"; //透析器型號
DataTable dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_machine_model, dt1, false, "NAME", "CODE");
Common.SetComboBoxItem(cbo_machine_model2, dt1, true, "NAME", "CODE");
cbo_machine_model.Select(0);
sSQL = "SELECT hp3_code AS CODE, hp3_name AS NAME FROM hpack3_setup WHERE hp3_status='Y'"; //管路型號
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_Tube, dt1, false, "NAME", "CODE");
Common.SetComboBoxItem(cbo_Tube2, dt1, true, "NAME", "CODE");
cbo_Tube.Select(0);
cbo_Tube2.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='dialysis_type' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_Machinetype, dt1, false, "NAME", "CODE");
cbo_Machinetype.Select(0);
sSQL = "SELECT pck_code AS CODE, pck_name AS NAME FROM package_setup WHERE pck_status='Y'";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_h_type, dt1, false, "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, false, "NAME", "CODE");
SelectBox10.Select(0);
}
protected void GetComboxData()
{
string sSQL = "SELECT hp2_code AS CODE, hp2_name AS NAME FROM hpack2_setup"; //透析器型號
DataTable dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_machine_model, dt1, false, "NAME", "CODE");
cbo_machine_model.Select(0);
sSQL = "SELECT CLASS2_CODE AS CODE, CLASS2_NAME AS NAME FROM a_class2 WHERE CLASS1_CODE='dialysis_type' ORDER BY CLASS2_CODE";
dt1 = db.Query(sSQL);
Common.SetComboBoxItem(cbo_Machinetype, dt1, false, "NAME", "CODE");
cbo_Machinetype.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, false, "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, false, "NAME", "CODE");
SelectBox10.Select(0);
sSQL = "SELECT a.pv_floor, a.pv_sec, a.pv_bedno, a.time_type, a.appointment_date AS NAME FROM appointment a ";
sSQL += "LEFT JOIN pat_info b ON a.pif_id=b.pif_id ";
sSQL += "WHERE b.pif_ic='" + Tex_Patient_ID.Text + "' ";//AND a.appointment_date>='" + toDay + "' ";
sSQL += "ORDER BY a.appointment_date DESC";
dt1 = db.Query(sSQL);
if (dt1.Rows.Count > 0)
{
cb_info_date.Text = dt1.Rows[0]["NAME"].ToString();
floor.Text = dt1.Rows[0]["pv_floor"].ToString();
area.Text = dt1.Rows[0]["pv_sec"].ToString();
bedno.Text = dt1.Rows[0]["pv_bedno"].ToString();
time.Text = dt1.Rows[0]["time_type"].ToString();
set_time_text();
}
Common.SetComboBoxItem(cb_info_date, dt1, false, "NAME", "NAME");
}
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(); //體重
}
