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