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