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