private void setGrfVs()
{
Cursor cursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
//pB1.Visible = true;
String sql = "", datestart = "", dateend = "";
datestart = bc.datetoDB(txtDateStart.Text);
dateend = bc.datetoDB(txtDateEnd.Text);
System.Drawing.Font font = new System.Drawing.Font("Microsoft Sans Serif", 12);
DataTable dt = new DataTable();
grfVs.Cols.Count = 15;
//grfVs.Rows.cl
grfVs.Rows.Count = 1;
grfVs.Cols[colHn].Width = 80;
grfVs.Cols[colName].Width = 300;
grfVs.Cols[colDate].Width = 110;
grfVs.Cols[colVn].Width = 65;
grfVs.Cols[colPreno].Width = 50;
grfVs.Cols[colAn].Width = 80;
grfVs.Cols[colHn].Caption = "HN";
grfVs.Cols[colName].Caption = "Name";
grfVs.Cols[colDate].Caption = "Date";
grfVs.Cols[colDateDisc].Caption = "Date Disc";
grfVs.Cols[colVn].Caption = "Vn";
grfVs.Cols[colPreno].Caption = "preno";
grfVs.Cols[colAn].Caption = "An";
grfVs.Cols[colID].Caption = "ID";
grfVs.Cols[colWeight].Caption = "Wright";
if (txtAn.Text.Trim().Length > 0)
{
dt = bc.bcDB.vsDB.selectNHSOPrint3(txtAn.Text.Trim());
}
else
{
dt = bc.bcDB.vsDB.selectNHSOPrint(datestart, dateend, "");
}
//pB1.Maximum = dt.Rows.Count;
//dgvPE.Columns[colPEId].HeaderText = "id";
if (dt.Rows.Count > 0)
{
if (txtAn.Text.Length > 0)
{
String where = "";
int len = txtAn.Text.Trim().Length;
//if (txtAn.Text.IndexOf(",") <= 0)
//{
// where = " mnc_an_no = '" + txtAn.Text + "' ";
// DataRow[] dr = dt.Select(where);
// int i = 0;
// if (dr.Length == 0)
// {
// MessageBox.Show("ไม่พบ AN " + txtAn.Text + " ที่ต้องการค้นหา", "1.");
// return;
// }
// grfVs.Rows.Count = dr.Length + 1;
// foreach (DataRow row in dr)
// {
// if (dr[i]["mnc_an_no"].ToString().Equals("21364"))
// {
// sql = "";
// }
// grfVs[i+1,0] = (i + 1);
// grfVs[i + 1, colHn] = dr[i]["mnc_hn_no"].ToString();
// grfVs[i + 1, colName] = dr[i]["MNC_PFIX_DSC"].ToString() + " " + dr[i]["MNC_FNAME_T"].ToString() + " " + dr[i]["MNC_LNAME_T"].ToString() + " [" + dr[i]["MNC_id_no"].ToString() + "]";
// grfVs[i + 1, colVn] = dr[i]["mnc_vn_no"].ToString() + "." + dr[i]["MNC_VN_SEQ"].ToString() + "." + dr[i]["MNC_VN_SUM"].ToString();
// grfVs[i + 1, colPreno] = dr[i]["MNC_PRE_NO"].ToString();
// grfVs[i + 1, colPaid] = bc.shortPaidName(dr[i]["MNC_FN_TYP_DSC"].ToString());
// grfVs[i + 1, colDate] = bc.dateDBtoShowShort1(bc.datetoDB(dr[i]["MNC_DATE"].ToString())) + " " + bc.FormatTime(dr[i]["MNC_time"].ToString());
// grfVs[i + 1, colDoctor] = dr[i]["prefix"].ToString() + " " + dr[i]["Fname"].ToString() + " " + dr[i]["Lname"].ToString() + " [" + dr[i]["mnc_dot_cd"].ToString() + "] ";
// grfVs[i + 1, colPdf] = "PDF";
// grfVs[i + 1, colDob] = bc.dateDBtoShowShort1(bc.datetoDB(dr[i]["MNC_BDAY"].ToString()));
// grfVs[i + 1, colDateDisc] = bc.dateDBtoShowShort1(bc.datetoDB(dr[i]["mnc_ds_date"].ToString()));
// grfVs[i + 1, colID] = dr[i]["mnc_id_no"].ToString();
// grfVs[i + 1, colWeight] = dr[i]["mnc_weight"].ToString();
// grfVs[i + 1, colAn] = dr[i]["mnc_an_no"].ToString() + "/" + dr[i]["mnc_an_yr"].ToString();
// int cnt = bc.bcDB.vsDB.selectNHSOPrintHN2("", grfVs[i + 1, colHn].ToString(), grfVs[i + 1, colPreno].ToString(), grfVs[i + 1, colVn].ToString());
// //if ((i % 2) != 0)
// grfVs[i, colChk] = cnt > 0 ? "1" : "0";
// //dgvView.Rows[i].DefaultCellStyle.BackColor = cnt > 0 ? Color.LightSalmon : Color.White;
// i++;
// //pB1.Value = i;
// }
//}
//else
//{
String[] an = txtAn.Text.Split(',');
String wherean = "";
for (int j = 0; j < an.Length; j++)
{
wherean += "'" + an[j].Trim() + "',";
}
if (wherean.Length > 0)
{
if (wherean.IndexOf(',', wherean.Length - 1) > 0)
{
wherean = wherean.Substring(0, wherean.Length - 1);
}
}
where = " mnc_an_no in (" + wherean + ") ";
DataRow[] dr = dt.Select(where);
//pB1.Maximum = dr.Length;
int i = 0;
if (dr.Length == 0)
{
MessageBox.Show("ไม่พบ AN " + txtAn.Text + " ที่ต้องการค้นหา", "2.");
return;
}
grfVs.Rows.Count = dr.Length + 1;
foreach (DataRow row in dr)
{
String hn = "", preno = "", vn = "";
hn = dr[i]["mnc_hn_no"].ToString();
preno = dr[i]["MNC_PRE_NO"].ToString();
vn = dr[i]["mnc_vn_no"].ToString() + "." + dr[i]["MNC_VN_SEQ"].ToString() + "." + dr[i]["MNC_VN_SUM"].ToString();
grfVs[i + 1, 0] = (i + 1);
grfVs[i + 1, colHn] = hn;
grfVs[i + 1, colName] = dr[i]["MNC_PFIX_DSC"].ToString() + " " + dr[i]["MNC_FNAME_T"].ToString() + " " + dr[i]["MNC_LNAME_T"].ToString() + " [" + dr[i]["MNC_id_no"].ToString() + "]";
grfVs[i + 1, colVn] = vn;
grfVs[i + 1, colPreno] = preno;
grfVs[i + 1, colPaid] = bc.shortPaidName(dr[i]["MNC_FN_TYP_DSC"].ToString());
grfVs[i + 1, colDate] = bc.dateDBtoShowShort(bc.datetoDB(dr[i]["MNC_DATE"].ToString())) + " " + bc.FormatTime(dr[i]["MNC_time"].ToString());
grfVs[i + 1, colDoctor] = dr[i]["prefix"].ToString() + " " + dr[i]["Fname"].ToString() + " " + dr[i]["Lname"].ToString() + " [" + dr[i]["mnc_dot_cd"].ToString() + "] ";
grfVs[i + 1, colPdf] = "PDF";
grfVs[i + 1, colDob] = bc.dateDBtoShowShort(bc.datetoDB(dr[i]["MNC_BDAY"].ToString()));
grfVs[i + 1, colDateDisc] = bc.dateDBtoShowShort(bc.datetoDB(dr[i]["mnc_ds_date"].ToString()));
grfVs[i + 1, colID] = dr[i]["mnc_id_no"].ToString();
grfVs[i + 1, colWeight] = dr[i]["mnc_weight"].ToString();
grfVs[i + 1, colAn] = dr[i]["mnc_an_no"].ToString() + "/" + dr[i]["mnc_an_yr"].ToString();
int cnt = bc.bcDB.vsDB.selectNHSOPrintHN2("", hn, preno, vn);
//if ((i % 2) != 0)
grfVs[i + 1, colChk] = cnt > 0 ? "1" : "0";
//dgvView.Rows[i].DefaultCellStyle.BackColor = cnt > 0 ? Color.LightSalmon : Color.White;
i++;
//pB1.Value = i;
}
//}
}
else
{
grfVs.Rows.Count = dt.Rows.Count + 1;
for (int i = 1; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["mnc_an_no"].ToString().Equals("21364"))
{
sql = "";
}
grfVs[i, 0] = (i + 1);
grfVs[i, colHn] = dt.Rows[i]["mnc_hn_no"].ToString();
grfVs[i, colName] = dt.Rows[i]["MNC_PFIX_DSC"].ToString() + " " + dt.Rows[i]["MNC_FNAME_T"].ToString() + " " + dt.Rows[i]["MNC_LNAME_T"].ToString() + " [" + dt.Rows[i]["MNC_id_no"].ToString() + "]";
grfVs[i, colVn] = dt.Rows[i]["mnc_vn_no"].ToString() + "." + dt.Rows[i]["MNC_VN_SEQ"].ToString() + "." + dt.Rows[i]["MNC_VN_SUM"].ToString();
grfVs[i, colPreno] = dt.Rows[i]["MNC_PRE_NO"].ToString();
grfVs[i, colPaid] = bc.shortPaidName(dt.Rows[i]["MNC_FN_TYP_DSC"].ToString());
grfVs[i, colDate] = bc.dateDBtoShowShort(bc.datetoDB(dt.Rows[i]["MNC_DATE"].ToString())) + " " + bc.FormatTime(dt.Rows[i]["MNC_time"].ToString());
grfVs[i, colDoctor] = dt.Rows[i]["prefix"].ToString() + " " + dt.Rows[i]["Fname"].ToString() + " " + dt.Rows[i]["Lname"].ToString() + " [" + dt.Rows[i]["mnc_dot_cd"].ToString() + "] ";
grfVs[i, colPdf] = "PDF";
grfVs[i, colDob] = bc.dateDBtoShowShort(bc.datetoDB(dt.Rows[i]["MNC_BDAY"].ToString()));
grfVs[i, colDateDisc] = bc.dateDBtoShowShort(bc.datetoDB(dt.Rows[i]["mnc_ds_date"].ToString()));
grfVs[i, colID] = dt.Rows[i]["mnc_id_no"].ToString();
grfVs[i, colWeight] = dt.Rows[i]["mnc_weight"].ToString();
grfVs[i, colAn] = dt.Rows[i]["mnc_an_no"].ToString() + "/" + dt.Rows[i]["mnc_an_yr"].ToString();
int cnt = bc.bcDB.vsDB.selectNHSOPrintHN2("", grfVs[i, colHn].ToString(), grfVs[i, colPreno].ToString(), grfVs[i, colVn].ToString());
//if ((i % 2) != 0)
grfVs[i, colChk] = cnt > 0 ? "1" : "0";
//dgvView.Rows[i].DefaultCellStyle.BackColor = cnt > 0 ? Color.LightSalmon : Color.White;
//pB1.Value = i;
}
}
}
for (int i = 0; i < grfVs.Rows.Count; i++)
{
if (grfVs.Rows.Count <= 1)
{
break;
}
if (grfVs[i, colChk] == null)
{
continue;
}
if (grfVs[i, colChk].ToString().Equals("0"))
{
grfVs.Rows.Remove(i);
i--;
}
}
for (int i = 0; i < grfVs.Rows.Count; i++)
{
grfVs[i, 0] = (i + 1);
}
grfVs.Font = font;
grfVs.Cols[colPreno].Visible = false;
grfVs.Cols[colChk].Visible = false;
grfVs.Cols[colWeight].Visible = false;
//dgvView.Columns[colAn].Visible = false;
grfVs.Cols[colID].Visible = false;
grfVs.Cols[colDob].Visible = false;
grfVs.Cols[colHn].AllowEditing = false;
grfVs.Cols[colName].AllowEditing = false;
grfVs.Cols[colVn].AllowEditing = false;
grfVs.Cols[colPreno].AllowEditing = false;
grfVs.Cols[colPaid].AllowEditing = false;
grfVs.Cols[colDate].AllowEditing = false;
grfVs.Cols[colDoctor].AllowEditing = false;
grfVs.Cols[colPdf].AllowEditing = false;
grfVs.Cols[colDob].AllowEditing = false;
grfVs.Cols[colDateDisc].AllowEditing = false;
grfVs.Cols[colID].AllowEditing = false;
grfVs.Cols[colWeight].AllowEditing = false;
grfVs.Cols[colAn].AllowEditing = false;
//pB1.Visible = false;
Cursor.Current = cursor;
}
