/// <summary> /// HÀM THỰC HIỆN TÌM KIẾM THÔNG TIN /// </summary> private void TIMKIEM_THONGTIN() { byte TRANG_THAI = 2; if (optDaxacnhan.Checked) { TRANG_THAI = 1; } if (optChuaxacnhan.Checked) { TRANG_THAI = 0; } string MaKho = "-1"; m_dtPhieutrathuocthua = DuocNoitru.ThuocNoitruTimkiemPhieutrathuocthua(Utility.Int32Dbnull(txtId.Text, -1), chkByDate.Checked ? dtFromdate.Value.ToString("dd/MM/yyyy") : "01/01/1900", chkByDate.Checked ? dtToDate.Value.ToString("dd/MM/yyyy") : "01/01/1900", Utility.Bool2byte(chkTheongaytra.Checked), Utility.Int32Dbnull(txtKhoanoitru.MyID, -1), Utility.Int32Dbnull(txtKhothuoc.MyID, -1) , Utility.Int32Dbnull(txtNguoitra.MyID, -1), Utility.Int32Dbnull(txtNguoinhan.MyID, -1), TRANG_THAI, KIEU_THUOC_VT); Utility.SetDataSourceForDataGridEx_Basic(grdList, m_dtPhieutrathuocthua, true, true, "1=1", ""); if (!Utility.isValidGrid(grdList)) { if (m_dtDetail != null) { m_dtDetail.Clear(); } } ModifyCommand(); }
/// <summary> /// hàm thực hiện việc di chuyển thông tin của trên lưới /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void grdList_SelectionChanged(object sender, EventArgs e) { if (Utility.isValidGrid(grdList)) { int IDPhieu = Utility.Int32Dbnull(grdList.GetValue(TPhieutrathuocthua.Columns.Id), -1); m_dtDetail = DuocNoitru.ThuocNoitruLayChitietPhieutrathuocthua(IDPhieu, (byte)0); Utility.SetDataSourceForDataGridEx(grdDetail, m_dtDetail.Tables[0], false, true, "1=1", ""); Utility.SetDataSourceForDataGridEx(grdChitiet, m_dtDetail.Tables[1], false, true, "1=1", ""); } else { grdChitiet.DataSource = null; grdDetail.DataSource = null; } ModifyCommand(); }
void GetData(byte tonghoplai) { DataSet dsData = DuocNoitru.ThuocNoitruLayChitietPhieutrathuocthua((int)idPhieutra, tonghoplai); Utility.SetDataSourceForDataGridEx(grdPres, dsData.Tables[0], false, true, "1=1", ""); Utility.SetDataSourceForDataGridEx(grdChitiet, dsData.Tables[1], false, true, "1=1", ""); foreach (GridEXRow exRow in grdChitiet.GetDataRows()) { exRow.BeginEdit(); exRow.IsChecked = Utility.Int32Dbnull(exRow.Cells["_checked"].Value, 0) == 1; exRow.EndEdit(); } dtpInputDate.Value = _item.NgayLapphieu; txtNhanvien.SetId(Utility.Int16Dbnull(_item.NguoiLapphieu, -1)); txtKhoanoitru.SetId(Utility.Int16Dbnull(_item.IdKhoatra, -1)); txtKhothuoc.SetId(Utility.Int16Dbnull(_item.IdKhonhan, -1)); }
private void SearchData() { try { hasLoaded = false; int id_khoanoitru = Utility.Int32Dbnull(txtKhoanoitru.MyID, -1); int id_kho = Utility.Int32Dbnull(txtKhothuoc.MyID, -1); m_dsData.Clear(); grdPres.DataSource = null; grdChitiet.DataSource = null; m_dsData = DuocNoitru.ThuocNoitruTimkiemThuocthuatralai(id_khoanoitru, id_kho, kieu_thuoc_vt); Utility.SetDataSourceForDataGridEx_Basic(grdPres, m_dsData.Tables[0], true, true, "1=1", ""); Utility.SetDataSourceForDataGridEx_Basic(grdChitiet, m_dsData.Tables[1], true, true, "1=1", "ten_thuoc"); } catch (Exception ex) { } finally { hasLoaded = true; ModifyCommands(); } }