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 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 setGrfFinish(String search)
{
//grfDept.Rows.Count = 7;
//grfFinish.Clear();
DataTable dt = new DataTable();
//if (search.Equals("")) //-0020
//{ //-0020
String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd");
//dt = ic.ivfDB.ovsDB.selectByStatusNurseFinish(ic.datetoDB(txtDateStart.Text)); //-0020
dt = ic.ivfDB.vsDB.selectByStatusPhamacyFinish(date); //+0020
//} //-0020
//else //-0020
//{ //-0020
// //grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search);
// if (txtDateStart.Text.Equals("")) //-0020
// { //-0020
// dt = ic.ivfDB.ovsDB.selectByStatusNurseFinishLike(search); //-0020
// } //-0020
//} //-0020
grfFinish.Rows.Count = 1;
grfFinish.Rows.Count = dt.Rows.Count + 1;
grfFinish.Cols.Count = 14;
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 = 80;
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] = ic.showVN(row["VN"].ToString());
grfFinish[i, colPttHn] = ic.showHN(row["PIDS"].ToString(), row["patient_year"].ToString());
grfFinish[i, colPttName] = row["PName"].ToString();
grfFinish[i, colVsDate] = ic.datetoShow(row["VDate"]);
grfFinish[i, colVsTime] = ic.timetoShow(row["VStartTime"].ToString());
grfFinish[i, colVsEtime] = ic.timetoShow(row["VEndTime"].ToString());
grfFinish[i, colStatus] = row["VName"].ToString();
grfFinish[i, colPttId] = row["PID"].ToString();
grfFinish[i, colVn] = row["VN"].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[colVn].Visible = false;
grfFinish.Cols[colDtr].Visible = false;
grfFinish.Cols[colStatusNurse].Visible = false;
grfFinish.Cols[colStatusCashier].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;
//theme1.SetTheme(grfFinish, ic.theme);
}
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 setGrfSearch(String search)
{
//grfDept.Rows.Count = 7;
tC.SelectedTab = tabSearch;
grfSearch.Clear();
DataTable dt1 = new DataTable();
DataTable dt = new DataTable();
dt = ic.ivfDB.ovsDB.selectByHNLike(search);
//grfPtt.DataSource = ic.ivfDB.vsOldDB.selectCurrentVisit(search);
//grfExpn.Rows.Count = dt.Rows.Count + 1;
grfSearch.Rows.Count = dt.Rows.Count + 1;
grfSearch.Cols.Count = 11;
//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();
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(); //vn
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] = row["VStartTime"].ToString();
grfSearch[i, colVsEtime] = row["VEndTime"].ToString();
grfSearch[i, colStatus] = row["VName"].ToString();
grfSearch[i, colPttId] = row["PID"].ToString();
grfSearch[i, colVn] = row["VN"].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;
//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 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;
}