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"]; 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 q = Request["q"]; var DONVI_ID = Request["DONVI_ID"]; var Size = Request["Size"]; var LoaiBang = Request["LoaiBang"]; Size = string.IsNullOrEmpty(Size) ? "20" : Size; var url = string.Format( "?q={0}&DONVI_ID={1}&LoaiBang={2}&Size={3}&" , q, DONVI_ID, LoaiBang, Size) + "{1}={0}"; var pg = LaiXeDal.pagerNormal(url, false, null, q, Convert.ToInt32(Size), DONVI_ID, LoaiBang, null); List.Pager = pg; }
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; }
protected void Page_Load(object sender, EventArgs e) { var loggedIn = Security.IsAuthenticated(); var Id = Request["Id"]; var PHOI_ID = Request["PHOI_ID"]; var STTBX = Request["STTBX"]; var STTALL = Request["STTALL"]; var XE_ID = Request["XE_ID"]; var Ngay = Request["Ngay"]; var Tien = Request["Tien"]; var XVB_ID = Request["XVB_ID"]; var Inserted = string.IsNullOrEmpty(Id); switch (subAct) { case "save": #region save if (loggedIn) { var Item = Inserted ? ThuChiDal.SelectByLastest(DAL.con(), Security.CqId) : ThuChiDal.SelectById(Convert.ToInt32(Id)); if (!string.IsNullOrEmpty(Tien)) { Item.Tien = Convert.ToDouble(Tien); } Item.CQ_ID = Security.CqId; if (!string.IsNullOrEmpty(PHOI_ID)) { Item.PHOI_ID = Convert.ToInt64(PHOI_ID); var phoi = PhoiDal.SelectById(Item.PHOI_ID); Item.XE_ID = Convert.ToInt32(phoi.XE_ID); } if (!string.IsNullOrEmpty(Ngay)) { Item.Ngay = Convert.ToDateTime(Ngay, new CultureInfo("vi-vn")); } if (Inserted) { Item.NguoiTao = Security.Username; Item.NgayTao = DateTime.Now; Item.RowId = Guid.NewGuid(); } if (Inserted) { var giaoCa = GiaoCaDal.Current(Security.CqId, Security.Username); Item.GIAOCA_ID = giaoCa.ID; giaoCa.DoanhThu += Item.Tien; giaoCa.NgayCapNhat = DateTime.Now; GiaoCaDal.Update(giaoCa); } Item.NgayCapNhat = DateTime.Now; Item.XVB_ID = Convert.ToInt64(XVB_ID); Item = Inserted ? ThuChiDal.Insert(Item) : ThuChiDal.Update(Item); if (Inserted) { if (!string.IsNullOrEmpty(XVB_ID)) { var xvb = XeVaoBenDal.SelectById(Convert.ToInt64(XVB_ID)); xvb.TC_ID = Item.ID; xvb.TrangThai = 800; xvb.NguoiXuLyThanhToan = Security.Username; xvb.NgayThanhToanXong = xvb.NgayCapNhat = DateTime.Now; XeVaoBenDal.Update(xvb); } var chamCongByPhoiId = ChamCongDal.SelectByPhoiId(Item.PHOI_ID); foreach (var item in chamCongByPhoiId) { item.NgayCapNhat = DateTime.Now; item.Draff = false; ChamCongDal.Update(item); } } rendertext(Item.ID.ToString()); } rendertext("0"); break; #endregion case "remove": #region remove if (loggedIn) { var Item = XeVaoBenDal.SelectById(Convert.ToInt64(Id)); if (Item.Username == Security.Username) { LaiXeDal.DeleteById(Item.ID); rendertext("0"); } } rendertext("-1"); break; #endregion case "getLatest": #region getLatest if (loggedIn) { var item = ThuChiDal.SelectByLastest(DAL.con(), Security.CqId); rendertext(string.Format("({0})", JavaScriptConvert.SerializeObject(item))); } rendertext("-1"); break; #endregion case "search": #region search #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { var loggedIn = Security.IsAuthenticated(); var Id = Request["Id"]; var BienSo_Chu = Request["BienSo_Chu"]; var BienSo_So = Request["BienSo_So"]; var LOAIXE_ID = Request["LOAIXE_ID"]; var TUYEN_ID = Request["TUYEN_ID"]; var DONVI_ID = Request["DONVI_ID"]; var LOAIXE_Ten = Request["LOAIXE_Ten"]; var TUYEN_Ten = Request["TUYEN_Ten"]; var DONVI_Ten = Request["DONVI_Ten"]; var NamSanXuat = Request["NamSanXuat"]; var NgayXuatBen = Request["NgayXuatBen"]; var TuyenCoDinh = Request["TuyenCoDinh"]; var LuuHanh = Request["LuuHanh"]; var Ghe = Request["Ghe"]; var SoKhach = Request["SoKhach"]; var MucPhi = Request["MucPhi"]; var GiaVe = Request["GiaVe"]; var GioXuatBen = Request["GioXuatBen"]; var XeVangLai = Request["XeVangLai"]; var XeTai = Request["XeTai"]; var BaoHiem = Request["BaoHiem"]; var BIEUDO_ID = Request["BIEUDO_ID"]; var ChuaDangKy = Request["ChuaDangKy"]; var Khoa = Request["Khoa"]; var XVB_ID = Request["XVB_ID"]; var NgayKyGuiBanVe = Request["NgayKyGuiBanVe"]; var KyGuiBanVe = Request["KyGuiBanVe"]; var ChapThuanTuyen_SoChuyen = Request["ChapThuanTuyen_SoChuyen"]; var q = Request["q"]; //For search var VangLai = Request["XeVangLai"]; KyGuiBanVe = !string.IsNullOrEmpty(KyGuiBanVe) ? "true" : "false"; XeVangLai = !string.IsNullOrEmpty(XeVangLai) ? "true" : "false"; XeTai = !string.IsNullOrEmpty(XeTai) ? "true" : "false"; Khoa = !string.IsNullOrEmpty(Khoa) ? "true" : "false"; ChuaDangKy = !string.IsNullOrEmpty(ChuaDangKy) ? "true" : "false"; var Inserted = string.IsNullOrEmpty(Id); switch (subAct) { case "save": #region save if (!loggedIn || !string.IsNullOrEmpty(BienSo_Chu) || !string.IsNullOrEmpty(BienSo_So)) { var Item = Inserted ? new Xe() : XeDal.SelectById(Convert.ToInt32(Id)); Item.BienSo_Chu = BienSo_Chu; Item.BienSo_So = BienSo_So; Item.LOAIXE_ID = Convert.ToInt32(LOAIXE_ID); Item.TUYEN_ID = Convert.ToInt32(TUYEN_ID); Item.DONVI_ID = Convert.ToInt32(DONVI_ID); if (!string.IsNullOrEmpty(TuyenCoDinh)) { Item.TuyenCoDinh = Convert.ToDateTime(TuyenCoDinh, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(LuuHanh)) { Item.LuuHanh = Convert.ToDateTime(LuuHanh, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(BaoHiem)) { Item.BaoHiem = Convert.ToDateTime(BaoHiem, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayKyGuiBanVe)) { Item.NgayKyGuiBanVe = Convert.ToDateTime(NgayKyGuiBanVe, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(ChapThuanTuyen_SoChuyen)) { Item.ChapThuanTuyen_SoChuyen = Convert.ToInt16(ChapThuanTuyen_SoChuyen); } Item.Ghe = Convert.ToInt16(Ghe); Item.SoKhach = Convert.ToInt16(SoKhach); Item.MucPhi = Convert.ToDouble(MucPhi); Item.GiaVe = Convert.ToDouble(GiaVe); Item.NamSanXuat = Convert.ToInt16(NamSanXuat); Item.GioXuatBen = GioXuatBen; Item.BIEUDO_ID = Convert.ToInt32(BIEUDO_ID); Item.XeTai = Convert.ToBoolean(XeTai); Item.XeVangLai = Convert.ToBoolean(XeVangLai); Item.Khoa = Convert.ToBoolean(Khoa); Item.KyGuiBanVe = Convert.ToBoolean(KyGuiBanVe); if (Item.ID != 0 && Item.ChuaDangKy && Convert.ToBoolean(ChuaDangKy)) // Đăng ký mới lần đầu { XeVaoBenDal.UpdateXeChuaDangKy(Item.ID); } Item.ChuaDangKy = !Convert.ToBoolean(ChuaDangKy); if (Inserted) { Item.Username = Security.Username; Item.NgayTao = DateTime.Now; Item.RowId = Guid.NewGuid(); //SearchManager.Add(string.Format("{0} {1}", Item.BienSo_Chu, Item.BienSo_So) // , string.Format("{0} {1} {2} {3} {4}", Item.BienSo_Chu, Item.BienSo_So, DONVI_Ten, TUYEN_Ten, LOAIXE_Ten) // , string.Format("{0} {1}", Item.BienSo_Chu, Item.BienSo_So) // , Item.RowId.ToString() // , Item.Url // , typeof(Xe).Name); } Item.NgayCapNhat = DateTime.Now; Item = Inserted ? XeDal.Insert(Item) : XeDal.Update(Item); rendertext(Item.ID.ToString()); } rendertext("0"); break; #endregion case "remove": #region remove if (loggedIn) { var Item = XeDal.SelectById(Convert.ToInt32(Id)); if (Item.Username == Security.Username) { XeDal.DeleteById(Item.ID); rendertext("0"); } } rendertext("-1"); break; #endregion case "GetById": #region GetById if (!string.IsNullOrEmpty(Id)) { var Item = XeDal.SelectById(Convert.ToInt32(Id)); Item.Tuyen = TuyenDal.SelectById(Item.TUYEN_ID); Item.LoaiBieuDo = LoaiBieuDoDal.SelectById(Item.BIEUDO_ID); Item.LaiXe = LaiXeDal.SelectByXeId(Item.ID); var ngay = DateTime.Now; if (!string.IsNullOrEmpty(NgayXuatBen)) { ngay = Convert.ToDateTime(ngay, new CultureInfo("Vi-vn")); } var ngaySoSanh = ngay.AddDays(BxVinhConfig.SoNgayHetHan); Item.HopLeAll = (ngaySoSanh < Item.BaoHiem) && (ngaySoSanh < Item.LuuHanh) && (ngaySoSanh < Item.BaoHiem); if (!string.IsNullOrEmpty(XVB_ID)) { var xvb = XeVaoBenDal.SelectById(Convert.ToInt64(XVB_ID)); xvb.TrangThai = 300; xvb.NguoiXuLyYeuCau = Security.Username; xvb.NgayXuLyYeuCau = xvb.NgayCapNhat = DateTime.Now; xvb = XeVaoBenDal.Update(xvb); } rendertext(string.Format("({0})", JavaScriptConvert.SerializeObject(Item))); } rendertext("-1"); break; #endregion case "search": #region search var pgResult = XeTinyDal.SearchSQL(q, VangLai); rendertext(JavaScriptConvert.SerializeObject(pgResult), "text/javascript"); break; #endregion default: break; } }