protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var idNull = string.IsNullOrEmpty(id); using (var con = DAL.con()) { var thuChi = ThuChiDal.SelectById(con, Convert.ToInt64(id)); Item = PhoiDal.SelectById(con, thuChi.PHOI_ID); var Xe = XeDal.SelectById(con, Item.XE_ID); var LaiXe = LaiXeDal.SelectById(con, Item.LAIXE_ID); var LoaiBieuDo = LoaiBieuDoDal.SelectById(con, Xe.BIEUDO_ID); var Tuyen = TuyenDal.SelectById(con, Xe.TUYEN_ID); var TruyThuItem = TruyThuDal.SelectByPhoiId(con, Convert.ToInt64(Item.ID)); var XeVaoBen = XeVaoBenDal.SelectByPhoiId(con, Item.ID); Item.TruyThuItem = TruyThuItem; Item.XeVaoBen = XeVaoBen; Xe.LaiXe = LaiXe; Item.LaiXe = LaiXe; Xe.LoaiBieuDo = LoaiBieuDo; Xe.Tuyen = Tuyen; Item.Xe = Xe; PhoiNgoaiTinh.Item = Item; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; Item = string.IsNullOrEmpty(id) ? new LaiXe() : LaiXeDal.SelectById(Convert.ToInt32(id)); Add.Item = Item; }
protected void Page_Load(object sender, EventArgs e) { var Id = Request["ID"]; using (var con = DAL.con()) { Item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); var phoi = PhoiDal.SelectById(con, Item.PHOI_ID); var Xe = XeDal.SelectById(con, Item.XE_ID); var Tuyen = TuyenDal.SelectById(con, Xe.TUYEN_ID); var LaiXe = LaiXeDal.SelectById(con, phoi.LAIXE_ID); Xe.Tuyen = Tuyen; phoi.Xe = Xe; phoi.LaiXe = LaiXe; Item.Phoi = phoi; Add.Item = Item; } }
protected void Page_Load(object sender, EventArgs e) { var Id = Request["ID"]; using (var con = DAL.con()) { Item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); var phoi = PhoiDal.SelectById(con, Item.PHOI_ID); var Xe = XeDal.SelectById(con, Item.XE_ID); var Tuyen = TuyenDal.SelectById(con, Xe.TUYEN_ID); var LaiXe = LaiXeDal.SelectById(con, phoi.LAIXE_ID); var chamCong = ChamCongDal.SelectByTruyThuId(con, Item.ID).Where(x => x.Loai != 1 && x.Loai != 2) .OrderBy(x => x.Ngay).ToList(); Xe.Tuyen = Tuyen; phoi.Xe = Xe; phoi.LaiXe = LaiXe; Item.Phoi = phoi; Add.Item = Item; Add.List = chamCong; Add.Phoi = phoi; } }
protected void Page_Load(object sender, EventArgs e) { var loggedIn = Security.IsAuthenticated(); var Id = Request["Id"]; var Ten = Request["Ten"]; var BangLai = Request["BangLai"]; var LoaiBang = Request["LoaiBang"]; var DONVI_ID = Request["DONVI_ID"]; var XE_ID = Request["XE_ID"]; var NgaySinh = Request["NgaySinh"]; var NgayHetHanBangLai = Request["NgayHetHanBangLai"]; var NgayHetHanGiayKhamSucKhoe = Request["NgayHetHanGiayKhamSucKhoe"]; var q = Request["q"]; var Khoa = Request["Khoa"]; Khoa = !string.IsNullOrEmpty(Khoa) ? "true" : "false"; var Inserted = string.IsNullOrEmpty(Id); switch (subAct) { case "save": #region save if (loggedIn || !string.IsNullOrEmpty(Ten) || !string.IsNullOrEmpty(BangLai)) { var Item = Inserted ? new LaiXe() : LaiXeDal.SelectById(Convert.ToInt32(Id)); Item.Ten = Ten; Item.BangLai = BangLai; Item.LoaiBang = LoaiBang; Item.XE_ID = Convert.ToInt32(XE_ID); Item.DONVI_ID = Convert.ToInt32(DONVI_ID); Item.NgaySinh = Convert.ToDateTime(NgaySinh, new CultureInfo("vi-vn")); if (!string.IsNullOrEmpty(NgayHetHanBangLai)) { Item.NgayHetHanBangLai = Convert.ToDateTime(NgayHetHanBangLai, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayHetHanGiayKhamSucKhoe)) { Item.NgayHetHanGiayKhamSucKhoe = Convert.ToDateTime(NgayHetHanGiayKhamSucKhoe, new CultureInfo("vi-vn")); } Item.Khoa = Convert.ToBoolean(Khoa); if (Inserted) { Item.Username = Security.Username; Item.NgayTao = DateTime.Now; Item.RowId = Guid.NewGuid(); } Item.NgayCapNhat = DateTime.Now; Item = Inserted ? LaiXeDal.Insert(Item) : LaiXeDal.Update(Item); rendertext(Item.ID.ToString()); } rendertext("0"); break; #endregion case "remove": #region remove if (loggedIn) { var Item = LaiXeDal.SelectById(Convert.ToInt32(Id)); if (Item.Username == Security.Username) { LaiXeDal.DeleteById(Item.ID); rendertext("0"); } } rendertext("-1"); break; #endregion case "search": #region search var pgResult = LaiXeDal.pagerNormal(null, false, null, q, 20, null, null, null); rendertext(JavaScriptConvert.SerializeObject(pgResult.List), "text/javascript"); break; #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var act = Request["act"]; var idNull = string.IsNullOrEmpty(id); using (var con = DAL.con()) { if (idNull) { Item = PhoiDal.SelectLastest(Security.CqId.ToString()); Item.CQ_ID = Security.CqId; Item.Xe = new Xe() { Tuyen = new Tuyen(), LoaiBieuDo = new LoaiBieuDo() }; Item.LaiXe = new LaiXe(); Item.ChamCongList = new List <ChamCong>(); Item.ChamCongListCurrent = new List <ChamCong>(); Item.TruyThuItem = new TruyThu(); Item.XeVaoBen = new XeVaoBen(); } else { Item = PhoiDal.SelectById(con, Convert.ToInt32(id)); var Xe = XeDal.SelectById(con, Item.XE_ID); var LaiXe = LaiXeDal.SelectById(con, Item.LAIXE_ID); var LoaiBieuDo = LoaiBieuDoDal.SelectById(con, Xe.BIEUDO_ID); var Tuyen = TuyenDal.SelectById(con, Xe.TUYEN_ID); var TruyThuItem = TruyThuDal.SelectByPhoiId(con, Item.ID); var XeVaoBen = XeVaoBenDal.SelectByPhoiId(con, Item.ID); Item.XeVaoBen = XeVaoBen; Item.TruyThuItem = TruyThuItem; Xe.LaiXe = LaiXe; Item.LaiXe = LaiXe; Xe.LoaiBieuDo = LoaiBieuDo; Xe.Tuyen = Tuyen; Item.Xe = Xe; var month = DateTime.Now.Month; var year = DateTime.Now.Year; var prevMonth = month == 1 ? 12 : month - 1; var tuNgay = new DateTime(year, prevMonth, 1).AddDays(-1); var chamCongList = ChamCongDal.SelectByXeTuNgay(id, tuNgay.ToString("dd/MM/yyyy"), Xe.ID).Where(x => x.Ngay < Item.NgayTao).ToList(); var chamCongListCurrent = ChamCongDal.SelectByTruyThuId(TruyThuItem.ID); Item.ChamCongList = chamCongList; Item.ChamCongListCurrent = chamCongListCurrent; // Duyệt truy thu nên đẩy XeVaoBen sang thu ngân if (act == "approvedTruyThu") { //var xvb = XeVaoBenDal.SelectByPhoiId(con, Item.ID); //xvb.TrangThai = 400; //xvb.NgayCapNhat = DateTime.Now; //xvb = XeVaoBenDal.Update(xvb); } } } Add.Item = Item; }