protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
Item = string.IsNullOrEmpty(id) ? new Tuyen() : TuyenDal.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 di = Request["DI_ID"];
var den = Request["DEN_ID"];
using (var con = DAL.con())
{
var list = new List <Xe>();
var tuyen = TuyenDal.SelectByDenIdDiId(con, den, di);
list = XeDal.ListByTuyen(con, Security.CqId, tuyen.ID, 50);
TS_Tuyen.Item = tuyen;
TS_Tuyen.List = list;
}
}
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 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 NoiTinh = Request["NoiTinh"];
var DI_ID = Request["DI_ID"];
var DEN_ID = Request["DEN_ID"];
var VeSinhLuuBen = Request["VeSinhLuuBen"];
var HoaHongBanVe = Request["HoaHongBanVe"];
NoiTinh = !string.IsNullOrEmpty(NoiTinh)
? "true"
: "false";
var Ten = Request["Ten"];
var Inserted = string.IsNullOrEmpty(Id);
switch (subAct)
{
case "save":
#region save
if (!loggedIn || !string.IsNullOrEmpty(Ten))
{
var Item = Inserted ? new Tuyen() : TuyenDal.SelectById(Convert.ToInt32(Id));
Item.Ten = Ten;
Item.NoiTinh = Convert.ToBoolean(NoiTinh);
Item.VeSinhLuuBen = Convert.ToDouble(VeSinhLuuBen);
Item.HoaHongBanVe = Convert.ToDouble(HoaHongBanVe);
Item.DI_ID = new Guid(DI_ID);
Item.DEN_ID = new Guid(DEN_ID);
if (Inserted)
{
Item.Username = Security.Username;
Item.NgayTao = DateTime.Now;
Item.RowId = Guid.NewGuid();
}
Item.NgayCapNhat = DateTime.Now;
Item = Inserted ? TuyenDal.Insert(Item) : TuyenDal.Update(Item);
rendertext(Item.ID.ToString());
}
rendertext("0");
break;
#endregion
case "remove":
#region remove
if (loggedIn)
{
var Item = TuyenDal.SelectById(Convert.ToInt32(Id));
if (Item.Username == Security.Username)
{
TuyenDal.DeleteById(Item.ID);
rendertext("0");
}
}
rendertext("-1");
break;
#endregion
case "search":
#region search
var pgResult = TuyenDal.SelectAll();
rendertext(JavaScriptConvert.SerializeObject(pgResult), "text/javascript");
break;
#endregion
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var pg = TuyenDal.pagerNormal("", false, null, "", 10);
List.Pager = pg;
}
protected void Page_Load(object sender, EventArgs e)
{
var cqId = Security.CqId;
TuyenId = Request["ID"];
TuNgay = Request["Thang"];
if (string.IsNullOrEmpty(TuyenId))
{
TuyenId = "2";
}
if (string.IsNullOrEmpty(TuNgay))
{
TuNgay = string.Format("{0:MM}/{0:yyyy}", DateTime.Now);
}
var thangStr = TuNgay.Split(new char[] { '/' });
var thangInt = Convert.ToInt32(thangStr[0]);
var namInt = Convert.ToInt32(thangStr[1]);
var tuNgay = new DateTime(namInt, thangInt, 1).AddDays(-1);
var denNgay = tuNgay.AddMonths(1);
var newListXe = new List <Xe>();
var item = new LichItem();
var listNgay = new List <LichItem>();
var listChamCong = new List <ChamCong>();
var startRener = DateTime.Now;
var endRender = DateTime.Now; // Kết thúc render
using (var con = DAL.con())
{
Item = TuyenDal.SelectById(con, Convert.ToInt32(TuyenId));
var listXe = XeDal.SelectByTuyenId(con, Item.ID);
foreach (var xe in listXe)
{
listChamCong = ChamCongDal.SelectByXeTuNgayCqId(con, cqId, tuNgay.ToString("dd/MM/yyyy"), denNgay.ToString("dd/MM/yyyy"), xe.ID);
listNgay = new List <LichItem>();
for (var d = tuNgay.AddDays(1); d <= denNgay; d = d.AddDays(1))
{
item = new LichItem()
{
Day = d
};
var ngayChamCong = listChamCong.Where(x => x.Ngay == d);
if (ngayChamCong.Any())
{
var chamCongBinhThuong = ngayChamCong.FirstOrDefault();
if (chamCongBinhThuong != null)
{
// Xác định chấm công này đã được lãnh đạo duyệt hay chưa
var kieuChamCong = chamCongBinhThuong.Loai != 3 ? chamCongBinhThuong.Loai : (chamCongBinhThuong.Duyet ? 3 : 5);
if (chamCongBinhThuong.TrangThaiNo == 1)
{
kieuChamCong = 6;
}
item.Item = chamCongBinhThuong;
item.KieuChamCong = kieuChamCong;
item.SoChuyen = ngayChamCong.Count();
item.GhiChu = chamCongBinhThuong.GhiChu;
item.TangCuong = chamCongBinhThuong.TangCuong;
item.Clickable = false;
}
}
listNgay.Add(item);
}
xe.ListChamCong = listChamCong;
xe.ListLichItem = listNgay;
newListXe.Add(xe);
}
}
endRender = DateTime.Now; // Kết thúc render
BangChamCongTheoCoQuan_List.Ngay = listNgay;
BangChamCongTheoCoQuan_List.List = newListXe;
BangChamCongTheoCoQuan_List.Item = Item;
BangChamCongTheoCoQuan_List.TuNgay = TuNgay;
}
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;
}
}
