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