protected void BtnSave_Click(object sender, DirectEventArgs e)
{
string sql;
sql = "SELECT cln1_diadate FROM clinical1_doc_henan ";
sql += "WHERE cln1_patic='" + Patient_ID.Text + "' AND cln1_diadate='" + text_info_date.Text + "' ";
DataTable dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical1_doc_henan ";
sql += "SET cln1_col1 = '" + Common.GetComboBoxText(cbo_h_type) + "',"; //血管通路類型
sql += "cln1_col2 = '" + Common.GetComboBoxText(cbo_machine_model) + "',"; //透析器型号
sql += "cln1_col3 = '" + Common.GetComboBoxText(cbo_Machinetype) + "',"; //透析方式
sql += "cln1_col4 = '" + txt_weight_after_expect.Text + "',"; //干体重
sql += "cln1_col5 = '" + Common.GetComboBoxText(SelectBox10) + "',"; //抗凝药物
sql += "cln1_col6 = '" + TextField3.Text + "',"; //目标定容量
sql += "cln1_col7 = '" + TextField8.Text + "',"; //首次剂量
sql += "cln1_col8 = '" + TextAdd.Text + "',"; //追加量
sql += "cln1_col9 = '" + TextAmount.Text + "', "; //总量
sql += "cln1_col10 = '" + TextField6.Text + "', ";
sql += "cln1_col11 = '" + TextField7.Text + "', ";
sql += "cln1_col12 = '" + TextField9.Text + "', ";
sql += "cln1_col13 = '" + TextField10.Text + "' ";
sql += "WHERE cln1_patic='" + Patient_ID.Text + "' AND cln1_diadate='" + text_info_date.Text + "' ";
}
else
{
sql = "INSERT INTO clinical1_doc_henan(cln1_patic,cln1_diadate,";
sql += "cln1_col1, cln1_col2, cln1_col3, cln1_col4, cln1_col5,";
sql += "cln1_col6, cln1_col7, cln1_col8, cln1_col9,";
sql += "cln1_col10, cln1_col11, cln1_col12, cln1_col13) ";
sql += "VALUES('" + Patient_ID.Text + "', '" + text_info_date.Text + "', ";
sql += "'" + Common.GetComboBoxText(cbo_h_type) + "', ";
sql += "'" + Common.GetComboBoxText(cbo_machine_model) + "', ";
sql += "'" + Common.GetComboBoxText(cbo_Machinetype) + "', ";
sql += "'" + txt_weight_after_expect.Text + "', ";
sql += "'" + Common.GetComboBoxText(SelectBox10) + "', ";
sql += "'" + TextField3.Text + "', ";
sql += "'" + TextField8.Text + "', ";
sql += "'" + TextAdd.Text + "', ";
sql += "'" + TextAmount.Text + "', ";
sql += "'" + TextField6.Text + "', ";
sql += "'" + TextField7.Text + "', ";
sql += "'" + TextField9.Text + "', ";
sql += "'" + TextField10.Text + "') ";
}
db.Excute(sql);
text_info_date.RemoveCls("Text-red");
text_info_date.AddCls("Text-blue");
_NotificationShow("<font size=4>储存成功!</font>");
}
private void Page_Init(object sender, EventArgs e)
{
try
{
DBMysql db = new DBMysql();
string sRPT_LOGO = "";
DataTable dtLOGO = db.Query("SELECT * FROM general_setup WHERE genst_code='RPT_LOGO'");
if (dtLOGO.Rows.Count > 0)
{
sRPT_LOGO = dtLOGO.Rows[0]["genst_desc"].ToString();
sRPT_LOGO = Server.MapPath(sRPT_LOGO);
}
string sRPT_NAME = "";
DataTable dtNAME = db.Query("SELECT * FROM general_setup WHERE genst_code='RPT_NAME'");
if (dtNAME.Rows.Count > 0)
{
sRPT_NAME = dtNAME.Rows[0]["genst_desc"].ToString();
}
#region 統計分析-病患人數
int W_COUNT = 0;
int W_ZINFO07_COUNT = 0;
DataTable dtPAT_INFO = db.Query("SELECT COUNT(*) AS COUNT FROM PAT_INFO ");
if (dtPAT_INFO.Rows.Count > 0)
{
W_COUNT = Convert.ToInt32(dtPAT_INFO.Rows[0]["COUNT"].ToString());
}
DataTable dtzinfo07 = db.Query("SELECT COUNT(*) as ZINFO07_COUNT FROM zinfo_a_07 WHERE opt_1 = '1' OR opt_1 = '2' OR opt_1 = '3' OR opt_1 = '4' ORDER BY PAT_ID");
if (dtzinfo07.Rows.Count > 0)
{
W_ZINFO07_COUNT = Convert.ToInt32(dtzinfo07.Rows[0]["ZINFO07_COUNT"].ToString());
}
int W_TOTAL = 0; //線上透析總人數
W_TOTAL = W_COUNT - W_ZINFO07_COUNT; //減去死亡或退出
string sqlCHKREG = "select genst_desc from general_setup where genst_ctg = 'statistics'" + " and genst_code = '001" + "'";
DataTable dt = db.Query(sqlCHKREG);
string sql = "";
if (dt.Rows.Count == 0)
{
sql = "INSERT into general_setup (genst_ctg, genst_code, genst_desc) VALUES('statistics', '001', '" + W_TOTAL + "') ";
}
else
{
sql = "UPDATE general_setup a set genst_desc='" + W_TOTAL + "' WHERE a.genst_ctg='statistics' AND a.genst_code='001'";
}
db.Excute(sql);
#endregion
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("statistics.rpt"));
rpt.DataDefinition.FormulaFields["RPT_LOGO"].Text = "ToText('" + sRPT_LOGO + "')";
rpt.DataDefinition.FormulaFields["RPT_NAME"].Text = "ToText('" + sRPT_NAME + "')";
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
CRViewer.ReportSource = rpt;
ConnectionInfo connInfo = new ConnectionInfo();
//Server=192.168.1.118;Database=myhaisv3;UID=root;PWD=; CharSet=utf8
//資料庫連線設定無效，阿亮是使用ODBC連線。
string[] MySqlString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString().Split(';');
for (int i = 0; i < MySqlString.Length; i++)
{
switch (MySqlString[i].ToUpper().Substring(0, 3))
{
case "SER":
connInfo.ServerName = MySqlString[i].Split('=')[1];
break;
case "DAT":
connInfo.DatabaseName = MySqlString[i].Split('=')[1];
break;
case "UID":
connInfo.UserID = MySqlString[i].Split('=')[1];
break;
case "PWD":
connInfo.Password = MySqlString[i].Split('=')[1];
break;
}
}
//connInfo. ServerName = "192.168.1.130";
//connInfo. DatabaseName = "mysql";
//connInfo. UserID = "root";
//connInfo. Password = "";
TableLogOnInfos tableLogOnInfos = CRViewer.LogOnInfo;
foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
{
tableLogOnInfo.ConnectionInfo = connInfo;
}
}
catch (Exception ex)
{
Common._ErrorMsgShow(ex.Message.ToString());
}
}
protected void Btn_save_Click(object sender, DirectEventArgs e)
{
string sql = "SELECT a.* ", scln3_bld = "1";
scln3_bld = Common.GetComboBoxValue(cbo_pressure);
//switch (Common.GetComboBoxText(cbo_pressure))
//{
// case "基本正常":
// scln3_bld = "1";
// break;
// case "较高":
// scln3_bld = "2";
// break;
// case "较低":
// scln3_bld = "3";
// break;
// default:
// throw new Exception("GetComboBoxText cbo_pressure failure");
//}
sql += " FROM clinical3_nurse a ";
sql += " where a.cln3_patic = '" + patient_id.Text + "' ";
sql += " and a.cln3_date = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
DataTable dt = db.Query(sql);
if (dt.Rows.Count == 1)
{
sql = "UPDATE clinical3_nurse b ";
sql += "set b.cln3_date = '" + DateTime.Now.ToString("yyyy-MM-dd") + "',";
sql += " b.cln3_time = '" + ttt.Text + "',";
sql += " b.cln3_rmk = '" + TextField4.Text + "',";
sql += " b.cln3_a1 = '" + TextField5.Text + "',";
sql += " b.cln3_a2 = '" + TextField6.Text + "',";
sql += " b.cln3_b1 = '" + TextField7.Text + "',";
sql += " b.cln3_b2 = '" + TextField8.Text + "',";
sql += " b.cln3_ysa = '" + Common.GetComboBoxText(cbo_symptom) + "',";
sql += " b.cln3_pressure = '" + Common.GetComboBoxText(cbo_pressure) + "',";
sql += " b.cln3_bld = '";
sql += scln3_bld;
sql += "', ";
sql += " b.cln3_yn = '" + (Common.GetComboBoxText(cbo_symptom) == "无症状" ? "N" : "Y");
sql += "', ";
sql += " b.cln3_rmk2 = '" + TextArea2.Text + "' ";
//sql += " b.cln3_doc1 = '" + TextField9.Text + "',";
//sql += " b.cln3_nur1 = '" + TextField10.Text + "' ";
sql += " where b.cln3_patic = '" + patient_id.Text + "' ";
sql += " AND b.cln3_date = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
}
else
{
sql = "INSERT into clinical3_nurse(cln3_patic,cln3_date,cln3_time," +
"cln3_a1,cln3_a2,cln3_b1,cln3_b2," +
"cln3_CatheterAccess,cln3_MuscleAtrophy,cln3_ysa,cln3_pressure,cln3_DialysisMachine,cln3_HeparinPumpArtery,cln3_HeparinPumpVein," +
"cln3_bld,cln3_yn,cln3_rmk2,cln3_rmk) "; //
sql += "VALUES('" + patient_id.Text + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + ttt.Text + "'," +
"'" + TextField5.Text + "','" + TextField6.Text + "','" + TextField7.Text + "','" + TextField8.Text + "'," +
"'',''," +
"'" + Common.GetComboBoxText(cbo_symptom) + "','" + Common.GetComboBoxText(cbo_pressure) + "'," +
"'','','','";
sql += scln3_bld;
sql += "','";
sql += Common.GetComboBoxText(cbo_symptom) == "无症状" ? "N" : "Y";
sql += "','" + TextArea2.Text + "','" + TextField4.Text + "')";
}
db.Excute(sql);
Common._NotificationShow("储存成功!");
}
protected void SaveSelRow(object sender, DirectEventArgs e)
{
string sql = "";
string drg_code, drg_intake, drg_freq, drg_medway;
string toDay = DateTime.Now.ToString("yyyy-MM-dd");
string toTime = DateTime.Now.ToString("HH:mm");
string[] StrArray = new string[4];
RowSelectionModel sm = this.Grid_DrugTerm.GetSelectionModel() as RowSelectionModel;
foreach (SelectedRow row in sm.SelectedRows)
{
StrArray = GetDrugValue(row.RecordID.ToString());
drg_code = StrArray[0];
drg_intake = StrArray[1];
drg_freq = StrArray[2];
drg_medway = StrArray[3];
if (DrugKind.Text == "L")
{
sql += "INSERT INTO longterm_ordermgt(lgord_patic, lgord_dateord, lgord_timeord, lgord_usr1, lgord_dtactst, lgord_usr2, ";
sql += "lgord_drug, lgord_intake, lgord_freq, lgord_medway, lgord_actst) ";
sql += "VALUES('" + PationID.Text + "','" + toDay + "','" + toTime + "','" + DocName.Text + "','','" + DocName.Text + "',";
sql += "'" + drg_code + "','" + drg_intake + "','" + drg_freq + "','" + drg_medway + "','00001'); ";
}
else //==S
{
sql += "INSERT INTO shortterm_ordermgt(shord_patic, shord_dateord, shord_timeord, shord_usr1, shord_dtactst, shord_usr2, ";
sql += "shord_drug, shord_intake, shord_freq, shord_medway, shord_actst) ";
sql += "VALUES('" + PationID.Text + "','" + toDay + "','" + toTime + "','" + DocName.Text + "','','" + DocName.Text + "',";
sql += "'" + drg_code + "','" + drg_intake + "','" + drg_freq + "','" + drg_medway + "','00001'); ";
}
}
db.Excute(sql);
Store istore = Grid_DrugTerm.GetStore();
istore.RemoveAll();
DetailsWindow.Close();
//更新長期醫囑清單
if (DrugKind.Text == "L")
{
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='" + PationID.Text + "' ";
sql += "ORDER BY a.lgord_dateord DESC, Status";
//sql += " AND a.lgord_actst='00001'"; //只取使用中的藥物
DataTable dt = db.Query(sql);
GridStore1.DataSource = db.GetDataArray(dt);
GridStore1.DataBind();
}
else //更新短期醫囑清單
{
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='" + PationID.Text + "' ";
//sql += "AND a.shord_dateord='" + toDay + "' ";
sql += "ORDER BY a.shord_dateord DESC, Status";
//sql += "AND a.shord_actst='00001'";//只取使用中
DataTable dt = db.Query(sql);
GridStore1.DataSource = db.GetDataArray(dt);
GridStore1.DataBind();
}
}
protected void Btn_save_Click(object sender, DirectEventArgs e)
{
string sql;
DataTable dt;
if (cbo_mechine_model.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入透析器型号!");
return;
}
else if (cbo_h_type.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入血管通路!");
return;
}
else
{
try //深静脉置管
{
//DBMysql db = new DBMysql();
sql = "SELECT cln1_diadate FROM clinical1_nurse_suzhou ";
sql += "WHERE cln1_patic = '" + patient_id.Text + "' AND cln1_diadate = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical1_nurse_suzhou SET ";
sql += "cln1_col11 = '" + Col11 + "',";
sql += "cln1_col12 = '" + coltext11 + "',";
sql += "cln1_col21 = '" + Col21 + "',";
sql += "cln1_col22 = '" + coltext21 + "',";
sql += "cln1_col31 = '" + Col31 + "',";
sql += "cln1_col32 = '" + coltext31 + "',";
sql += "cln1_col41 = '" + Col41 + "',";
sql += "cln1_col42 = '" + coltext41 + "',";
sql += "cln1_col50 = '" + Col50 + "' ";
sql += "WHERE cln1_patic = '" + patient_id.Text + "' AND cln1_diadate = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT INTO clinical1_nurse_suzhou (cln1_patic, cln1_diadate,";
sql += "cln1_col11, cln1_col12, cln1_col21, cln1_col22, cln1_col31, cln1_col32, cln1_col41, cln1_col42, cln1_col50) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "',";
sql += "'" + Col11 + "','" + coltext11 + "',";
sql += "'" + Col21 + "','" + coltext21 + "',";
sql += "'" + Col31 + "','" + coltext31 + "',";
sql += "'" + Col41 + "','" + coltext41 + "',";
sql += "'" + Col50 + "')";
}
db.Excute(sql); //深静脉置管
}
catch //深静脉置管，儲存失敗
{
}
string checktext = ",";
if (CheckboxEPO.Checked == true || SelectBoxEPO.Text.Trim() != "")
{
checktext += "EPO,";
}
if (CheckboxLCard.Checked == true || SelectBoxLcard.Text.Trim() != "")
{
checktext += "左卡,";
}
if (CheckboxMecobalamin.Checked == true || SelectBoxMecobalamin.Text.Trim() != "")
{
checktext += "甲钴铵,";
}
if (CheckboxIron.Checked == true || SelectBoxIron.Text.Trim() != "")
{
checktext += "铁剂,";
}
if (CheckboxCalcitriol.Checked == true || SelectBoxCalcitriol.Text.Trim() != "")
{
checktext += "溉醇,";
}
if (CheckboxSodium.Checked == true || SelectBoxSodium.Text.Trim() != "")
{
checktext += "透析液钠,";
}
if (CheckboxCalcitriol.Checked == true || SelectBoxCalcitriol.Text.Trim() != "")
{
checktext += "透析液钾,";
}
sql = "UPDATE clinical1_nurse a ";
sql += " SET a.cln1_col1 = '" + Common.GetComboBoxText(cbo_diagnosis) + "',";
sql += " a.cln1_col2 = '" + bedno.Text + "',";
sql += " a.cln1_col3 = '" + cbo_dialysis_type.Text + "',";
sql += " a.cln1_col4 = '" + hpack.Text + "',";
sql += " a.cln1_col5 = '" + txt_weight_before.Text + "',";
sql += " a.cln1_col6 = '" + txt_weight_after_expect.Text + "',";
sql += " a.cln1_col7 = '" + TextField3.Text + "',";
if (txt_weight_after.Text != "")
{
sql += " a.cln1_col8 = '" + txt_weight_after.Text + "',";
}
sql += " a.cln1_col9 = '" + info_date1.Text + "',";
sql += " a.cln1_col10 = '" + TextField5.Text + "',";
sql += " a.cln1_col11 = '" + TextField6.Text + "',";
sql += " a.cln1_col12 = '" + TextField7.Text + "',";
sql += " a.cln1_col13 = '" + TextFirst.Text + "',";
sql += " a.cln1_col14 = '" + TextAdd.Text + "',";
sql += " a.cln1_col15 = '" + SelectBox10.Text + "',";
if (checktext.Length > 1)
{
sql += " a.cln1_col16 = '" + checktext.Substring(1) + "',";
}
else
{
sql += " a.cln1_col16 = '',";
}
sql += " a.cln1_col17 = '" + TextAmount.Text + "',";
sql += " a.cln1_col19 = '" + TextReplaceAmount.Text + "',"; //置換量
sql += " a.cln1_col20 = '" + TextField12.Text + "',";
sql += " a.cln1_col21 = '" + TextField13.Text + "',";
//sql += " a.cln1_col22 = '" + TextField14.Text + "',";
sql += " a.cln1_col25 = '" + TextField131.Text + "',";
sql += " a.cln1_col23 = '" + TextArea1.Text + "',";
sql += " a.cln1_col26 = '" + Common.GetComboBoxText(cbo_mechine_model) + "', ";
sql += " a.cln1_col28 = '" + Common.GetComboBoxText(SelectBoxEPO) + "', ";
sql += " a.cln1_col29 = '" + Common.GetComboBoxText(SelectBoxLcard) + "', ";
sql += " a.cln1_col30 = '" + Common.GetComboBoxText(SelectBoxMecobalamin) + "', ";
sql += " a.cln1_col31 = '" + Common.GetComboBoxText(SelectBoxIron) + "', ";
sql += " a.cln1_col32 = '" + Common.GetComboBoxText(SelectBoxCalcitriol) + "', ";
sql += " a.cln1_col33 = '" + TextField23.Text + "',";
if (cbo_hpack3.Text == "")
{
sql += "a.cln1_col27 = '血管路', ";
}
else
{
sql += "a.cln1_col27 = '" + Common.GetComboBoxText(cbo_hpack3) + "', ";
}
sql += " a.cln1_col34 = '" + Common.GetComboBoxText(cbo_h_type) + "',";
sql += " a.cln1_col35 = '" + TextCln1_col35.Text + "',";
//sql += " a.cln1_col36 = '" + TextField25.Text + "',";
sql += " a.cln1_col37 = '" + Common.GetComboBoxText(SelectBoxSodium) + "', ";
sql += " a.cln1_col38 = '" + Common.GetComboBoxText(SelectBoxPotassium) + "', ";
sql += " a.cln1_user = '',";
sql += " a.cln1_dateadded = '' ";
sql += "WHERE a.cln1_patic = '" + patient_id.Text + "' ";
sql += " AND a.cln1_diadate = '" + info_date1.Text + "' ";
db.Excute(sql);
//更新clinical1_nurse_xian
sql = "SELECT cln1_diadate FROM clinical1_nurse_xian ";
sql += "WHERE cln1_patic = '" + patient_id.Text + "' AND cln1_diadate = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical1_nurse_xian ";
sql += " SET cln1_col11 = '" + TextField2.Text + "',";
sql += " cln1_col12 = '" + TextField4.Text + "',";
sql += " cln1_col21 = '" + TextField9.Text + "',";
sql += " cln1_col22 = '" + TextField10.Text + "', ";
sql += " cln1_col31 = '" + TextField11.Text + "',";
sql += " cln1_col32 = '" + TextField15.Text + "' ";
sql += "WHERE cln1_patic = '" + patient_id.Text + "' ";
sql += " AND cln1_diadate = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT into clinical1_nurse_xian(cln1_patic,cln1_diadate,";
sql += "cln1_col11,cln1_col12,cln1_col21" + ",";
sql += "cln1_col22,cln1_col31,cln1_col32" + ") ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "','";
sql += TextField2.Text + "','" + TextField4.Text + "','" + TextField9.Text + "','";
sql += TextField10.Text + "','" + TextField11.Text + "','" + TextField15.Text + "')";
}
db.Excute(sql);
//更新pat_info
sql = "UPDATE pat_info " +
"SET pif_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pif_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pif_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pif_ic='" + patient_id.Text + "' ";
db.Excute(sql);
//更新pat_visit
sql = "UPDATE pat_visit " +
"SET pv_macno='" + Common.GetComboBoxValue(cbo_dialysis_type) + "', " +
"pv_weight='" + txt_weight_before.Text + "', " +
"pv_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pv_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pv_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pv_ic='" + patient_id.Text + "' " +
"AND pv_datevisit='" + info_date1.Text + "' ";
db.Excute(sql);
sql = "SELECT * FROM clinical3_nurse ";
sql += " where cln3_patic = '" + patient_id.Text + "' ";
sql += " and cln3_date = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical3_nurse ";
sql += "SET cln3_doc1 = '" + TextField23.Text + "', ";
sql += " cln3_nur1 = '" + TextField13.Text + "' ";
sql += "WHERE cln3_patic = '" + patient_id.Text + "' ";
sql += "AND cln3_date = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT INTO clinical3_nurse(cln3_patic,cln3_date,cln3_doc1,cln3_nur1) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "','" + TextField23.Text + "','" + TextField13.Text + "')";
}
CheckcboValue();
Common._NotificationShow("<font size=4>储存成功!</font>");
}
}
protected void cmdSAVE(object sender, DirectEventArgs e)
{
try {
string SQLT_APPOINTMENT_SEL = @"
SELECT apptst_patrefid, apptst_patic, apptst_daytyp FROM appointment_setup
WHERE apptst_flr='{0}' AND apptst_sec='{1}' AND apptst_bed='{2}' AND apptst_timetyp='{3}' and apptst_daytyp='{4}';";
string SQLT_APPOINTMENT_CHANGE_SEL = @"SELECT * FROM appointment_change
WHERE ah_date='{0}' AND ah_flr='{1}' AND ah_sec='{2}' AND ah_bed='{3}' AND ah_timetyp='{4}';";
string SQLT_APPOINTMENT_CHANGE_UPDATE = @"UPDATE appointment_change
SET ah_patic = '{0}'
WHERE ah_date='{1}' AND ah_flr='{2}' AND ah_sec='{3}' AND ah_bed='{4}' AND ah_timetyp='{5}';";
string SQLT_APPOINTMENT_CHANGE_INSERT = @"INSERT INTO appointment_change (ah_date, ah_patic, ah_flr, ah_sec, ah_bed, ah_mactyp, ah_timetyp, ah_stat, ah_dycnt)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', 'N', '{7}');";
ChangeRecords <BedWeeklySchedule> recs = new StoreDataHandler(e.ExtraParams["data"]).BatchObjectData <BedWeeklySchedule>();
foreach (BedWeeklySchedule curBed in recs.Updated)
{
// analysis if patient changed from Monday to Sunday
int iweek = GetWeekNo() + 1;
for (int i = iweek; i <= 7; i++) //大於或等於今天日期才可以換床
{
BedWeeklySchedule.Patient TmpPatient = null;
BedWeeklySchedule.Patient newPatient = null;
switch (i)
{
case 1:
TmpPatient = curBed.Week1;
break;
case 2:
TmpPatient = curBed.Week2;
break;
case 3:
TmpPatient = curBed.Week3;
break;
case 4:
TmpPatient = curBed.Week4;
break;
case 5:
TmpPatient = curBed.Week5;
break;
case 6:
TmpPatient = curBed.Week6;
break;
case 7:
TmpPatient = curBed.Week7;
break;
default:
break;
}
if (TmpPatient.Name.Contains("(s)") == false)
{
newPatient = TmpPatient;
// original patient state before saving(combine patient in appointment_setup & appointment_change
// patient in appointment_setup table
string oldPatientId = null;
DateTime dtCurAnalysis = GetDateTimeFromDayType(i);
string sql = string.Format(SQLT_APPOINTMENT_SEL,
curBed.Floor,
curBed.Area,
curBed.BedNo,
curBed.TimeType,
i.ToString()
);
DataTable dtAppointSetup = db.Query(sql);
// patient in appointment_change table
string dateStringChange = GetDateTimeFromDayType(i).ToString("yyyy-MM-dd");
string sqlChange = string.Format(SQLT_APPOINTMENT_CHANGE_SEL,
dateStringChange,
curBed.Floor,
curBed.Area,
curBed.BedNo,
curBed.TimeType
);
DataTable dtChange = db.Query(sqlChange);
// get real patient state here. (the state before saving)
DataRow drChg = null;
if (dtChange.Rows.Count > 0)
{
drChg = dtChange.Rows[0];
oldPatientId = drChg["ah_patic"].ToString();
}
else
{
if (dtAppointSetup.Rows.Count > 0)
{
oldPatientId = dtAppointSetup.Rows[0]["apptst_patic"].ToString();
}
else
{
oldPatientId = ""; // no patient
}
}
// patient changed
if (newPatient.Id != oldPatientId)
{
// we already have record in the appointment change table
if (drChg != null)
{
string sqlUpdate = string.Format(SQLT_APPOINTMENT_CHANGE_UPDATE,
newPatient.Id,
dateStringChange,
curBed.Floor,
curBed.Area,
curBed.BedNo,
curBed.TimeType);
db.Excute(sqlUpdate);
}
else
{
// not exist in appoint_change table, insert it
string sqlInsert = string.Format(SQLT_APPOINTMENT_CHANGE_INSERT,
dateStringChange,
newPatient.Id,
curBed.Floor,
curBed.Area,
curBed.BedNo,
curBed.MachineType,
curBed.TimeType,
i.ToString());
db.Excute(sqlInsert);
}
}
}
}
}
Load_Appointment();
} catch (Exception ex) {
Common._ErrorMsgShow(ex.Message.ToString());
}
}
//2015.01.20 andy 短期醫囑:增加給藥方式 執行護士
//2015.04.16 andy
protected void Btn_save_drg_Click(object sender, DirectEventArgs e)
{
// DBMysql db = new DBMysql();
string sql;
string ildrgcode;
//if (cbo_druggrp.Text == "" || cbo_druglist.Text == "" || txt_ordcount.Text == "" ||
// cmd_medway.Text == "" || cmb_ordfreq.Text == "" || txt_nuser_stfcode.Text == "")
if (cbo_druggrp.Text == "" || cbo_druglist.Text == "" || txt_ordcount.Text == "" ||
cmd_medway.Text == "" || cmb_ordfreq.Text == "")
{
Common._ErrorMsgShow("注意 : *注记为 '必填栏位' ");
return;
}
string sql2 = "SELECT drg_code ";
sql2 += "FROM drug_list ";
sql2 += "WHERE drg_name = '" + cbo_druglist.Text + "'";
DataTable dt2 = db.Query(sql2);
if (dt2.Rows.Count != 0)
{
ildrgcode = dt2.Rows[0]["drg_code"].ToString();
}
else
{
ildrgcode = "";
}
//2015.01.20 04.22 andy 護士工號
//string sql3 = "";
//string wacclv_id = "";
//sql3 = " select acclv_id from access_level where acclv_stfcode = '" + txt_nuser_stfcode.Text + "' ";
//DataTable dt3 = db.Query(sql3);
//if (dt3.Rows.Count != 0)
//{
// wacclv_id = dt3.Rows[0]["acclv_id"].ToString();
//}
//else
//{
// bs._ErrorMsgShow("注意.护士工号未填或不存在!");
// return;
//}
//2015.01.20 04.22 andy 護士工號
//string sql5 = "";
//sql5 = "SELECT a.associate_id,a.associate_active";
//sql5 += " FROM associate_list a ";
//sql5 += " WHERE a.associate_id = '" + wacclv_id + "'";
//sql5 += " AND a.associate_active ='A" + "'";
//DataTable dt5 = db.Query(sql5);
//if (dt5.Rows.Count == 0)
//{
// bs._NotificationShow("此工號已關閉，请重新输入!");
// return;
//}
//2015.01.20 andy 增加 給藥方式(med_medway) 執行護士(txt_nuser_stfcode):之前是傳空值 (護士姓名 與備註串一起)
//txt_ordremark.Text = txt_ordremark.Text + " ,護士姓名:" + txt_nuser_name.Text ;
//txt_ordremark.Text = txt_ordremark.Text + " " + txt_nuser_name.Text;
txt_ordremark.Text = txt_ordremark.Text;
sql = "INSERT INTO shortterm_ordermgt(shord_patic,shord_dateord,shord_timeord,shord_usr1,shord_drug,shord_actst,shord_dtactst,shord_usr2,shord_comment,shord_intake,shord_freq,shord_nurs,shord_medway) ";
sql += "VALUES('" + patient_id.Text + "','" + txt_orddate.Text + "','" + txt_ordtime.Text + "','" + txt_orddoc.Text;
sql += "','" + ildrgcode + "','00001','','','" + txt_ordremark.Text + "','" + txt_ordcount.Text + "','" + cmb_ordfreq.Text + "','','" + cmd_medway.Text + "')";
//sql += "','" + ildrgcode + "','00001','','','" + txt_ordremark.Text + "','" + txt_ordcount.Text + "','" + cmb_ordfreq.Text + "','" + txt_nuser_stfcode.Text + "','" + cmd_medway.Text + "')";
db.Excute(sql);
Show_shortdrughistory();
txt_ordtime.Text = DateTime.Now.ToString("HH:mm");
txt_ordcount.Text = "";
txt_ordremark.Text = "";
cmb_ordfreq.Text = "";
}
protected void Btn_save_Click(object sender, DirectEventArgs e)
{
string sql = "SELECT a.* ", scln3_bld = "1";
// 2015年7月27日 下午 01:20:23 svn Revision: 3122 當時或之前.
// ipad 净化过程小结 與 pc版血透 myhaisv4 净化过程小结 各唱各的調
// ipad 將 血压 寫在 clinical3_nurse 資料表 cln3_pressure 欄位
// pc版血透myhaisv4 將 血压 寫在 clinical3_nurse 資料表 cln3_bld 欄位
switch (Common.GetComboBoxText(cbo_pressure))
{
case "基本正常":
scln3_bld = "1";
break;
case "较高":
scln3_bld = "2";
break;
case "较低":
scln3_bld = "3";
break;
default:
throw new Exception("GetComboBoxText cbo_pressure failure");
}
sql += " FROM clinical3_nurse a ";
sql += " where a.cln3_patic = '" + patient_id.Text + "' ";
sql += " and a.cln3_date = '" + info_date1.Text + "' ";
DataTable dt = db.Query(sql);
if (dt.Rows.Count == 1)
{
sql = "UPDATE clinical3_nurse b ";
sql += "set b.cln3_date = '" + info_date1.Text + "',";
sql += " b.cln3_time = '" + ttt.Text + "',";
sql += " b.cln3_rmk = '" + TextField4.Text + "',";
sql += " b.cln3_a1 = '" + TextField5.Text + "',";
sql += " b.cln3_a2 = '" + TextField6.Text + "',";
sql += " b.cln3_b1 = '" + TextField7.Text + "',";
sql += " b.cln3_b2 = '" + TextField8.Text + "',";
sql += " b.cln3_ysa = '" + Common.GetComboBoxText(cbo_symptom) + "',";
sql += " b.cln3_pressure = '" + Common.GetComboBoxText(cbo_pressure) + "',";
sql += " b.cln3_bld = '";
sql += scln3_bld;
sql += "', ";
sql += " b.cln3_yn = '" + (Common.GetComboBoxText(cbo_symptom) == "无症状" ? "N" : "Y");
sql += "', ";
sql += " b.cln3_rmk2 = '" + TextArea2.Text + "' ";
//sql += " b.cln3_doc1 = '" + TextField9.Text + "',";
//sql += " b.cln3_nur1 = '" + TextField10.Text + "' ";
sql += " where b.cln3_patic = '" + patient_id.Text + "' ";
sql += " AND b.cln3_date = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT into clinical3_nurse(cln3_patic,cln3_date,cln3_time," +
"cln3_a1,cln3_a2,cln3_b1,cln3_b2," +
"cln3_CatheterAccess,cln3_MuscleAtrophy,cln3_ysa,cln3_pressure,cln3_DialysisMachine,cln3_HeparinPumpArtery,cln3_HeparinPumpVein," +
"cln3_bld,cln3_yn,cln3_rmk2,cln3_rmk) "; //
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "','" + ttt.Text + "'," +
"'" + TextField5.Text + "','" + TextField6.Text + "','" + TextField7.Text + "','" + TextField8.Text + "'," +
"'',''," +
"'" + Common.GetComboBoxText(cbo_symptom) + "','" + Common.GetComboBoxText(cbo_pressure) + "'," +
"'','','','";
sql += scln3_bld;
sql += "','";
sql += Common.GetComboBoxText(cbo_symptom) == "无症状" ? "N" : "Y";
sql += "','" + TextArea2.Text + "','" + TextField4.Text + "')";
}
db.Excute(sql);
Common._NotificationShow("储存成功!");
}
protected void Btn_save_Click(object sender, DirectEventArgs e)
{
string sql;
DataTable dt;
if (cbo_mechine_model.Text.Trim() == "")
{
ErrorMsgShow("请输入透析器型号!");
return;
}
else if (cbo_h_type.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入血管通路!");
return;
}
else
{
string checktext = ",";
if (SelectBoxEPO.Text.Trim() != "")
{
checktext += "EPO,";
}
if (SelectBoxLcard.Text.Trim() != "")
{
checktext += "左卡,";
}
if (SelectBoxFe.Text.Trim() != "")
{
checktext += "铁剂,";
}
if (SelectBoxCalcitriol.Text.Trim() != "")
{
checktext += "骨化三醇,";
}
if (SelectBoxMethycobal.Text.Trim() != "")
{
checktext += "弥可保,";
}
if (SelectBoxB12.Text.Trim() != "")
{
checktext += "维生素B12";
}
sql = "UPDATE clinical1_nurse a ";
sql += " SET a.cln1_col1 = '" + Common.GetComboBoxText(cbo_diagnosis) + "',";
sql += " a.cln1_col2 = '" + bedno.Text + "',";
sql += " a.cln1_col3 = '" + cbo_dialysis_type.Text + "',";
sql += " a.cln1_col4 = '" + hpack.Text + "',";
sql += " a.cln1_col5 = '" + txt_weight_before.Text + "',";
sql += " a.cln1_col6 = '" + txt_weight_after_expect.Text + "',";
sql += " a.cln1_col7 = '" + TextField3.Text + "',";
if (txt_weight_after.Text != "")
{
sql += " a.cln1_col8 = '" + txt_weight_after.Text + "',";
}
sql += " a.cln1_col9 = '" + info_date1.Text + "',";
sql += " a.cln1_col10 = '" + TextField5.Text + "',";
sql += " a.cln1_col11 = '" + TextField6.Text + "',";
sql += " a.cln1_col12 = '" + TextField7.Text + "',";
sql += " a.cln1_col13 = '" + TextField8.Text + "',";
sql += " a.cln1_col14 = '" + TextField9.Text + "',";
sql += " a.cln1_col15 = '" + TextField10.Text + "',";
if (checktext.Length > 1)
{
sql += " a.cln1_col16 = '" + checktext.Substring(1) + "',";
}
else
{
sql += " a.cln1_col16 = '',";
}
sql += " a.cln1_col28 = '" + SelectBoxEPO.Text + "',";
sql += " a.cln1_col29 = '" + SelectBoxLcard.Text + "',";
sql += " a.cln1_col30 = '" + SelectBoxFe.Text + "',";
sql += " a.cln1_col31 = '" + SelectBoxCalcitriol.Text + "',";
sql += " a.cln1_col32 = '" + SelectBoxMethycobal.Text + "',";
sql += " a.cln1_col37 = '" + SelectBoxB12.Text + "',";
sql += " a.cln1_col30q = 0,";
sql += " a.cln1_col31q = 0,";
sql += " a.cln1_col32q = 0,";
sql += " a.cln1_col17 = '" + cbo_SelDialysisNa.Text + "',";
sql += " a.cln1_col18 = '',";
sql += " a.cln1_col19 = '" + TextField11.Text + "',";
sql += " a.cln1_col20 = '',";
sql += " a.cln1_col21 = '" + TextField13.Text + "',";
sql += " a.cln1_col22 = '',";
sql += " a.cln1_col25 = '" + TextField131.Text + "',";
sql += " a.cln1_col23 = '" + TextArea1.Text + "',";
sql += " a.cln1_col26 = '" + Common.GetComboBoxText(cbo_mechine_model) + "', ";
sql += " a.cln1_col33 = '" + TextField23.Text + "',";
if (cbo_hpack3.Text == "")
{
sql += "a.cln1_col27 = '血管路', ";
}
else
{
sql += "a.cln1_col27 = '" + Common.GetComboBoxText(cbo_hpack3) + "', ";
}
sql += " a.cln1_col34 = '" + Common.GetComboBoxText(cbo_h_type) + "',";
sql += " a.cln1_col35 = '" + TextField24.Text + "',";
sql += " a.cln1_col36 = '',";
sql += " a.cln1_user = '',";
sql += " a.cln1_dateadded = '" + TextTotalCap.Text + "' ";
sql += "WHERE a.cln1_patic = '" + patient_id.Text + "' ";
sql += " AND a.cln1_diadate = '" + info_date1.Text + "' ";
db.Excute(sql);
//更新pat_info
sql = "UPDATE pat_info " +
"SET pif_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pif_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pif_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pif_ic='" + patient_id.Text + "' ";
db.Excute(sql);
//更新pat_visit
sql = "UPDATE pat_visit " +
"SET pv_macno='" + Common.GetComboBoxValue(cbo_dialysis_type) + "', " + //透析方式
"pv_weight='" + txt_weight_before.Text + "', " +
"pv_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pv_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pv_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pv_ic='" + patient_id.Text + "' " +
"AND pv_datevisit='" + info_date1.Text + "' ";
db.Excute(sql);
sql = "SELECT * FROM clinical3_nurse ";
sql += " where cln3_patic = '" + patient_id.Text + "' ";
sql += " and cln3_date = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical3_nurse SET ";
sql += "cln3_CatheterAccess = '" + TextFieldCatheterAccess.Text + "',";
sql += "cln3_MuscleAtrophy = '" + TextFieldMuscleAtrophy.Text + "',";
sql += "cln3_DialysisMachine = '" + Common.GetComboBoxText(cbo_DialysisMachine) + "',";
sql += "cln3_HeparinPumpArtery = '" + Common.GetComboBoxText(cbo_HeparinPump_a) + "',";
sql += "cln3_HeparinPumpVein = '" + Common.GetComboBoxText(cbo_HeparinPump_v) + "' ";
sql += "WHERE cln3_patic = '" + patient_id.Text + "' AND cln3_date='" + info_date1.Text + "' ";
}
else
{
sql = "INSERT INTO clinical3_nurse(cln3_patic, cln3_date, cln3_CatheterAccess, cln3_MuscleAtrophy, cln3_DialysisMachine, cln3_HeparinPumpArtery, cln3_HeparinPumpVein) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "',";
sql += "'" + TextFieldCatheterAccess.Text + "',";
sql += "'" + TextFieldMuscleAtrophy.Text + "',";
sql += "'" + Common.GetComboBoxText(cbo_DialysisMachine) + "',";
sql += "'" + Common.GetComboBoxText(cbo_HeparinPump_a) + "',";
sql += "'" + Common.GetComboBoxText(cbo_HeparinPump_v) + "')";
}
db.Excute(sql);
CheckcboValue();
Common._NotificationShow("<font size=4>储存成功!</font>");
db.myConnection.Close();
}
}
protected void Btn_save_Click(object sender, DirectEventArgs e)
{
string sql;
DataTable dt;
if (cbo_mechine_model.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入透析器型号!");
return;
}
else if (cbo_h_type.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入血管通路!");
return;
}
else
{
try //深静脉置管
{
if (Radio11.Checked == true)
{
Col11 = Radio11.InputValue;
coltext11 = "";
}
else if (Radio12.Checked == true)
{
Col11 = Radio12.InputValue;
coltext11 = "";
}
else if (Radio13.Checked == true)
{
Col11 = Radio13.InputValue;
coltext11 = RField1.Text;
}
if (Radio21.Checked == true)
{
Col21 = Radio21.InputValue;
coltext21 = "";
}
else if (Radio22.Checked == true)
{
Col21 = Radio22.InputValue;
coltext21 = RField2.Text;
}
if (Radio31.Checked == true)
{
Col31 = Radio31.InputValue;
coltext31 = "";
}
else if (Radio32.Checked == true)
{
Col31 = Radio32.InputValue;
coltext31 = RField3.Text;
}
if (Radio41.Checked == true)
{
Col41 = Radio41.InputValue;
coltext41 = "";
}
else if (Radio42.Checked == true)
{
Col41 = Radio42.InputValue;
coltext41 = RField4.Text;
}
if (Radio51.Checked == true)
{
Col50 = Radio51.InputValue;
}
else if (Radio52.Checked == true)
{
Col50 = Radio52.InputValue;
}
//DBMysql db = new DBMysql();
sql = "SELECT cln1_diadate FROM clinical1_nurse_suzhou ";
sql += "WHERE cln1_patic = '" + patient_id.Text + "' AND cln1_diadate = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical1_nurse_suzhou SET ";
sql += "cln1_col11 = '" + Col11 + "',";
sql += "cln1_col12 = '" + coltext11 + "',";
sql += "cln1_col21 = '" + Col21 + "',";
sql += "cln1_col22 = '" + coltext21 + "',";
sql += "cln1_col31 = '" + Col31 + "',";
sql += "cln1_col32 = '" + coltext31 + "',";
sql += "cln1_col41 = '" + Col41 + "',";
sql += "cln1_col42 = '" + coltext41 + "',";
sql += "cln1_col50 = '" + Col50 + "' ";
sql += "WHERE cln1_patic = '" + patient_id.Text + "' AND cln1_diadate = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT INTO clinical1_nurse_suzhou (cln1_patic, cln1_diadate,";
sql += "cln1_col11, cln1_col12, cln1_col21, cln1_col22, cln1_col31, cln1_col32, cln1_col41, cln1_col42, cln1_col50) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "',";
sql += "'" + Col11 + "','" + coltext11 + "',";
sql += "'" + Col21 + "','" + coltext21 + "',";
sql += "'" + Col31 + "','" + coltext31 + "',";
sql += "'" + Col41 + "','" + coltext41 + "',";
sql += "'" + Col50 + "')";
}
db.Excute(sql); //深静脉置管
}
catch //深静脉置管，儲存失敗
{
}
if (TextCheckbox3q.Text == "")
{
TextCheckbox3q.Text = "0";
}
if (TextCheckbox4q.Text == "")
{
TextCheckbox4q.Text = "0";
}
if (TextCheckbox5q.Text == "")
{
TextCheckbox5q.Text = "0";
}
string checktext = ",";
if (Checkbox1.Checked == true && SelectBoxEPO.Text != "")
{
checktext += "EPO,";
}
if (Checkbox2.Checked == true && TextCheckbox2.Text != "" && TextCheckbox2.Text != "0")
{
checktext += "左卡,";
}
if (Checkbox3.Checked == true && SelectCheckbox3.Text != "")
{
checktext += "钙剂,";
}
if (Checkbox4.Checked == true && SelectCheckbox4.Text != "")
{
checktext += "稀释液,";
}
if (Checkbox5.Checked == true && SelectCheckbox5.Text != "")
{
checktext += "其它";
}
sql = "UPDATE clinical1_nurse a ";
sql += " SET a.cln1_col1 = '" + Common.GetComboBoxText(cbo_diagnosis) + "',";
sql += " a.cln1_col2 = '" + bedno.Text + "',";
sql += " a.cln1_col3 = '" + cbo_dialysis_type.Text + "',";
sql += " a.cln1_col4 = '" + hpack.Text + "',";
sql += " a.cln1_col5 = '" + txt_weight_before.Text + "',";
sql += " a.cln1_col6 = '" + txt_weight_after_expect.Text + "',";
sql += " a.cln1_col7 = '" + TextField3.Text + "',";
if (txt_weight_after.Text != "")
{
sql += " a.cln1_col8 = '" + txt_weight_after.Text + "',";
}
sql += " a.cln1_col9 = '" + info_date1.Text + "',";
sql += " a.cln1_col10 = '" + TextField5.Text + "',";
sql += " a.cln1_col11 = '" + TextField6.Text + "',";
sql += " a.cln1_col12 = '" + TextField7.Text + "',";
sql += " a.cln1_col13 = '" + TextField8.Text + "',";
sql += " a.cln1_col14 = '" + TextField9.Text + "',";
sql += " a.cln1_col15 = '" + TextField10.Text + "',";
if (checktext.Length > 1)
{
sql += " a.cln1_col16 = '" + checktext.Substring(1) + "',";
}
else
{
sql += " a.cln1_col16 = '',";
}
sql += " a.cln1_col28 = '" + SelectBoxEPO.Text.Replace("'", "''") + "',";
sql += " a.cln1_col29 = '" + TextCheckbox2.Text + "',";
sql += " a.cln1_col30 = '" + SelectCheckbox3.Text + "',";
sql += " a.cln1_col31 = '" + SelectCheckbox4.Text + "',";
sql += " a.cln1_col32 = '" + SelectCheckbox5.Text + "',";
if (TextCheckbox3q.Text == "")
{
TextCheckbox3q.Text = "0";
}
if (TextCheckbox4q.Text == "")
{
TextCheckbox4q.Text = "0";
}
if (TextCheckbox5q.Text == "")
{
TextCheckbox5q.Text = "0";
}
sql += " a.cln1_col30q = " + TextCheckbox3q.Text + ",";
sql += " a.cln1_col31q = " + TextCheckbox4q.Text + ",";
sql += " a.cln1_col32q = " + TextCheckbox5q.Text + ",";
sql += " a.cln1_col17 = '" + SelectBox3.Text + "',";
sql += " a.cln1_col18 = '" + Common.GetComboBoxText(cbo_change_type) + "',";
sql += " a.cln1_col19 = '" + TextField11.Text + "',";
sql += " a.cln1_col20 = '" + TextField12.Text + "',";
sql += " a.cln1_col21 = '" + TextField13.Text + "',";
sql += " a.cln1_col22 = '" + TextField14.Text + "',";
sql += " a.cln1_col25 = '" + TextField131.Text + "',";
sql += " a.cln1_col23 = '" + TextArea1.Text + "',";
sql += " a.cln1_col26 = '" + Common.GetComboBoxText(cbo_mechine_model) + "', ";
sql += " a.cln1_col33 = '" + TextField23.Text + "',";
if (cbo_hpack3.Text == "")
{
sql += "a.cln1_col27 = '血管路', ";
}
else
{
sql += "a.cln1_col27 = '" + Common.GetComboBoxText(cbo_hpack3) + "', ";
}
sql += " a.cln1_col34 = '" + Common.GetComboBoxText(cbo_h_type) + "',";
sql += " a.cln1_col35 = '" + TextField24.Text + "',";
sql += " a.cln1_col36 = '" + TextField25.Text + "',";
sql += " a.cln1_user = '',";
sql += " a.cln1_dateadded = ''";
sql += "WHERE a.cln1_patic = '" + patient_id.Text + "' ";
sql += " AND a.cln1_diadate = '" + info_date1.Text + "' ";
db.Excute(sql);
//更新pat_info
sql = "UPDATE pat_info " +
"SET pif_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pif_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pif_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pif_ic='" + patient_id.Text + "' ";
db.Excute(sql);
//更新pat_visit
sql = "UPDATE pat_visit " +
"SET pv_macno='" + Common.GetComboBoxValue(cbo_dialysis_type) + "', " +
"pv_weight='" + txt_weight_before.Text + "', " +
"pv_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pv_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pv_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pv_ic='" + patient_id.Text + "' " +
"AND pv_datevisit='" + info_date1.Text + "' ";
db.Excute(sql);
sql = "SELECT * FROM clinical3_nurse ";
sql += " where cln3_patic = '" + patient_id.Text + "' ";
sql += " and cln3_date = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical3_nurse ";
sql += "SET cln3_doc1 = '" + TextField23.Text + "', ";
sql += " cln3_nur1 = '" + TextField25.Text + "' ";
sql += "WHERE cln3_patic = '" + patient_id.Text + "' ";
sql += "AND cln3_date = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT INTO clinical3_nurse(cln3_patic,cln3_date,cln3_doc1,cln3_nur1) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "','" + TextField23.Text + "','" + TextField25.Text + "')";
}
CheckcboValue();
Common._NotificationShow("<font size=4>储存成功!</font>");
}
}
protected void Btn_save_Click(object sender, DirectEventArgs e)
{
string sql;
DataTable dt;
if (cbo_mechine_model.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入透析器型号!");
return;
}
else if (cbo_h_type.Text.Trim() == "")
{
Common._ErrorMsgShow("请输入血管通路!");
return;
}
string checktext = ",";
if (Checkbox1.Checked == true)
{
checktext += "EPO,";
}
if (Checkbox2.Checked == true)
{
checktext += "左卡,";
}
if (Checkbox3.Checked == true)
{
checktext += "铁剂,";
}
if (Checkbox4.Checked == true)
{
checktext += "钙剂,";
}
if (Checkbox5.Checked == true)
{
checktext += "抗菌素/其它";
}
sql = "SELECT a.cln1_diadate FROM clinical1_nurse a ";
sql += "WHERE a.cln1_patic = '" + patient_id.Text + "' AND a.cln1_diadate = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical1_nurse a ";
sql += " SET a.cln1_col1 = '" + Common.GetComboBoxText(cbo_diagnosis) + "',";
sql += " a.cln1_col2 = '" + bedno.Text + "',";
sql += " a.cln1_col3 = '" + machine_type.Text + "',";
sql += " a.cln1_col4 = '" + hpack.Text + "',";
sql += " a.cln1_col5 = '" + txt_weight_before.Text + "',";
sql += " a.cln1_col6 = '" + txt_weight_after_expect.Text + "',";
sql += " a.cln1_col7 = '" + TextField3.Text + "',";
if (txt_weight_after.Text != "")
{
sql += " a.cln1_col8 = '" + txt_weight_after.Text + "',";
}
sql += " a.cln1_col9 = '" + info_date1.Text + "',";
sql += " a.cln1_col10 = '" + TextField5.Text + "',";
sql += " a.cln1_col11 = '" + TextField6.Text + "',";
sql += " a.cln1_col12 = '" + TextField7.Text + "',";
sql += " a.cln1_col13 = '" + TextField8.Text + "',";
sql += " a.cln1_col14 = '" + TextField9.Text + "',";
sql += " a.cln1_col15 = '" + TextField10.Text + "',";
if (checktext.Length > 1)
{
sql += " a.cln1_col16 = '" + checktext.Substring(1) + "',";
}
else
{
sql += " a.cln1_col16 = '',";
}
sql += " a.cln1_col28 = '',";
sql += " a.cln1_col29 = '',";
sql += " a.cln1_col30 = '',";
sql += " a.cln1_col31 = '',";
sql += " a.cln1_col32 = '" + TextCheckbox5.Text + "',";
sql += " a.cln1_col30q = 0,";
sql += " a.cln1_col31q = 0,";
sql += " a.cln1_col32q = 0,";
sql += " a.cln1_col17 = '" + SelectBox3.Text + "',";
sql += " a.cln1_col18 = '" + Common.GetComboBoxText(cbo_change_type) + "',";
sql += " a.cln1_col19 = '" + TextField11.Text + "',";
sql += " a.cln1_col20 = '" + TextField12.Text + "',";
sql += " a.cln1_col21 = '" + TextField13.Text + "',";
sql += " a.cln1_col22 = '',";
sql += " a.cln1_col25 = '" + TextField131.Text + "',";
sql += " a.cln1_col23 = '" + TextArea1.Text + "',";
sql += " a.cln1_col26 = '" + Common.GetComboBoxText(cbo_mechine_model) + "', ";
sql += " a.cln1_col33 = '" + TextField23.Text + "',";
if (cbo_hpack3.Text == "")
{
sql += "a.cln1_col27 = '血管路', ";
}
else
{
sql += "a.cln1_col27 = '" + Common.GetComboBoxText(cbo_hpack3) + "', ";
}
sql += " a.cln1_col34 = '" + Common.GetComboBoxText(cbo_h_type) + "',";
sql += " a.cln1_col35 = '" + TextField24.Text + "',";
sql += " a.cln1_col36 = '" + TextField25.Text + "',";
sql += " a.cln1_user = '',";
sql += " a.cln1_dateadded = ''";
sql += "WHERE a.cln1_patic = '" + patient_id.Text + "' ";
sql += " AND a.cln1_diadate = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT into clinical1_nurse(cln1_patic,cln1_diadate,";
sql += "cln1_col1,cln1_col2,cln1_col3,cln1_col4,cln1_col5,";
sql += "cln1_col6,cln1_col7,cln1_col8,cln1_col9,cln1_col10,";
sql += "cln1_col11,cln1_col12,cln1_col13,cln1_col14,cln1_col15,";
sql += "cln1_col16,cln1_col17,cln1_col18,cln1_col19,cln1_col20,";
sql += "cln1_col21,cln1_col22,cln1_col23,cln1_col24,cln1_col25,";
sql += "cln1_col26,cln1_col27,";
sql += "cln1_col28,cln1_col29,cln1_col30,cln1_col31,cln1_col32, cln1_col30q,cln1_col31q,cln1_col32q,"; //加上數量
sql += "cln1_col33,cln1_col34,cln1_col35,";
sql += "cln1_col36,cln1_user,cln1_dateadded) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "','";
sql += Common.GetComboBoxText(cbo_diagnosis) + "','" + bedno.Text + "','" + machine_type.Text + "','" + hpack.Text + "','" + txt_weight_before.Text + "','";
//sql += Common.GetComboBoxText(cbo_diagnosis) + "','" + bedno.Text + "','" + machine_type.Text + "','" + txt_weight_before.Text + "','";
sql += txt_weight_after_expect.Text + "','" + TextField3.Text + "','" + txt_weight_after.Text + "','" + info_date1.Text + "','" + TextField5.Text + "','";
sql += TextField6.Text + "','" + TextField7.Text + "','" + TextField8.Text + "','" + TextField9.Text + "','" + TextField10.Text + "','";
sql += checktext.Substring(1); //cln1_col16
sql += "','" + SelectBox3.Text + "','" + Common.GetComboBoxText(cbo_change_type) + "','" + TextField11.Text + "','" + TextField12.Text + "',";
sql += "'" + TextField13.Text + "','','" + TextArea1.Text + "','','',";
sql += "'" + Common.GetComboBoxText(cbo_mechine_model) + "','" + Common.GetComboBoxText(cbo_hpack3) + "',";
//擬用藥 EPO...Value
sql += "'','','','','" + TextCheckbox5.Text + "',0,0,0,";
//擬用藥
sql += "'" + TextField23.Text + "','" + Common.GetComboBoxText(cbo_h_type) + "','" + TextField24.Text + "',";
sql += "'" + TextField25.Text + "','','')";
}
db.Excute(sql);
//更新pat_info
sql = "UPDATE pat_info " +
"SET pif_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pif_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pif_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pif_ic='" + patient_id.Text + "' ";
db.Excute(sql);
//更新pat_visit
sql = "UPDATE pat_visit " +
"SET pv_macno='" + Common.GetComboBoxValue(cbo_dialysis_type) + "', " +
"pv_weight='" + txt_weight_before.Text + "', " +
"pv_hpack='" + Common.GetComboBoxValue(cbo_h_type) + "', " + //20160321 Alex
"pv_hpack2='" + Common.GetComboBoxValue(cbo_mechine_model) + "', " +
"pv_hpack3='" + Common.GetComboBoxValue(cbo_hpack3) + "' " + //20160321 Alex
"WHERE pv_ic='" + patient_id.Text + "' " +
"AND pv_datevisit='" + info_date1.Text + "' ";
db.Excute(sql);
sql = "SELECT * FROM clinical3_nurse ";
sql += " where cln3_patic = '" + patient_id.Text + "' ";
sql += " and cln3_date = '" + info_date1.Text + "' ";
dt = db.Query(sql);
if (dt.Rows.Count > 0)
{
sql = "UPDATE clinical3_nurse ";
sql += "SET cln3_doc1 = '" + TextField23.Text + "', ";
sql += " cln3_nur1 = '" + TextField25.Text + "' ";
sql += "WHERE cln3_patic = '" + patient_id.Text + "' ";
sql += "AND cln3_date = '" + info_date1.Text + "' ";
}
else
{
sql = "INSERT INTO clinical3_nurse(cln3_patic,cln3_date,cln3_doc1,cln3_nur1) ";
sql += "VALUES('" + patient_id.Text + "','" + info_date1.Text + "','" + TextField23.Text + "','" + TextField25.Text + "')";
}
CheckcboValue();
Common._NotificationShow("<font size=4>储存成功!</font>");
}
protected void SaveDataList(object sender, DirectEventArgs e)
{
string PationID = e.ExtraParams["PationID"];
string DialysisDate = e.ExtraParams["DialysisDate"];
string DialysisTime = e.ExtraParams["DialysisTime"];
string sql1 = "";
string sql0 = "SELECT dialysis_time, column_7, column_6, column_2, column_3, column_10, column_8, column_4 FROM data_list ";
sql0 += "WHERE person_id='" + PationID + "' ";
sql0 += "AND dialysis_date='" + DialysisDate + "' ";
sql0 += "AND dialysis_time='" + OldTime.Text + "'";
DataTable dt0 = db.Query(sql0);
if (dt0.Rows.Count > 0)
{
sql1 += "UPDATE data_list SET ";
sql1 += "dialysis_time='" + DialysisTime + "', ";
sql1 += "column_7='" + diagno.Text + "', ";
sql1 += "column_6='" + Column4.Text + "', ";
sql1 += "column_2='" + Column2.Text + "', ";
sql1 += "column_3='" + Column23.Text + "', ";
sql1 += "column_10='" + Column3.Text + "', ";
sql1 += "column_8='" + Column1.Text + "', ";
sql1 += "column_4='" + Column5.Text + "' ";
sql1 += "WHERE person_id='" + PationID + "' ";
sql1 += "AND dialysis_date='" + DialysisDate + "' ";
sql1 += "AND dialysis_time='" + OldTime.Text + "'; ";
}
else
{
dt0.Clear();
sql0 = "SELECT pv_floor, pv_bedno FROM pat_visit ";
sql0 += "WHERE pv_ic='" + PationID + "' ";
sql0 += "AND pv_datevisit='" + DialysisDate + "' ";
dt0 = db.Query(sql0);
string pv_floor = dt0.Rows[0]["pv_floor"].ToString();
string pv_bedno = dt0.Rows[0]["pv_bedno"].ToString();
sql1 += "INSERT INTO data_list ";
sql1 += "(person_id, dialysis_date, dialysis_time, floor_no, bed_no, column_7, column_6, column_2, column_10, column_8, column_4) ";
sql1 += "VALUES('" + PationID + "','" + DialysisDate + "','" + DialysisTime + "','" + pv_floor + "','" + pv_bedno + "','";
sql1 += diagno.Text + "','" + Column4.Text + "','" + Column2.Text + "','";
sql1 += Column3.Text + "','" + Column1.Text + "','" + Column5.Text + "'); ";
}
sql0 = "SELECT cln2_date, cln2_time, cln2_t, cln2_p, cln2_r, cln2_bp, cln2_rmk, cln2_user, cln2_dateadded FROM clinical2_nurse ";
sql0 += "WHERE cln2_patic='" + PationID + "' ";
sql0 += "AND cln2_date='" + DialysisDate + "' ";
sql0 += "AND cln2_time='" + OldTime.Text + "'";
dt0 = db.Query(sql0);
if (dt0.Rows.Count > 0)
{
sql1 += "UPDATE clinical2_nurse SET ";
sql1 += "cln2_time='" + DialysisTime + "', ";
sql1 += "cln2_t='" + Column6.Text + "', ";
sql1 += "cln2_p='" + Column7.Text + "', ";
sql1 += "cln2_r='" + Column8.Text + "', ";
sql1 += "cln2_bp='" + Column9.Text + "', ";
sql1 += "cln2_rmk='" + Column10.Text + "', ";
sql1 += "cln2_user='******' ";
sql1 += "WHERE cln2_patic='" + PationID + "' ";
sql1 += "AND cln2_date='" + DialysisDate + "' ";
sql1 += "AND cln2_time='" + OldTime.Text + "';";
}
else
{
sql1 += "INSERT INTO clinical2_nurse ";
sql1 += "(cln2_patic, cln2_date, cln2_time, cln2_t, cln2_p, cln2_r, cln2_bp, cln2_rmk, cln2_user) ";
sql1 += "VALUES('" + PationID + "','" + DialysisDate + "','" + DialysisTime + "','";
sql1 += Column6.Text + "','" + Column7.Text + "','" + Column8.Text + "','" + Column9.Text + "','";
sql1 += Column10.Text + "','" + Column11.Text + "')";
}
db.Excute(sql1);
this.DetailsWindow.Hide();
GridStore.Reload();
}
protected void Btn_Submit_Click(object sender, DirectEventArgs e)
{
DBMysql db = new DBMysql();
string checktext = "";
if (Checkbox1.Checked == true)
{
checktext += ",EPO";
}
if (Checkbox2.Checked == true)
{
checktext += ",左卡";
}
if (Checkbox3.Checked == true)
{
checktext += ",铁剂";
}
if (Checkbox4.Checked == true)
{
checktext += ",钙剂";
}
if (Checkbox5.Checked == true)
{
checktext += ",抗菌素/其它";
}
string sql = "update clinical1_nurse a,pat_info b ";
sql += "set a.cln1_col1 = '" + SelectBox1.Text.Replace("'", "''") + "',";
sql += "a.cln1_col2 = '" + TextField2.Text.Replace("'", "''") + "',";
sql += "a.cln1_col3 = '" + TextField3.Text.Replace("'", "''") + "',";
sql += "a.cln1_col34 = '" + TextField4.Text.Replace("'", "''") + "',";
sql += "a.cln1_col5 = '" + TextField5.Text.Replace("'", "''") + "',";
sql += "a.cln1_col6 = '" + TextField6.Text.Replace("'", "''") + "',";
sql += "a.cln1_col7 = '" + TextField7.Text.Replace("'", "''") + "',";
sql += "a.cln1_col8 = '" + TextField8.Text.Replace("'", "''") + "',";
//sql += "a.cln1_col9 = '" + TextField9.Text.Replace("'", "''") + "',";
sql += "a.cln1_col10 = '" + TextField10.Text.Replace("'", "''") + "',";
sql += "a.cln1_col11 = '" + TextField11.Text.Replace("'", "''") + "',";
sql += "a.cln1_col12 = '" + TextField12.Text.Replace("'", "''") + "',";
sql += "a.cln1_col13 = '" + TextField13.Text.Replace("'", "''") + "',";
sql += "a.cln1_col14 = '" + TextField14.Text.Replace("'", "''") + "',";
sql += "a.cln1_col15 = '" + TextField15.Text.Replace("'", "''") + "',";
if (checktext.Length > 1)
{
sql += "a.cln1_col16 = '" + checktext.Substring(1) + "',";
}
else
{
sql += "a.cln1_col16 = '',";
}
sql += "a.cln1_col28 = '" + TextCheckbox1.Text.Replace("'", "''") + "',";
sql += "a.cln1_col29 = '" + TextCheckbox2.Text.Replace("'", "''") + "',";
sql += "a.cln1_col30 = '" + TextCheckbox3.Text.Replace("'", "''") + "',";
sql += "a.cln1_col31 = '" + TextCheckbox4.Text.Replace("'", "''") + "',";
sql += "a.cln1_col32 = '" + TextCheckbox5.Text.Replace("'", "''") + "',";
sql += "a.cln1_col17 = '" + SelectBox3.Text + "',";
sql += "a.cln1_col18 = '" + SelectBox4.Text + "',";
sql += "a.cln1_col19 = '" + TextField18.Text.Replace("'", "''") + "',";
sql += "a.cln1_col20 = '" + TextField19.Text.Replace("'", "''") + "',";
sql += "a.cln1_col21 = '" + TextField20.Text.Replace("'", "''") + "',";
sql += "a.cln1_col22 = '" + TextField21.Text.Replace("'", "''") + "',";
sql += "a.cln1_col35 = '" + TextField17.Text.Replace("'", "''") + "',";
sql += "a.cln1_col36 = '" + TextField22.Text.Replace("'", "''") + "',";
sql += "a.cln1_col33 = '" + TextField23.Text.Replace("'", "''") + "',";
sql += "a.cln1_col23 = '" + TextArea1.Text.Replace("'", "''") + "' ";
sql += " WHERE b.pif_id = '" + _PAT_ID + "' ";
sql += " AND a.cln1_patic = b.pif_ic ";
sql += " AND a.cln1_diadate = '" + TextField9.Text + "' ";
db.Excute(sql);
Panel1.Hidden = true;
Grid_clinical1_nurse.Hidden = false;
show_grid();
//增加一筆常規記錄zinfo_e_01 Andy 20150601
//1.hpack2_setup 透析機器型號設置
//2.clinical1_nurs 血液淨化紀錄
//3.clinical2_nurse 血液淨化過程明細
//4.a_result_log 檢驗記錄檔
//1.透析機器型號設置 hp2_id資料序號:key 自動
DataTable dt;
string sSQL = "";
string w_opt_11 = "";
string w_pif_ic = "";
sSQL = "SELECT * FROM pat_info " +
"LEFT JOIN hpack2_setup " +
"ON pat_info.pif_hpack2 = hpack2_setup.hp2_code " +
"WHERE pif_id=" + _PAT_ID + " ";
dt = new DataTable();
dt = db.Query(sSQL);
if (dt.Rows.Count > 0)
{
//透析器名稱 hp2_name
w_opt_11 = dt.Rows[0]["hp2_name"].ToString();
w_pif_ic = dt.Rows[0]["pif_ic"].ToString();
}
dt.Dispose();
//2.clinical1_nurs 血液淨化紀錄
//cli_id淨化流水號 :key 自動
//病人身分證號 cln1_patic + 日期cln1_diadate
string winfo_date = _Get_YMD(TextField9.Text);
string w_opt_7 = "";
string w_num_13 = "";
string w_num_8 = "";
string w_num_9 = "";
string w_num_10 = "";
sSQL = "SELECT * FROM clinical1_nurse WHERE cln1_patic='" + w_pif_ic + "' AND cln1_diadate='" + TextField9.Text + "' ";
dt = new DataTable();
dt = db.Query(sSQL);
if (dt.Rows.Count > 0)
{
//血管通路類型 cln1_col4
w_opt_7 = dt.Rows[0]["cln1_col4"].ToString();
//體重(乾體重)
w_num_13 = dt.Rows[0]["cln1_col6"].ToString();
//抗凝方案(甘素首量)
w_num_8 = dt.Rows[0]["cln1_col13"].ToString();
//抗凝方案(追加量)
w_num_9 = dt.Rows[0]["cln1_col14"].ToString();
//抗凝方案(低分子肝素)
w_num_10 = dt.Rows[0]["cln1_col15"].ToString();
}
dt.Dispose();
//3.clinical2_nurse 血液淨化過程明細
//KEY:cln2_id:血液淨化流水號 自動
string w_TextArea1 = "";
int iCNT = 0;
string w_num_16 = "";
string w_num_17 = "";
string w_num_18 = "";
string w_num_19 = "";
string w_num_57 = "";
string w_num_58 = "";
double bpiLOW_MIN = 9999;
double bpiLOW_MAX = 0;
double bpiLOW_SUM = 0;
double bpiLOW_AVG = 0;
double bpiHIGH_MIN = 9999;
double bpiHIGH_MAX = 0;
double bpiHIGH_SUM = 0;
double bpiHIGH_AVG = 0;
string bpsLOW_MIN = "";
string bpsLOW_MAX = "";
string bpsLOW_AVG = "";
string bpsHIGH_MIN = "";
string bpsHIGH_MAX = "";
string bpsHIGH_AVG = "";
sSQL = "SELECT * FROM clinical2_nurse " +
"WHERE cln2_patic='" + w_pif_ic + "' " +
" AND cln2_bp LIKE '%/%' " +
" AND cln2_date LIKE '" + TextField9.Text + "%' " +
" ORDER BY cln2_date, cln2_time ";
dt = new DataTable();
dt = db.Query(sSQL);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string[] t = dt.Rows[i]["cln2_bp"].ToString().Split('/');
double zL = 0;
double zH = 0;
if (Double.TryParse(t[1], out zL))
{
zL = Convert.ToDouble(t[1]);
}
if (Double.TryParse(t[0], out zH))
{
zH = Convert.ToDouble(t[0]);
}
if ((zH > zL) && (zL > 0))
{
bpiLOW_SUM = bpiLOW_SUM + zL;
bpiHIGH_SUM = bpiHIGH_SUM + zH;
if (zH > bpiHIGH_MAX)
{
bpiHIGH_MAX = zH;
}
if (zL > bpiLOW_MAX)
{
bpiLOW_MAX = zL;
}
if (zH < bpiHIGH_MIN)
{
bpiHIGH_MIN = zH;
}
if (zL < bpiLOW_MIN)
{
bpiLOW_MIN = zL;
}
iCNT++;
w_TextArea1 += iCNT.ToString() + ". " + dt.Rows[i]["cln2_date"].ToString() + " " +
dt.Rows[i]["cln2_time"].ToString() + " " +
dt.Rows[i]["cln2_bp"].ToString() + Environment.NewLine;
}
else
{
w_TextArea1 += "X. " + dt.Rows[i]["cln2_date"].ToString() + " " +
dt.Rows[i]["cln2_time"].ToString() + " " +
dt.Rows[i]["cln2_bp"].ToString() + Environment.NewLine;
}
}
bpiLOW_AVG = bpiLOW_SUM / iCNT;
if (bpiLOW_AVG != 0)
{
bpsLOW_AVG = bpiLOW_AVG.ToString("0.0");
}
bpiHIGH_AVG = bpiHIGH_SUM / iCNT;
if (bpiHIGH_AVG != 0)
{
bpsHIGH_AVG = bpiHIGH_AVG.ToString("0.0");
}
if (bpiLOW_MIN != 9999)
{
bpsLOW_MIN = bpiLOW_MIN.ToString();
}
if (bpiLOW_MAX != 0)
{
bpsLOW_MAX = bpiLOW_MAX.ToString();
}
if (bpiHIGH_MIN != 9999)
{
bpsHIGH_MIN = bpiHIGH_MIN.ToString();
}
if (bpiHIGH_MAX != 0)
{
bpsHIGH_MAX = bpiHIGH_MAX.ToString();
}
}
//血壓範圍：
w_num_16 = bpsLOW_MIN;
w_num_17 = bpsLOW_MAX;
w_num_18 = bpsHIGH_MIN;
w_num_19 = bpsHIGH_MAX;
w_num_57 = bpsLOW_AVG;
w_num_58 = bpsHIGH_AVG;
dt.Dispose();
//
//4.a_result_log檢驗記錄檔 ROW_ID自動編號 :KEY
// 病患資料列序號 PAT_NO
sSQL = "";
string w_num_31 = "";
string w_num_32 = "";
string w_num_37 = "";
string w_txt_43 = "";
string w_num_44 = "";
string w_num_45 = "";
string w_num_46 = "";
string w_num_47 = "";
string w_num_50 = "";
string w_num_51 = "";
sSQL = "SELECT RESULT_DATE, RESULT_CODE, RESULT_VALUE_T " +
" FROM a_result_log " +
" WHERE PAT_NO=" + _PAT_ID + " " +
" AND RESULT_DATE='" + TextField9.Text + "' " +
" AND RESULT_VER=0 ";
dt = new DataTable();
dt = db.Query(sSQL);
for (int i = 0; i < dt.Rows.Count; i++)
{
switch (dt.Rows[i]["RESULT_CODE"].ToString())
{
case "5017":
w_num_31 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //URR
break;
case "5018":
w_num_32 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //KT/V
break;
case "4003":
w_num_37 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //Hb
break;
case "4027":
w_txt_43 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //鐵蛋白
break;
case "4050":
w_num_44 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //鐵蛋白飽和度
break;
case "4021":
w_num_45 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //鈣
break;
case "4023":
w_num_46 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //磷
break;
case "4030":
w_num_47 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //iPTH
break;
case "4009":
w_num_50 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //GOT=AST
break;
case "4010":
w_num_51 = dt.Rows[i]["RESULT_VALUE_T"].ToString(); //GPT=ALT
break;
}
}
dt.Dispose();
//
//寫入常規記錄
//PAT_ID 1/404
//病患資料序號pat_id + 記錄日期INFO_DATE
//string winfo_date = _Get_YMD(TextField9.Text);
string ww_opt_7 = "";
switch (w_opt_7)
{
case "临时中心静脉置管": //"临时中心静脉置管":
ww_opt_7 = "1";
break;
case "长期中心静脉置管": //"长期中心静脉置管":
ww_opt_7 = "2";
break;
case "自体内瘘": //"自体内瘘":
ww_opt_7 = "3";
break;
case "移植血管": //"移植血管":
ww_opt_7 = "4";
break;
default:
break;
}
string ww_opt_11 = "";
switch (w_opt_11)
{
case "Toray TS-1.3 S": //"Toray TS-1.3 S":
ww_opt_11 = "1";
break;
case "Toray TS-1.3 U": //"Toray TS-1.3 U":
ww_opt_11 = "2";
break;
case "Toray TS-1.6 SL": //"Toray TS-1.6 SL":
ww_opt_11 = "3";
break;
case "Toray TS-1.8 SL": //"Toray TS-1.8 SL":
ww_opt_11 = "4";
break;
case "旭化成REXEED 15UC": //"旭化成REXEED 15UC":
ww_opt_11 = "5";
break;
case "尼普洛FB-150U": //"尼普洛FB-150U":
ww_opt_11 = "6";
break;
case "B1-1.6H": //"B1-1.6H":
ww_opt_11 = "7";
break;
default:
ww_opt_11 = "0";
break;
}
sSQL = "";
sSQL = " SELECT * ";
sSQL += " FROM zinfo_e_01 ";
sSQL += " WHERE pat_id = '" + _PAT_ID + "'";
sSQL += " AND info_date = '" + winfo_date + "'";
DataTable dt2 = db.Query(sSQL);
if (dt2.Rows.Count == 1)
{
sSQL = " UPDATE zinfo_e_01 set opt_7 = '" + ww_opt_7 + "'," +
" num_8 = '" + w_num_8 + "'," +
" num_9 = '" + w_num_9 + "'," +
" num_10 = '" + w_num_10 + "'," +
" opt_11 = '" + ww_opt_11 + "'," +
" num_13 = '" + w_num_13 + "'," +
" num_16 = '" + w_num_16 + "'," +
" num_17 = '" + w_num_17 + "'," +
" num_18 = '" + w_num_18 + "'," +
" num_19 = '" + w_num_19 + "'," +
" num_31 = '" + w_num_31 + "'," +
" num_32 = '" + w_num_32 + "'," +
" num_37 = '" + w_num_37 + "'," +
" txt_43 = '" + w_txt_43 + "'," +
" num_44 = '" + w_num_44 + "'," +
" num_45 = '" + w_num_45 + "'," +
" num_46 = '" + w_num_46 + "'," +
" num_47 = '" + w_num_47 + "'," +
" num_50 = '" + w_num_50 + "'," +
" num_51 = '" + w_num_51 + "'," +
" num_57 = '" + w_num_57 + "'," +
" num_58 = '" + w_num_58 + "'," +
"info_user = '******'" +
" WHERE pat_id ='" + _PAT_ID + "'" +
" AND info_date ='" + winfo_date + "'";
db.Excute(sSQL);
}
else
{
sSQL = "INSERT INTO zinfo_e_01 (pat_id,info_date,info_user,opt_7,num_8,num_9,num_10,opt_11,num_13,num_16,num_17,num_18,num_19,num_31,num_32,num_37,txt_43,num_44,num_45,num_46,num_47,num_50,num_51,num_57,num_58) ";
sSQL += "VALUES('" + _PAT_ID + "','" + winfo_date + "',";
sSQL += "'Admin" + "',";
sSQL += "'" + ww_opt_7 + "',";
sSQL += "'" + w_num_8 + "',";
sSQL += "'" + w_num_9 + "',";
sSQL += "'" + w_num_10 + "',";
sSQL += "'" + ww_opt_11 + "',";
sSQL += "'" + w_num_13 + "',";
sSQL += "'" + w_num_16 + "',";
sSQL += "'" + w_num_17 + "',";
sSQL += "'" + w_num_18 + "',";
sSQL += "'" + w_num_19 + "',";
sSQL += "'" + w_num_31 + "',";
sSQL += "'" + w_num_32 + "',";
sSQL += "'" + w_num_37 + "',";
sSQL += "'" + w_txt_43 + "',";
sSQL += "'" + w_num_44 + "',";
sSQL += "'" + w_num_45 + "',";
sSQL += "'" + w_num_46 + "',";
sSQL += "'" + w_num_47 + "',";
sSQL += "'" + w_num_50 + "',";
sSQL += "'" + w_num_51 + "',";
sSQL += "'" + w_num_57 + "',";
sSQL += "'" + w_num_58 + "'";
sSQL += "" + ")";
db.Excute(sSQL);
}
dt2.Dispose();
//
_NotificationShow("储存成功!");
}
/// <summary>
/// 排班轉檔作業
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
//
this.Panel4.Hidden = true;
this.txtMESSAGE.Text = "排班轉檔......";
if (!X.IsAjaxRequest)
{
}
// 未來排班轉檔程式要從 Web 搬移出去 , 在 windows 排程中 執行
//
DBMysql db = new DBMysql();
DateTime now = DateTime.Now;
this.txtDATE.Text = now.ToString("yyyy-MM-dd");
this.txtTIME.Text = now.ToString("yyyy-MM-dd HH:mm:ss");
string w_apptst_flr = "";
string sql = "";
GET_WEEK();
string w_flag = "";
//目前時間
int Hm = int.Parse(now.ToString("HHmm"));
//Hm = 2300;
//this.txtWEEK.Text = "星期日";
if (this.txtWEEK.Text == "星期日")
{
if (Hm >= 2200 && w_flag == "")
{
//星期日 22:00開始 排班轉檔
DateTime dt = DateTime.Now;
DateTime w_date1;
DateTime w_date2;
DateTime w_date3;
DateTime w_date4;
DateTime w_date5;
DateTime w_date6;
DateTime w_date7;
w_date1 = dt.AddDays(1);
string s_date1 = w_date1.ToString("yyyy-MM-dd");
w_date2 = dt.AddDays(2);
string s_date2 = w_date2.ToString("yyyy-MM-dd");
w_date3 = dt.AddDays(3);
string s_date3 = w_date3.ToString("yyyy-MM-dd");
w_date4 = dt.AddDays(4);
string s_date4 = w_date4.ToString("yyyy-MM-dd");
w_date5 = dt.AddDays(5);
string s_date5 = w_date5.ToString("yyyy-MM-dd");
w_date6 = dt.AddDays(6);
string s_date6 = w_date6.ToString("yyyy-MM-dd");
w_date7 = dt.AddDays(7);
string s_date7 = w_date7.ToString("yyyy-MM-dd");
//
try
{
//select a.*,b.pif_id,b.pif_name from appointment a, pat_info b where a.pif_id = b.pif_id order by a.pif_id
//SELECT a.*,b.pif_id,b.pif_name as patrefid,b.pif_ic as patic FROM appointment a,pat_info b
//where a.pif_id = b.pif_id
//and appointment_date in ('2015-06-22','2015-06-23','2015-06-24','2015-06-25','2015-06-26','2015-06-27','2015-06-28') ORDER BY appointment_date
//20150909 Andy
sql = "";
sql = "DELETE FROM appointment_setup";
DataTable appointment_DATA = db.Query(sql);
sql = "";
sql = "SELECT mac_flr, mac_sec, mac_bedno, mac_typ FROM mac_setup";
DataTable mac_setup_DATA = db.Query(sql);
sql = "";
sql = "SELECT a.*,b.pif_id,b.pif_name as patrefid,b.pif_ic as patic FROM appointment a,pat_info b where a.pif_id = b.pif_id and appointment_date in ('" +
s_date1 + "','" + s_date2 + "','" + s_date3 + "','" + s_date4 + "','" +
s_date5 + "','" + s_date6 + "','" + s_date7 + "')" + " ORDER BY appointment_date ";
DataTable dtappointment_DATA = db.Query(sql);
foreach (DataRow dr in dtappointment_DATA.Rows)
{
try
{
dr["mac_type"] = mac_setup_DATA.Select("mac_flr = '" + dr["pv_floor"].ToString() + "' and mac_sec = '" + dr["pv_sec"].ToString() + "' and mac_bedno = '" + dr["pv_bedno"].ToString() + "'")[0]["mac_typ"].ToString();
}
catch (Exception ex)
{
logger.Error(ex.Message + ":" + ex.StackTrace);
}
}
//if (dtappointment_DATA.Rows.Count > 0)
for (int i = 0; i < dtappointment_DATA.Rows.Count; i++)
{
sql = "";
sql = "insert into appointment_setup (apptst_flr,apptst_sec,";
sql += "apptst_bed,apptst_mactyp,apptst_patrefid,apptst_patic,apptst_wktyp,apptst_daytyp,apptst_timetyp) ";
sql += " values ('";
sql += dtappointment_DATA.Rows[i]["pv_floor"].ToString() + "','";
sql += dtappointment_DATA.Rows[i]["pv_sec"].ToString() + "','";
sql += dtappointment_DATA.Rows[i]["pv_bedno"].ToString() + "','";
sql += dtappointment_DATA.Rows[i]["mac_type"].ToString() + "','";
sql += dtappointment_DATA.Rows[i]["patrefid"].ToString() + "','";
sql += dtappointment_DATA.Rows[i]["patic"].ToString() + "','";
//1
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date1)
{
sql += "135" + "','";
sql += "1" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date2)
{
sql += "246" + "','";
sql += "2" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date3)
{
sql += "135" + "','";
sql += "3" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date4)
{
sql += "246" + "','";
sql += "4" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date5)
{
sql += "135" + "','";
sql += "5" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date6)
{
sql += "246" + "','";
sql += "6" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
if (dtappointment_DATA.Rows[i]["appointment_date"].ToString() == s_date7)
{
sql += "135" + "','";
sql += "7" + "','";
sql += dtappointment_DATA.Rows[i]["time_type"].ToString() + "'";
}
sql += ")";
db.Excute(sql);
}
}
catch (Exception ex)
{
Common._ErrorMsgShow(ex.Message.ToString());
//logger.Error(ex.Message + ":" + ex.StackTrace);
}
}
}
w_flag = "Y";
}