private void setGrf(String hn, String vn, String preno, String dsDate, String chk, String an, C1FlexGrid grf) { String dsDate1 = "", dsTime = "", dsDate2 = ""; dsDate1 = bc.bcDB.vsDB.selectDSDateAN(hn, vn, preno); String[] aa = dsDate.Split(','); if (aa.Length > 1) { dsDate2 = aa[0]; //an = aa[1]; } String[] bb = dsDate1.Split('*'); if (bb.Length > 1) { dsDate2 = bb[0]; dsTime = bb[1]; } DataTable dt, dtt12; if (chk.Equals("")) { dt = bc.bcDB.vsDB.selectNHSOPrintHN("", hn, preno, vn); } else { dt = bc.bcDB.vsDB.selectNHSOPrintHNAll("", hn, preno, vn); } DateTime dtEnd = new DateTime(); DateTime dtStart = new DateTime(); String datestart = "", dateend = "", time3 = ""; String[] an1 = an.Split('/'); if (an1.Length >= 1) { dtt12 = bc.bcDB.vsDB.selectPatientOR(hn, preno, an1[0]); if (dtt12.Rows.Count > 0) { datestart = dtt12.Rows[0]["MNC_OR_DATE_S"].ToString(); if (datestart.Length >= 10) { datestart = datestart.Substring(0, 10); //dateend = datestart; String time1 = "0" + dtt12.Rows[0]["MNC_OR_TIME_S"].ToString(); if (time1.Length > 2) { String time2 = time1.Substring(time1.Length - 2, 2); //String time3 = ""; String time4 = time1.Substring(time1.Length - 4, 2); time3 = " " + time4 + ":" + time2; if (DateTime.TryParse(datestart + time3, out dtStart)) { dtEnd = dtStart; String time5 = ""; time5 = dtt12.Rows[0]["MNC_OR_HOUR"].ToString(); int cnt = 0; if (int.TryParse(time5, out cnt)) { int cnt1 = 0, cnt2 = 0, cnt0 = 0; cnt1 = cnt / 60; cnt2 = cnt % 60; dtEnd = dtEnd.AddHours(cnt1); dtEnd = dtEnd.AddMinutes(cnt2); dateend = dtEnd.ToString("HH:mm"); } } } } } } if (dt.Rows.Count > 0) { grf.Rows.Count = dt.Rows.Count + 1; for (int i = 1; i <= dt.Rows.Count; i++) { grf[i, 0] = (i + 1); grf[i, colGrfPhTn] = dt.Rows[i - 1]["MNC_PH_TN"].ToString() + " [" + dt.Rows[i - 1]["MNC_PH_cd"].ToString() + "]"; grf[i, colGrfQty] = dt.Rows[i - 1]["qty"].ToString(); grf[i, colGrfPrice] = dt.Rows[i - 1]["MNC_PH_PRI01"].ToString(); grf[i, colGrfAmt] = dt.Rows[i - 1]["amt"].ToString(); //grf[i, colHn] = dt.Rows[i]["amt"].ToString(); grf[i, colGrfDate] = bc.dateDBtoShowShort(bc.datetoDB(dt.Rows[i - 1]["MNC_CFG_DAT"].ToString())) + " " + time3 + "-" + dateend; } } }