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 id = Request["ID"]; var xeId = Request["XE_ID"]; var idNull = string.IsNullOrEmpty(id); var chamCongs = new List <ChamCong>(); using (var con = DAL.con()) { if (!idNull) { var thuNo = ThuNoDal.SelectById(con, Convert.ToInt64(id)); chamCongs = ChamCongDal.NoByXeTuNgay(con, null, id, thuNo.XE_ID); Item = ThuNoDal.SelectById(Convert.ToInt64(id)); var xe = XeDal.SelectById(con, Convert.ToInt64(Item.XE_ID)); Item.XE_BienSo = xe.BienSoStr; Item.XE_ID = xe.ID; } else { Item = ThuNoDal.SelectByLastest(con, Security.CqId); if (!string.IsNullOrEmpty(xeId)) { chamCongs = ChamCongDal.NoByXeTuNgay(con, null, null, Convert.ToInt64(xeId)); var xe = XeDal.SelectById(con, Convert.ToInt64(xeId)); Item.XE_BienSo = xe.BienSoStr; Item.XE_ID = xe.ID; } } ThuNoItem.ChamCongs = chamCongs; ThuNoItem.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 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 loggedIn = Security.IsAuthenticated(); var chamCongIds = Request["ChamCongIds"]; var ngay = Request["Ngay"]; var tien = Request["Tien"]; var xeID = Request["XE_ID"]; var Inserted = string.IsNullOrEmpty(Id); switch (subAct) { case "save": #region save ///////////////////////////////////////// //////////////////////////////////////// if (!loggedIn || !string.IsNullOrEmpty(Id)) { var item = ThuNoDal.SelectById(Convert.ToInt64(Id)); item.NgayThu = DateTime.Now; item.NguoiThu = Security.Username; item.DaThu = true; ThuNoDal.Update(item); var chiTiets = ThuNoChiTietDal.SelectByThuNoId(item.ID); foreach (var chiTiet in chiTiets) { chiTiet.DaThu = true; chiTiet.NgayThu = item.NgayCapNhat = DateTime.Now; chiTiet.NguoiThu = Security.Username; ThuNoChiTietDal.Update(chiTiet); var chamCong = ChamCongDal.SelectById(chiTiet.CONG_ID); chamCong.NgayCapNhat = chamCong.NgayThanhToan = DateTime.Now; chamCong.TrangThaiNo = 2; chamCong.Loai = 3; ChamCongDal.Update(chamCong); } rendertext(item.ID.ToString()); } rendertext("0"); break; #endregion case "remove": #region remove if (loggedIn) { var item = ThuNoDal.SelectById(Convert.ToInt32(Id)); if (item.NguoiTao == Security.Username) { ThuNoChiTietDal.DeleteByThuNoId(item.ID); ThuNoDal.DeleteById(item.ID); rendertext("0"); } } rendertext("-1"); 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 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 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 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) { #region Variables var loggedIn = Security.IsAuthenticated(); var Id = Request["Id"]; var STTBX = Request["STTBX"]; var STTALL = Request["STTALL"]; var NgayXuatBen = Request["NgayXuatBen"]; var XE_BienSo = Request["XE_BienSo"]; var XE_ID = Request["XE_ID"]; var LAIXE_Ten = Request["LAIXE_Ten"]; var LAIXE_ID = Request["LAIXE_ID"]; var DONVI_Ten = Request["DONVI_Ten"]; var DI_Ten = Request["DI_Ten"]; var DEN_Ten = Request["DEN_Ten"]; var GioXuatBen = Request["GioXuatBen"]; var XeThayThe_BienSo = Request["XeThayThe_BienSo"]; var XeThayThe_ID = Request["XeThayThe_ID"]; var PHI_BenBai = Request["PHI_BenBai"]; var PHI_XeDauDem = Request["PHI_XeDauDem"]; var PHI_VeSinhBenBai = Request["PHI_VeSinhBenBai"]; var GiaVe = Request["GiaVe"]; var HoaHongBanVe = Request["HoaHongBanVe"]; var PhiTrenMotVe = Request["PhiTrenMotVe"]; var Ve = Request["Ve"]; var PHI_HoaHongBanVe = Request["PHI_HoaHongBanVe"]; var KhachTruyThu = Request["KhachTruyThu"]; var PHI_KhachTruyThu = Request["PHI_KhachTruyThu"]; var PHI_XeLuuBen = Request["PHI_XeLuuBen"]; var PHI_ChuyenTruyThu = Request["PHI_ChuyenTruyThu"]; var ChuyenTruyThu = Request["ChuyenTruyThu"]; var PHI_TruyThuGiam = Request["PHI_TruyThuGiam"]; var PHI_Khac = Request["PHI_Khac"]; var PHI_Tong = Request["PHI_Tong"]; var PHI_Nop = Request["PHI_Nop"]; var PHI_ConNo = Request["PHI_ConNo"]; var SoChuyenBieuDo = Request["SoChuyenBieuDo"]; var DeNghi = Request["DeNghi"]; var SoChuyenDeNghi = Request["SoChuyenDeNghi"]; var NOIDUNG_Ten = Request["NOIDUNG_Ten"]; var NOIDUNG_ID = Request["NOIDUNG_ID"]; var DANHGIA_Ten = Request["DANHGIA_Ten"]; var DANHGIA_ID = Request["DANHGIA_ID"]; var TRUYTHU_ID = Request["TRUYTHU_ID"]; var DeNghiCuaNhaXe = Request["DeNghiCuaNhaXe"]; var GiaTienDichVuTrongHopDong = Request["GiaTienDichVuTrongHopDong"]; var TongTruyThu = Request["TongTruyThu"]; var GiamTru = Request["GiamTru"]; var ConLai = Request["ConLai"]; var q = Request["q"]; var NgayChamCong = Request["NgayChamCong"]; var XVB_ID = Request["XVB_ID"]; var XeTangCuong = Request["XeTangCuong"]; var PHI_ChiThuBenBai = Request["PHI_ChiThuBenBai"]; var saveType = Request["saveType"]; var hopLe = Request["hopLe"]; var Draff = Request["Draff"]; var YKienQuanLy = Request["YKienQuanLy"]; XeTangCuong = !string.IsNullOrEmpty(XeTangCuong) ? "true" : "false"; PHI_ChiThuBenBai = !string.IsNullOrEmpty(PHI_ChiThuBenBai) ? "true" : "false"; var XeThayThe = Request["XeThayThe"]; XeThayThe = !string.IsNullOrEmpty(XeThayThe) ? "true" : "false"; #endregion var Inserted = Convert.ToBoolean(Draff); if (string.IsNullOrEmpty(saveType)) { saveType = ""; } switch (subAct) { case "save": #region save ///////////////////////////////////////// // Ý tưởng cơ bản là check số NgayChamCong != Null => Có truy thu. // Nếu số chuyến đề nghị =0 nghĩa là tự nguyện truy thu. Ngược lại là có phát sinh đề nghị truy thu. //////////////////////////////////////// if (!loggedIn || !string.IsNullOrEmpty(STTBX) || !string.IsNullOrEmpty(XE_BienSo)) { var Item = Inserted ? PhoiDal.SelectLastest(Security.CqId.ToString(), true) : PhoiDal.SelectById(Convert.ToInt64(Id)); if (Inserted && !string.IsNullOrEmpty(Id)) { Item.ID = Convert.ToInt64(Id); } if (!string.IsNullOrEmpty(NgayXuatBen)) { Item.NgayXuatBen = Convert.ToDateTime(NgayXuatBen, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(XE_ID)) { Item.XE_ID = Convert.ToInt64(XE_ID); var xe = XeDal.SelectById(Convert.ToInt64(XE_ID)); Item.DONVI_ID = xe.DONVI_ID; } if (!string.IsNullOrEmpty(LAIXE_ID)) { Item.LAIXE_ID = Convert.ToInt64(LAIXE_ID); } if (!string.IsNullOrEmpty(XeThayThe_ID)) { Item.XeThayThe_ID = Convert.ToInt64(XeThayThe_ID); } // PHI if (!string.IsNullOrEmpty(PHI_BenBai)) { Item.PHI_BenBai = Convert.ToDouble(PHI_BenBai); } if (!string.IsNullOrEmpty(PHI_XeDauDem)) { Item.PHI_XeDauDem = Convert.ToDouble(PHI_XeDauDem); } if (!string.IsNullOrEmpty(PHI_VeSinhBenBai)) { Item.PHI_VeSinhBenBai = Convert.ToDouble(PHI_VeSinhBenBai); } if (!string.IsNullOrEmpty(GiaVe)) { Item.GiaVe = Convert.ToDouble(GiaVe); } if (!string.IsNullOrEmpty(Ve)) { Item.Ve = Convert.ToInt16(Ve); } if (!string.IsNullOrEmpty(PHI_HoaHongBanVe)) { Item.PHI_HoaHongBanVe = Convert.ToDouble(PHI_HoaHongBanVe); } // Truy thu if (!string.IsNullOrEmpty(KhachTruyThu)) { Item.KhachTruyThu = Convert.ToInt16(KhachTruyThu); } if (!string.IsNullOrEmpty(PHI_KhachTruyThu)) { Item.PHI_KhachTruyThu = Convert.ToDouble(PHI_KhachTruyThu); } if (!string.IsNullOrEmpty(PHI_XeLuuBen)) { Item.PHI_XeLuuBen = Convert.ToDouble(PHI_XeLuuBen); } if (!string.IsNullOrEmpty(ChuyenTruyThu)) { Item.ChuyenTruyThu = Convert.ToInt16(ChuyenTruyThu); } if (!string.IsNullOrEmpty(PHI_ChuyenTruyThu)) { Item.PHI_ChuyenTruyThu = Convert.ToDouble(PHI_ChuyenTruyThu); } if (!string.IsNullOrEmpty(PHI_TruyThuGiam)) { Item.PHI_TruyThuGiam = Convert.ToDouble(PHI_TruyThuGiam); } if (!string.IsNullOrEmpty(PHI_Khac)) { Item.PHI_Khac = Convert.ToDouble(PHI_Khac); } Item.PHI_ChiThuBenBai = Convert.ToBoolean(PHI_ChiThuBenBai); Item.XeThayThe = Convert.ToBoolean(XeThayThe); Item.XeTangCuong = Convert.ToBoolean(XeTangCuong); Item.CQ_ID = Security.CqId; Item.PhiMotChuyenTruyThu = Item.PHI_ChiThuBenBai ? Item.PHI_BenBai : (Item.PHI_HoaHongBanVe + Item.PHI_BenBai); Item.NgayCapNhat = DateTime.Now; if (!string.IsNullOrEmpty(PHI_Tong)) { Item.PHI_Tong = Convert.ToDouble(PHI_Tong); } // !imporant giả định là cứ cấp phơi mặc định nộp đủ if (!string.IsNullOrEmpty(PHI_Tong)) { Item.PHI_Nop = Item.PHI_Tong; } //if (!string.IsNullOrEmpty(PHI_ConNo)) //{ // Item.PHI_ConNo = Convert.ToDouble(PHI_ConNo); //} // Trong trường hợp chỉ tiến hành Truy thu if (saveType.ToLower().Contains("truythu")) { Item.PHI_Tong = Item.PhiMotChuyenTruyThu * Item.ChuyenTruyThu; Item.PHI_Nop = Item.PHI_Tong; } Item.Draff = false; if (Inserted) { Item.Username = Security.Username; Item.NgayTao = DateTime.Now; Item.RowId = Guid.NewGuid(); //Update Ca làm việc var giaoCa = GiaoCaDal.Current(Security.CqId, Security.Username); Item.GIAOCA_ID = giaoCa.ID; giaoCa.TongSoPhoi += 1; giaoCa.DoanhThu += Item.PHI_Tong; giaoCa.NgayCapNhat = DateTime.Now; GiaoCaDal.Update(giaoCa); } Item = PhoiDal.Update(Item); var chamCong = new ChamCong(); if (Inserted) { if (!saveType.ToLower().Contains("truythu")) // Trong trường hợp không truy thu { // Thêm chấm công mới short loaiChamCong = 1; if (hopLe == "0") { loaiChamCong = 2; } chamCong.Loai = loaiChamCong; chamCong.Duyet = true; chamCong.Ngay = new DateTime(Item.NgayXuatBen.Year, Item.NgayXuatBen.Month, Item.NgayXuatBen.Day); chamCong.PHOI_ID = Item.ID; chamCong.XE_ID = Item.XE_ID; chamCong.CQ_ID = Security.CqId; chamCong.TrangThaiNo = 0; chamCong.NgayCapNhat = DateTime.Now; chamCong.Username = Security.Username; chamCong.NgayTao = DateTime.Now; chamCong.RowId = Guid.NewGuid(); chamCong.Draff = false; ChamCongDal.Insert(chamCong); } } var idTruyThuNull = string.IsNullOrEmpty(TRUYTHU_ID); var truyThu = idTruyThuNull ? TruyThuDal.SelectLastest(Security.CqId) : TruyThuDal.SelectById(Convert.ToInt64(TRUYTHU_ID)); if (!string.IsNullOrEmpty(DANHGIA_ID)) { truyThu.DANHGIA_ID = new Guid(DANHGIA_ID); } if (!string.IsNullOrEmpty(NOIDUNG_ID)) { truyThu.NOIDUNG_ID = new Guid(NOIDUNG_ID); } if (!string.IsNullOrEmpty(SoChuyenDeNghi)) { truyThu.SoChuyenDeNghi = Convert.ToInt16(SoChuyenDeNghi); } truyThu.SoChuyenThieu = Item.ChuyenTruyThu; truyThu.TongTruyThu = Item.PHI_ChuyenTruyThu; truyThu.Duyet = truyThu.SoChuyenDeNghi == 0; truyThu.CQ_ID = Security.CqId; truyThu.PHOI_ID = Item.ID; truyThu.DeNghiCuaNhaXe = DeNghiCuaNhaXe; truyThu.PHOI_ID = Item.ID; truyThu.XE_ID = Item.XE_ID; truyThu.DeNghi = truyThu.SoChuyenDeNghi != 0; truyThu.YKienQuanLy = YKienQuanLy; if (truyThu.DeNghi) { truyThu.TrangThai = 1; } else { truyThu.TrangThai = 0; } truyThu.NgayCapNhat = DateTime.Now; if (idTruyThuNull) { truyThu.Username = Security.Username; truyThu.NgayTao = DateTime.Now; truyThu.RowId = Guid.NewGuid(); truyThu.NguoiLap = Security.Username; truyThu = TruyThuDal.Insert(truyThu); } else { truyThu = TruyThuDal.Update(truyThu); ChamCongDal.DeleteByTruyThuId(Convert.ToInt64(TRUYTHU_ID)); } var chamCongByPhoiId = ChamCongDal.SelectByPhoiId(Item.ID); foreach (var item in chamCongByPhoiId) { item.Tien = Item.PhiMotChuyenTruyThu; item.XE_ID = Item.XE_ID; item.TRUYTHU_ID = truyThu.ID; item.NgayCapNhat = DateTime.Now; //item.Draff = false; ChamCongDal.Update(item); } // Xử lý phần XeVaoBen if (!string.IsNullOrEmpty(XVB_ID)) { var xvb = XeVaoBenDal.SelectById(Convert.ToInt64(XVB_ID)); xvb.NgayDuyetPhoi = xvb.NgayCapNhat = DateTime.Now; xvb.NguoiDuyetPhoi = Security.Username; xvb.PHOI_ID = Item.ID; xvb.Tien = Item.PHI_Tong; xvb.TrangThai = 400; if (truyThu.SoChuyenDeNghi > 0 && !truyThu.Duyet) // Có đề nghị truy thu và truy thu này chưa duyệt { xvb.TrangThai = 500; // Chờ duyệt truy thu } xvb.TRUYTHU_ID = truyThu.ID; XeVaoBenDal.Update(xvb); } else { var xvb = new XeVaoBen { TrangThai = 400 }; xvb.NgayDuyetPhoi = xvb.NgayCapNhat = DateTime.Now; xvb.NguoiDuyetPhoi = Security.Username; xvb.PHOI_ID = Item.ID; xvb.XE_ID = Item.XE_ID; xvb.Loai = 300; xvb.Username = Security.Username; xvb.CQ_ID = Security.CqId; xvb.TrangThai = 400; xvb.Tien = Item.PHI_Tong; if (truyThu.SoChuyenDeNghi > 0 && !truyThu.Duyet) // Có đề nghị truy thu và truy thu này chưa duyệt { xvb.TrangThai = 500; // Chờ duyệt truy thu } xvb.TRUYTHU_ID = truyThu.ID; XeVaoBenDal.Insert(xvb); } rendertext(Item.ID.ToString()); } rendertext("0"); break; #endregion case "getLatest": #region getLatest if (loggedIn) { var Item = PhoiDal.SelectLastest(Security.CqId.ToString()); rendertext(string.Format("({0})", JavaScriptConvert.SerializeObject(Item))); } rendertext("-1"); break; #endregion case "remove": #region remove if (loggedIn) { var Item = PhoiDal.SelectById(Convert.ToInt32(Id)); if (Item.Username == Security.Username) { PhoiDal.DeleteById(Item.ID); rendertext("0"); } } rendertext("-1"); break; #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { var loggedIn = Security.IsAuthenticated(); var Id = Request["Id"]; var soChuyenDuocDuyet = Request["SoChuyenDuocDuyet"]; var yKienChiDao = Request["YKienChiDao"]; var KienNghi = Request["KienNghi"]; var PHI_ConNo = Request["PHI_ConNo"]; var PHI_Nop = Request["PHI_Nop"]; switch (subAct) { case "duyet": if (loggedIn && !string.IsNullOrEmpty(Id)) { using (var con = DAL.con()) { var item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); item.Duyet = true; item.NgayDuyet = DateTime.Now; item.LanhDaoDuyet = Security.Username; item.SoChuyenDuocDuyet = Convert.ToInt16(soChuyenDuocDuyet); item.YKienChiDao = yKienChiDao; item.NgayCapNhat = item.NgayDuyet; item.TrangThai = 2; item = TruyThuDal.Update(item); var phoi = PhoiDal.SelectById(con, item.PHOI_ID); phoi.PHI_TruyThuGiam = phoi.PhiMotChuyenTruyThu * (phoi.ChuyenTruyThu - Convert.ToInt16(soChuyenDuocDuyet)); //phoi.PHI_Tong = phoi.PHI_Tong - phoi.PHI_TruyThuGiam; phoi.NgayCapNhat = item.NgayDuyet; PhoiDal.Update(phoi); var xvb = XeVaoBenDal.SelectByPhoiId(con, phoi.ID); xvb.TrangThai = 510; xvb.NgayCapNhat = DateTime.Now; xvb.NguoiDuyetTruyThu = Security.Username; xvb.NgayLanhDaoDuyetTruyThu = item.NgayDuyet; xvb = XeVaoBenDal.Update(xvb); rendertext(Id); } } break; case "nhaXeChapNhan": if (loggedIn && !string.IsNullOrEmpty(Id)) { using (var con = DAL.con()) { var item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); item.TrangThai = 4; item.NgayCapNhat = DateTime.Now; item = TruyThuDal.Update(item); // Duyệt toàn bộ chấm công ChamCongDal.UpdateDuyetByTruyThuId(con, item.ID); var phoi = PhoiDal.SelectById(con, item.PHOI_ID); if (!string.IsNullOrEmpty(PHI_ConNo)) { phoi.PHI_ConNo = Convert.ToDouble(PHI_ConNo); } if (!string.IsNullOrEmpty(PHI_Nop)) { phoi.PHI_Nop = Convert.ToDouble(PHI_Nop); } phoi.NgayCapNhat = DateTime.Now; PhoiDal.Update(phoi); var xvb = XeVaoBenDal.SelectByPhoiId(con, item.PHOI_ID); xvb.TrangThai = 400; xvb.NgayCapNhat = DateTime.Now; xvb.NguoiDuyetTruyThu = Security.Username; xvb.NgayLanhDaoDuyetTruyThu = item.NgayDuyet; xvb = XeVaoBenDal.Update(xvb); rendertext(Id); } } break; case "khongDuyet": if (loggedIn && !string.IsNullOrEmpty(Id)) { using (var con = DAL.con()) { var item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); item.Duyet = true; item.NgayDuyet = DateTime.Now; item.LanhDaoDuyet = Security.Username; item.SoChuyenDuocDuyet = Convert.ToInt16(soChuyenDuocDuyet); item.YKienChiDao = yKienChiDao; item.NgayCapNhat = DateTime.Now; item.TrangThai = 2; item = TruyThuDal.Update(item); var phoi = PhoiDal.SelectById(con, item.PHOI_ID); phoi.NgayCapNhat = item.NgayDuyet; PhoiDal.Update(phoi); var xvb = XeVaoBenDal.SelectByPhoiId(con, phoi.ID); xvb.TrangThai = 510; xvb.NgayCapNhat = DateTime.Now; xvb.NguoiDuyetTruyThu = Security.Username; xvb.NgayLanhDaoDuyetTruyThu = item.NgayDuyet; xvb = XeVaoBenDal.Update(xvb); rendertext(Id); } } break; case "nhaXeKienNghi": if (loggedIn && !string.IsNullOrEmpty(Id)) { using (var con = DAL.con()) { var item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); item.NgayCapNhat = DateTime.Now; item.TrangThai = 3; item.Duyet = false; item.KienNghi = KienNghi; item = TruyThuDal.Update(item); var phoi = PhoiDal.SelectById(item.PHOI_ID); phoi.PHI_TruyThuGiam = 0; phoi.NgayCapNhat = DateTime.Now; PhoiDal.Update(phoi); var xvb = XeVaoBenDal.SelectByPhoiId(con, item.PHOI_ID); xvb.TrangThai = 500; xvb.NgayCapNhat = DateTime.Now; xvb = XeVaoBenDal.Update(xvb); rendertext(Id); } } break; case "huyTruyThu": if (loggedIn && !string.IsNullOrEmpty(Id)) { using (var con = DAL.con()) { var item = TruyThuDal.SelectById(con, Convert.ToInt64(Id)); item.NgayCapNhat = DateTime.Now; item.TrangThai = 5; item.Duyet = false; item = TruyThuDal.Update(item); // Xóa bỏ hết chấm công ChamCongDal.DeleteByTruyThuId(item.ID); PhoiDal.DeleteById(item.PHOI_ID); var xvb = XeVaoBenDal.SelectByPhoiId(con, item.PHOI_ID); xvb.TrangThai = 200; xvb.NgayCapNhat = DateTime.Now; xvb = XeVaoBenDal.Update(xvb); rendertext(Id); } } break; case "remove": #region remove if (loggedIn) { var Item = TruyThuDal.SelectById(Convert.ToInt32(Id)); if (Item.Username == Security.Username) { TruyThuDal.DeleteById(Item.ID); rendertext("0"); } } rendertext("-1"); break; #endregion default: break; } }