private void setGrfRptDrugDaily()
{
String startdate = "", enddate = "";
DataTable dt = new DataTable();
DateTime startdate1 = new DateTime();
DateTime enddate1 = new DateTime();
DateTime.TryParse(txtRptDateStart.Text, out startdate1);
DateTime.TryParse(txtRptDateEnd.Text, out enddate1);
startdate = startdate1.ToString("yyyy-MM-dd", new CultureInfo("en-US"));
enddate = enddate1.ToString("yyyy-MM-dd", new CultureInfo("en-US"));
dt = ic.ivfDB.oJpxdDB.selectByDate1(startdate, enddate);
grfRpt.Rows.Count = 1;
grfRpt.Rows.Count = dt.Rows.Count + 1;
grfRpt.Cols.Count = 8;
grfRpt.Cols[colRptDrugDailyDrugCode].Width = 80;
grfRpt.Cols[colRptDrugDailyDrugName].Width = 300;
grfRpt.Cols[colRptDrugDailyPttHn].Width = 100;
grfRpt.Cols[colRptDrugDailyPttName].Width = 300;
grfRpt.Cols[colRptDrugDailyQty].Width = 80;
grfRpt.Cols[colRptDrugDailyTime].Width = 140;
grfRpt.Cols[colRptDrugDailyVN].Width = 80;
grfRpt.Cols[colRptDrugDailyTime].Caption = "TIME";
grfRpt.Cols[colRptDrugDailyQty].Caption = "QTY";
grfRpt.Cols[colRptDrugDailyPttName].Caption = "Patient Name";
grfRpt.Cols[colRptDrugDailyPttHn].Caption = "HN";
grfRpt.Cols[colRptDrugDailyDrugName].Caption = "NAME";
grfRpt.Cols[colRptDrugDailyDrugCode].Caption = "CODE";
grfRpt.Cols[colRptDrugDailyTime].Caption = "Date ";
grfRpt.Cols[colRptDrugDailyVN].Caption = "VN ";
ContextMenu menuGw = new ContextMenu();
//menuGw.MenuItems.Add("&receive operation", new EventHandler(ContextMenu_Apm));
grfRpt.ContextMenu = menuGw;
int i = 1;
foreach (DataRow row in dt.Rows)
{
grfRpt[i, colRptDrugDailyDrugCode] = row["DUID"].ToString();
grfRpt[i, colRptDrugDailyDrugName] = row["DUName"].ToString();
grfRpt[i, colRptDrugDailyPttHn] = ic.showHN(row["patient_hn"].ToString(), row["patient_year"].ToString());
grfRpt[i, colRptDrugDailyPttName] = row["patient_name"].ToString();
grfRpt[i, colRptDrugDailyQty] = row["QTY"].ToString();
grfRpt[i, colRptDrugDailyTime] = ic.datetimetoShow(row["order_date_time"].ToString());
grfRpt[i, colRptDrugDailyVN] = ic.showVN(row["vn"].ToString());
i++;
}
grfRpt.Cols[colRptDrugDailyDrugCode].AllowEditing = false;
grfRpt.Cols[colRptDrugDailyDrugName].AllowEditing = false;
grfRpt.Cols[colRptDrugDailyPttHn].AllowEditing = false;
grfRpt.Cols[colRptDrugDailyPttName].AllowEditing = false;
grfRpt.Cols[colRptDrugDailyQty].AllowEditing = false;
grfRpt.Cols[colRptDrugDailyTime].AllowEditing = false;
grfRpt.Cols[colRptDrugDailyVN].AllowEditing = false;
}
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;
}
