public PatientSmartcard setLabM01(PatientSmartcard p) { p.patient_smartcard_id = ""; p.prefixname = ""; p.first_name = ""; p.middle_name = ""; p.last_name = ""; p.first_name_e = ""; p.middle_name_e = ""; p.last_name_e = ""; p.pid = ""; p.dob = ""; p.home_no = ""; p.moo = ""; p.trok = ""; p.soi = ""; p.road = ""; p.district_name = ""; p.amphur_name = ""; p.province_name = ""; p.date_order = ""; p.status_send = ""; p.doc = ""; p.hn = ""; p.hn_year = ""; p.mobile = ""; p.prefixname_e = ""; p.attach_note = ""; return(p); }
private void BtnGet_Click(object sender, EventArgs e) { //throw new NotImplementedException(); DateTime dtstart = new DateTime(); dtstart = DateTime.Now; DateTime.TryParse(txtDateStart.Text, out dtstart); String date = ""; date = dtstart.ToString("yyyy-MM-dd"); DataTable dt = new DataTable(); dt = bc.bcDB.pttDB.selectPatientCovidByDate(date); if (dt.Rows.Count > 0) { int chk = 0; Patient ptt = new Patient(); PatientSmartcard pttsc = new PatientSmartcard(); foreach (DataRow drow in dt.Rows) { ptt.Hn = drow["MNC_HN_NO"].ToString(); ptt.Age = drow["MNC_AGE"].ToString(); ptt.patient_birthday = drow["MNC_bday"].ToString(); ptt.Name = drow["prefix"].ToString() + " " + drow["MNC_FNAME_T"].ToString() + " " + drow["MNC_LNAME_T"].ToString(); ptt.idcard = drow["mnc_id_no"].ToString(); ptt.hnyr = drow["mnc_hn_yr"].ToString(); ptt.MNC_HN_NO = drow["MNC_HN_NO"].ToString(); ptt.MNC_HN_YR = drow["mnc_hn_yr"].ToString(); ptt.MNC_CUR_CHW = drow["MNC_CUR_CHW"].ToString(); ptt.MNC_CUR_AMP = drow["MNC_CUR_AMP"].ToString(); ptt.MNC_CUR_TUM = drow["MNC_CUR_TUM"].ToString(); ptt.MNC_CUR_ADD = drow["MNC_CUR_ADD"].ToString(); ptt.MNC_CUR_MOO = drow["MNC_CUR_MOO"].ToString(); ptt.MNC_CUR_SOI = drow["MNC_CUR_SOI"].ToString(); ptt.MNC_FNAME_T = drow["MNC_FNAME_T"].ToString(); ptt.MNC_LNAME_T = drow["MNC_LNAME_T"].ToString(); ptt.MNC_FNAME_E = drow["MNC_FNAME_E"].ToString(); ptt.MNC_LNAME_E = drow["MNC_LNAME_E"].ToString(); ptt.MNC_PFIX_CDT = drow["MNC_PFIX_CDT"].ToString(); ptt.MNC_CUR_TEL = drow["MNC_CUR_TEL"].ToString(); ptt.MNC_PFIX_CDE = drow["MNC_PFIX_CDE"].ToString(); ptt.MNC_ATT_NOTE = drow["MNC_ATT_NOTE"].ToString(); ptt.MNC_OCC_CD = drow["MNC_OCC_CD"].ToString(); ptt.MNC_EDU_CD = drow["MNC_EDU_CD"].ToString(); ptt.MNC_NAT_CD = drow["MNC_NAT_CD"].ToString(); ptt.MNC_REL_CD = drow["MNC_REL_CD"].ToString(); ptt.MNC_NATI_CD = drow["MNC_NATI_CD"].ToString(); ptt.MNC_CUR_ROAD = drow["MNC_CUR_ROAD"].ToString(); setPatientSmartcard(pttsc, ptt); String re = bc.bcDB.pttscDB.insertPatientSmartcard(pttsc, ""); } setGrfOPBKKMainCHRGITEM(); } }
private void TxtHn_KeyUp(object sender, KeyEventArgs e) { //throw new NotImplementedException(); if (e.KeyCode == Keys.Enter) { sep.Clear(); if (txtPaidType.Text.Length < 9) { sep.SetError(txtPaidType, "error"); return; } try { Patient ptt = new Patient(); if (txtHn.Text.Length == 13) { ptt = bc.bcDB.pttDB.selectPatinetByID1(txtHn.Text.Trim()); } else { ptt = bc.bcDB.pttDB.selectPatinetByHn(txtHn.Text.Trim()); } if (ptt.MNC_HN_NO.Length > 0) { int chk = 0; PatientSmartcard pttsc = new PatientSmartcard(); setPatientSmartcard(pttsc, ptt); Visit vs = new Visit(); //vs = bc.bcDB.vsDB.selectVisit String re = bc.bcDB.pttscDB.insertPatientSmartcard(pttsc, ""); if (int.TryParse(re, out chk)) { setGrfOPBKKMainCHRGITEM(); txtHn.SelectAll(); //txtPaidType.SelectAll(); } else { MessageBox.Show("error", ""); } } else { sep.SetError(txtHn, "error"); txtHn.SelectAll(); } } catch (Exception ex) { MessageBox.Show("error " + ex.Message, ""); txtHn.SelectAll(); } } }
private void chkNull(PatientSmartcard p) { long chk = 0; int chk1 = 0; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.prefixname = p.prefixname == null ? "" : p.prefixname; p.first_name = p.first_name == null ? "" : p.first_name; p.middle_name = p.middle_name == null ? "" : p.middle_name; p.last_name = p.last_name == null ? "" : p.last_name; p.first_name_e = p.first_name_e == null ? "" : p.first_name_e; p.middle_name_e = p.middle_name_e == null ? "" : p.middle_name_e; p.last_name_e = p.last_name_e == null ? "" : p.last_name_e; p.pid = p.pid == null ? "" : p.pid; p.dob = p.dob == null ? "" : p.dob; p.home_no = p.home_no == null ? "" : p.home_no; p.moo = p.moo == null ? "" : p.moo; p.trok = p.trok == null ? "" : p.trok; p.soi = p.soi == null ? "" : p.soi; p.road = p.road == null ? "" : p.road; p.district_name = p.district_name == null ? "" : p.district_name; p.amphur_name = p.amphur_name == null ? "" : p.amphur_name; p.province_name = p.province_name == null ? "" : p.province_name; p.date_order = p.date_order == null ? "" : p.date_order; p.status_send = p.status_send == null ? "" : p.status_send; p.doc = p.doc == null ? "" : p.doc; p.MNC_OCC_CD = p.MNC_OCC_CD == null ? "" : p.MNC_OCC_CD; p.MNC_EDU_CD = p.MNC_EDU_CD == null ? "" : p.MNC_EDU_CD; p.MNC_NAT_CD = p.MNC_NAT_CD == null ? "" : p.MNC_NAT_CD; p.MNC_REL_CD = p.MNC_REL_CD == null ? "" : p.MNC_REL_CD; p.MNC_NATI_CD = p.MNC_NATI_CD == null ? "" : p.MNC_NATI_CD; p.MNC_CAR_CD = p.MNC_CAR_CD == null ? "" : p.MNC_CAR_CD; p.sex = p.sex == null ? "" : p.sex; p.req_no = p.req_no == null ? "" : p.req_no; p.req_date = p.req_date == null ? "" : p.req_date; p.pre_no = p.pre_no == null ? "" : p.pre_no; p.visit_date = p.visit_date == null ? "" : p.visit_date; p.hn = p.hn == null ? "" : p.hn; p.hn_year = p.hn_year == null ? "" : p.hn_year; p.mobile = p.mobile == null ? "" : p.mobile; p.prefixname_e = p.prefixname_e == null ? "" : p.prefixname_e; p.attach_note = p.attach_note == null ? "" : p.attach_note; //p.doc_group_sub_id = long.TryParse(p.doc_group_sub_id, out chk) ? chk.ToString() : "0"; //p.pre_no = long.TryParse(p.pre_no, out chk) ? chk.ToString() : "0"; }
private PatientSmartcard setPatientSmartcard(PatientSmartcard pttsc, Patient ptt) { String doc = "", datestart = "", pid1 = ""; DateTime dtstart = new DateTime(); DateTime.TryParse(txtDateStart.Text, out dtstart); if (dtstart.Year > 2500) { dtstart = dtstart.AddYears(-543); } else if (dtstart.Year < 2000) { dtstart = dtstart.AddYears(543); } datestart = dtstart.ToString("yyyy-MM-dd", new CultureInfo("en-US")); pid1 = dtstart.ToString("yyMMdd", new CultureInfo("en-US")); pid1 += ptt.MNC_HN_NO; pttsc.patient_smartcard_id = ""; pttsc.prefixname = ptt.MNC_PFIX_CDT; pttsc.first_name = ptt.MNC_FNAME_T; pttsc.middle_name = ""; pttsc.last_name = ptt.MNC_LNAME_T; pttsc.first_name_e = ptt.MNC_FNAME_E; pttsc.middle_name_e = ""; pttsc.last_name_e = ptt.MNC_LNAME_E; pttsc.pid = !ptt.idcard.Equals("") ? ptt.idcard : pid1; pttsc.dob = ptt.patient_birthday; pttsc.home_no = ptt.MNC_CUR_ADD; pttsc.moo = ptt.MNC_CUR_MOO; pttsc.trok = ""; pttsc.soi = ptt.MNC_CUR_SOI; pttsc.road = ptt.MNC_CUR_ROAD; pttsc.district_name = ptt.MNC_CUR_TUM; pttsc.amphur_name = ptt.MNC_CUR_AMP; pttsc.province_name = ptt.MNC_CUR_CHW; pttsc.date_order = datestart; pttsc.status_send = ""; pttsc.doc = txtPaidType.Text.Trim(); pttsc.hn = ptt.MNC_HN_NO; pttsc.hn_year = ptt.MNC_HN_YR; pttsc.mobile = ptt.MNC_CUR_TEL; pttsc.prefixname_e = ptt.MNC_PFIX_CDE; pttsc.attach_note = ptt.MNC_ATT_NOTE; pttsc.MNC_OCC_CD = ptt.MNC_OCC_CD; pttsc.MNC_EDU_CD = ptt.MNC_EDU_CD; pttsc.MNC_NAT_CD = ptt.MNC_NAT_CD; pttsc.MNC_REL_CD = ptt.MNC_REL_CD; pttsc.MNC_NATI_CD = ptt.MNC_NATI_CD; //pttsc.attach_note = ptt.MNC_ATT_NOTE; return(pttsc); }
public String insertPatientSmartcard(PatientSmartcard p, String userId) { String re = ""; if (p.patient_smartcard_id.Equals("")) { re = insert(p, ""); } else { re = update(p, ""); } return(re); }
public String insert(PatientSmartcard p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); sql = "Insert Into " + pttsc.table + " (" + pttsc.prefixname + "," + pttsc.first_name + "," + pttsc.middle_name + "," + pttsc.last_name + "" + "," + pttsc.first_name_e + "," + pttsc.middle_name_e + "," + pttsc.last_name_e + "," + pttsc.pid + "" + "," + pttsc.dob + "," + pttsc.home_no + "," + pttsc.moo + "," + pttsc.trok + "" + "," + pttsc.soi + "," + pttsc.road + "," + pttsc.district_name + "," + pttsc.amphur_name + "" + "," + pttsc.province_name + "," + pttsc.date_order + "," + pttsc.status_send + "," + pttsc.doc + "" + "," + pttsc.hn + "," + pttsc.hn_year + "," + pttsc.mobile + "," + pttsc.prefixname_e + "" + "," + pttsc.MNC_OCC_CD + "," + pttsc.MNC_EDU_CD + "," + pttsc.MNC_NAT_CD + "," + pttsc.MNC_REL_CD + "" + "," + pttsc.MNC_NATI_CD + "" + "," + pttsc.attach_note + "" + "," + pttsc.sex + "," + pttsc.req_no + "," + pttsc.req_date + "," + pttsc.pre_no + "" + "," + pttsc.visit_date + "" + ") " + "Values ('" + p.prefixname.Replace("'", "''") + "','" + p.first_name.Replace("'", "''") + "','" + p.middle_name.Replace("'", "''") + "','" + p.last_name.Replace("'", "''") + "' " + ",'" + p.first_name_e.Replace("'", "''") + "','" + p.middle_name_e.Replace("'", "''") + "','" + p.last_name_e.Replace("'", "''") + "','" + p.pid + "' " + ",'" + p.dob + "','" + p.home_no.Replace("'", "''") + "','" + p.moo.Replace("'", "''") + "','" + p.trok.Replace("'", "''") + "' " + ",'" + p.soi.Replace("'", "''") + "','" + p.road.Replace("'", "''") + "','" + p.district_name.Replace("'", "''") + "','" + p.amphur_name.Replace("'", "''") + "' " + ",'" + p.province_name.Replace("'", "''") + "','" + p.date_order + "','" + p.status_send + "','" + p.doc + "' " + ",'" + p.hn.Replace("'", "''") + "','" + p.hn_year + "','" + p.mobile + "','" + p.prefixname_e.Replace("'", "''") + "' " + ",'" + p.MNC_OCC_CD.Replace("'", "''") + "','" + p.MNC_EDU_CD + "','" + p.MNC_NAT_CD + "','" + p.MNC_REL_CD + "' " + ",'" + p.MNC_NATI_CD.Replace("'", "''") + "' " + ",'" + p.attach_note.Replace("'", "''") + "' " + ",'" + p.sex + "','" + p.req_no + "','" + p.req_date + "','" + p.pre_no + "' " + ",'" + p.visit_date + "' " + ")"; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { //sql = ex.Message + " " + ex.InnerException; new LogWriter("d", "PatientSmartcardDB insert ex.InnerException " + ex.InnerException + "\n" + sql); } return(re); }
private void initConfig() { pttsc = new PatientSmartcard(); pttsc.patient_smartcard_id = "patient_smartcard_id"; pttsc.prefixname = "prefixname"; pttsc.first_name = "first_name"; pttsc.middle_name = "middle_name"; pttsc.last_name = "last_name"; pttsc.first_name_e = "first_name_e"; pttsc.middle_name_e = "middle_name_e"; pttsc.last_name_e = "last_name_e"; pttsc.pid = "pid"; pttsc.dob = "dob"; pttsc.home_no = "home_no"; pttsc.moo = "moo"; pttsc.trok = "trok"; pttsc.soi = "soi"; pttsc.road = "road"; pttsc.district_name = "district_name"; pttsc.amphur_name = "amphur_name"; pttsc.province_name = "province_name"; pttsc.date_order = "date_order"; pttsc.status_send = "status_send"; pttsc.doc = "doc"; pttsc.hn = "hn"; pttsc.hn_year = "hn_year"; pttsc.mobile = "mobile"; pttsc.prefixname_e = "prefixname_e"; pttsc.attach_note = "attach_note"; pttsc.MNC_OCC_CD = "MNC_OCC_CD"; pttsc.MNC_EDU_CD = "MNC_EDU_CD"; pttsc.MNC_NAT_CD = "MNC_NAT_CD"; pttsc.MNC_REL_CD = "MNC_REL_CD"; pttsc.MNC_NATI_CD = "MNC_NATI_CD"; pttsc.MNC_CAR_CD = "MNC_CAR_CD"; pttsc.sex = "sex"; pttsc.req_no = "req_no"; pttsc.req_date = "req_date"; pttsc.pre_no = "pre_no"; pttsc.visit_date = "visit_date"; pttsc.table = "b_patient_smartcard"; pttsc.pkField = "patient_smartcard_id"; }
public String update(PatientSmartcard p, String userId) { String re = ""; String sql = ""; int chk = 0; chkNull(p); sql = "Update " + pttsc.table + " Set " + " " + pttsc.prefixname + " = '" + p.prefixname.Replace("'", "''") + "'" + ", " + pttsc.first_name + " = '" + p.first_name.Replace("'", "''") + "'" + ", " + pttsc.middle_name + " = '" + p.middle_name + "'" + ", " + pttsc.last_name + " = '" + p.last_name + "'" + ", " + pttsc.first_name_e + " = '" + p.first_name_e + "'" + ", " + pttsc.middle_name_e + " = '" + p.middle_name_e + "'" + ", " + pttsc.last_name_e + " = '" + p.last_name_e + "'" + ", " + pttsc.pid + " = '" + p.pid + "'" + ", " + pttsc.dob + " = '" + p.dob + "'" + ", " + pttsc.home_no + " = '" + p.home_no + "'" + ", " + pttsc.moo + " = '" + p.moo + "'" + ", " + pttsc.trok + " = '" + p.trok + "'" + ", " + pttsc.soi + " = '" + p.soi + "'" + ", " + pttsc.road + " = '" + p.road + "'" + ", " + pttsc.district_name + " = '" + p.district_name + "'" + ", " + pttsc.amphur_name + " = '" + p.amphur_name + "'" + ", " + pttsc.province_name + " = '" + p.province_name + "'" + ", " + pttsc.date_order + " = '" + p.date_order + "'" + ", " + pttsc.status_send + " = '" + p.status_send + "'" + ", " + pttsc.doc + " = '" + p.doc + "'" + "Where " + pttsc.pkField + "='" + p.patient_smartcard_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public PatientSmartcard setLabM01(DataTable dt) { PatientSmartcard labM01 = new PatientSmartcard(); if (dt.Rows.Count > 0) { labM01.patient_smartcard_id = dt.Rows[0]["patient_smartcard_id"].ToString(); labM01.prefixname = dt.Rows[0]["prefixname"].ToString(); labM01.first_name = dt.Rows[0]["first_name"].ToString(); labM01.middle_name = dt.Rows[0]["middle_name"].ToString(); labM01.last_name = dt.Rows[0]["last_name"].ToString(); labM01.first_name_e = dt.Rows[0]["first_name_e"].ToString(); labM01.middle_name_e = dt.Rows[0]["middle_name_e"].ToString(); labM01.last_name_e = dt.Rows[0]["last_name_e"].ToString(); labM01.pid = dt.Rows[0]["pid"].ToString(); labM01.dob = dt.Rows[0]["dob"].ToString(); labM01.home_no = dt.Rows[0]["home_no"].ToString(); labM01.moo = dt.Rows[0]["moo"].ToString(); labM01.trok = dt.Rows[0]["trok"].ToString(); labM01.soi = dt.Rows[0]["soi"].ToString(); labM01.road = dt.Rows[0]["road"].ToString(); labM01.district_name = dt.Rows[0]["district_name"].ToString(); labM01.amphur_name = dt.Rows[0]["amphur_name"].ToString(); labM01.province_name = dt.Rows[0]["province_name"].ToString(); labM01.date_order = dt.Rows[0]["date_order"].ToString(); labM01.status_send = dt.Rows[0]["status_send"].ToString(); labM01.doc = dt.Rows[0]["doc"].ToString(); labM01.hn = dt.Rows[0]["hn"].ToString(); labM01.hn_year = dt.Rows[0]["hn_year"].ToString(); labM01.mobile = dt.Rows[0]["mobile"].ToString(); labM01.prefixname_e = dt.Rows[0]["prefixname_e"].ToString(); labM01.attach_note = dt.Rows[0]["attach_note"].ToString(); } else { setLabM01(labM01); } return(labM01); }