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(); }