public static List<ExceptionPOS> Load(ExceptionPOS obj) { using(var model= new SGCoopSTEntities()) { var list = from l in model.ExceptionPOS where l.MaDotKhuyenMai == obj.MaDotKhuyenMai select l; return list.ToList(); } }
void set_object(string GuidCT, int STT) { //Khuyen Mai POS objKM.TenDotKhuyenMai = txtTenDotKhuyenMai.Text; objKM.MaDotKhuyenMai = STT.ToString("0000000000"); objKM.HinhThucKM = int.Parse(cboKhuyenMai.SelectedValue.ToString().Trim()); objKM.MaNVTao = CurrentUser.MaNV; objKM.TuNgay = dateTuNgay.Value; objKM.DenNgay = dateDenNgay.Value; objKM.STT = STT; objKM.GhiChu = txtGhiChu.Text; objKM.DaApDung = chkDaApDung.Checked; objKM.DaThucHien = chkDaThucHien.Checked; objKM.IsExept = chkLoaiTruSKU.Checked; objKM.IsCombo = chkCombo.Checked; //KM Sieu Thi //CTKhuyen Mai POS objCT.MaDotKhuyenMai = STT.ToString("0000000000"); objCT.CTKhuyenMaiID = GuidCT; objCT.MaLoaiKhuyenMai = cboKhuyenMai.SelectedValue.ToString(); objCT.STT = STT; if (txtDKCongDiem.Enabled == true && txtDiemThuongGioiHan.Enabled == true) objCT.DieuKien = txtDKCongDiem.Text; else objCT.DieuKien = "0"; if (txtDiemThuongGioiHan.Enabled == true) objCT.DiemThuongGioiHan = decimal.Parse(txtDiemThuongGioiHan.Text); else objCT.DiemThuongGioiHan = decimal.Parse("0"); objCT.GiaTriTongHoaDon = decimal.Parse(txtGiaTriHoaDon.Text); objCT.GhiChu = txtGhiChu.Text; //Dieu kien khuyen mai POS for (int i = 0; i < dgvDieuKienKM.Rows.Count; i++) { objDK = new DieuKienKhuyenMaiPOS(); DataGridViewRow dr = dgvDieuKienKM.Rows[i]; if (dr.Cells["GiaTri"].Value == null || dr.Cells["TongGiaTri"].Value == null || dr.Cells["TongSoLuong"].Value == null || dr.Cells["DiemThuong"].Value==null || dr.Cells["DiemThuongGioiHan"].Value==null) { break; } objDK.CTKhuyenMaiID = GuidCT; objDK.GiaTri = dr.Cells["GiaTri"].Value.ToString(); objDK.TongGiaTri = decimal.Parse(dr.Cells["TongGiaTri"].Value.ToString().Replace(".", "")); objDK.TongSoLuong = decimal.Parse(dr.Cells["TongSoLuong"].Value.ToString()); objDK.DiemThuong = decimal.Parse(dr.Cells["DiemThuong"].Value.ToString()); objDK.DiemThuongGioiHan = decimal.Parse(dr.Cells["DiemThuongGioiHan"].Value.ToString()); lstDK.Add(objDK); } //Exception POS if (chkLoaiTruSKU.Checked == true) { for (int i = 0; i < dgvExPOS.Rows.Count; i++) { objEX = new ExceptionPOS(); DataGridViewRow dr = dgvExPOS.Rows[i]; if (dr.Cells["SKULoaiTru"].Value == null) break; objEX.MaDotKhuyenMai = STT.ToString("0000000000"); objEX.SKULoaiTru = dr.Cells["SKULoaiTru"].Value.ToString(); lstEX.Add(objEX); } } }
void load_data_update() { txtTenDotKhuyenMai.Text = objKM.TenDotKhuyenMai; cboKhuyenMai.SelectedItem = objKM.HinhThucKM.ToString().Trim(); chkCombo.Checked = bool.Parse(objKM.IsCombo.ToString()); chkLoaiTruSKU.Checked = bool.Parse(objKM.IsExept.ToString()); dateTuNgay.Value = objKM.TuNgay; dateDenNgay.Value = objKM.DenNgay; chkDaApDung.Checked = objKM.DaApDung; chkDaThucHien.Checked = bool.Parse(objKM.DaThucHien.ToString()); //*******load CTKhuyenMaiPOS************************************// objCT = new CTKhuyenMaiPOS(); objCT.MaDotKhuyenMai = objKM.MaDotKhuyenMai; objCT = CTLCTKhuyenMaiPOS.load(objCT); txtDKCongDiem.Text = objCT.DieuKien; txtDiemThuongGioiHan.Text = objCT.DiemThuongGioiHan.ToString(); txtGiaTriHoaDon.Text = format_value(objCT.GiaTriTongHoaDon.ToString().Replace(".00", "")); txtGhiChu.Text = objCT.GhiChu; //******load DieuKienKhuyenMai POS*****************************// objDK = new DieuKienKhuyenMaiPOS(); objDK.CTKhuyenMaiID = objCT.CTKhuyenMaiID; lstDK = new List<DieuKienKhuyenMaiPOS>(); lstDK = CTLDieuKienKhuyenMaiPOS.Load(objDK); if(lstDK.Count>0) { dgvDieuKienKM.AutoGenerateColumns = false; dgvDieuKienKM.DataSource = lstDK; } //*****load ExceptionPOS**************************************// if(objKM.IsExept==true) { objEX = new ExceptionPOS(); objEX.MaDotKhuyenMai = objKM.MaDotKhuyenMai; lstEX = new List<ExceptionPOS>(); lstEX = CTLExceptionPOS.Load(objEX); if(lstEX.Count>0) { dgvExPOS.AutoGenerateColumns = false; dgvExPOS.DataSource = lstEX; } } }