private void setControl()
{
chkAll.Checked = true;
ptt = ic.ivfDB.pttDB.selectByPk1(pttid);
vs = ic.ivfDB.vsDB.selectByPk1(visitid);
txtId.Value = deposit.deposit_id;
txtDepositCode.Value = deposit.deposit_code;
txtDepositDate.Value = ic.datetoShow(deposit.deposit_date);
txtDeposit.Value = deposit.deposit_amount;
txtHn.Value = deposit.patient_hn;
txtName.Value = deposit.deposit_name;
txtRemark.Value = deposit.remark;
if (deposit.active != null && deposit.active.Equals("1"))
{
chkActive.Checked = true;
}
txtWithDrawVisitId.Value = vs.t_visit_id;
txtWithDrawVn.Value = vs.visit_vn;
txtWithDrawHn.Value = ic.showHN(ptt.patient_hn, ptt.patient_year);
txtWithDrawVisitId.Value = vs.t_visit_id;
txtWithDrawPttId.Value = vs.t_patient_id;
txtWithDrawName.Value = ptt.patient_name;
ic.setC1Combo(cboPackage, deposit.pck_id);
if (txtHn.Text.Length > 0 && txtHn.Text.Trim().IndexOf(ic.hnspareyear) > 0)
{
ptt = ic.ivfDB.pttDB.selectByHn(txtHn.Text.Trim().Substring(0, txtHn.Text.Trim().IndexOf(ic.hnspareyear)));
txtHn.Value = ic.showHN(ptt.patient_hn, ptt.patient_year);
txtName.Value = ptt.patient_name;
txtWithDrawHn.Value = ic.showHN(ptt.patient_hn, ptt.patient_year);
txtWithDrawName.Value = ptt.patient_name;
vs = ic.ivfDB.vsDB.selectByPk1(visitid);
txtWithDrawVisitId.Value = vs.t_visit_id;
txtWithDrawVn.Value = vs.visit_vn;
}
if (txtId.Text.Length <= 0)
{
txtDepositDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
}
}
private void setControl(String vsid)
{
//vsOld = ic.ivfDB.ovsDB.selectByPk1(vsid); // -0020
//pttOld = ic.ivfDB.pttOldDB.selectByPk1(vsOld.PID); // -0020
//vs = ic.ivfDB.vsDB.selectByVn(vsid); // -0020
vs = ic.ivfDB.vsDB.selectByPk1(vsid); // +0020
ptt = ic.ivfDB.pttDB.selectByPk1(vs.t_patient_id);
//txtHn.Value = ptt.patient_hn;// -0020
txtHn.Value = ic.showHN(ptt.patient_hn, ptt.patient_year);// +0020
txtVn.Value = vs.visit_vn;
txtPttNameE.Value = ptt.Name;
txtPttName.Value = ic.ivfDB.fpfDB.getList1(ptt.f_patient_prefix_id) + " " + ptt.patient_firstname + " " + ptt.patient_lastname;
txtVnShow.Value = ic.showVN(vs.visit_vn);
txtDob.Value = ic.datetoShow(ptt.patient_birthday) + " [" + ptt.AgeStringShort() + "]";
txtAllergy.Value = ptt.allergy_description;
txtIdOld.Value = ptt.t_patient_id_old;
txtVnOld.Value = vs.visit_vn;
txtVsId.Value = vs.t_visit_id;
txtPttId.Value = ptt.t_patient_id;
txtSex.Value = ptt.f_sex_id.Equals("1") ? "ชาย" : "หญิง";
txtBg.Value = ptt.f_patient_blood_group_id.Equals("2140000005") ? "O"
: ptt.f_patient_blood_group_id.Equals("2140000002") ? "A" : ptt.f_patient_blood_group_id.Equals("2140000003") ? "B"
: ptt.f_patient_blood_group_id.Equals("2140000004") ? "AB" : "ไม่ระบุ";
txtVisitHeight.Value = vs.height;
txtVisitBW.Value = vs.bw;
txtVisitBP.Value = vs.bp;
txtVisitPulse.Value = vs.pulse;
chkChronic.Checked = ptt.status_congenial.Equals("1") ? true : false;
ic.setC1Combo(cboDoctor, vs.doctor_id);
Patient ptt1 = new Patient();
ptt1 = ic.ivfDB.pttDB.selectByHn(vs.patient_hn_male);
txtNameMale.Value = ptt1.Name;
stt.Show("<p><b>สวัสดี</b></p>คุณ " + ptt.congenital_diseases_description + "<br> กรุณา ป้อนรหัสผ่าน", chkChronic);
txtCongenital.Value = ptt.congenital_diseases_description;
if (!ptt.t_patient_id.Equals(""))
{
PatientImage pttI = new PatientImage();
pttI = ic.ivfDB.pttImgDB.selectByPttIDStatus4(ptt.t_patient_id);
filenamepic = pttI.image_path;
Thread threadA = new Thread(new ParameterizedThreadStart(ExecuteA));
threadA.Start();
}
//if (!vsOld.VSID.Equals("166")) // -0020
// ต้องการ พิมพ์ sticker ย้อยหลัง
//if (!vs.vsid.Equals("166")) // ต้องการ พิมพ์ sticker ย้อยหลัง
//{ // ต้องการ พิมพ์ sticker ย้อยหลัง
// btnPrnSticker.Enabled = false; // ต้องการ พิมพ์ sticker ย้อยหลัง
//} // ต้องการ พิมพ์ sticker ย้อยหลัง
//txtBg.Value = pttOld.b
//txtAllergy.Value =
}
private void setControl()
{
stkr = ic.ivfDB.stkrDB.selectByPk(recID);
txtId.Value = stkr.rec_id;
txtRecDate.Value = ic.datetoShow(stkr.rec_date);
txtRemark.Value = stkr.remark;
txtDescription.Value = stkr.description;
txtRecDoc.Value = stkr.rec_doc;
setGrfStockRec(recID);
}
private void BtnPrint_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
FrmReport frm = new FrmReport(ic);
DataTable dt = new DataTable();
dt = ic.ivfDB.eggsdDB.selectByEggStiId(txtId.Text);
dt.Columns.Add("status_abnormal", typeof(String));
dt.Columns.Add("abnormal1", typeof(String));
dt.Columns.Add("abnormal2", typeof(String));
dt.Columns.Add("status_typing", typeof(String));
dt.Columns.Add("status_typing_other", typeof(String));
dt.Columns.Add("typing_other", typeof(String));
dt.Columns.Add("status_infectious", typeof(String));
dt.Columns.Add("status_add_lab", typeof(String));
dt.Columns.Add("add_lab", typeof(String));
dt.Columns.Add("bhcg", typeof(String));
String date1 = "";
foreach (DataRow row in dt.Rows)
{
date1 = ic.datetoShow(row["date"].ToString());
row["date"] = date1.Replace("-", "/");
row["status_abnormal"] = chkAbnormal.Checked ? "1": "0";
row["abnormal1"] = txtAbnormal1.Text;
row["abnormal2"] = txtAbnormal2.Text;
row["status_typing"] = chkTyping.Checked ? "1" : "0";
row["status_typing_other"] = chkOther.Checked ? "1" : "0";;
row["typing_other"] = cboOther.Text;
row["status_infectious"] = chkInfection.Checked ? "1" : "0";
row["status_add_lab"] = chkAmh.Checked ? "1" : "0";
row["add_lab"] = cboAmh.Text;
row["bhcg"] = cboBhcg.Text;
//row["status_abnormal"] = "";
//row["status_abnormal"] = "";
}
frm.setEggStiReport(dt, txtPttNameE.Text, "", txtVisitLMP.Text, txtG.Text, txtP.Text, txtA.Text, cboDoctor.Text
, txtOPUDate.Text, txtOPUTime.Text, txtEmbryoTranferDate.Text, txtEmbryoTranferTime.Text, txtAllergy.Text, txtVisitHeight.Text, txtVisitBP.Text, txtVisitBW.Text, txtVisitPulse.Text);
frm.ShowDialog(this);
}
private void initConifg()
{
ptt = new Patient();
vs = new Visit();
ptt = ic.ivfDB.pttDB.selectByHn(hn);
vs = ic.ivfDB.vsDB.selectByPk1(vsid);
txtPttNameE.Value = name;
txtHn.Value = hn;
txtDob.Value = ptt.AgeStringShort() + " [" + ic.datetoShow(ptt.patient_birthday) + "]";
ic.ivfDB.stfDB.setCboDoctor(cboDoctor, vs.doctor_id);
ic.ivfDB.stfDB.setCboDoctor(cboAnes, "");
btnFinish.Click += BtnFinish_Click;
}
private void setGrfQue(String search)
{
//grfDept.Rows.Count = 7;
//grfQue.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))
{
//dt11 = dt11.AddDays(-1);
date = dt11.Year + "-" + dt11.ToString("MM-dd");
//dt = ic.ivfDB.ovsDB.selectByDate(date);
}
if (chkAll.Checked)
{
//dt = ic.ivfDB.ovsDB.selectByReceptionSend(); // -0020
//dt = ic.ivfDB.vsDB.selectByReceptionSend(); // +0020 else
//dt = ic.ivfDB.ovsDB.selectByStatusCashierFinish(cboVisitBsp.SelectedItem == null ? "" : ((ComboBoxItem)cboVisitBsp.SelectedItem).Value); // -0020
dt = ic.ivfDB.vsDB.selectByStatusCashierFinish(); // +0020
}
}
else
{
//grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search);
}
grfQue.Rows.Count = 1;
grfQue.Rows.Count = dt.Rows.Count + 1;
grfQue.Cols.Count = 14;
//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[colVsDate].Editor = txt;
grfQue.Cols[colVNshow].Width = 80;
grfQue.Cols[colPttHn].Width = 120;
grfQue.Cols[colPttName].Width = 300;
grfQue.Cols[colVsDate].Width = 100;
grfQue.Cols[colVsTime].Width = 80;
grfQue.Cols[colVsEtime].Width = 80;
grfQue.Cols[colStatus].Width = 200;
grfQue.Cols[colStatusNurse].Width = 50;
grfQue.Cols[colStatusCashier].Width = 55;
grfQue.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfQue.Cols[colVNshow].Caption = "VN";
grfQue.Cols[colPttHn].Caption = "HN";
grfQue.Cols[colPttName].Caption = "Name";
grfQue.Cols[colVsDate].Caption = "Date";
grfQue.Cols[colVsTime].Caption = "Time visit";
grfQue.Cols[colVsEtime].Caption = "Time finish";
grfQue.Cols[colStatus].Caption = "Status";
grfQue.Cols[colStatusNurse].Caption = "Nurse";
grfQue.Cols[colStatusCashier].Caption = "Cashier";
ContextMenu menuGw = new ContextMenu();
//menuGw.MenuItems.Add("&receive operation", new EventHandler(ContextMenu_Apm));
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["id"].ToString();
grfQue[i, colVNshow] = ic.showVN(row["VN"].ToString());
grfQue[i, colVn] = row["VN"].ToString();
grfQue[i, colPttHn] = ic.showHN(row["PIDS"].ToString(), row["patient_year"].ToString());
grfQue[i, colPttName] = row["PName"].ToString();
grfQue[i, colVsDate] = ic.datetoShow(row["VDate"]);
grfQue[i, colVsTime] = ic.timetoShow(row["VStartTime"].ToString());
grfQue[i, colVsEtime] = ic.timetoShow(row["VEndTime"].ToString());
grfQue[i, colStatus] = row["VName"].ToString();
grfQue[i, colPttId] = row["PID"].ToString();
grfQue[i, colDtr] = row["dtrname"].ToString();
grfQue[i, colStatusNurse] = row["status_nurse"].ToString();
grfQue[i, colStatusCashier] = row["status_cashier"].ToString();
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, colVNshow);
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[colVn].Visible = false;
grfQue.Cols[colPttId].Visible = false;
grfQue.Cols[colVNshow].AllowEditing = false;
grfQue.Cols[colPttHn].AllowEditing = false;
grfQue.Cols[colPttName].AllowEditing = false;
grfQue.Cols[colVsDate].AllowEditing = false;
grfQue.Cols[colVsTime].AllowEditing = false;
grfQue.Cols[colDtr].AllowEditing = false;
//theme1.SetTheme(grfQue, 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 setGrfHn(String hn)
{
//grfDept.Rows.Count = 7;
//grfHn.Clear();
DataTable dt = new DataTable();
grfHn.DataSource = null;
ConnectDB con = new ConnectDB(ic.iniC);
//con.OpenConnectionEx();
if (ic.iniC.statusAppDonor.Equals("1"))
{
//dt = ic.ivfDB.ovsDB.selectCurrentVisit(con.connEx);
//dt = ic.ivfDB.ovsDB.selectCurrentVisit(con.conn);
if (statussearchtable == StatusSearchTable.VisitSearch)
{
dt = ic.ivfDB.ovsDB.selectLikeByHN(hn, ic.conn.conn);
}
else
{
dt = ic.ivfDB.pttDB.selectBySearch1(hn);
}
}
else
{
//if (hn.Equals("")) //-0021
//{ //-0021
// dt = ic.ivfDB.ovsDB.selectCurrentVisit(ic.conn.conn); //-0021
//} //-0021
//else //-0021
//{ //-0021
//if(statusconn == StatusConnection.hostEx) //-0021
//{ //-0021
// dt = ic.ivfDB.vsDB.selectByHNEx(hn); //-0021
//} //-0021
//else //-0021
//{ //-0021
// if (statussearchtable == StatusSearchTable.VisitSearch) //-0021
// { //-0021
// dt = ic.ivfDB.vsDB.selectLikeByHN(hn); //-0021
// } //-0021
// else //-0021
// { //-0021
dt = ic.ivfDB.pttDB.selectBySearch1(hn); //-0021
// } //-0021
//} //-0021
//dt = ic.ivfDB.vsDB.selectLikeByHNSearch(hn);
//} //-0021
}
if (dt.Rows.Count <= 0)
{
dt = ic.ivfDB.pttDB.selectBySearch1(hn);
}
//con.CloseConnectionEx();
//grfExpn.Rows.Count = dt.Rows.Count + 1;
grfHn.Rows.Count = 1;
grfHn.Cols.Count = 11;
//C1TextBox txt = new C1TextBox();
//C1ComboBox cboproce = new C1ComboBox();
//ic.ivfDB.itmDB.setCboItem(cboproce);
//grfHn.Cols[colCuHn].Editor = txt;
//grfHn.Cols[colCuVn1].Editor = txt;
//grfHn.Cols[colCuName].Editor = txt;
grfHn.Cols[colCuHnShow].Width = 100;
grfHn.Cols[colCuVnShow].Width = 100;
grfHn.Cols[colCuName].Width = 280;
grfHn.Cols[colCuDate].Width = 100;
grfHn.Cols[colCuTime].Width = 80;
grfHn.Cols[colDept].Width = 120;
//grfHn.Cols[colCuTime].Width = 80;
grfHn.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfHn.Cols[colCuHnShow].Caption = "HN";
grfHn.Cols[colCuVnShow].Caption = "VN";
grfHn.Cols[colCuName].Caption = "Name";
grfHn.Cols[colCuDate].Caption = "Date";
grfHn.Cols[colCuTime].Caption = "Time";
grfHn.Cols[colDept].Caption = "dept";
Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor);
//CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE);
//rg1.Style = grfBank.Styles["date"];
//grfHn.Cols[colID].Visible = false;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
Row row = grfHn.Rows.Add();
row[0] = i;
row[colCuVnShow] = ic.showVN(dt.Rows[i]["VN"].ToString());
row[colCuHnShow] = ic.showHN(dt.Rows[i]["PIDS"].ToString(), dt.Rows[i]["patient_year"].ToString());
row[colCuName] = dt.Rows[i]["PName"].ToString();
row[colCuDate] = ic.datetoShow(dt.Rows[i]["VDate"].ToString());
row[colCuTime] = ic.timetoShow(dt.Rows[i]["VStartTime"].ToString());
row[colDept] = dt.Rows[i]["VName"].ToString();
row[colDOb] = ic.datetoShow(dt.Rows[i]["dob"].ToString());
row[colCuPttYear] = dt.Rows[i]["patient_year"].ToString();
row[colCuPttHn] = dt.Rows[i]["patient_hn"].ToString();
row[colCuVn] = dt.Rows[i]["VN"].ToString();
}
grfHn.Cols[colCuHnShow].AllowEditing = false;
grfHn.Cols[colCuVnShow].AllowEditing = false;
grfHn.Cols[colCuName].AllowEditing = false;
grfHn.Cols[colCuDate].AllowEditing = false;
grfHn.Cols[colCuTime].AllowEditing = false;
grfHn.Cols[colDept].AllowEditing = false;
grfHn.Cols[colDOb].AllowEditing = false;
//grfHn.Cols[colDOb].Visible = false;
grfHn.Cols[colCuPttYear].Visible = false;
grfHn.Cols[colCuPttHn].Visible = false;
grfHn.Cols[colCuVn].Visible = false;
}
private void setGrfPtt(String search)
{
//grfDept.Rows.Count = 7;
//grfPtt.Clear();
grfPtt.DataSource = null;
grfPtt.Rows.Count = 1;
DataTable dt = new DataTable();
if (search.Equals(""))
{
String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd");
//grfPtt.DataSource = ic.ivfDB.pttDB.selectByDate1(date);
//grfPtt.DataSource = ic.ivfDB.pttDB.selectByDate1(date);
if (ic.iniC.statusAppDonor.Equals("1"))
{
if (chkToday.Checked)
{
grfPtt.DataSource = ic.ivfDB.pttDB.selectBySearchDate(date);
}
}
else
{
if (chkToday.Checked)
{
grfPtt.DataSource = ic.ivfDB.pttDB.selectBySearchDate(date);
}
}
}
else
{
grfPtt.DataSource = ic.ivfDB.pttDB.selectBySearch(search); // +0010
//if (ic.iniC.statusAppDonor.Equals("1")) // -0010
//{ // -0010
// grfPtt.DataSource = ic.ivfDB.pttDB.selectBySearch(search); // -0010
//} // -0010
//else // -0010
//{ // -0010
// grfPtt.DataSource = ic.ivfDB.pttOldDB.selectBySearch(search); // -0010
//} // -0010
}
//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);
//grfPtt.Cols[colPttHn].Editor = txt;
//grfPtt.Cols[colPttName].Editor = txt;
//grfPtt.Cols[colPttRemark].Editor = txt;
grfPtt.Cols[colPttName].Width = 250;
grfPtt.Cols[colPttHn].Width = 120;
grfPtt.Cols[colPttRemark].Width = 300;
grfPtt.Cols[colPttDOB].Width = 110;
grfPtt.Cols[colPttHnOld].Width = 110;
grfPtt.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfPtt.Cols[colPttHn].Caption = "HN";
grfPtt.Cols[colPttName].Caption = "Name";
grfPtt.Cols[colPttRemark].Caption = "Remark";
grfPtt.Cols[colPttDOB].Caption = "DOB";
grfPtt.Cols[colPttHnOld].Caption = "HN Old";
ContextMenu menuGw = new ContextMenu();
menuGw.MenuItems.Add("&แก้ไข Patient", new EventHandler(ContextMenu_edit));
grfPtt.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;
for (int i = 1; i <= grfPtt.Rows.Count - 1; i++)
{
grfPtt[i, 0] = i;
grfPtt[i, colPttDOB] = ic.datetoShow(grfPtt[i, colPttDOB].ToString());
if (i % 2 == 0)
{
grfPtt.Rows[i].StyleNew.BackColor = color;
}
}
grfPtt.Cols[colPttId].Visible = false;
if (ic.user.status_admin.Equals("2"))
{
grfPtt.Cols[colStfCreate].Visible = true;
grfPtt.Cols[colStfModi].Visible = true;
//grfPtt.Cols[colStfCreate].Visible = true;
//grfPtt.Cols[colStfModi].Visible = true;
}
else
{
grfPtt.Cols[colStfCreate].Visible = false;
grfPtt.Cols[colStfModi].Visible = false;
//grfPtt.Cols[colStfCreate].Visible = false;
//grfPtt.Cols[colStfModi].Visible = false;
}
grfPtt.Cols[colPttHn].AllowEditing = false;
grfPtt.Cols[colPttName].AllowEditing = false;
grfPtt.Cols[colPttRemark].AllowEditing = false;
//grfPtt.Cols[colPttHn].AllowEditing = false;
theme1.SetTheme(grfPtt, ic.theme);
}
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;
}
private void ContextMenu_sticker(object sender, System.EventArgs e)
{
String chk1 = "", name = "", id = "", vsid = "", resid = "", re3 = "";
if (grfReq.Row < 0)
{
return;
}
id = grfReq[grfReq.Row, colReqId] != null ? grfReq[grfReq.Row, colReqId].ToString() : "";
vsid = grfReq[grfReq.Row, colReqVsId] != null ? grfReq[grfReq.Row, colReqVsId].ToString() : "";
if (id.Length <= 0)
{
return;
}
SetDefaultPrinter(ic.iniC.printerSticker);
DataTable dt = new DataTable();
dt.Columns.Add("hn", typeof(String));
dt.Columns.Add("name", typeof(String));
dt.Columns.Add("age", typeof(String));
dt.Columns.Add("vn", typeof(String));
dt.Columns.Add("path_barcode", typeof(String));
LabRequest lbreq = new LabRequest();
lbreq = ic.ivfDB.lbReqDB.selectByPk1(id);
Visit vs = new Visit();
vs = ic.ivfDB.vsDB.selectByPk1(vsid);
Patient ptt = new Patient();
ptt = ic.ivfDB.pttDB.selectByPk1(vs.t_patient_id);
Lis lis = new Lis();
lis.lis_id = "";
lis.barcode = "";
lis.req_id = id;
lis.visit_vn = vs.visit_vn;
lis.patient_name = ptt.Name;
lis.visit_hn = ptt.patient_hn;
lis.visit_id = vs.t_visit_id;
lis.message_lis = "";
lis.active = "";
lis.remark = "";
lis.date_create = "";
lis.date_modi = "";
lis.date_cancel = "";
lis.user_create = "";
lis.user_modi = "";
lis.user_cancel = "";
lis.statis_lis = "";
lis.date_time_receive = "";
lis.date_time_finish = "";
lis.lab_id = lbreq.lab_id;
re3 = ic.ivfDB.lisDB.insertLis(lis, ic.cStf.staff_id);
String re = "", re1 = "", re2 = "";
long chk = 0, chk2 = 0;
Lis lis1 = new Lis();
lis1 = ic.ivfDB.lisDB.selectByPk(re3);
DataRow row11 = dt.NewRow();
row11["hn"] = vs.visit_hn;
row11["name"] = ptt.Name;
row11["age"] = "Age " + ptt.AgeStringShort() + " [" + ic.datetoShow(ptt.patient_birthday) + "]";
row11["vn"] = lis1.barcode;
row11["path_barcode"] = System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg";
dt.Rows.Add(row11);
if (!Directory.Exists("report"))
{
Directory.CreateDirectory("report");
}
if (!File.Exists(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg"))
{
File.Delete(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg");
}
C1BarCode barc = new C1BarCode();
if (ic.iniC.lisBarcode.Equals("Code_128_B"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128_B;
}
else if (ic.iniC.lisBarcode.Equals("Code_128_A"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128_A;
}
else if (ic.iniC.lisBarcode.Equals("Code_128_C"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128_C;
}
else if (ic.iniC.lisBarcode.Equals("Code_128auto"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128auto;
}
else if (ic.iniC.lisBarcode.Equals("Code_128auto"))
{
//barc.CodeType = C1.BarCode.CodeType.en;
}
else
{
}
barc.Size = new Size(100, 60);
barc.BarHeight = 60;
barc.Text = lis1.barcode;
Bitmap bitm = new Bitmap(100, 40);
//bitm = barc.Image;
Image img = barc.Image;
//img.Size = new Size(100, 40);
img.Save(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg", ImageFormat.Jpeg);
FrmReport frm = new FrmReport(ic);
frm.setStickerPatientThemalLIS(dt);
frm.ShowDialog(this);
}
private void setGrfItem(String itmid, C1FlexGrid grf)
{
DataTable dt = new DataTable();
long chk = 0;
String re = "";
re = ic.ivfDB.stkcDB.genStockItem(itmid);
dt = ic.ivfDB.stkcDB.selectAll();
grf.Rows.Count = 1;
grf.Rows.Count = dt.Rows.Count + 1;
grf.Cols.Count = 9;
grf.Cols[colItmDesc].Width = 200;
grf.Cols[colItmQty].Width = 80;
grf.Cols[colItmPrice].Width = 120;
grf.Cols[colItmAmt].Width = 120;
grf.Cols[colItmRemark].Width = 200;
grf.Cols[colItmOnhand].Width = 80;
grf.Cols[colItmDesc].Caption = "Description";
grf.Cols[colItmQty].Caption = "QTY";
grf.Cols[colItmPrice].Caption = "Price";
grf.Cols[colItmAmt].Caption = "Amount";
grf.Cols[colItmRemark].Caption = "Remark";
grf.Cols[colItmOnhand].Caption = "Onhand";
Color color = ColorTranslator.FromHtml(ic.iniC.grfRowColor);
int i = 1;
foreach (DataRow row in dt.Rows)
{
try
{
Decimal chk1 = 0, qty = 0;
grf[i, 0] = i;
grf[i, colItmDesc] = row["status_rec_draw"].ToString().Equals("1") ? "รับเข้า " : row["status_rec_draw"].ToString().Equals("2") ? "ตัดจ่าย" : row["status_rec_draw"].ToString().Equals("3") ? "ขาย" : row["status_rec_draw"].ToString().Equals("0") ? "ยกมา" : "";
grf[i, colItmQty] = row["qty"].ToString();
grf[i, colItmPrice] = row["price"].ToString();
grf[i, colItmRemark] = row["remark"].ToString();
grf[i, colItmrecdrawjxpxid] = row["stock_id"].ToString();
grf[i, colItmDate] = ic.datetoShow(row["rec_draw_sale_date"].ToString());
grf[i, colItmOnhand] = row["onhand"].ToString();
//grfPkg[i, colPkgUse] = row["QTYused"].ToString();
//Decimal.TryParse(row["QTY"].ToString(), out qty);
//Decimal.TryParse(row["QTYused"].ToString(), out chk);
//if (chk < qty)
//{
// grfPkg.Rows[i].StyleNew.BackColor = color;
// //grfPkg.Rows[i].StyleNew.BackColor = Color.Red;
//}
//else if (chk > 0)
//{
// grfPkg.Rows[i].StyleNew.BackColor = Color.Red;
//}
////if (i % 2 == 0)
//// grfPtt.Rows[i].StyleNew.BackColor = color;
i++;
}
catch (Exception ex)
{
String err = "";
}
}
CellNoteManager mgr = new CellNoteManager(grf);
grf.Cols[colItmAmt].Visible = false;
grf.Cols[colItmAmt].AllowEditing = false;
grf.Cols[colItmRemark].AllowEditing = false;
grf.Cols[colItmDate].AllowEditing = false;
grf.Cols[colOnhand].AllowEditing = false;
grf.Cols[colItmPrice].AllowEditing = false;
grf.Cols[colItmDesc].AllowEditing = false;
}
private void setGrfPttDonor(String search)
{
//grfDept.Rows.Count = 7;
grfPtt.Clear();
DataTable dt = new DataTable();
if (search.Equals(""))
{
//String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd");
if (chkToday.Checked)
{
dt = ic.ivfDB.vsDB.selectCurrentVisitNoVisit();
}
else
{
dt = ic.ivfDB.vsDB.selectCurrentVisit();
}
}
else
{
//grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search);
}
//grfExpn.Rows.Count = dt.Rows.Count + 1;
grfPtt.Rows.Count = dt.Rows.Count + 1;
grfPtt.Cols.Count = 9;
C1TextBox txt = new C1TextBox();
//C1ComboBox cboproce = new C1ComboBox();
//ic.ivfDB.itmDB.setCboItem(cboproce);
grfPtt.Cols[colHn].Editor = txt;
grfPtt.Cols[colName].Editor = txt;
grfPtt.Cols[colVsDate].Editor = txt;
grfPtt.Cols[colVN].Width = 120;
grfPtt.Cols[colHn].Width = 120;
grfPtt.Cols[colName].Width = 300;
grfPtt.Cols[colVsDate].Width = 100;
grfPtt.Cols[colVsTime].Width = 80;
grfPtt.Cols[colVsEtime].Width = 80;
grfPtt.Cols[colStatus].Width = 200;
grfPtt.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfPtt.Cols[colVN].Caption = "VN";
grfPtt.Cols[colHn].Caption = "HN";
grfPtt.Cols[colName].Caption = "Name";
grfPtt.Cols[colVsDate].Caption = "Date";
grfPtt.Cols[colVsTime].Caption = "Time visit";
grfPtt.Cols[colVsEtime].Caption = "Time finish";
grfPtt.Cols[colStatus].Caption = "Status";
ContextMenu menuGw = new ContextMenu();
menuGw.MenuItems.Add("&แก้ไข Visit", new EventHandler(ContextMenu_edit_vs_donor));
menuGw.MenuItems.Add("&แก้ไข ประวัติ", new EventHandler(ContextMenu_edit_ptt));
grfPtt.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)
{
grfPtt[i, 0] = i;
grfPtt[i, colID] = row["id"].ToString();
grfPtt[i, colVN] = row["VN"].ToString();
grfPtt[i, colHn] = row["PIDS"].ToString();
grfPtt[i, colName] = row["PName"].ToString();
grfPtt[i, colVsDate] = ic.datetoShow(row["VDate"]);
grfPtt[i, colVsTime] = row["VStartTime"].ToString();
grfPtt[i, colVsEtime] = row["VEndTime"].ToString();
grfPtt[i, colStatus] = row["VName"].ToString();
//if (i % 2 == 0)
// grfPtt.Rows[i].StyleNew.BackColor = color;
i++;
}
//menuGw = new ContextMenu();
//grfPtt.ContextMenu = menuGw;
grfPtt.Cols[colID].Visible = false;
grfPtt.Cols[colVN].AllowEditing = false;
grfPtt.Cols[colHn].AllowEditing = false;
grfPtt.Cols[colName].AllowEditing = false;
grfPtt.Cols[colVsDate].AllowEditing = false;
grfPtt.Cols[colVsTime].AllowEditing = false;
grfPtt.Cols[colVsEtime].AllowEditing = false;
grfPtt.Cols[colStatus].AllowEditing = false;
theme1.SetTheme(grfPtt, ic.theme);
}
private void setGrfOpera()
{
//grfDept.Rows.Count = 7;
grfOpera.Clear();
DataTable dt = new DataTable();
dt = ic.ivfDB.oropDB.selectByStatusOperation();
//grfExpn.Rows.Count = dt.Rows.Count + 1;
grfOpera.Rows.Count = dt.Rows.Count + 1;
grfOpera.Cols.Count = 11;
grfOpera.Cols[colQueHn].Width = 100;
grfOpera.Cols[colQueName].Width = 200;
grfOpera.Cols[colQueOpera].Width = 300;
grfOpera.Cols[colQueOrDate].Width = 100;
grfOpera.Cols[colQueOrTime].Width = 60;
grfOpera.Cols[colQueSurgeon].Width = 160;
//grfQue.Cols[colStatus].Width = 200;
grfOpera.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfOpera.Cols[colQueHn].Caption = "HN";
grfOpera.Cols[colQueName].Caption = "Patient Name";
grfOpera.Cols[colQueOpera].Caption = "Operation";
grfOpera.Cols[colQueOrDate].Caption = "OR Date";
grfOpera.Cols[colQueOrTime].Caption = "OR Time";
grfOpera.Cols[colQueSurgeon].Caption = "Surgeon";
//grfQue.Cols[colStatus].Caption = "Status";
ContextMenu menuGw = new ContextMenu();
//menuGw.MenuItems.Add("&receive operation", new EventHandler(ContextMenu_Apm));
menuGw.MenuItems.Add("edit operation", new EventHandler(ContextMenu_order_edit));
MenuItem addDevice = new MenuItem("[Form Print]");
menuGw.MenuItems.Add(addDevice);
addDevice.MenuItems.Add(new MenuItem("Form DF ผ่าตัด", new EventHandler(ContextMenu_order_prn_df)));
addDevice.MenuItems.Add(new MenuItem("Form A ค่าใช้จ่าย", new EventHandler(ContextMenu_order_prn_form_a)));
addDevice.MenuItems.Add(new MenuItem("Form B ค่าใช้จ่าย", new EventHandler(ContextMenu_orderprn_form_b)));
grfOpera.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)
{
grfOpera[i, 0] = i;
grfOpera[i, colQueId] = row[ic.ivfDB.oropDB.orop.or_id].ToString();
grfOpera[i, colQueHn] = row[ic.ivfDB.oropDB.orop.patient_hn].ToString();
grfOpera[i, colQueName] = row[ic.ivfDB.oropDB.orop.patient_name].ToString();
grfOpera[i, colQueOpera] = row["operation"].ToString();
grfOpera[i, colQueOrDate] = ic.datetoShow(row[ic.ivfDB.oropDB.orop.or_date].ToString());
grfOpera[i, colQueOrTime] = row[ic.ivfDB.oropDB.orop.or_time].ToString();
grfOpera[i, colQueSurgeon] = row["surgeon"].ToString();
grfOpera[i, colQueRemark] = row["remark"].ToString();
grfOpera[i, colQueAge] = row["age"].ToString();
grfOpera[i, colQueAnes] = row["anesthesia_name"].ToString();
if (!row[ic.ivfDB.oropDB.orop.or_req_id].ToString().Equals("0"))
{
CellNote note = new CellNote("ส่ง Lab Request Foam A");
CellRange rg = grfOpera.GetCellRange(i, colQueHn);
rg.UserData = note;
}
//if (i % 2 == 0)
// grfPtt.Rows[i].StyleNew.BackColor = color;
i++;
}
CellNoteManager mgr = new CellNoteManager(grfQue);
grfOpera.Cols[colQueId].Visible = false;
grfOpera.Cols[colQueHn].AllowEditing = false;
grfOpera.Cols[colQueName].AllowEditing = false;
grfOpera.Cols[colQueOpera].AllowEditing = false;
grfOpera.Cols[colQueOrDate].AllowEditing = false;
grfOpera.Cols[colQueOrTime].AllowEditing = false;
grfOpera.Cols[colQueSurgeon].AllowEditing = false;
//theme1.SetTheme(grfQue, ic.theme);
}
//private void clearGrf()
//{
// foreach (Control con in panel3.Controls)
// {
// if (con is C1DockingTab)
// {
// foreach (Control cond in con.Controls)
// {
// if (cond is C1DockingTabPage)
// {
// foreach (Control cong in cond.Controls)
// {
// if (cong is C1DockingTab)
// {
// foreach (Control congd in cong.Controls)
// {
// if (congd is C1DockingTabPage)
// {
// foreach (Control congd1 in congd.Controls)
// {
// if (congd1 is C1FlexGrid)
// {
// C1FlexGrid grf1;
// grf1 = (C1FlexGrid)congd1;
// //grf1.Clear();
// grf1.Rows.Count = 0;
// }
// }
// }
// }
// }
// }
// }
// }
// }
// }
//}
private void setGrfVs()
{
//grfVs.Clear();
grfVs.Rows.Count = 0;
grfVs.Rows.Count = 2;
grfVs.Cols.Count = 8;
//C1TextBox text = new C1TextBox();
//grfVs.Cols[colVsVsDate].Editor = text;
//grfVs.Cols[colVsVn].Editor = text;
//grfVs.Cols[colVsDept].Editor = text;
//grfVs.Cols[colVsPreno].Editor = text;
grfVs.Cols[colVsVsDate].Width = 100;
grfVs.Cols[colVsVn].Width = 80;
grfVs.Cols[colVsDept].Width = 240;
grfVs.Cols[colVsPreno].Width = 100;
grfVs.Cols[colVsStatus].Width = 60;
grfVs.ShowCursor = true;
//grfVs.AllowMerging = C1.Win.C1FlexGrid.AllowMergingEnum.RestrictRows;
grfVs.Cols[colVsVsDate].Caption = "Visit Date";
grfVs.Cols[colVsVn].Caption = "VN";
grfVs.Cols[colVsDept].Caption = "แผนก";
grfVs.Cols[colVsPreno].Caption = "";
grfVs.Cols[colVsPreno].Visible = false;
grfVs.Cols[colVsVn].Visible = true;
grfVs.Cols[colVsAn].Visible = false;
grfVs.Cols[colVsAndate].Visible = false;
grfVs.Rows[0].Visible = false;
grfVs.Cols[0].Visible = false;
grfVs.Cols[colVsVsDate].AllowEditing = false;
grfVs.Cols[colVsVn].AllowEditing = false;
grfVs.Cols[colVsDept].AllowEditing = false;
grfVs.Cols[colVsPreno].AllowEditing = false;
DataTable dt = new DataTable();
//MessageBox.Show("hn "+hn, "");
//if (ic.cop.comp_name_e.IndexOf("World Wide IVF") >= 0 || ic.cop.comp_name_e.IndexOf("IVF Worldwide Co., Ltd.") >= 0) //-0021
//{ //-0021
// dt = ic.ivfDB.ovsDB.selectByHN(txtHn.Text); //-0021
//} //-0021
//else //-0021
//{ //-0021
//dt = ic.ivfDB.vsDB.selectByHN(txtHn.Text); //+0021
dt = ic.ivfDB.vsDB.selectByHN(ptt.patient_hn); //+0021
//} //-0021
int i = 1, j = 1, row = grfVs.Rows.Count;
//txtVN.Value = dt.Rows.Count;
//txtName.Value = "";
//txt.Value = "";
foreach (DataRow row1 in dt.Rows)
{
Row rowa = grfVs.Rows.Add();
String status = "", vn = "";
//status = row1["MNC_PAT_FLAG"] != null ? row1["MNC_PAT_FLAG"].ToString().Equals("O") ? "OPD" : "IPD" : "-";
rowa[colVsVsDate] = ic.datetoShow(row1["VDate"]);
//rowa[colVsVn] = vn;
rowa[colVsStatus] = status;
rowa[colVsVn] = row1["VN"].ToString();
//vn = row1["MNC_VN_NO"].ToString() + "/" + row1["MNC_VN_SEQ"].ToString() + "(" + row1["MNC_VN_SUM"].ToString() + ")" ;
//rowa[colVsVsDate] = ic.datetoShow(row1["mnc_date"]);
//rowa[colVsVn] = vn;
//rowa[colVsStatus] = status;
//rowa[colVsPreno] = row1["mnc_pre_no"].ToString();
//rowa[colVsDept] = row1["MNC_SHIF_MEMO"].ToString();
//rowa[colVsAn] = row1["mnc_an_no"].ToString()+"/"+ row1["mnc_an_yr"].ToString();
//rowa[colVsAndate] = ic.datetoShow(row1["mnc_ad_date"].ToString());
}
//ContextMenu menuGw = new ContextMenu();
//menuGw.MenuItems.Add("&ยกเลิก รูปภาพนี้", new EventHandler(ContextMenu_Void));
//menuGw.MenuItems.Add("&Update ข้อมูล", new EventHandler(ContextMenu_Update));
//foreach (DocGroupScan dgs in bc.bcDB.dgsDB.lDgs)
//{
// menuGw.MenuItems.Add("&เลือกประเภทเอกสาร และUpload Image [" + dgs.doc_group_name + "]", new EventHandler(ContextMenu_upload));
//}
//grfVs.ContextMenu = menuGw;
grfVs.Cols[colVsVsDate].AllowEditing = false;
grfVs.Cols[colVsVn].AllowEditing = false;
grfVs.Cols[colVsStatus].AllowEditing = false;
//grfVs.Cols[colImagePath].Visible = false;
//row1[colVSE2] = row[ic.ivfDB.pApmDB.pApm.e2].ToString().Equals("1") ? imgCorr : imgTran;
//grfVs.AutoSizeCols();
//grfVs.AutoSizeRows();
//grfVs.Refresh();
//theme1.SetTheme(grfVs, "ExpressionDark");
}
private void setGrfPttHn()
{
//grfDept.Rows.Count = 7;
grfPtt.Clear();
grfPtt.DataSource = null;
grfPtt.Cols.Count = 8;
grfPtt.Rows.Count = 1;
try
{
String startDate = "", endDate = "";
DateTime dtStart = new DateTime();
DateTime dtEnd = new DateTime();
dtStart = (DateTime)txtStartDate.Value;
dtEnd = (DateTime)txtEndDate.Value;
DataTable dt = new DataTable();
startDate = dtStart.Year + "-" + dtStart.ToString("MM-dd");
endDate = dtEnd.Year + "-" + dtEnd.ToString("MM-dd");
dt = ic.ivfDB.oJpxDB.selectByDate(startDate, endDate, txtSearch.Text);
//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);
grfPtt.Cols[colVN].Editor = txt;
grfPtt.Cols[colHn].Editor = txt;
grfPtt.Cols[colName].Editor = txt;
grfPtt.Cols[colVsDate].Editor = txt;
grfPtt.Cols[colStatus].Editor = txt;
grfPtt.Cols[colVN].Width = 120;
grfPtt.Cols[colHn].Width = 120;
grfPtt.Cols[colName].Width = 300;
grfPtt.Cols[colVsDate].Width = 120;
grfPtt.Cols[colStatus].Width = 50;
grfPtt.Cols[colStatusNurse].Width = 50;
grfPtt.Cols[colStatusCashier].Width = 55;
grfPtt.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfPtt.Cols[colVN].Caption = "VN";
grfPtt.Cols[colHn].Caption = "HN";
grfPtt.Cols[colName].Caption = "Name";
grfPtt.Cols[colVsDate].Caption = "Date";
grfPtt.Cols[colStatus].Caption = "Status";
grfPtt.Cols[colStatusNurse].Caption = "Nurse";
grfPtt.Cols[colStatusCashier].Caption = "Cashier";
menuGw = new ContextMenu();
menuGw.MenuItems.Add("&พิมพ์ Sticker", new EventHandler(ContextMenu_edit));
grfPtt.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)
{
Row row1 = grfPtt.Rows.Add();
row1[0] = i;
row1[colVN] = row["VN"].ToString();
row1[colHn] = row["PIDS"].ToString();
row1[colName] = row["name"].ToString();
row1[colVsDate] = ic.datetoShow(row["Date"].ToString());
row1[colStatus] = row["Status"].ToString();
row1[colStatusNurse] = row["status_nurse"] != null ? row["status_nurse"].ToString() : "";
row1[colStatusCashier] = row["status_cashier"] != null ? row["status_cashier"].ToString() : "";
if (i % 2 == 0)
{
grfPtt.Rows[i].StyleNew.BackColor = color;
}
i++;
}
//grfPtt.Cols[colVN].Visible = false;
theme1.SetTheme(grfPtt, ic.theme);
}
catch (Exception ex)
{
MessageBox.Show("" + ex.Message, "Error");
}
}
private void setGrfQue(String search)
{
//grfDept.Rows.Count = 7;
//grfStk.Clear();
grfStk.Rows.Count = 1;
DataTable dt = new DataTable();
dt = ic.ivfDB.stkrDB.selectByYearId(cboYear.Text.Trim());
//grfExpn.Rows.Count = dt.Rows.Count + 1;
grfStk.Rows.Count = dt.Rows.Count + 1;
grfStk.Cols.Count = 7;
grfStk.Cols[colRecDoc].Width = 120;
grfStk.Cols[colRecDate].Width = 120;
grfStk.Cols[colRecRemark].Width = 300;
grfStk.Cols[colRecStatus].Width = 300;
grfStk.Cols[colRecDesc].Width = 300;
grfStk.ShowCursor = true;
//grdFlex.Cols[colID].Caption = "no";
//grfDept.Cols[colCode].Caption = "รหัส";
grfStk.Cols[colRecDoc].Caption = "Doc";
grfStk.Cols[colRecDate].Caption = "Date";
grfStk.Cols[colRecRemark].Caption = "Remark";
grfStk.Cols[colRecStatus].Caption = "Status";
grfStk.Cols[colRecDesc].Caption = "Decription";
ContextMenu menuGw = new ContextMenu();
//menuGw.MenuItems.Add("&receive operation", new EventHandler(ContextMenu_Apm));
grfStk.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)
{
try
{
grfStk[i, 0] = i;
grfStk[i, colRecId] = row["rec_id"].ToString();
grfStk[i, colRecDoc] = row["rec_doc"].ToString();
grfStk[i, colRecDate] = ic.datetoShow(row["rec_date"].ToString());
grfStk[i, colRecRemark] = row["remark"].ToString();
grfStk[i, colRecStatus] = row["status_stock"].ToString().Equals("1") ? "add receive" : row["status_stock"].ToString().Equals("2") ? "gen stock" : "";
grfStk[i, colRecDesc] = row["description"].ToString();
//if (i % 2 == 0)
// grfPtt.Rows[i].StyleNew.BackColor = color;
i++;
}
catch (Exception ex)
{
new LogWriter("e", "FrmNurseView SetGrfQue " + ex.Message + " InnerException " + ex.InnerException);
}
}
CellNoteManager mgr = new CellNoteManager(grfStk);
//grfStk.Cols[colID].Visible = false;
grfStk.Cols[colRecDoc].AllowEditing = false;
grfStk.Cols[colRecDate].AllowEditing = false;
grfStk.Cols[colRecRemark].AllowEditing = false;
grfStk.Cols[colRecStatus].AllowEditing = false;
grfStk.Cols[colRecDesc].AllowEditing = false;
//theme1.SetTheme(grfQue, ic.theme);
}
