private void initConfig() { lFormDay1 = new LabFormDay1(); opu = new LabOpu(); ptt = new Patient(); ovs = new VisitOld(); vs = new Visit(); stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); ic.ivfDB.dtrOldDB.setCboDoctor(cboDoctor, ""); ic.ivfDB.lformDay1DB.setCboRemark(cboRemark); ic.setCboDay(cboEmbryoFreezingDay, ""); setControl(); chkBiopsy.CheckedChanged += ChkBiopsy_CheckedChanged; chkEmbryoFreezingDay.CheckedChanged += ChkEmbryoFreezingDay_CheckedChanged; chkBlastocyst.CheckedChanged += ChkBlastocyst_CheckedChanged; chkEmbryoTransferFresh.CheckedChanged += ChkEmbryoTransferFresh_CheckedChanged; btnPrint.Click += BtnPrint_Click; chkPgsMin.CheckedChanged += ChkPgsMin_CheckedChanged; chkNgs.CheckedChanged += ChkNgs_CheckedChanged; btmDonorSearch.Click += BtmDonorSearch_Click; btnMaleSearch.Click += BtnMaleSearch_Click; btnSave.Click += BtnSave_Click; ChkBiopsy_CheckedChanged(null, null); ChkEmbryoFreezingDay_CheckedChanged(null, null); ChkBlastocyst_CheckedChanged(null, null); ChkEmbryoTransferFresh_CheckedChanged(null, null); ChkPgsMin_CheckedChanged(null, null); ChkNgs_CheckedChanged(null, null); }
public LabFormDay1 setLabFormDay1(DataTable dt) { LabFormDay1 vs1 = new LabFormDay1(); if (dt.Rows.Count > 0) { vs1.form_day1_id = dt.Rows[0][lformDay1.form_day1_id].ToString(); vs1.t_patient_id = dt.Rows[0][lformDay1.t_patient_id].ToString(); vs1.t_visit_id = dt.Rows[0][lformDay1.t_visit_id].ToString(); vs1.day1_date = dt.Rows[0][lformDay1.day1_date].ToString(); vs1.form_day1_code = dt.Rows[0][lformDay1.form_day1_code].ToString(); vs1.hn_male = dt.Rows[0][lformDay1.hn_male].ToString(); vs1.hn_female = dt.Rows[0][lformDay1.hn_female].ToString(); vs1.name_male = dt.Rows[0][lformDay1.name_male].ToString(); vs1.name_female = dt.Rows[0][lformDay1.name_female].ToString(); vs1.hn_donor = dt.Rows[0][lformDay1.hn_donor].ToString(); vs1.name_donor = dt.Rows[0][lformDay1.name_donor].ToString(); vs1.day1_remark = dt.Rows[0][lformDay1.day1_remark].ToString(); vs1.dob_male = dt.Rows[0][lformDay1.dob_male].ToString(); vs1.dob_female = dt.Rows[0][lformDay1.dob_female].ToString(); vs1.dob_donor = dt.Rows[0][lformDay1.dob_donor].ToString(); vs1.status_no_biopsy = dt.Rows[0][lformDay1.status_no_biopsy].ToString(); vs1.status_biopsy_pgs = dt.Rows[0][lformDay1.status_biopsy_pgs].ToString(); vs1.status_biopsy_ngs = dt.Rows[0][lformDay1.status_biopsy_ngs].ToString(); vs1.status_biopsy_ngs_7_pair = dt.Rows[0][lformDay1.status_biopsy_ngs_7_pair].ToString(); vs1.status_biopsy_ngs_23_pair = dt.Rows[0][lformDay1.status_biopsy_ngs_23_pair].ToString(); vs1.biopsy_pgs_min = dt.Rows[0][lformDay1.biopsy_pgs_min].ToString(); vs1.biopsy_pgs_max = dt.Rows[0][lformDay1.biopsy_pgs_max].ToString(); vs1.biopsy_ngs_min = dt.Rows[0][lformDay1.biopsy_ngs_min].ToString(); vs1.biopsy_ngs_max = dt.Rows[0][lformDay1.biopsy_ngs_max].ToString(); vs1.status_embryo_freezing_day = dt.Rows[0][lformDay1.status_embryo_freezing_day].ToString(); vs1.embryo_freezing_day = dt.Rows[0][lformDay1.embryo_freezing_day].ToString(); vs1.embryo_freezing_day_max = dt.Rows[0][lformDay1.embryo_freezing_day_max].ToString(); vs1.status_stage_blastocyst = dt.Rows[0][lformDay1.status_stage_blastocyst].ToString(); vs1.status_stage_morula = dt.Rows[0][lformDay1.status_stage_morula].ToString(); vs1.status_stage_cleavage = dt.Rows[0][lformDay1.status_stage_cleavage].ToString(); vs1.status_embryo_tranfer = dt.Rows[0][lformDay1.status_embryo_tranfer].ToString(); vs1.status_embryo_tranfer_day = dt.Rows[0][lformDay1.status_embryo_tranfer_day].ToString(); vs1.status_embryo_tranfer_embryo_glue = dt.Rows[0][lformDay1.status_embryo_tranfer_embryo_glue].ToString(); vs1.status_discard_all = dt.Rows[0][lformDay1.status_discard_all].ToString(); vs1.status_remark = dt.Rows[0][lformDay1.status_remark].ToString(); vs1.remark_other = dt.Rows[0][lformDay1.remark_other].ToString(); vs1.active = dt.Rows[0][lformDay1.active].ToString(); vs1.remark = dt.Rows[0][lformDay1.remark].ToString(); vs1.date_create = dt.Rows[0][lformDay1.date_create].ToString(); vs1.date_modi = dt.Rows[0][lformDay1.date_modi].ToString(); vs1.date_cancel = dt.Rows[0][lformDay1.date_cancel].ToString(); vs1.user_create = dt.Rows[0][lformDay1.user_create].ToString(); vs1.user_modi = dt.Rows[0][lformDay1.user_modi].ToString(); vs1.user_cancel = dt.Rows[0][lformDay1.user_cancel].ToString(); vs1.form_a_id = dt.Rows[0][lformDay1.form_a_id].ToString(); vs1.fertili_2_pn = dt.Rows[0][lformDay1.fertili_2_pn].ToString(); } else { setLabFormDay1(vs1); } return(vs1); }
public LabFormDay1 selectByPk1(String pttId) { LabFormDay1 cop1 = new LabFormDay1(); DataTable dt = new DataTable(); String sql = "select lformDay1.* " + "From " + lformDay1.table + " lformDay1 " + "Where lformDay1." + lformDay1.pkField + " ='" + pttId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setLabFormDay1(dt); return(cop1); }
private void initConfig() { lformDay1 = new LabFormDay1(); lformDay1.form_day1_id = "form_day1_id"; lformDay1.t_patient_id = "t_patient_id"; lformDay1.t_visit_id = "t_visit_id"; lformDay1.day1_date = "day1_date"; lformDay1.form_day1_code = "form_day1_code"; lformDay1.hn_male = "hn_male"; lformDay1.hn_female = "hn_female"; lformDay1.name_male = "name_male"; lformDay1.name_female = "name_female"; lformDay1.hn_donor = "hn_donor"; lformDay1.name_donor = "name_donor"; lformDay1.day1_remark = "day1_remark"; lformDay1.dob_male = "dob_male"; lformDay1.dob_female = "dob_female"; lformDay1.dob_donor = "dob_donor"; lformDay1.status_no_biopsy = "status_no_biopsy"; lformDay1.status_biopsy_pgs = "status_biopsy_pgs"; lformDay1.status_biopsy_ngs = "status_biopsy_ngs"; lformDay1.status_biopsy_ngs_7_pair = "status_biopsy_ngs_7_pair"; lformDay1.status_biopsy_ngs_23_pair = "status_biopsy_ngs_23_pair"; lformDay1.biopsy_pgs_min = "biopsy_pgs_min"; lformDay1.biopsy_pgs_max = "biopsy_pgs_max"; lformDay1.biopsy_ngs_min = "biopsy_ngs_min"; lformDay1.biopsy_ngs_max = "biopsy_ngs_max"; lformDay1.status_embryo_freezing_day = "status_embryo_freezing_day"; lformDay1.embryo_freezing_day = "embryo_freezing_day"; lformDay1.embryo_freezing_day_max = "embryo_freezing_day_max"; lformDay1.status_stage_blastocyst = "status_stage_blastocyst"; lformDay1.status_stage_morula = "status_stage_morula"; lformDay1.status_stage_cleavage = "status_stage_cleavage"; lformDay1.status_embryo_tranfer = "status_embryo_tranfer"; lformDay1.status_embryo_tranfer_day = "status_embryo_tranfer_day"; lformDay1.status_embryo_tranfer_embryo_glue = "status_embryo_tranfer_embryo_glue"; lformDay1.status_discard_all = "status_discard_all"; lformDay1.status_remark = "status_remark"; lformDay1.remark_other = "remark_other"; lformDay1.active = "active"; lformDay1.remark = "remark"; lformDay1.date_create = "date_create"; lformDay1.date_modi = "date_modi"; lformDay1.date_cancel = "date_cancel"; lformDay1.user_create = "user_create"; lformDay1.user_modi = "user_modi"; lformDay1.user_cancel = "user_cancel"; lformDay1.form_a_id = "form_a_id"; lformDay1.fertili_2_pn = "fertili_2_pn"; lformDay1.pkField = "form_day1_id"; lformDay1.table = "lab_t_form_day1"; }
public LabFormDay1 selectByVsId(String vsid) { LabFormDay1 cop1 = new LabFormDay1(); DataTable dt = new DataTable(); String sql = "select lformDay1.* " + "From " + lformDay1.table + " lformDay1 " + "Where lformDay1." + lformDay1.t_visit_id + " ='" + vsid + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setLabFormDay1(dt); return(cop1); }
public LabFormDay1 setLabFormDay1(LabFormDay1 vs1) { vs1.form_day1_id = ""; vs1.t_patient_id = ""; vs1.t_visit_id = ""; vs1.day1_date = ""; vs1.form_day1_code = ""; vs1.hn_male = ""; vs1.hn_female = ""; vs1.name_male = ""; vs1.name_female = ""; vs1.hn_donor = ""; vs1.name_donor = ""; vs1.day1_remark = ""; vs1.dob_male = ""; vs1.dob_female = ""; vs1.dob_donor = ""; vs1.status_no_biopsy = ""; vs1.status_biopsy_pgs = ""; vs1.status_biopsy_ngs = ""; vs1.status_biopsy_ngs_7_pair = ""; vs1.status_biopsy_ngs_23_pair = ""; vs1.biopsy_pgs_min = ""; vs1.biopsy_pgs_max = ""; vs1.biopsy_ngs_min = ""; vs1.biopsy_ngs_max = ""; vs1.status_embryo_freezing_day = ""; vs1.embryo_freezing_day = ""; vs1.embryo_freezing_day_max = ""; vs1.status_stage_blastocyst = ""; vs1.status_stage_morula = ""; vs1.status_stage_cleavage = ""; vs1.status_embryo_tranfer = ""; vs1.status_embryo_tranfer_day = ""; vs1.status_embryo_tranfer_embryo_glue = ""; vs1.status_discard_all = ""; vs1.status_remark = ""; vs1.remark_other = ""; vs1.active = ""; vs1.remark = ""; vs1.date_create = ""; vs1.date_modi = ""; vs1.date_cancel = ""; vs1.user_create = ""; vs1.user_modi = ""; vs1.user_cancel = ""; vs1.form_a_id = ""; vs1.fertili_2_pn = ""; return(vs1); }
public String insertLabFormday1(LabFormDay1 p, String userId) { String re = ""; if (p.form_day1_id.Equals("")) { re = insert(p, userId); } else { re = update(p, userId); } return(re); }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { setLabFormDay1(); String re = ""; long chk = 0; re = ic.ivfDB.lformDay1DB.insertLabFormday1(lFormDay1, ic.cStf.staff_id); if (long.TryParse(re, out chk)) { if (chk > 1) { LabFormDay1 formday1 = new LabFormDay1(); formday1 = ic.ivfDB.lformDay1DB.selectByPk1(re); txtFormDay1Code.Value = formday1.form_day1_code; } } } }
public String update(LabFormDay1 p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); sql = "Update " + lformDay1.table + " " + //" Set "+lformA.patient_appoint_date_time + "='"+p.patient_appoint_date_time + "' " + "Set " + lformDay1.t_patient_id + "='" + p.t_patient_id + "'" + "," + lformDay1.t_visit_id + "='" + p.t_visit_id + "'" + "," + lformDay1.day1_date + "='" + p.day1_date + "'" + "," + lformDay1.form_day1_code + "='" + p.form_day1_code + "'" + "," + lformDay1.hn_male + "='" + p.hn_male + "'" + "," + lformDay1.hn_female + "='" + p.hn_female + "'" + "," + lformDay1.hn_donor + "='" + p.hn_donor + "'" + "," + lformDay1.name_donor + "='" + p.name_donor.Replace("'", "''") + "'" + "," + lformDay1.day1_remark + "='" + p.day1_remark + "'" + "," + lformDay1.dob_male + "='" + p.dob_male + "'" + "," + lformDay1.dob_female + "='" + p.dob_female + "'" + "," + lformDay1.dob_donor + "='" + p.dob_donor + "'" + "," + lformDay1.status_no_biopsy + "='" + p.status_no_biopsy + "'" + "," + lformDay1.status_biopsy_pgs + "='" + p.status_biopsy_pgs + "'" + "," + lformDay1.status_biopsy_ngs + "='" + p.status_biopsy_ngs + "'" + "," + lformDay1.status_biopsy_ngs_7_pair + "='" + p.status_biopsy_ngs_7_pair + "'" + "," + lformDay1.status_biopsy_ngs_23_pair + "='" + p.status_biopsy_ngs_23_pair + "'" + "," + lformDay1.biopsy_pgs_min + "='" + p.biopsy_pgs_min + "'" + "," + lformDay1.biopsy_pgs_max + "='" + p.biopsy_pgs_max + "'" + "," + lformDay1.biopsy_ngs_min + "='" + p.biopsy_ngs_min + "'" + "," + lformDay1.biopsy_ngs_max + "='" + p.biopsy_ngs_max + "'" + "," + lformDay1.status_embryo_freezing_day + "='" + p.status_embryo_freezing_day + "'" + "," + lformDay1.embryo_freezing_day + "='" + p.embryo_freezing_day + "'" + "," + lformDay1.embryo_freezing_day_max + "='" + p.embryo_freezing_day_max + "'" + "," + lformDay1.status_stage_blastocyst + "='" + p.status_stage_blastocyst + "'" + "," + lformDay1.status_stage_morula + "='" + p.status_stage_morula + "'" + "," + lformDay1.status_stage_cleavage + "='" + p.status_stage_cleavage + "'" + "," + lformDay1.status_embryo_tranfer + "='" + p.status_embryo_tranfer + "'" + "," + lformDay1.status_embryo_tranfer_day + "='" + p.status_embryo_tranfer_day + "'" + "," + lformDay1.status_embryo_tranfer_embryo_glue + "='" + p.status_embryo_tranfer_embryo_glue + "'" + "," + lformDay1.status_discard_all + "='" + p.status_discard_all + "'" + "," + lformDay1.status_remark + "='" + p.status_remark + "'" + "," + lformDay1.remark_other + "='" + p.remark_other.Replace("'", "''") + "'" + "," + lformDay1.date_modi + "=now() " + "," + lformDay1.user_modi + "='" + userId + "@" + conn._IPAddress + "' " + "," + lformDay1.form_a_id + "='" + p.form_a_id + "'" + "," + lformDay1.fertili_2_pn + "='" + p.fertili_2_pn + "'" + " Where " + lformDay1.pkField + " = '" + p.form_day1_id + "' " ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public String insert(LabFormDay1 p, String userId) { String re = ""; String sql = ""; chkNull(p); try { sql = "Insert Into " + lformDay1.table + " " + "Set " + lformDay1.t_patient_id + "='" + p.t_patient_id + "'" + "," + lformDay1.t_visit_id + "='" + p.t_visit_id + "'" + "," + lformDay1.day1_date + "='" + p.day1_date + "'" + "," + lformDay1.form_day1_code + "='" + p.form_day1_code + "'" + "," + lformDay1.hn_male + "='" + p.hn_male + "'" + "," + lformDay1.hn_female + "='" + p.hn_female + "'" + "," + lformDay1.hn_donor + "='" + p.hn_donor + "'" + "," + lformDay1.name_donor + "='" + p.name_donor + "'" + "," + lformDay1.day1_remark + "='" + p.day1_remark + "'" + "," + lformDay1.dob_male + "='" + p.dob_male + "'" + "," + lformDay1.dob_female + "='" + p.dob_female + "'" + "," + lformDay1.dob_donor + "='" + p.dob_donor + "'" + "," + lformDay1.status_no_biopsy + "='" + p.status_no_biopsy + "'" + "," + lformDay1.status_biopsy_pgs + "='" + p.status_biopsy_pgs + "'" + "," + lformDay1.status_biopsy_ngs + "='" + p.status_biopsy_ngs + "'" + "," + lformDay1.status_biopsy_ngs_7_pair + "='" + p.status_biopsy_ngs_7_pair + "'" + "," + lformDay1.status_biopsy_ngs_23_pair + "='" + p.status_biopsy_ngs_23_pair + "'" + "," + lformDay1.biopsy_pgs_min + "='" + p.biopsy_pgs_min + "'" + "," + lformDay1.biopsy_pgs_max + "='" + p.biopsy_pgs_max + "'" + "," + lformDay1.biopsy_ngs_min + "='" + p.biopsy_ngs_min + "'" + "," + lformDay1.biopsy_ngs_max + "='" + p.biopsy_ngs_max + "'" + "," + lformDay1.status_embryo_freezing_day + "='" + p.status_embryo_freezing_day + "'" + "," + lformDay1.embryo_freezing_day + "='" + p.embryo_freezing_day + "'" + "," + lformDay1.embryo_freezing_day_max + "='" + p.embryo_freezing_day_max + "'" + "," + lformDay1.status_stage_blastocyst + "='" + p.status_stage_blastocyst + "'" + "," + lformDay1.status_stage_morula + "='" + p.status_stage_morula + "'" + "," + lformDay1.status_stage_cleavage + "='" + p.status_stage_cleavage + "'" + "," + lformDay1.status_embryo_tranfer + "='" + p.status_embryo_tranfer + "'" + "," + lformDay1.status_embryo_tranfer_day + "='" + p.status_embryo_tranfer_day + "'" + "," + lformDay1.status_embryo_tranfer_embryo_glue + "='" + p.status_embryo_tranfer_embryo_glue + "'" + "," + lformDay1.status_discard_all + "='" + p.status_discard_all + "'" + "," + lformDay1.status_remark + "='" + p.status_remark + "'" + "," + lformDay1.remark_other + "='" + p.remark_other + "'" + "," + lformDay1.active + "='" + p.active + "' " + "," + lformDay1.remark + "='" + p.remark + "' " + "," + lformDay1.date_create + "=now() " + "," + lformDay1.date_modi + "='' " + "," + lformDay1.date_cancel + "='' " + "," + lformDay1.user_create + "='" + userId + "@" + conn._IPAddress + "' " + "," + lformDay1.user_modi + "='' " + "," + lformDay1.user_cancel + "='' " + "," + lformDay1.form_a_id + "='" + p.form_a_id + "'" + "," + lformDay1.fertili_2_pn + "='" + p.fertili_2_pn + "'" + ""; re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private void chkNull(LabFormDay1 p) { long chk = 0; decimal 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.day1_date = p.day1_date == null ? "" : p.day1_date; p.form_day1_code = p.form_day1_code == null ? "" : p.form_day1_code; p.hn_male = p.hn_male == null ? "" : p.hn_male; p.hn_female = p.hn_female == null ? "" : p.hn_female; p.name_male = p.name_male == null ? "" : p.name_male; p.name_female = p.name_female == null ? "" : p.name_female; p.hn_donor = p.hn_donor == null ? "" : p.hn_donor; p.name_donor = p.name_donor == null ? "" : p.name_donor; p.day1_remark = p.day1_remark == null ? "" : p.day1_remark; p.dob_male = p.dob_male == null ? "" : p.dob_male; p.dob_female = p.dob_female == null ? "" : p.dob_female; p.dob_donor = p.dob_donor == null ? "" : p.dob_donor; p.biopsy_pgs_min = p.biopsy_pgs_min == null ? "" : p.biopsy_pgs_min; p.biopsy_pgs_max = p.biopsy_pgs_max == null ? "" : p.biopsy_pgs_max; p.biopsy_ngs_min = p.biopsy_ngs_min == null ? "" : p.biopsy_ngs_min; p.biopsy_ngs_max = p.biopsy_ngs_max == null ? "" : p.biopsy_ngs_max; p.embryo_freezing_day = p.embryo_freezing_day == null ? "" : p.embryo_freezing_day; p.embryo_freezing_day_max = p.embryo_freezing_day_max == null ? "" : p.embryo_freezing_day_max; p.remark_other = p.remark_other == null ? "" : p.remark_other; p.active = p.active == null ? "1" : p.active; p.remark = p.remark == null ? "" : p.remark; p.fertili_2_pn = p.fertili_2_pn == null ? "" : p.fertili_2_pn; //p.opu_date = p.opu_date == null ? "" : p.opu_date; //p.opu_date = p.opu_date == null ? "" : p.opu_date; //p.opu_date = p.opu_date == null ? "" : p.opu_date; //p.opu_date = p.opu_date == null ? "" : p.opu_date; //p.opu_date = p.opu_date == null ? "" : p.opu_date; p.status_no_biopsy = p.status_no_biopsy == null ? "0" : p.status_no_biopsy; p.status_biopsy_pgs = p.status_biopsy_pgs == null ? "0" : p.status_biopsy_pgs; p.status_biopsy_ngs = p.status_biopsy_ngs == null ? "0" : p.status_biopsy_ngs; p.status_biopsy_ngs_7_pair = p.status_biopsy_ngs_7_pair == null ? "0" : p.status_biopsy_ngs_7_pair; p.status_biopsy_ngs_23_pair = p.status_biopsy_ngs_23_pair == null ? "0" : p.status_biopsy_ngs_23_pair; p.status_embryo_freezing_day = p.status_embryo_freezing_day == null ? "0" : p.status_embryo_freezing_day; p.status_stage_blastocyst = p.status_stage_blastocyst == null ? "0" : p.status_stage_blastocyst; p.status_stage_morula = p.status_stage_morula == null ? "0" : p.status_stage_morula; p.status_stage_cleavage = p.status_stage_cleavage == null ? "0" : p.status_stage_cleavage; p.status_embryo_tranfer = p.status_embryo_tranfer == null ? "0" : p.status_embryo_tranfer; p.status_embryo_tranfer_day = p.status_embryo_tranfer_day == null ? "0" : p.status_embryo_tranfer_day; p.status_embryo_tranfer_embryo_glue = p.status_embryo_tranfer_embryo_glue == null ? "0" : p.status_embryo_tranfer_embryo_glue; p.status_discard_all = p.status_discard_all == null ? "0" : p.status_discard_all; p.status_remark = p.status_remark == null ? "0" : p.status_remark; //p.y_selection = p.y_selection == null ? "0" : p.y_selection; //p.y_selection = p.y_selection == null ? "0" : p.y_selection; //p.y_selection = p.y_selection == null ? "0" : p.y_selection; //p.y_selection = p.y_selection == null ? "0" : p.y_selection; //p.y_selection = p.y_selection == null ? "0" : p.y_selection; p.t_patient_id = long.TryParse(p.t_patient_id, out chk) ? chk.ToString() : "0"; p.t_visit_id = long.TryParse(p.t_visit_id, out chk) ? chk.ToString() : "0"; p.form_a_id = long.TryParse(p.form_a_id, out chk) ? chk.ToString() : "0"; //p.t_patient_id = long.TryParse(p.t_patient_id, out chk) ? chk.ToString() : "0"; //p.t_patient_id = long.TryParse(p.t_patient_id, out chk) ? chk.ToString() : "0"; //p.t_patient_id = long.TryParse(p.t_patient_id, out chk) ? chk.ToString() : "0"; }
private void setControl() { lFormDay1 = ic.ivfDB.lformDay1DB.selectByPk1(lformDay1Id); vs = ic.ivfDB.vsDB.selectByPk1(vsid); ptt = ic.ivfDB.pttDB.selectByPk1(pttid); if (lFormDay1.form_day1_id.Equals("")) { lFormDay1 = ic.ivfDB.lformDay1DB.selectByVsId(vs.t_visit_id); } if (!lFormDay1.form_day1_id.Equals("")) // found { LabRequest req = new LabRequest(); //opu = ic.ivfDB.opuDB.selectByReqID(req.req_id); setControl1(); } else// Not found { ovs = ic.ivfDB.ovsDB.selectByPk1(vsidOld); txtHnFeMale.Value = ptt.patient_hn; txtNameFeMale.Value = ptt.Name; txtDobFeMale.Value = ptt.AgeString(); txtHnMale.Value = ptt.patient_hn_couple; txtNameMale.Value = ptt.patient_couple_firstname; txtPttId.Value = ptt.t_patient_id; txtVsId.Value = vs.t_visit_id; txtAgent.Value = ic.ivfDB.oAgnDB.getAgentNameById(ptt.agent); ic.setC1Combo(cboDoctor, vs.doctor_id); txtFormDay1Date.Value = DateTime.Now.Year.ToString() + "-" + DateTime.Now.ToString("MM-dd"); if (ic.iniC.statusAppDonor.Equals("1")) { if (ptt.f_sex_id.Equals("1"))//male { Patient ptt1 = new Patient(); ptt1 = ic.ivfDB.pttDB.selectByHn(ptt.patient_hn_1); txtHnMale.Value = ptt.patient_hn; txtNameMale.Value = ptt.Name; txtHnFeMale.Value = ptt.patient_hn_1; txtNameFeMale.Value = ptt1.Name; txtDobFeMale.Value = ptt1.patient_birthday; txtDobMale.Value = ptt.patient_birthday; } else if (ptt.f_sex_id.Equals("2")) //female { if (!ptt.patient_hn_1.Equals("") && !ptt.patient_hn_2.Equals("")) // record donor { txtHnFeMale.Value = ptt.patient_hn_1; txtHnMale.Value = ptt.patient_hn_2; txtHnDonor.Value = ptt.patient_hn; txtNameDonor.Value = ptt.Name; Patient ptt1 = new Patient(); ptt1 = ic.ivfDB.pttDB.selectByHn(ptt.patient_hn_1); txtNameFeMale.Value = ptt1.Name; Patient ptt2 = new Patient(); ptt2 = ic.ivfDB.pttDB.selectByHn(ptt.patient_hn_2); txtNameMale.Value = ptt2.Name; txtDobFeMale.Value = ptt1.patient_birthday; txtDobMale.Value = ptt2.patient_birthday; } else if (ptt.patient_hn_1.Equals("") && !ptt.patient_hn_2.Equals("")) // record female { Patient ptt1 = new Patient(); ptt1 = ic.ivfDB.pttDB.selectByHn(ptt.patient_hn_2); txtHnMale.Value = ptt.patient_hn_2; txtNameMale.Value = ptt1.Name; txtHnFeMale.Value = ptt.patient_hn; txtNameFeMale.Value = ptt.Name; txtDobMale.Value = ptt1.patient_birthday; txtDobFeMale.Value = ptt.patient_birthday; } } } else { if (ptt.f_sex_id.Equals("1"))//male { Patient ptt1 = new Patient(); ptt1 = ic.ivfDB.pttDB.selectByHn(ptt.patient_hn_1); txtHnMale.Value = ptt.patient_hn; txtNameMale.Value = ptt.Name; txtHnFeMale.Value = ptt.patient_hn_1; txtNameFeMale.Value = ptt1.Name; txtDobMale.Value = ptt.patient_birthday; txtDobFeMale.Value = ptt1.patient_birthday; } else if (ptt.f_sex_id.Equals("2"))//female { Patient ptt2 = new Patient(); ptt2 = ic.ivfDB.pttDB.selectByHn(ptt.patient_hn_2); txtHnMale.Value = ptt.patient_hn_2; txtNameMale.Value = ptt2.Name; txtHnFeMale.Value = ptt.patient_hn; txtNameFeMale.Value = ptt.Name; txtDobMale.Value = ptt2.patient_birthday; txtDobFeMale.Value = ptt.patient_birthday; } } } }