private void setOrRequest() { orreq.or_req_id = txtID.Text; orreq.or_req_code = ic.ivfDB.copDB.genReqDoc(); orreq.or_req_date = ic.datetoDB(txtReqDate.Text); orreq.patient_hn = txtHn.Text; orreq.patient_name = txtPttNameE.Text; orreq.remark = cboDiag.Text; orreq.date_create = ""; orreq.date_modi = ""; orreq.date_cancel = ""; orreq.user_create = ""; orreq.user_modi = ""; orreq.user_cancel = ""; orreq.active = ""; orreq.doctor_anesthesia_id = ""; orreq.doctor_surgical_id = ""; orreq.or_date = ic.datetoDB(txtOrDate.Text); orreq.or_time = txtOrTime.Text; orreq.status_or = "1"; orreq.b_service_point_id = cboVisitBsp.SelectedItem == null ? "" : ((ComboBoxItem)cboVisitBsp.SelectedItem).Value;; orreq.or_id = ""; orreq.opera_id = txtDiagId.Text; orreq.t_patient_id = txtPttId.Text; orreq.status_urgent = chkUrgent.Checked ? "1" : "2"; orreq.anesthesia_id = txtAnesId.Text; orreq.doctor_surgical_id = txtDtrId.Text; }
private void setWithDraw() { dwithdraw.active = "1"; dwithdraw.deposit_id = txtId.Text.Trim(); dwithdraw.withdraw_id = txtWithDrawId.Text.Trim(); dwithdraw.withdraw_name = txtWithDrawName.Text.Trim(); dwithdraw.withdraw_code = txtWithDrawCode.Text.Trim(); dwithdraw.withdraw_date = ic.datetoDB(txtWithDrawDate.Text); dwithdraw.patient_hn = txtHn.Text.Trim(); dwithdraw.remark = txtWithDrawRemark.Text.Trim(); dwithdraw.withdraw_amount = txtWithDrawAmount.Text; dwithdraw.visit_vn = txtWithDrawVn.Text; dwithdraw.t_visit_id = txtWithDrawVisitId.Text; dwithdraw.t_patient_id = txtWithDrawPttId.Text.Trim(); }
private void setLabRequest() { lbReq.req_id = txtID.Text; lbReq.req_code = ic.ivfDB.copDB.genReqDoc(); lbReq.req_date = ic.datetoDB(txtReqDate.Text); lbReq.hn_male = ""; lbReq.name_male = ""; lbReq.hn_female = txtHn.Text; lbReq.name_female = txtName.Text; lbReq.status_req = "1"; lbReq.accept_date = ""; lbReq.start_date = ""; lbReq.result_date = ""; lbReq.visit_id = ""; lbReq.vn = txtVn.Text; lbReq.active = "1"; lbReq.remark = txtRemark.Text; lbReq.date_create = ""; lbReq.date_modi = ""; lbReq.date_cancel = ""; lbReq.user_create = ""; lbReq.user_modi = ""; lbReq.user_cancel = ""; lbReq.item_id = cboLabReq.SelectedItem != null ? ((ComboBoxItem)(cboLabReq.SelectedItem)).Value : ""; lbReq.doctor_id = cboDoctor.SelectedItem != null ? ((ComboBoxItem)(cboDoctor.SelectedItem)).Value : ""; }
private void setLabPrescription() { labPresc.presc_id = txtID.Text; labPresc.opu_fet_id = opufetid; labPresc.presc_date = ic.datetoDB(txtDate.Text); labPresc.visit_hn = hn; labPresc.pkg_id = cboPkg.SelectedItem == null ? "" : ((ComboBoxItem)cboPkg.SelectedItem).Value; labPresc.status_embryo_freezing = chkEmbryoFreezing.Checked ? "1" : "0"; labPresc.embryo_freezing = txtEmbryoFreezing.Text.Trim(); labPresc.embryo_straws = txtEmbryoStraws.Text.Trim(); labPresc.embryo_straws_extra = txtEmbryoStrawsExtra.Text.Trim(); labPresc.status_ngs = chkNGS.Checked ? "1" : "0"; labPresc.embryo_ngs = txtNGSEmbryo.Text.Trim(); labPresc.embryo_ngs_extra = txtNGSExtra.Text.Trim(); labPresc.status_pgs = chkPGS.Checked ? "1" : "0"; labPresc.embryo_pgs = txtPGSEmbryo.Text.Trim(); labPresc.embryo_pgs_extra = txtPGSExtra.Text.Trim(); labPresc.status_day6 = chkDay6.Checked ? "1" : "0"; labPresc.status_assisted_hatching = chkAssistedHatching.Checked ? "1" : "0"; labPresc.status_ha = chkHA.Checked ? "1" : "0"; labPresc.status_sperm_selection = chkSpermSelection.Checked ? "1" : "0"; labPresc.sperm_selection = txtSpermSelection.Text.Trim(); labPresc.status_sperm_precaution = chkSpermPrecaution.Checked ? "1" : "0"; labPresc.sperm_precaution = txtSpermPrecaution.Text.Trim(); labPresc.status_embryo_glue = chkEmbryoGlue.Checked ? "1" : "0"; labPresc.status_embryo_remaining = chkEmbryoRemaining.Checked ? "1" : "0"; labPresc.embryo_remaining = txtEmbryoRemaining.Text.Trim(); labPresc.status_discard_all = chkDiscardAll.Checked ? "1" : "0"; labPresc.staff_id = cboStfId.SelectedItem == null ? "" : ((ComboBoxItem)cboStfId.SelectedItem).Value; labPresc.checkby_id = cboChkId.SelectedItem == null ? "" : ((ComboBoxItem)cboChkId.SelectedItem).Value; }
private void setVisit() { vs = new Visit(); vs = ic.ivfDB.vsDB.setVisit1(vs); vs.t_visit_id = txtID.Text; vs.visit_hn = txtHn.Text; vs.t_patient_id = txtPttId.Text; vs.b_service_point_id = cboBsp.SelectedItem == null ? "" : ((ComboBoxItem)cboBsp.SelectedItem).Value; vs.visit_notice = txtComment.Text; vs.visit_begin_visit_time = DateTime.Now.Year.ToString() + "-" + DateTime.Now.ToString("MM-dd hh:mm:ss"); vs.visit_vn = ic.ivfDB.copDB.genVNDoc(); vs.remark = txtRemark.Text; vs.f_visit_status_id = "1"; vs.visit_record_staff = txtStfConfirmID.Text; vs.f_visit_type_id = ic.iniC.statusAppDonor.Equals("1") ? "2" : "1"; vs.status_urge = chkUrge.Checked ? "1" : "0"; vs.patient_hn_1 = txtHnFemale.Text; vs.lmp = ic.datetoDB(txtLMP.Text); vs.height = txtHeight.Text; vs.bw = txtBW.Text; vs.bp = txtBP.Text; vs.queue_id = ic.ivfDB.copDB.genQueueDoc(); vs.pulse = txtPulse.Text; vs.status_nurse = "1"; vs.patient_hn_male = txtHnMale.Text; }
private void setLabFormDay1() { lFormDay1.form_day1_id = txtID.Text; //txtLabFormACode.Value = lFormA.form_a_code; lFormDay1.t_patient_id = txtPttId.Text; lFormDay1.t_visit_id = txtVsId.Text; //txtVnOld.Value = lFormDay1.vn_old; //txtHnOld.Value = lFormDay1.hn_old; lFormDay1.hn_female = txtHnFeMale.Text; lFormDay1.name_female = txtNameFeMale.Text; lFormDay1.name_male = txtNameMale.Text; lFormDay1.hn_male = txtHnMale.Text; lFormDay1.dob_female = ic.datetoDB(txtDobFeMale.Text); lFormDay1.dob_male = ic.datetoDB(txtDobMale.Text); lFormDay1.form_day1_code = txtFormDay1Code.Text.Trim().Equals("") ? ic.ivfDB.copDB.genFormADay1Doc() : txtFormDay1Code.Text.Trim(); lFormDay1.day1_date = ic.datetoDB(txtFormDay1Date.Text); //ic.setC1Combo(cboDoctor, lFormDay1.doctor_id); //txtFertili2Pn.Value = opu.fertili_2_pn; lFormDay1.fertili_2_pn = txtFertili2Pn.Text; //ic.setC1Combo(cboDoctor, lFormDay1.doctor_id); //lFormDay1.form_day1_code = txtLabFormACode.Text; lFormDay1.status_no_biopsy = chkNoBiopsy.Checked ? "1" : "2"; //lFormDay1.status_no_biopsy = chkBiopsy.Checked ? "2" : "1"; lFormDay1.status_biopsy_pgs = chkPgsMin.Checked ? "1" : "0"; //lFormDay1.status_biopsy_pgs = chkPgsMin.Checked ? "1" : "0"; lFormDay1.status_biopsy_ngs = chkNgs.Checked ? "1" : "0"; lFormDay1.status_biopsy_ngs_7_pair = chkNgs7Pair.Checked ? "1" : "0"; lFormDay1.status_biopsy_ngs_23_pair = chkNgs23Pair.Checked ? "1" : "0"; lFormDay1.biopsy_ngs_min = txtNgsMin.Text; lFormDay1.biopsy_ngs_max = txtNgsMax.Text; lFormDay1.embryo_freezing_day = chkEmbryoFreezingDay.Checked ? "1" : "0"; //ic.setC1Combo(cboEmbryoFreezingDay, lFormDay1.embryo_freezing_day); lFormDay1.embryo_freezing_day = cboEmbryoFreezingDay.SelectedItem == null ? "" : ((ComboBoxItem)cboEmbryoFreezingDay.SelectedItem).Value; lFormDay1.embryo_freezing_day_max = txtEmbryoFreezingEmbryoMax.Text; lFormDay1.status_stage_blastocyst = chkBlastocyst.Checked ? "1" : "0"; lFormDay1.status_stage_morula = chkMorula.Checked ? "1" : "0"; lFormDay1.status_embryo_tranfer = chkEmbryoTransferFresh.Checked ? "1": "0"; lFormDay1.status_embryo_tranfer_embryo_glue = chkEmbryoGlue.Checked ? "1" : "0"; lFormDay1.status_embryo_tranfer_day = chkEmbryoTransferFreshDay3.Checked ? "3" : "5"; //chkEmbryoTransferFreshDay5.Checked = lFormDay1.status_embryo_tranfer_day.Equals("5") ? true : false; lFormDay1.status_discard_all = chkDiscard.Checked ? "1" : "0"; lFormDay1.remark = cboRemark.Text; }
private void setStockDrug() { stkr.rec_id = txtId.Text.Trim(); stkr.rec_doc = txtRecDoc.Text.Trim();; stkr.inv_ex = ""; stkr.description = txtDescription.Text.Trim(); stkr.rec_date = ic.datetoDB(txtRecDate.Text); stkr.inv_ex_date = ""; stkr.comp_id = ""; stkr.vend_id = ""; stkr.active = ""; stkr.remark = txtRemark.Text.Trim(); stkr.date_create = ""; stkr.date_modi = ""; stkr.date_cancel = ""; stkr.user_create = ""; stkr.user_modi = ""; stkr.user_cancel = ""; stkr.branch_id = ""; stkr.status_stock = ""; stkr.stock_sub_id = cboStkSubName.SelectedItem == null ? "" : ((ComboBoxItem)cboStkSubName.SelectedItem).Value; }
private void BtnConvertApm_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ConnectDB connS; pB1.Show(); pB1.Minimum = 0; connS = new ConnectDB(ic.iniC); connS.conn.ConnectionString = "Server=" + txtShost.Text + ";Database=" + txtSdatabase.Text + ";Uid=" + txtSuser.Text + ";Pwd=" + txtSpassword.Text + ";port = " + txtSport.Text + "; Connection Timeout = 300;default command timeout=0; CharSet=utf8;SslMode=none;"; DataTable dtPtt = new DataTable(); String sql = ""; sql = "Select * " + "From t_patient "; dtPtt = connS.selectData(connS.conn, sql); DataTable dtVs = new DataTable(); sql = "Select * " + "From t_patient "; dtVs = connS.selectData(connS.conn, sql); DataTable dtApm = new DataTable(); sql = "Select ID, PID, PIDS, AppTime, DATE_FORMAT(AppDate, '%Y-%m-%d') as AppDate, Doctor, Status, PatientName, MobilePhoneNo, PName, PSurname, HormoneTest, TVS, OPU, OPUTime, OPURemark, ET_FET, ET_FET_Time, BetaHCG, Other, OtherRemark, Comment " + "From Appointment "; //sql = "Select ID, PID, PIDS, AppTime, Doctor, Status, PatientName, MobilePhoneNo, PName, PSurname, HormoneTest, TVS, OPU, OPUTime, OPURemark, ET_FET, ET_FET_Time, BetaHCG, Other, OtherRemark, Comment " + // "From Appointment "; dtApm = connS.selectData(connS.conn, sql); if (dtApm.Rows.Count > 0) { pB1.Maximum = dtApm.Rows.Count + 1; //sql = "Delete From t_patient Where status_convert = '1' "; //connS.ExecuteNonQuery(ic.conn.conn, sql); foreach (DataRow row in dtApm.Rows) { String time = "", pttid = "", dtr = ""; time = "0" + row["AppTime"].ToString(); if (time.Length >= 5) { time = time.Substring(time.Length - 5); } DataRow[] resPtt = dtPtt.Select("patient_hn = '" + row["PIDS"].ToString() + "'"); if (resPtt.Length > 0) { try { pttid = resPtt[0]["PIDS"].ToString(); } catch (Exception ex) { } } //DataRow[] resVs = dtVs.Select("PIDS = '" + row["PIDS"].ToString() + "'"); //if (resPtt.Length > 0) //{ // pttid = resPtt[0]["PIDS"].ToString(); //} //Patient ptt = new Patient(); //ptt = ic.ivfDB.pttDB.selectByHn(row["PIDS"].ToString()); PatientAppointment pApm = new PatientAppointment(); pApm.t_patient_appointment_id = ""; pApm.t_patient_id = pttid; pApm.patient_appoint_date_time = ic.datetoDB(row["AppDate"].ToString()); pApm.patient_appointment_date = ic.datetoDB(row["AppDate"].ToString()); pApm.patient_appointment_time = time; pApm.patient_appointment = row["Comment"].ToString(); pApm.patient_appointment_doctor = row["Doctor"].ToString().Trim().Equals("DR. Thitikorn") ? "1" : row["Doctor"].ToString().Trim().Equals("DR. Thitikorn Wanichkul") ? "1" : row["Doctor"].ToString().Trim().Equals("Thitikorn") ? "1" : row["Doctor"].ToString().Trim().Equals("DR. Wisut") ? "2" : row["Doctor"].ToString().Trim().Equals("DR. Visut Suvithayasiri") ? "2" : row["Doctor"].ToString().Trim().Equals("DR. Sakchai") ? "5" : row["Doctor"].ToString().Trim().Equals("DR. Niwat") ? "3" : row["Doctor"].ToString().Trim().Equals("DR. Niwar") ? "3" : "0"; pApm.patient_appointment_servicepoint = "2120000002"; pApm.patient_appointment_notice = row["Comment"].ToString(); pApm.t_visit_id = ""; pApm.patient_appointment_vn = ""; pApm.remark = row["OtherRemark"].ToString(); pApm.opu_remark = row["OPURemark"].ToString(); pApm.opu_time = row["OPUTime"].ToString(); pApm.opu = row["OPU"].ToString(); pApm.hormone_test = row["HormoneTest"].ToString(); pApm.tvs = row["TVS"].ToString(); //pApm.et = row["HormoneTest"].ToString(); pApm.fet = row["ET_FET"].ToString(); pApm.fet_time = row["ET_FET_Time"].ToString(); pApm.beta_hgc = row["BetaHCG"].ToString(); pApm.other = row["Other"].ToString(); pApm.other_remark = row["OtherRemark"].ToString(); pApm.status_convert = "1"; pApm.active = row["Status"].ToString().Equals("1") ? "1" : "3"; pApm.patient_hn_papm = row["PIDS"].ToString(); ic.ivfDB.pApmDB.insertPatientAppointment(pApm, ""); pB1.Value++; } } pB1.Hide(); }
private void setGrfSearch(String search) { //grfDept.Rows.Count = 7; tC.SelectedTab = tabSearch; //grfSearch.Clear(); DataTable dt1 = new DataTable(); DataTable dt = new DataTable(); if (search.Equals("")) { String date = ""; DateTime dt11 = new DateTime(); if (DateTime.TryParse(txtDateStart.Text, out dt11)) { date = dt11.Year + "-" + dt11.ToString("MM-dd"); dt = ic.ivfDB.ovsDB.selectByHnFormA(date); } } else { dt = ic.ivfDB.ovsDB.selectByHNLike(search); dt = ic.ivfDB.vsDB.selectByStatusCashierSearch(txtSearch.Text, ic.datetoDB(txtDateStart.Text)); //+0020 //grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search); } grfSearch.Rows.Count = 1; grfSearch.Rows.Count = dt.Rows.Count + 1; grfSearch.Cols.Count = 10; //C1TextBox txt = new C1TextBox(); //C1ComboBox cboproce = new C1ComboBox(); //ic.ivfDB.itmDB.setCboItem(cboproce); //grfSearch.Cols[colPttHn].Editor = txt; //grfSearch.Cols[colPttName].Editor = txt; //grfSearch.Cols[colVsDate].Editor = txt; grfSearch.Cols[colVNshow].Width = 120; grfSearch.Cols[colPttHn].Width = 120; grfSearch.Cols[colPttName].Width = 300; grfSearch.Cols[colVsDate].Width = 100; grfSearch.Cols[colVsTime].Width = 80; grfSearch.Cols[colVsEtime].Width = 80; grfSearch.Cols[colStatus].Width = 200; grfSearch.ShowCursor = true; //grdFlex.Cols[colID].Caption = "no"; //grfDept.Cols[colCode].Caption = "รหัส"; grfSearch.Cols[colVNshow].Caption = "VN"; grfSearch.Cols[colPttHn].Caption = "HN"; grfSearch.Cols[colPttName].Caption = "Name"; grfSearch.Cols[colVsDate].Caption = "Date"; grfSearch.Cols[colVsTime].Caption = "Time visit"; grfSearch.Cols[colVsEtime].Caption = "Time finish"; grfSearch.Cols[colStatus].Caption = "Status"; ContextMenu menuGw = new ContextMenu(); //menuGw.MenuItems.Add("&No Appointment Close Operation", new EventHandler(ContextMenu_NO_Apm_Ptt)); grfSearch.ContextMenu = menuGw; Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor); //CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE); //rg1.Style = grfBank.Styles["date"]; //grfCu.Cols[colID].Visible = false; int i = 1; foreach (DataRow row in dt.Rows) { grfSearch[i, 0] = i; grfSearch[i, colID] = row["id"].ToString(); grfSearch[i, colVNshow] = row["VN"].ToString(); grfSearch[i, colPttHn] = row["PIDS"].ToString(); grfSearch[i, colPttName] = row["PName"].ToString(); grfSearch[i, colVsDate] = ic.datetoShow(row["VDate"]); grfSearch[i, colVsTime] = ic.timetoShow(row["VStartTime"].ToString()); grfSearch[i, colVsEtime] = ic.timetoShow(row["VEndTime"].ToString()); grfSearch[i, colStatus] = row["VName"].ToString(); grfSearch[i, colPttId] = row["PID"].ToString(); if (!row[ic.ivfDB.ovsDB.vsold.form_a_id].ToString().Equals("0")) { CellNote note = new CellNote("ส่ง Lab Request Foam A"); CellRange rg = grfSearch.GetCellRange(i, colVNshow); rg.UserData = note; } //if (i % 2 == 0) // grfPtt.Rows[i].StyleNew.BackColor = color; i++; } CellNoteManager mgr = new CellNoteManager(grfSearch); grfSearch.Cols[colID].Visible = false; grfSearch.Cols[colVNshow].AllowEditing = false; grfSearch.Cols[colPttHn].AllowEditing = false; grfSearch.Cols[colPttName].AllowEditing = false; grfSearch.Cols[colVsDate].AllowEditing = false; grfSearch.Cols[colVsTime].AllowEditing = false; grfSearch.Cols[colVsEtime].AllowEditing = false; grfSearch.Cols[colStatus].AllowEditing = false; grfSearch.Cols[colPttId].AllowEditing = false; //theme1.SetTheme(grfQue, ic.theme); }
private void setGrfFinish(String search) { //grfDept.Rows.Count = 7; grfFinish.Clear(); DataTable dt = new DataTable(); if (search.Equals("")) { //String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd"); dt = ic.ivfDB.ovsDB.selectByStatusNurseFinish(ic.datetoDB(txtDateStart.Text)); } else { //grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search); if (txtDateStart.Text.Equals("")) { dt = ic.ivfDB.ovsDB.selectByStatusNurseFinishLike(search); } } //grfExpn.Rows.Count = dt.Rows.Count + 1; grfFinish.Rows.Count = dt.Rows.Count + 1; grfFinish.Cols.Count = 10; C1TextBox txt = new C1TextBox(); //C1ComboBox cboproce = new C1ComboBox(); //ic.ivfDB.itmDB.setCboItem(cboproce); grfFinish.Cols[colPttHn].Editor = txt; grfFinish.Cols[colPttName].Editor = txt; grfFinish.Cols[colVsDate].Editor = txt; grfFinish.Cols[colVNshow].Width = 120; grfFinish.Cols[colPttHn].Width = 120; grfFinish.Cols[colPttName].Width = 300; grfFinish.Cols[colVsDate].Width = 100; grfFinish.Cols[colVsTime].Width = 80; grfFinish.Cols[colVsEtime].Width = 80; grfFinish.Cols[colStatus].Width = 200; grfFinish.ShowCursor = true; //grdFlex.Cols[colID].Caption = "no"; //grfDept.Cols[colCode].Caption = "รหัส"; grfFinish.Cols[colVNshow].Caption = "VN"; grfFinish.Cols[colPttHn].Caption = "HN"; grfFinish.Cols[colPttName].Caption = "Name"; grfFinish.Cols[colVsDate].Caption = "Date"; grfFinish.Cols[colVsTime].Caption = "Time visit"; grfFinish.Cols[colVsEtime].Caption = "Time finish"; grfFinish.Cols[colStatus].Caption = "Status"; ContextMenu menuGw = new ContextMenu(); grfFinish.ContextMenu = menuGw; Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor); //CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE); //rg1.Style = grfBank.Styles["date"]; //grfCu.Cols[colID].Visible = false; int i = 1; foreach (DataRow row in dt.Rows) { grfFinish[i, 0] = i; grfFinish[i, colID] = row["id"].ToString(); grfFinish[i, colVNshow] = row["VN"].ToString(); grfFinish[i, colPttHn] = row["PIDS"].ToString(); grfFinish[i, colPttName] = row["PName"].ToString(); grfFinish[i, colVsDate] = ic.datetoShow(row["VDate"]); grfFinish[i, colVsTime] = row["VStartTime"].ToString(); grfFinish[i, colVsEtime] = row["VEndTime"].ToString(); grfFinish[i, colStatus] = row["VName"].ToString(); grfFinish[i, colPttId] = row["PID"].ToString(); if (!row[ic.ivfDB.ovsDB.vsold.form_a_id].ToString().Equals("0")) { CellNote note = new CellNote("ส่ง Lab Request Foam A"); CellRange rg = grfFinish.GetCellRange(i, colVNshow); rg.UserData = note; } //if (i % 2 == 0) // grfPtt.Rows[i].StyleNew.BackColor = color; i++; } CellNoteManager mgr = new CellNoteManager(grfFinish); grfFinish.Cols[colID].Visible = false; grfFinish.Cols[colPttId].Visible = false; grfFinish.Cols[colVNshow].AllowEditing = false; grfFinish.Cols[colPttHn].AllowEditing = false; grfFinish.Cols[colPttName].AllowEditing = false; grfFinish.Cols[colVsDate].AllowEditing = false; grfFinish.Cols[colVsTime].AllowEditing = false; grfFinish.Cols[colVsEtime].AllowEditing = false; grfFinish.Cols[colStatus].AllowEditing = false; grfFinish.Cols[colPttId].AllowEditing = false; //theme1.SetTheme(grfFinish, ic.theme); }
private void setGrfQue() { //grfDept.Rows.Count = 7; grfQue.Clear(); DataTable dt1 = new DataTable(); DataTable dt = new DataTable(); dt = ic.ivfDB.lFormaDB.selectReportByDate(ic.datetoDB(txtDateStart.Text), ic.datetoDB(txtDateEnd.Text), txtSearch.Text.Trim()); //if (search.Equals("")) //{ // String date = ""; // DateTime dt11 = new DateTime(); // if (DateTime.TryParse(txtDateStart.Text, out dt11)) // { // date = dt11.Year + "-" + dt11.ToString("MM-dd"); // dt = ic.ivfDB.vsOldDB.selectByDate(date); // } //} //else //{ // //grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search); //} //grfExpn.Rows.Count = dt.Rows.Count + 1; grfQue.Rows.Count = dt.Rows.Count + 1; grfQue.Cols.Count = 10; //C1TextBox txt = new C1TextBox(); //C1ComboBox cboproce = new C1ComboBox(); //ic.ivfDB.itmDB.setCboItem(cboproce); //grfQue.Cols[colPttHn].Editor = txt; //grfQue.Cols[colPttName].Editor = txt; //grfQue.Cols[colFormADate].Editor = txt; grfQue.Cols[colCode].Width = 100; grfQue.Cols[colPttHn].Width = 100; grfQue.Cols[colPttName].Width = 250; grfQue.Cols[colFormADate].Width = 100; grfQue.Cols[colHnMale].Width = 100; grfQue.Cols[colNameMale].Width = 250; grfQue.Cols[colDtrName].Width = 200; grfQue.ShowCursor = true; //grdFlex.Cols[colID].Caption = "no"; //grfDept.Cols[colCode].Caption = "รหัส"; grfQue.Cols[colCode].Caption = "DOC"; grfQue.Cols[colPttHn].Caption = "HN"; grfQue.Cols[colPttName].Caption = "Name"; grfQue.Cols[colFormADate].Caption = "Date"; grfQue.Cols[colHnMale].Caption = "HN Male"; grfQue.Cols[colNameMale].Caption = "Name Male"; grfQue.Cols[colDtrName].Caption = "Doctor "; ContextMenu menuGw = new ContextMenu(); //menuGw.MenuItems.Add("&receive operation", new EventHandler(ContextMenu_Apm)); //menuGw.MenuItems.Add("&receive operation", new EventHandler(ContextMenu_Apm)); menuGw.MenuItems.Add("LAB request FORM A", new EventHandler(ContextMenu_LAB_req_formA_Ptt)); menuGw.MenuItems.Add("LAB Form Day1", new EventHandler(ContextMenu_Form_day1)); //menuGw.MenuItems.Add("&Cancel Receive", new EventHandler(ContextMenu_Apm_Ptt)); //menuGw.MenuItems.Add("&No Appointment Close Operation", new EventHandler(ContextMenu_NO_Apm_Ptt)); //grfQue.ContextMenu = menuGw; Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor); //CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE); //rg1.Style = grfBank.Styles["date"]; //grfCu.Cols[colID].Visible = false; int i = 1; foreach (DataRow row in dt.Rows) { grfQue[i, 0] = i; grfQue[i, colID] = row["form_a_id"].ToString(); grfQue[i, colCode] = row["form_a_code"].ToString(); grfQue[i, colPttHn] = row["hn_female"].ToString(); grfQue[i, colPttName] = row["name_female"].ToString(); grfQue[i, colFormADate] = ic.datetoShow(row["form_a_date"]); grfQue[i, colHnMale] = row["hn_male"].ToString(); grfQue[i, colNameMale] = row["name_male"].ToString(); grfQue[i, colDtrName] = row["doctor_name"].ToString(); grfQue[i, colPttId] = ""; if (!row[ic.ivfDB.ovsDB.vsold.form_a_id].ToString().Equals("0")) { CellNote note = new CellNote("ส่ง Lab Request Foam A"); CellRange rg = grfQue.GetCellRange(i, colCode); rg.UserData = note; } //if (i % 2 == 0) // grfPtt.Rows[i].StyleNew.BackColor = color; i++; } CellNoteManager mgr = new CellNoteManager(grfQue); grfQue.Cols[colID].Visible = false; grfQue.Cols[colPttId].Visible = false; grfQue.SelectionMode = SelectionModeEnum.Row; //theme1.SetTheme(grfQue, ic.theme); }
private void BtnGenEggSti_Click(object sender, EventArgs e) { //throw new NotImplementedException(); String lmpdate = ""; DateTime lmpdate1 = new DateTime(); lmpdate = ic.datetoDB(txtVisitLMP.Text); if (!DateTime.TryParse(lmpdate, out lmpdate1)) { MessageBox.Show("วันที่ LMP Date ไม่ถูกต้อง ", ""); return; } if (MessageBox.Show("ต้องการ Day Egg Sti \nวันที่ LMP Date " + txtVisitLMP.Text, "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { setEggSti(); ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { int chk = 0; String re = ic.ivfDB.eggsDB.insertEggSti(eggs, ic.cStf.staff_id); if (int.TryParse(re, out chk)) { txtId.Value = re; lmpdate = ic.datetoDB(txtVisitLMP.Text); if (DateTime.TryParse(lmpdate, out lmpdate1)) { for (int i = 1; i <= 17; i++) { if (i != 1) { lmpdate1 = lmpdate1.AddDays(1); } EggStiDay eggsd = new EggStiDay(); eggsd.egg_sti_day_id = ""; eggsd.egg_sti_id = re; eggsd.day1 = i.ToString(); eggsd.date = ic.datetoDB(lmpdate1.Year.ToString() + "-" + lmpdate1.ToString("MM-dd")); eggsd.e2 = ""; eggsd.lh = ""; eggsd.active = ""; eggsd.remark = ""; eggsd.fsh = ""; eggsd.date_create = ""; eggsd.date_modi = ""; eggsd.date_cancel = ""; eggsd.user_create = ""; eggsd.user_modi = ""; eggsd.user_cancel = ""; eggsd.prolactin = ""; eggsd.rt_ovary_1 = ""; eggsd.rt_ovary_2 = ""; eggsd.lt_ovary_1 = ""; eggsd.lt_ovary_2 = ""; eggsd.endo = ""; eggsd.medication = ""; ic.ivfDB.eggsdDB.insertEggStiDay(eggsd, ic.cStf.staff_id); } } setControlEggSti(); } } } }
private void BtnDel_Click(object sender, EventArgs e) { //throw new NotImplementedException(); if (Directory.Exists(ic.iniC.pathImageScan)) { if (MessageBox.Show("ต้องการ Upload ข้อมูล รูป scan ", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { //DirectoryInfo dir = new DirectoryInfo(ic.iniC.pathImageScan); //foreach (FileInfo fi in dir.GetFiles()) //{ // fi.Delete(); //} int i = 0; String dgs = "", name = ""; Boolean chk = false; txtVN.Hide(); btnVn.Hide(); //label3.Hide(); //txtAN.Hide(); //txtAnCnt.Hide(); //chkIPD.Hide(); label6.Hide(); txtVisitDate.Hide(); //txtAnDate.Hide(); //txtPreNo.Hide(); setVisible(false); ProgressBar pB1 = new ProgressBar(); pB1.Location = new System.Drawing.Point(15, 15); pB1.Name = "pB1"; pB1.Size = new System.Drawing.Size(862, 23); //pB1.Left = txtVN.Left; pB1.Show(); pB1.Value = 0; pB1.Minimum = 0; pB1.Maximum = array1.Count; groupBox1.Controls.Add(pB1); Application.DoEvents(); foreach (String aa in array1) { i++; pB1.Value++; String[] aaa = aa.Split(','); if (aaa.Length == 3) { name = aaa[2].Replace("*", ""); string ext = Path.GetExtension(name); String dgssname = "", dgssid = "", vn = "", an = ""; dgssid = ic.ivfDB.dgssDB.getIdDgss("Document Other"); DocGroupSubScan dgss = new DocGroupSubScan(); dgss = ic.ivfDB.dgssDB.selectByPk(dgssid); DocScan dsc = new DocScan(); dsc.active = "1"; dsc.doc_scan_id = ""; dsc.doc_group_id = dgss.doc_group_id; //dsc.hn = txtHn.Text; //-0021 //dsc.hn = txtHn.Text.Trim().Replace(ic.hnspareyear, "").Replace(txtPttYear.Text.Trim(), ""); //+0021 int index = txtHn.Text.IndexOf(ic.hnspareyear); if (index >= 6) { dsc.hn = txtHn.Text.Substring(0, index); } dsc.vn = txtVN.Text; dsc.an = ""; dsc.visit_date = ic.datetoDB(txtVisitDate.Text); dsc.host_ftp = ic.iniC.hostFTP; //dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1]; dsc.image_path = ""; dsc.doc_group_sub_id = dgssid; dsc.pre_no = ""; dsc.an = ""; DateTime dt = new DateTime(); //dsc.an_date = (DateTime.TryParse(txtAnDate.Text, out dt)) ? ic.datetoDB(txtAnDate.Text) : ""; //if (dsc.an_date.Equals("1-01-01")) //{ dsc.an_date = ""; //} dsc.folder_ftp = ic.iniC.folderFTP; dsc.status_ipd = "O"; String re = ic.ivfDB.dscDB.insertDocScan(dsc, ic.userId); //dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + re + ext; //if (chkIPD.Checked) //{ // vn = txtAN.Text.Replace("/", "_").Replace("(", "_").Replace(")", ""); //} //else //{ vn = txtVN.Text.Replace("/", "_").Replace("(", "_").Replace(")", ""); //} dsc.image_path = txtHn.Text.Replace("-", "").Replace("/", "") + "_" + vn + "//" + txtHn.Text.Replace("-", "").Replace("/", "") + "_" + vn + "_" + re + ext; String re1 = ic.ivfDB.dscDB.updateImagepath(dsc.image_path, re); FtpClient ftp = new FtpClient(ic.iniC.hostFTP, ic.iniC.userFTP, ic.iniC.passFTP, ic.ftpUsePassive, ic.iniC.pathChar); //MessageBox.Show("111", ""); //ftp.createDirectory(txtHn.Text); ftp.createDirectory(ic.iniC.folderFTP + "//" + txtHn.Text.Replace("-", "").Replace("/", "") + "_" + vn); //MessageBox.Show("222", ""); ftp.delete(ic.iniC.folderFTP + "//" + dsc.image_path); //MessageBox.Show("333", ""); ftp.upload(ic.iniC.folderFTP + "//" + dsc.image_path, name); //break; //Application.DoEvents(); } } pB1.Dispose(); txtVN.Show(); btnVn.Show(); //label3.Show(); //txtAN.Show(); //txtAnCnt.Show(); //chkIPD.Show(); label6.Show(); delFile(); grf.Dispose(); initGrf(); setGrf(); setImage1(true); setVisible(true); MessageBox.Show("Upload รูป เวชระเบียน เรียบร้อย", ""); } } }
private void setGrfSearch() { grfSearch.DataSource = null; //grfSearch.Clear(); DataTable dt = new DataTable(); String date1 = "", date2 = ""; date1 = ic.datetoDB(txtFiDateStart.Text); date2 = ic.datetoDB(txtFiDateEnd.Text); //dt = ic.ivfDB.lbReqDB.selectByStatusReqAccept(); //grfExpn.Rows.Count = dt.Rows.Count + 1; grfSearch.Rows.Count = 1; grfSearch.Cols.Count = 14; if (txtFiDateStart.Text.Equals("")) { return; } dt = ic.ivfDB.lbresDB.selectLabBloodBySearchHn(txtSearch.Text.Trim()); //C1TextBox txt = new C1TextBox(); //C1ComboBox cboproce = new C1ComboBox(); //ic.ivfDB.itmDB.setCboItem(cboproce); //grfReq.Cols[colRqReqNum].Editor = txt; //grfReq.Cols[colRqHn].Editor = txt; //grfReq.Cols[colRqVn].Editor = txt; //grfReq.Cols[colRqName].Editor = txt; grfSearch.Cols[colRsLabName].Width = 200; grfSearch.Cols[colRsMethod].Width = 100; grfSearch.Cols[colRsResult].Width = 100; grfSearch.Cols[colRsInterpret].Width = 100; grfSearch.Cols[colRsUnit].Width = 80; grfSearch.Cols[colRsNormal].Width = 100; grfSearch.Cols[colRsRemark].Width = 200; grfSearch.Cols[colRsHn].Width = 100; grfSearch.Cols[colRsPttName].Width = 200; grfSearch.Cols[colRsReqDate].Width = 160; grfSearch.ShowCursor = true; //grdFlex.Cols[colID].Caption = "no"; //grfDept.Cols[colCode].Caption = "รหัส"; grfSearch.Cols[colRsLabName].Caption = "Name"; grfSearch.Cols[colRsReqDate].Caption = "Request Date"; grfSearch.Cols[colRsMethod].Caption = "Method"; grfSearch.Cols[colRsResult].Caption = "Result"; grfSearch.Cols[colRsInterpret].Caption = "Interpret"; grfSearch.Cols[colRsUnit].Caption = "Unit"; grfSearch.Cols[colRsNormal].Caption = "Normal"; grfSearch.Cols[colRsRemark].Caption = "Remark"; grfSearch.Cols[colRsHn].Caption = "HN"; grfSearch.Cols[colRsPttName].Caption = "Patient Name"; Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor); //CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE); //rg1.Style = grfBank.Styles["date"]; //grfCu.Cols[colID].Visible = false; int i = 1; String chk = ""; foreach (DataRow row in dt.Rows) { Row row1 = grfSearch.Rows.Add(); row1[colRsId] = row[ic.ivfDB.lbresDB.lbRes.result_id].ToString(); row1[colRsLabName] = row[ic.ivfDB.oLabiDB.labI.LName].ToString(); row1[colRsMethod] = row[ic.ivfDB.lbresDB.lbRes.method].ToString(); row1[colRsResult] = row[ic.ivfDB.lbresDB.lbRes.result].ToString(); row1[colRsInterpret] = row[ic.ivfDB.lbresDB.lbRes.interpret].ToString(); row1[colRsUnit] = row[ic.ivfDB.lbresDB.lbRes.unit].ToString(); row1[colRsNormal] = row[ic.ivfDB.lbresDB.lbRes.normal_value].ToString(); row1[colRsRemark] = row[ic.ivfDB.lbresDB.lbRes.remark].ToString(); row1[colRsLabId] = row[ic.ivfDB.lbresDB.lbRes.lab_id].ToString(); row1[colRsReqId] = row[ic.ivfDB.lbresDB.lbRes.req_id].ToString(); row1[colRsHn] = ic.showHN(row["patient_hn"].ToString(), row["patient_year"].ToString()); row1[colRsPttName] = row["pname"].ToString(); row1[colRsReqDate] = ic.datetimetoShow(row[ic.ivfDB.lbresDB.lbRes.req_date_time].ToString()); //row1[colOPUTimeModi] = row[ic.ivfDB.lFormaDB.lformA.opu_time_modi].ToString(); //row1[colRqLabName] = row["SName"].ToString(); //row1[colRqHnMale] = row["hn_male"].ToString(); //row1[colRqNameMale] = row["name_male"].ToString(); //row1[colRqHnDonor] = row["hn_donor"].ToString(); //row1[colRqNameDonor] = row["name_donor"].ToString(); i++; } grfSearch.Cols[colRsId].Visible = false; grfSearch.Cols[colRsLabId].Visible = false; grfSearch.Cols[colRsReqId].Visible = false; grfSearch.Cols[colRsLabName].AllowEditing = false; grfSearch.Cols[colRsMethod].AllowEditing = false; grfSearch.Cols[colRsResult].AllowEditing = false; grfSearch.Cols[colRsInterpret].AllowEditing = false; grfSearch.Cols[colRsUnit].AllowEditing = false; grfSearch.Cols[colRsNormal].AllowEditing = false; grfSearch.Cols[colRsRemark].AllowEditing = false; grfSearch.Cols[colRsHn].AllowEditing = false; grfSearch.Cols[colRsPttName].AllowEditing = false; //grfReq.Cols[coldt].Visible = false; }
private void setGrfReq() { gB.Enabled = false; groupBox1.Enabled = false; try { String startdate = "", enddate = ""; DateTime datestart, dateend; String datestart1 = "", dateend1 = ""; if (DateTime.TryParse(txtDateStart.Text, out datestart)) { datestart1 = datestart.ToString("yyyy-MM-dd"); } else { datestart1 = ic.datetoDB(txtDateStart.Text); } if (DateTime.TryParse(txtDateEnd.Text, out datestart)) { dateend1 = datestart.ToString("yyyy-MM-dd"); } else { dateend1 = ic.datetoDB(txtDateEnd.Text); } grfReq.Clear(); grfReq.Cols.Count = 15; grfReq.Rows.Count = 1; DataTable dt = new DataTable(); grfReq.DataSource = null; dt = ic.ivfDB.oJsDB.selectByStatusUnAccept1(datestart1, dateend1); //grfExpn.Rows.Count = dt.Rows.Count + 1; //grfCu.Rows.Count = 41; //grfCu.Cols.Count = 4; C1TextBox txt = new C1TextBox(); //C1ComboBox cboproce = new C1ComboBox(); //ic.ivfDB.itmDB.setCboItem(cboproce); grfReq.Cols[colRqReqNum].Editor = txt; grfReq.Cols[colRqHn].Editor = txt; grfReq.Cols[colRqVn].Editor = txt; grfReq.Cols[colRqItmName].Editor = txt; grfReq.Cols[colRqHn].Width = 120; grfReq.Cols[colRqVn].Width = 120; grfReq.Cols[colRqItmName].Width = 120; grfReq.Cols[colRqDate].Width = 100; grfReq.Cols[colPttName].Width = 200; grfReq.Cols[colDtrName].Width = 200; grfReq.Cols[colRqOPUdate].Width = 120; grfReq.ShowCursor = true; //grdFlex.Cols[colID].Caption = "no"; //grfDept.Cols[colCode].Caption = "รหัส"; grfReq.Cols[colRqReqNum].Caption = "req number"; grfReq.Cols[colRqHn].Caption = "HN"; grfReq.Cols[colRqVn].Caption = "VN"; grfReq.Cols[colRqItmName].Caption = "LAB Name"; grfReq.Cols[colPttName].Caption = "Patient Name"; grfReq.Cols[colRqDate].Caption = "Date"; grfReq.Cols[colRqRemark].Caption = "Remark"; grfReq.Cols[colDtrId].Caption = "Remark"; grfReq.Cols[colDtrName].Caption = "Doctor"; grfReq.Cols[colRqOPUdate].Caption = "OPU Date"; Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor); //CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE); //rg1.Style = grfBank.Styles["date"]; //grfCu.Cols[colID].Visible = false; int i = 1; foreach (DataRow row in dt.Rows) { Row row1 = grfReq.Rows.Add(); row1[colRqId] = row["odsd_id"].ToString(); row1[colRqReqNum] = row["odsd_id"].ToString(); row1[colRqHn] = row["PIDS"].ToString(); row1[colRqVn] = row["VN"].ToString(); row1[colRqItmName] = row["SName"].ToString(); row1[colPttName] = row["pttname"].ToString(); row1[colRqDate] = ic.datetoShow(row["Date"].ToString()); row1[colDtrId] = row["dtrid"].ToString(); row1[colDtrName] = row["dtrname"].ToString(); row1[colRqRemark] = row["remark"].ToString(); row1[colRqStatusReq] = row["status_req_accept"].ToString(); row1[colRqDob] = row["dob"].ToString(); row1[colRqItmCode] = row["SID"].ToString(); row1[0] = i; if (row["status_req_accept"].ToString().Equals("1")) { grfReq.Rows[i].StyleNew.BackColor = color; } if (row["status_wait_confirm_opu_date"].ToString().Equals("1")) { //grfReq.Rows[i].StyleNew.BackColor = ColorTranslator.FromHtml(ic.iniC.grfRowColor); String txt1 = ""; txt1 = "รอ confirm วัน เวลา OPU จากทาง พยาบาล"; CellNote note = new CellNote(txt1); CellRange rg = grfReq.GetCellRange(i, colRqHn); rg.UserData = note; grfReq.Rows[i].StyleNew.BackColor = Color.Yellow; } else if (row["status_wait_confirm_opu_date"].ToString().Equals("2")) { grfReq.Rows[i].StyleNew.BackColor = Color.Green; } i++; } grfReq.Cols[colRqId].Visible = false; grfReq.Cols[colRqVn].Visible = false; grfReq.Cols[colDtrId].Visible = false; grfReq.Cols[colRqStatusReq].Visible = false; grfReq.Cols[colRqDob].Visible = false; grfReq.Cols[colRqItmCode].Visible = false; CellNoteManager mgr = new CellNoteManager(grfReq); } catch (Exception ex) { MessageBox.Show("" + ex.Message, ""); } gB.Enabled = true; groupBox1.Enabled = true; }