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; }