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"]);
}
