private void dgvCongNo_CellClick(object sender, DataGridViewCellEventArgs e) { if (this.dgvCongNo.CurrentRow.Selected) { this.dangThayDoiDL = true; this.btnXacNhanThanhToan.Enabled = true; this.txtSoTienTraHomNay.Enabled = true; this.dateTimePickerNgayTra.Enabled = true; this.btnCapNhatHanTraNo.Enabled = true; cn = lstCongNo.Where(p => p.MACONGNO == this.dgvCongNo.CurrentRow.Cells["MACONGNO"].Value.ToString() && p.TRANGTHAI == true).FirstOrDefault(); KHACHHANG kh = KhachHangBUS.LayThongTin(this.dgvCongNo.CurrentRow.Cells["MAKHCongNo"].Value.ToString()); this.lblTenkh.Text = kh.TENKH; this.lblDiaChi.Text = kh.DIACHI; this.lblSDT.Text = kh.SDT; //tongTien = this.dgvCongNo.CurrentRow.Cells["TONGTIENCN"].Value.ToString(); //tienConNo = this.dgvCongNo.CurrentRow.Cells["TIENCONNOCN"].Value.ToString(); this.lblTongTien.Text = Convert.ToDecimal(cn.TONGTIEN).ToString("#,##0") + " VND"; this.lblTienConNo.Text = Convert.ToDecimal(cn.TIENCONNO).ToString("#,##0") + " VND"; this.dateTimePickerNgayTra.Value = Convert.ToDateTime(this.dgvCongNo.CurrentRow.Cells["NGAYTRA"].Value); } else { Reset(); } }
private static CONGNO LayBaoCao() { CONGNO cn = (from c in db.CONGNOes orderby c.MaCongNo descending select c).FirstOrDefault(); return(cn); }
public static bool TimBaoCao(int thang, int nam) { CONGNO cn = (from t in db.CONGNOes where t.NgayBatDau.Value.Month == thang && t.NgayBatDau.Value.Year == nam select t).SingleOrDefault(); if (cn == null) { return(false); } return(true); }
public static bool ThemCongNo(CONGNO congno) { return(CongNoDAO.ThemCongNo(congno)); }
public static bool CapNhatCongNo(CONGNO congno) { return(CongNoDAO.CapNhatCongNo(congno)); }
public static void ThemBaoCao(int thang, int nam) { // tìm ngày bắt đầu và kết thúc DateTime NgayBD = new DateTime(nam, thang, 1); DateTime NgayKT = new DateTime(nam, thang, 30); switch (thang) { case 1: case 3: case 5: case 7: case 8: case 10: case 12: NgayKT = new DateTime(nam, thang, 31); break; case 2: NgayKT = new DateTime(nam, thang, 28); if (NgayKT.AddDays(1).Month == thang) { NgayKT = NgayKT.AddDays(1); } break; case 4: case 6: case 9: case 11: NgayKT = new DateTime(nam, thang, 30); break; } // Bước 2: Lập báo cáo List <CHITIETCONGNO> DsChiTiet = new List <CHITIETCONGNO>(); // Lấy báo cáo gần nhất int MaCongNo = LayBaoCao().MaCongNo; List <CHITIETCONGNO> DsChiTietGanNhat = (from ct in db.CHITIETCONGNOes where ct.MaCongNo == MaCongNo select ct).ToList(); IEnumerable <KHACHHANG> DsKhachHang = from kh in db.KHACHHANGs select kh; foreach (KHACHHANG kh in DsKhachHang) { CHITIETCONGNO cur = new CHITIETCONGNO(); cur.MaKH = kh.MaKH; double NoDauKy = 0; CHITIETCONGNO chitiet = DsChiTietGanNhat.Find(ct => ct.MaKH == kh.MaKH); if (chitiet != null) { NoDauKy = chitiet.NoCuoi.Value; } cur.NoDau = NoDauKy; double NoCuoiKy = 0; List <HOADON> hd = (from h in db.HOADONs where h.NgayHoaDon.Value.Month == thang && h.NgayHoaDon.Value.Year == nam && h.MaKH == kh.MaKH select h).ToList(); List <THANHTOAN> tt = (from t in db.THANHTOANs where t.NgayThanhToan.Value.Month == thang && t.NgayThanhToan.Value.Year == nam && t.MaKhachHang == kh.MaKH select t).ToList(); double NoTrongKy = 0; if (hd != null) { NoTrongKy = hd.Sum(h => h.TongTien.Value); } double ThanhToanTrongKy = 0; if (tt != null) { ThanhToanTrongKy = tt.Sum(h => h.SoTien.Value); } cur.NoCuoi = NoDauKy + NoTrongKy - ThanhToanTrongKy; DsChiTiet.Add(cur); } CONGNO congco = new CONGNO { NgayBatDau = NgayBD, NgayKetThuc = NgayKT }; try { db.CONGNOes.Add(congco); db.SaveChanges(); } catch { } MaCongNo = LayBaoCao().MaCongNo; foreach (CHITIETCONGNO ct in DsChiTiet) { ct.MaCongNo = MaCongNo; db.CHITIETCONGNOes.Add(ct); } db.SaveChanges(); }