public void Fill(int sttct) { var db = new CCDCDataContext(); var soCTMuaMois = (from ct in db.Chungtus where ct.STTCT == sttct select ct.SoCT).FirstOrDefault(); var lyDo = (from ct in db.Chungtus where ct.STTCT == sttct select ct.Lydo).FirstOrDefault(); //var Xuat = (from ct in db.Chungtus // where ct.STTCT == sttct // select ct.Den).FirstOrDefault(); var listMaCCDCMuaMois = (from ctietTH in db.ChitietCTs where ctietTH.SoCT == soCTMuaMois select new { SoCT = ctietTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, LyDo = lyDo, }).ToList(); DataSet ds = dsCCDC; listMaCCDCMuaMois.CopyToDataTable(ds.Tables["CCDC"]); }
public void Fill(DateTime dtime) { var db = new CCDCDataContext(); var soCTXuats = (from ct in db.Chungtus where ct.Maloaiphieu == "X00" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCXuats = (from ctTH in soCTXuats join ctietTH in db.ChitietCTs on ctTH.SoCT equals ctietTH.SoCT select new { SoCT = ctTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); DataSet ds = dsCCDC; listMaCCDCXuats.CopyToDataTable(ds.Tables["CCDC"]); }
public static void UpdateLastPasswordChangeDate(string username) { using (var usersContext = new CCDCDataContext()) { var updateLogin = usersContext.Users.SingleOrDefault(d => d.UserName == username); updateLogin.LastPasswordChangedDate = GetSystemDate(); usersContext.SubmitChanges(); } }
public static void UpdateNewPassword(string username, string newpassword) { using (var usersContext = new CCDCDataContext()) { var updateLogin = usersContext.Users.SingleOrDefault(d => d.UserName == username); updateLogin.Password = newpassword; usersContext.SubmitChanges(); } }
public void Fill(DateTime dtime) { var db = new CCDCDataContext(); var soCTMuaMois = (from ct in db.Chungtus where ct.Maloaiphieu == "N00" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCMuaMois = (from ctTH in soCTMuaMois join ctietTH in db.ChitietCTs on ctTH.SoCT equals ctietTH.SoCT select new { SoCT = ctTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumMuaMoi = from p in listMaCCDCMuaMois group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongXuat = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; DataSet ds = dsCCDC; SumMuaMoi.CopyToDataTable(ds.Tables["CCDC"]); }
private static CCDCDataContext GetDb() { var db = new CCDCDataContext(); return(db); }
public void Fill(DateTime dtime) { var db = new CCDCDataContext(); var soCTMuaMois = (from ct in db.Chungtus where ct.Maloaiphieu == "N00" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCMuaMois = (from ctTH in soCTMuaMois join ctietTH in db.ChitietCTs on ctTH.SoCT equals ctietTH.SoCT select new { SoCT = ctTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumMuaMoi = from p in listMaCCDCMuaMois group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongMoi = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; var soCTThuHois = (from ct in db.Chungtus where ct.Maloaiphieu == "N01" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCThuHois = (from ctTH in soCTThuHois join ctietTH in db.ChitietCTs on ctTH.SoCT equals ctietTH.SoCT select new { SoCT = ctTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumThuHoi = from p in listMaCCDCThuHois group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongThuHoi = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; var resultNhap = from p in SumMuaMoi join p2 in SumThuHoi on p.MaCCDC equals p2.MaCCDC into banGroup from ban in banGroup.DefaultIfEmpty() select new { MaCCDC = p.MaCCDC, SoLuongMoi = (int)(p.SoLuongMoi), SoLuongThuHoi = (ban != null) ? ban.SoLuongThuHoi : 0, SoCT = p.SoCT, DonViSuDung = p.DonViSuDung, TenCCDC = p.TenCCDC, NgaySuDung = p.NgaySuDung, DonViTinh = p.DonViTinh, TinhTrang = p.TinhTrang, }; var afterNhap = from p in resultNhap group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongNhap = g.Sum(k => k.SoLuongMoi + k.SoLuongThuHoi), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; //XUAT var soCTXuats = (from ct in db.Chungtus where ct.Maloaiphieu == "X00" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCXuats = (from ctX in soCTXuats join ctietTH in db.ChitietCTs on ctX.SoCT equals ctietTH.SoCT select new { SoCT = ctX.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumXuat = from p in listMaCCDCXuats group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongXuat = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; //THANH LY var soCTThanhLys = (from ct in db.Chungtus where ct.Maloaiphieu == "X01" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCThanhLys = (from ctX in soCTThanhLys join ctietTH in db.ChitietCTs on ctX.SoCT equals ctietTH.SoCT select new { SoCT = ctX.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumThanhLy = from p in listMaCCDCThanhLys group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongThanhLy = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; //Xuat+ Thanh ly= Xuat2 var resultXuat2 = from p in SumXuat join p2 in SumThanhLy on p.MaCCDC equals p2.MaCCDC into banGroup from ban in banGroup.DefaultIfEmpty() select new { MaCCDC = p.MaCCDC, SoLuongXuat = (int)(p.SoLuongXuat), SoLuongThanhLy = (ban != null) ? ban.SoLuongThanhLy : 0, SoCT = p.SoCT, DonViSuDung = p.DonViSuDung, TenCCDC = p.TenCCDC, NgaySuDung = p.NgaySuDung, DonViTinh = p.DonViTinh, TinhTrang = p.TinhTrang, }; var afterXuat2 = from p in resultXuat2 group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongXuat2 = g.Sum(k => k.SoLuongXuat + k.SoLuongThanhLy), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; // var resultTon = from p in afterNhap join p2 in afterXuat2 on p.MaCCDC equals p2.MaCCDC into banGroup from ban in banGroup.DefaultIfEmpty() select new { MaCCDC = p.MaCCDC, SoLuongNhap = (int)(p.SoLuongNhap), SoLuongXuat2 = (ban != null) ? ban.SoLuongXuat2 : 0, SoCT = p.SoCT, DonViSuDung = p.DonViSuDung, TenCCDC = p.TenCCDC, NgaySuDung = p.NgaySuDung, DonViTinh = p.DonViTinh, TinhTrang = p.TinhTrang, }; var afterTonKho = from p in resultTon group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuong = g.Sum(k => k.SoLuongNhap - k.SoLuongXuat2), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; var afterAgain = from p in afterTonKho where p.SoLuong > 0 select new { MaCCDC = p.MaCCDC, SoLuong = p.SoLuong, DonViSuDung = p.DonViSuDung, TenCCDC = p.TenCCDC, NgaySuDung = p.NgaySuDung, DonViTinh = p.DonViTinh, TinhTrang = p.TinhTrang, SoCT = p.SoCT, }; DataSet ds = dsCCDC; afterAgain.CopyToDataTable(ds.Tables["CCDC"]); }
public void Fill(DateTime dtime) { var db = new CCDCDataContext(); var soCTMuaMois = (from ct in db.Chungtus where ct.Maloaiphieu == "N00" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCMuaMois = (from ctTH in soCTMuaMois join ctietTH in db.ChitietCTs on ctTH.SoCT equals ctietTH.SoCT select new { SoCT = ctTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumMuaMoi = from p in listMaCCDCMuaMois group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongMoi = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; var soCTThuHois = (from ct in db.Chungtus where ct.Maloaiphieu == "N01" && ct.Madvql == IDDonVi group ct by ct.SoCT into g select new { SoCT = g.Key, }); var listMaCCDCThuHois = (from ctTH in soCTThuHois join ctietTH in db.ChitietCTs on ctTH.SoCT equals ctietTH.SoCT select new { SoCT = ctTH.SoCT, DonViSuDung = ctietTH.Madonvi, MaCCDC = ctietTH.MaCCDC, TenCCDC = ctietTH.TenCCDC, SoLuong = ctietTH.Soluong, NgaySuDung = ctietTH.NgaySD, DonViTinh = ctietTH.Madvt, TinhTrang = ctietTH.Matinhtrang, }).ToList(); var SumThuHoi = from p in listMaCCDCThuHois group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuongThuHoi = g.Sum(k => k.SoLuong), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; var result = from p in SumMuaMoi join p2 in SumThuHoi on p.MaCCDC equals p2.MaCCDC into banGroup from ban in banGroup.DefaultIfEmpty() select new { MaCCDC = p.MaCCDC, SoLuongMoi = (int)(p.SoLuongMoi), SoLuongThuHoi = (ban != null) ? ban.SoLuongThuHoi : 0, SoCT = p.SoCT, DonViSuDung = p.DonViSuDung, TenCCDC = p.TenCCDC, NgaySuDung = p.NgaySuDung, DonViTinh = p.DonViTinh, TinhTrang = p.TinhTrang, }; var after = from p in result group p by p.MaCCDC into g select new { MaCCDC = g.Key, SoLuong = g.Sum(k => k.SoLuongMoi + k.SoLuongThuHoi), SoCT = g.Select(k => k.SoCT).FirstOrDefault(), DonViSuDung = g.Select(k => k.DonViSuDung).FirstOrDefault(), TenCCDC = g.Select(k => k.TenCCDC).FirstOrDefault(), NgaySuDung = g.Select(k => k.NgaySuDung).FirstOrDefault(), DonViTinh = g.Select(k => k.DonViTinh).FirstOrDefault(), TinhTrang = g.Select(k => k.TinhTrang).FirstOrDefault(), }; DataSet ds = dsCCDC; after.CopyToDataTable(ds.Tables["CCDC"]); }