public void lapPhieuBaoTuDong()
{
DateTime HienTai = DateTime.Now;
var queryTK = from u in db.TaiKhoans
where Convert.ToBoolean(u.TrangThai) == true
select u;
foreach (var x in queryTK)
{
var query = from u in db.PhieuBaos
where x.TenTruyCap == u.TenTruyCap && Convert.ToInt32(u.ThangLap) == HienTai.Month &&
Convert.ToDateTime(u.NgayLap).Year == HienTai.Year
select u;
if (!query.Any())
{
PhieuBao item = new PhieuBao();
item.MaPhieu = sinhMaTuDong();
item.TenTruyCap = x.TenTruyCap;
item.NgayLap = HienTai;
item.ThangLap = HienTai.Month.ToString();
item.TinhTrang = Convert.ToBoolean(false);
item.NgayTT = (DateTime)SqlDateTime.MinValue;
item.NgayTT = null;
item.HinhThucTT = null;
item.TongTien = 0;
db.PhieuBaos.InsertOnSubmit(item);
db.SubmitChanges();
}
}
}
public string sinhMaTuDong()
{
var q = (from u in db.PhieuBaos
orderby u.MaPhieu descending
select u);
PhieuBao pb = q.FirstOrDefault();
string st;
st = (pb == null)? "":pb.MaPhieu.ToString();
if (st == null || st == "")
{
return("PB0001");
}
else
{
int i = int.Parse(st.Substring(2));
i += 1;
if (i < 10)
{
return("PB000" + i.ToString());
}
else if (i >= 10 && i < 100)
{
return("PB00" + i.ToString());
}
else if (i >= 100 && i < 1000)
{
return("PB0" + i.ToString());
}
else
{
return("PB" + i.ToString());
}
}
}
