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 LoaiBieuDo() : LoaiBieuDoDal.SelectById(Convert.ToInt32(id)); Add.Item = Item; }
protected void Page_Load(object sender, EventArgs e) { var XE_ID = Request["XE_ID"]; var PHOI_ID = Request["PHOI_ID"]; if (!string.IsNullOrEmpty(XE_ID)) { var month = DateTime.Now.Month; var year = DateTime.Now.Year; var prevMonth = month == 1 ? 12 : month - 1; var tuNgay = new DateTime(year, prevMonth, 1).AddMonths(-2); var Xe = XeDal.SelectById(Convert.ToInt64(XE_ID)); var loaiBieuDo = LoaiBieuDoDal.SelectById(Xe.BIEUDO_ID); var chamCongList = ChamCongDal.SelectByXeTuNgay(PHOI_ID, tuNgay.ToString("dd/MM/yyyy"), Xe.ID); var chamCongListCurrent = new List <ChamCong>(); var phoi = new Phoi() { XE_ID = Xe.ID }; phoi.Xe = Xe; ChamCongCalendar_View.Item = phoi; ChamCongCalendar_View.NgayXuatBen = DateTime.Now.ToString("dd/MM/yyyy"); ChamCongCalendar_View.ListChamCong = chamCongList; ChamCongCalendar_View.ListChamCongCurrent = chamCongListCurrent; ChamCongCalendar_View.LoaiBieuDo = loaiBieuDo; ChamCongCalendar_View.Visible = true; ChamCongCalendar_View.TuNgay = tuNgay; ChamCongCalendar_View.DenNgay = DateTime.Now; ChamCongCalendar_View.ShowFullMonth = true; } }
protected void Page_Load(object sender, EventArgs e) { var XE_ID = Request["XE_ID"]; var PHOI_ID = Request["PHOI_ID"]; if (!string.IsNullOrEmpty(XE_ID)) { 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 Xe = XeDal.SelectById(Convert.ToInt64(XE_ID)); var LoaiBieuDo = LoaiBieuDoDal.SelectById(Xe.BIEUDO_ID); var chamCongList = ChamCongDal.SelectByXeTuNgay(PHOI_ID, tuNgay.ToString("dd/MM/yyyy"), Xe.ID); var chamCongListCurrent = new List <ChamCong>(); ChamCongCalendar_View.ListChamCong = chamCongList; ChamCongCalendar_View.ListChamCongCurrent = chamCongListCurrent; ChamCongCalendar_View.LoaiBieuDo = LoaiBieuDo; ChamCongCalendar_View.Visible = true; BieuDo = LoaiBieuDo; } }
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 SoTuyenKhoan = Request["SoTuyenKhoan"]; var CachNgay = Request["CachNgay"]; var KhoanTuyen = Request["KhoanTuyen"]; var HaiTuyenTrenNgay = Request["HaiTuyenTrenNgay"]; KhoanTuyen = !string.IsNullOrEmpty(KhoanTuyen) ? "true" : "false"; HaiTuyenTrenNgay = !string.IsNullOrEmpty(HaiTuyenTrenNgay) ? "true" : "false"; var q = Request["q"]; var Ten = Request["Ten"]; var Inserted = string.IsNullOrEmpty(Id); switch (subAct) { case "save": #region save if (!loggedIn || !string.IsNullOrEmpty(Ten)) { var Item = Inserted ? new LoaiBieuDo() : LoaiBieuDoDal.SelectById(Convert.ToInt32(Id)); Item.Ten = Ten; Item.KhoanTuyen = Convert.ToBoolean(KhoanTuyen); Item.HaiTuyenTrenNgay = Convert.ToBoolean(HaiTuyenTrenNgay); Item.SoTuyenKhoan = Convert.ToInt16(SoTuyenKhoan); Item.CachNgay = Convert.ToInt16(CachNgay); if (Inserted) { Item.Username = Security.Username; Item.NgayTao = DateTime.Now; Item.RowId = Guid.NewGuid(); } Item.NgayCapNhat = DateTime.Now; Item = Inserted ? LoaiBieuDoDal.Insert(Item) : LoaiBieuDoDal.Update(Item); rendertext(Item.ID.ToString()); } rendertext("0"); break; #endregion case "remove": #region remove if (loggedIn) { var Item = LoaiBieuDoDal.SelectById(Convert.ToInt32(Id)); if (Item.Username == Security.Username) { LoaiBieuDoDal.DeleteById(Item.ID); rendertext("0"); } } rendertext("-1"); break; #endregion case "search": #region search var pgResult = LoaiBieuDoDal.SelectAll(); rendertext(JavaScriptConvert.SerializeObject(pgResult), "text/javascript"); break; #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { var loggedIn = Security.IsAuthenticated(); var Id = Request["Id"]; var XE_ID = Request["XE_ID"]; var PHOI_ID = Request["PHOI_ID"]; var NgayXuatBen = Request["NgayXuatBen"]; var Ngay = Request["Ngay"]; var TangCuong = Request["TangCuong"]; var PhoiId = Request["PhoiId"]; var CHAMCONG_ID = Request["CHAMCONG_ID"]; var CHAMCONG_GhiChu = Request["CHAMCONG_GhiChu"]; var CHAMCONG_Tien = Request["CHAMCONG_Tien"]; var CHAMCONG_TrangThaiNo = Request["CHAMCONG_TrangThaiNo"]; var ChamCongTruyChuCkb = Request["ChamCongTruyChuCkb"]; var GhiChu = Request["GhiChu"]; var Loai = Request["Loai"]; Loai = string.IsNullOrEmpty(Loai) ? "4" : "3"; if (string.IsNullOrEmpty(NgayXuatBen)) { NgayXuatBen = DateTime.Now.ToString("dd/MM/yyyy"); } var q = Request["q"]; switch (subAct) { case "BangChamCongTheoXe": #region BangChamCongTheoXe if (!string.IsNullOrEmpty(XE_ID)) { using (var con = DAL.con()) { var month = DateTime.Now.Month; var year = DateTime.Now.Year; var prevMonth = month == 1 ? 12 : month - 1; var tuNgay = new DateTime(year, prevMonth, 1); var Xe = XeDal.SelectById(con, Convert.ToInt64(XE_ID)); var loaiBieuDo = LoaiBieuDoDal.SelectById(con, Xe.BIEUDO_ID); var chamCongList = ChamCongDal.SelectByXeTuNgay(con, PHOI_ID, tuNgay.ToString("dd/MM/yyyy"), Xe.ID); var chamCongListCurrent = new List <ChamCong>(); var phoi = new Phoi() { XE_ID = Xe.ID }; phoi.Xe = Xe; ChamCongCalendar_View.Item = phoi; ChamCongCalendar_View.NgayXuatBen = NgayXuatBen; ChamCongCalendar_View.ListChamCong = chamCongList; ChamCongCalendar_View.ListChamCongCurrent = chamCongListCurrent; ChamCongCalendar_View.LoaiBieuDo = loaiBieuDo; ChamCongCalendar_View.Visible = true; ChamCongCalendar_View.TuNgay = tuNgay; ChamCongCalendar_View.DenNgay = DateTime.Now; } } break; #endregion case "LuuChamCongDraff": #region LuuChamCongDraff if (!string.IsNullOrEmpty(PhoiId) && loggedIn) { var item = new ChamCong(); item.PHOI_ID = Convert.ToInt64(PhoiId); item.Ngay = Convert.ToDateTime(Ngay, new CultureInfo("Vi-vn")); item.TangCuong = Convert.ToBoolean(TangCuong); item.Draff = true; item.NgayTao = DateTime.Now; item.Username = Security.Username; item.CQ_ID = Security.CqId; item.Loai = 3; item = ChamCongDal.Insert(item); AddPhoiListItem.Item = item; AddPhoiListItem.Visible = true; } break; #endregion case "UpdateChamCongDraff": #region UpdateChamCongDraff if (!string.IsNullOrEmpty(Id) && loggedIn) { var item = ChamCongDal.SelectById(Convert.ToInt64(Id)); item.GhiChu = GhiChu; if (!string.IsNullOrEmpty(ChamCongTruyChuCkb)) { item.Loai = 3; } else { item.Loai = 2; } item.NgayCapNhat = DateTime.Now; ChamCongDal.Update(item); } break; #endregion case "XoaChamCongDraff": #region XoaChamCongDraff if (!string.IsNullOrEmpty(Id) && loggedIn) { ChamCongDal.DeleteById(Convert.ToInt64(Id)); } break; #endregion case "BangCongNoTheoXe": #region BangCongNoTheoXe if (!string.IsNullOrEmpty(XE_ID)) { var chamCongList = ChamCongDal.NoByXeTuNgay(DAL.con(), null, Convert.ToInt64(XE_ID)); ThuNoList.XE_ID = XE_ID; ThuNoList.List = chamCongList; ThuNoList.Visible = chamCongList.Any(); } break; #endregion case "updateAjaxTruyThuDuyetKetQua": #region updateAjaxTruyThuDuyetKetQua if (loggedIn && !string.IsNullOrEmpty(CHAMCONG_ID)) { var item = ChamCongDal.SelectById(Convert.ToInt64(CHAMCONG_ID)); if (!string.IsNullOrEmpty(CHAMCONG_Tien)) { item.Tien = CHAMCONG_Tien.ToMoney(); } item.TrangThaiNo = Convert.ToInt16(string.IsNullOrEmpty(CHAMCONG_TrangThaiNo) ? 2 : 1); item.NgayCapNhat = DateTime.Now; item.GhiChu = CHAMCONG_GhiChu; item.Loai = Convert.ToInt16(Loai); item = ChamCongDal.Update(item); rendertext(item.ID.ToString()); } rendertext("0"); break; #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; } }