/// <summary>
/// false: not login; true: login
/// </summary>
/// <param name="floor"></param>
/// <param name="area"></param>
/// <param name="time"></param>
/// <param name="beno"></param>
/// <returns></returns>
static public bool does_login(pat pat_obj)
{
string floor = pat_obj.floor, area = pat_obj.area, time = pat_obj.time, bedno = pat_obj.bedno;
string sql = "SELECT b.pif_name name,b.pif_sex,b.pif_ic id," + DateTime.Now.Year.ToString() + "-year(b.pif_dob) age,b.pif_hpack,a.pv_macno,a.pv_weight,a.pv_macstat ";
sql += "from pat_visit a,pat_info b ";
sql += "where a.pv_datevisit = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
sql += "and a.pv_floor = '" + floor + "' ";
sql += "and a.pv_sec = '" + area + "' ";
sql += "and a.pv_time = '" + time + "' ";
sql += "and a.pv_bedno = '" + bedno + "' ";
sql += "and a.pv_ic = b.pif_ic";
string result;
DataTable dt = DBMysql.query(sql, out result);
if (dt.Rows.Count == 0)
{
return(false);
}
// if(dt.Rows.Count > 0)
// {
// throw new Exception("在同一天而且同一個時段而且同一張床查到兩筆以上的淨化資料");
// }
return(true);
}
/// <summary>
/// pv_ic: Tex_Patient_ID.Text; macno: Tex_Machine_type.Text; weight: Tex_Patient_weight.Text;
/// weight: before weight
/// </summary>
/// <param name="pv_ic"></param>
static public void insert_new_pat_to_pat_visit(pat pat_obj, string macno, string weight)
{
string sql = "INSERT into pat_visit (pv_mrn, " +
"pv_ic, " +
"pv_datevisit, " +
"pv_floor, " +
"pv_sec, " +
"pv_time, " +
"pv_bedno, " +
"pv_macno, " +
"pv_hpack, " +
"pv_hpack2, " +
"pv_hpack3, " +
"pv_pattyp, " +
"pv_weight, " +
"pv_macstat) " +
"VALUES('', " +
"'" + pat_obj.pif_ic + "', " +
"'" + DateTime.Now.ToString("yyyy-MM-dd") + "', " +
"'" + pat_obj.floor + "', " +
"'" + pat_obj.area + "', " +
"'" + pat_obj.time + "', " +
"'" + pat_obj.bedno + "', " +
"'" + macno + "', " +
"'" + pat_obj.pif_hpack + "', " + // ComboBox為什麼還要做Replace("'", "''") --> 多餘
"'" + pat_obj.pif_hpack2 + "', " +
"'" + pat_obj.pif_hpack3 + "', " +
"'H', " +
"'" + weight + "', " +
"'A') ";
// 分流方式 pif_hpack, like. 自体内瘘
// 透析器型號 pif_hpack2
// 管路型號 pif_hpack3
// 病患身分證號 pif_ic
if (pat_obj == null ||
pat_obj.pif_hpack == null ||
pat_obj.pif_hpack2 == null ||
pat_obj.pif_hpack3 == null ||
pat_obj.pif_ic == null)
{
throw new Exception("please check the sql: " + sql);
}
if (pat_obj.pif_hpack.Length == 0 ||
pat_obj.pif_hpack2.Length == 0 ||
pat_obj.pif_hpack3.Length == 0 ||
pat_obj.pif_ic.Length == 0)
{
throw new Exception("please check the sql: " + sql);
}
DBMysql db = new DBMysql();
db.Excute(sql);
}
static public pat_status get_pat_status(pat pat_obj)
{
string floor = pat_obj.floor, area = pat_obj.area, time = pat_obj.time, bedno = pat_obj.bedno;
if (DBMysql.does_login(pat_obj))
{
if (DBMysql.does_stop(pat_obj.pif_ic))
{
return(pat_status.stop);
}
else
{
// 因為已經登入, 所以does_stop回傳false才能視為not stop, 否則does_stop回傳false是N/A
return(pat_status.not_stop);
}
}
return(pat_status.not_login);
}
/// <summary>
/// 分流方式 pif_hpack
/// 透析器型號 pif_hpack2
/// 管路型號 pif_hpack3
/// 病患身分證號 pif_ic
/// </summary>
/// <param name="pif_hpack"></param>
/// <param name="pif_hpack2"></param>
/// <param name="pif_hpack3"></param>
/// <param name="pif_ic"></param>
static public void update_pat_info(pat pat_obj)
{
DBMysql db = new DBMysql();
string sql = "";
try
{
sql = "UPDATE pat_info SET pif_hpack='" + pat_obj.pif_hpack + "', " +
"pif_hpack2='" + pat_obj.pif_hpack2 + "', " +
"pif_hpack3='" + pat_obj.pif_hpack3 + "' " +
"WHERE pif_ic='" + pat_obj.pif_ic + "'";
db.Excute(sql);
}
catch (Exception ex)
{
Common.SaveERR("Update pat_info", ex.Message);
}
}
