private void loadGiaoNhan()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
var lstDD = db.db_SelectPhuongThucCanXN(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "NVXacNhan").ToList();
if (int.Parse(session.User.ma_dviqly + "") == 2)
{
List <Phuongthuc> dsT = new List <Phuongthuc>();
foreach (var list in lstDD)
{
var a = db.HD_GiamDocXNGiaoNhans.Where(x => x.IDChiNhanh == list.IDChiNhanh + "").Where(x => x.Thang == int.Parse(cmbThang.Value + "")).Where(x => x.Nam == int.Parse(cmbNam.Value + "")).Where(x => x.TrangThai == null).ToList();
var b = db.HD_ThongTinKies.Where(x => x.IDChinhNhanh == int.Parse(list.IDChiNhanh + "")).Where(x => x.Thang == int.Parse(cmbThang.Value + "")).Where(x => x.Nam == int.Parse(cmbNam.Value + "")).Where(x => x.ChucVu == 3).Where(x => x.TrangThai == null).ToList();
if (a.Count != 0 || b.Count != 0)
{
Phuongthuc ds = new Phuongthuc();
ds.IDChiNhanh = list.IDChiNhanh + "";
ds.TenPhuongThuc = list.TenPhuongThuc + "";
dsT.Add(ds);
}
}
cmbPhuongThuc.DataSource = dsT;
cmbPhuongThuc.ValueField = "IDChiNhanh";
cmbPhuongThuc.TextField = "TenPhuongThuc";
cmbPhuongThuc.DataBind();
}
else
{
cmbPhuongThuc.DataSource = lstDD;
cmbPhuongThuc.ValueField = "IDChiNhanh";
cmbPhuongThuc.TextField = "TenPhuongThuc";
cmbPhuongThuc.DataBind();
}
}
private void loadGiaoNhan()
{
//Where(x => x.IDChiNhanh == cmbPhuongThuc.Value + "");
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
List <Phuongthuc> dsT = new List <Phuongthuc>();
if (int.Parse(session.User.ma_dviqly + "") == 2)
{
var lstDD = db.db_SelectPhuongThucCanXN(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "TPXacNhan").ToList();
foreach (var list in lstDD)
{
var a = db.HD_GiamDocXNGiaoNhans.Where(x => x.IDChiNhanh == list.IDChiNhanh + "").Where(x => x.Thang == int.Parse(cmbThang.Value + "")).Where(x => x.Nam == int.Parse(cmbNam.Value + "")).ToList();
var b = db.HD_ThongTinKies.Where(x => x.IDChinhNhanh == int.Parse(list.IDChiNhanh + "")).Where(x => x.Thang == int.Parse(cmbThang.Value + "")).Where(x => x.Nam == int.Parse(cmbNam.Value + "")).Where(x => x.ChucVu == 3).ToList();
if (a.Count != 0 || b.Count != 0)
{
Phuongthuc ds = new Phuongthuc();
ds.IDChiNhanh = list.IDChiNhanh + "";
ds.TenPhuongThuc = list.TenPhuongThuc + "";
dsT.Add(ds);
}
}
cmbPhuongThuc.DataSource = dsT;
}
else
{
var lstDDALL = db.db_SelectPhuongThucCanXN(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "TPXNALL").ToList();
foreach (var list in lstDDALL)
{
if (list.IDChiNhanh != 0)
{
var checkphuongthuc = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(list.IDChiNhanh + ""));
if (checkphuongthuc.DiemCuoiNguon == 2 || checkphuongthuc.DiemDauNguon == 2)
{
Phuongthuc ds = new Phuongthuc();
ds.IDChiNhanh = list.IDChiNhanh + "";
ds.TenPhuongThuc = list.TenPhuongThuc + "";
dsT.Add(ds);
}
}
}
var lstDD = db.db_SelectPhuongThucCanXN(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "TPXacNhan").ToList();
foreach (var list in lstDD)
{
if (list.IDChiNhanh != 0)
{
Phuongthuc ds = new Phuongthuc();
ds.IDChiNhanh = list.IDChiNhanh + "";
ds.TenPhuongThuc = list.TenPhuongThuc + "";
dsT.Add(ds);
}
}
cmbPhuongThuc.DataSource = dsT;
}
cmbPhuongThuc.ValueField = "IDChiNhanh";
cmbPhuongThuc.TextField = "TenPhuongThuc";
cmbPhuongThuc.DataBind();
}
private void loadGiaoNhan()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int strMadviqly = int.Parse(session.User.ma_dviqly);
List <Phuongthuc> dsT = new List <Phuongthuc>();
if (strMadviqly == 2)
{
var lstDD = db.db_GD_PhuongThucCanXN(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "GDXN").ToList();
cmbPhuongThuc.DataSource = lstDD;
}
else
{
var lstDDNPC = db.db_GD_PhuongThucCanXN_NPCT(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "GDXN").ToList();
if (lstDDNPC.Count > 0)
{
foreach (var list in lstDDNPC)
{
int id = int.Parse(list.DiemCuoiNguon + "");
int id2 = int.Parse(list.DiemDauNguon + "");
if (id == 2 || id2 == 2)
{
Phuongthuc ds = new Phuongthuc();
ds.IDChiNhanh = list.IDChiNhanh + "";
ds.TenPhuongThuc = list.TenPhuongThuc + "";
dsT.Add(ds);
}
}
}
var lstDD = db.db_GD_PhuongThucCanXN(int.Parse(session.User.ma_dviqly + ""), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), "GDXN").ToList();
foreach (var list in lstDD)
{
int id = int.Parse(list.DiemCuoiNguon + "");
int id2 = int.Parse(list.DiemDauNguon + "");
if (id != 2 && id2 != 2)
{
Phuongthuc ds = new Phuongthuc();
ds.IDChiNhanh = list.IDChiNhanh + "";
ds.TenPhuongThuc = list.TenPhuongThuc + "";
dsT.Add(ds);
}
}
cmbPhuongThuc.DataSource = dsT;
}
cmbPhuongThuc.ValueField = "IDChiNhanh";
cmbPhuongThuc.TextField = "TenPhuongThuc";
cmbPhuongThuc.DataBind();
}
