private void fThongKePhieu_Load(object sender, EventArgs e) { repoTenHang.DataSource = Local_Params.lstDanhMucHang; repoTenHang.DisplayMember = "TenHang"; repoTenHang.ValueMember = "MaVatTu"; oDonDatHangCT_Phieu obj = new oDonDatHangCT_Phieu(); obj.TinhTrang = 0; gridMain.DataSource = ADonDatHangCT_Phieu.find(obj); }
public static List<P_DonDatHang_CT_Phieu> find(oDonDatHangCT_Phieu obj) { using (var model = ModelConnector.Connector()) { var list = from l in model.P_DonDatHang_CT_Phieu select l; if (!string.IsNullOrEmpty(obj.SoDonDatHang)) list = list.Where(a => a.SoDonDatHang.Equals(obj.SoDonDatHang)); if (!string.IsNullOrEmpty(obj.TinhTrang.ToString())) list = list.Where(a => a.TinhTrang==obj.TinhTrang); if (!string.IsNullOrEmpty(obj.TuNgay.ToString())) list = list.Where(a => a.TuNgay >= obj.TuNgay.Value); if (!string.IsNullOrEmpty(obj.DenNgay.ToString())) list = list.Where(a => a.DenNgay <= obj.DenNgay.Value); if (!string.IsNullOrEmpty(obj.TenHang)) list = list.Where(a => a.TenHang == obj.TenHang); if (!string.IsNullOrEmpty(obj.TinhTrang.ToString())) list = list.Where(a => a.TinhTrang == obj.TinhTrang); //list = list.Where(a => a.IsDel == obj.IsDel); return list.ToList(); } }
void load_DonDatHang() { dateNgayGiaoDich.DateTime = objPDonDatHang.NgayDatHang.Value; gridlk_DanhMucPhapNhan.EditValue = objPDonDatHang.DonViGoi; gridlk_DanhMucPhapNhanDatHang.EditValue = objPDonDatHang.DonViDat; txtSoDonHang.Text = objPDonDatHang.SoDonDatHang; txtSoHoaDon.Text = objPDonDatHang.SoHoaDon; chkLenhXuatKho.Checked = objPDonDatHang.IsSoPhieu.Value; chkLenhXuatKho.Enabled = objPDonDatHang.IsSoPhieu.Value == true ? false : true; path_folder = objPDonDatHang.FileLuuTru; if(chkLenhXuatKho.Checked==true) { oDonDatHangCT_Phieu ophieu = new oDonDatHangCT_Phieu() { SoDonDatHang = objPDonDatHang.SoDonDatHang}; lstPDonDatHangCtPhieu = new List<P_DonDatHang_CT_Phieu>(); lstPDonDatHangCtPhieu = ADonDatHangCT_Phieu.find(ophieu); DataTable dtphieu = commons.ToDataTable(lstPDonDatHangCtPhieu); dtphieu.Columns.Add("DVT", typeof(string)); for (int i = 0; i < dtphieu.Rows.Count; i++) { dtphieu.Rows[i]["DVT"] = ((P_DanhMucHang)repoTenHangPhieu.GetDataSourceRowByKeyValue(dtphieu.Rows[i]["TenHang"])).DVT; } gridMainPhieu.DataSource = dtphieu; } oDonDatHangCT ct= new oDonDatHangCT(); ct.SoDonDatHang = objPDonDatHang.SoDonDatHang; DataTable dt = commons.ToDataTable(ADonDatHangCT.find(ct)); dt.Columns.Add("HinhThucThanhToan").DefaultValue = "CK"; gridMain.DataSource = dt; }
List<P_DonDatHang_CT_Phieu> load() { objPhieu = new oDonDatHangCT_Phieu(); if (chkDateF.Checked) objPhieu.TuNgay = Utils_DateTime.FromDate(dateF.DateTime); if (chkDateT.Checked) objPhieu.DenNgay = Utils_DateTime.ToDate(dateT.DateTime); if (chkState.Checked) objPhieu.TinhTrang = lkState.EditValue == null ? byte.Parse("0") : byte.Parse(lkState.EditValue.ToString()); if (chkTenHang.Checked) objPhieu.TenHang = lkTenHang.EditValue == null ? "" : lkTenHang.EditValue.ToString(); return ADonDatHangCT_Phieu.find(objPhieu); }