public ActionResult ApproveContract(ContractViewModel model) { //创建数据 List<ContractDeliverPlan> listPlan = new List<ContractDeliverPlan>(); if (model.DeliverPlans != null) { foreach (ContractDeliverPlanViewModel m in model.DeliverPlans) { ContractDeliverPlan p = new ContractDeliverPlan(); p.Id = m.Id; p.ContractId = m.ContractId; p.PlanId = m.PlanId; p.Packages = m.Packages; p.Tunnages = m.Tunnages; p.Piles = m.Piles; p.TenThousands = m.TenThousands; p.TransportChargeExpression = m.TransportChargeExpression; p.TransportPriceExpression = m.TransportPriceExpression; p.KM = m.KM; p.TransportPrice = m.TransportPrice; p.TransportCharges = m.TransportCharges; p.ApprovedTransportPrice = m.ApprovedTransportPrice; p.ApprovedTransportCharges = m.ApprovedTransportCharges; listPlan.Add(p); } } //保存数据 string strMessage; ContractSystem contract = new ContractSystem(); bool bSuccess = contract.ApproveContract(model.Id, listPlan, LoginAccountId, LoginStaffName, out strMessage); var ret = new { Success = bSuccess, Message = strMessage }; return Json(ret); }
public ActionResult FineContracts(List<ContractFineViewModel> models) { if (ModelState.IsValid) { //创建数据 List<Contract> listContract = new List<Contract>(); if (models != null) { foreach (ContractFineViewModel model in models) { Contract c = new Contract(); c.Id = model.ContractId; c.FineAmount = model.FineAmount; listContract.Add(c); } } //保存数据 string strErrText; ContractSystem contract = new ContractSystem(); if (contract.FineContracts(listContract, LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } } return View(models); }
public ActionResult SubmitPrintContract(string id) { string strMessage; ContractSystem contract = new ContractSystem(); bool bSuccess = contract.SubmitPrintContract(long.Parse(id), LoginAccountId, LoginStaffName, out strMessage); var ret = new { Success = bSuccess, Message = strMessage }; return Json(ret); }
public ActionResult SubmitContract(ContractViewModel model) { string strErrText; ContractSystem contract = new ContractSystem(); if (contract.SubmitContract(model.Id, LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } }
public ActionResult SubmitContract(string id) { string strErrText; //读取合同数据 ContractSystem contract = new ContractSystem(); Contract data = contract.LoadContract(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } //创建Model ContractViewModel model = new ContractViewModel(); model.Id = data.Id; model.DispatchBillId = data.DispatchBillId; model.ContractNo = data.ContractNo; model.CarNo = data.CarNo; model.TrailerNo = data.TrailerNo; model.DriverName = data.DriverName; model.DriverLicenseNo = data.DriverLicenseNo; model.DriverMobileTel = data.DriverMobileTel; model.DriverHomeTel = data.DriverHomeTel; model.CarrierId = data.CarrierId; model.CarrierName = data.CarrierName; model.GoodsName = data.GoodsName; model.Packing = data.Packing; model.StartPlace = data.StartPlace; model.DestPlace = data.DestPlace; model.ShipmentTime = data.ShipmentTime.ToString("yyyy-MM-dd"); model.ArrivalTime = data.ArrivalTime.ToString("yyyy-MM-dd"); model.TotalPackages = data.TotalPackages; model.TotalTunnages = data.TotalTunnages; model.TotalPiles = data.TotalPiles; model.TotalTenThousands = data.TotalTenThousands; model.TotalTransportCharges = data.TotalTransportCharges; model.PrepayTransportCharges = data.PrepayTransportCharges; model.ResidualTransportCharges = data.ResidualTransportCharges; model.OriginalContractNo = data.OriginalContractNo; return View(model); }
public JsonResult LoadSaveFinesGrid(string sidx, string sord, int page, int rows, string saveFines) { //读取数据 List<Contract> listFineContract = new List<Contract>(); if (saveFines != string.Empty) { string strErrText; ContractSystem contract = new ContractSystem(); List<Contract> listContract = contract.LoadFineContractsByConditions(string.Empty, string.Empty, string.Empty, LoginAccountId, LoginStaffName, out strErrText); if (listContract == null) { throw new Exception(strErrText); } //过滤数据 string[] fines = saveFines.Split(','); foreach (string fine in fines) { if (fine != string.Empty) { string[] s = fine.Split('|'); long nContractId = long.Parse(s[0]); decimal decFineAmount = decimal.Parse(s[1]); Contract o = listContract.Find(delegate(Contract c) { return c.Id == nContractId; }); if (o == null) { throw new Exception(InnoSoft.LS.Resources.Strings.FindFineContractDataFaild); } o.FineAmount = decFineAmount; listFineContract.Add(o); } } } //提取当前页面数据 int nTotalRows = listFineContract.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "ContractNo") + " " + (sord ?? "ASC"); var data = listFineContract.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.ContractNo, c.OriginalContractNo, c.CarNo, c.TrailerNo, c.DriverName, c.DriverMobileTel, c.CreatorName, c.FineAmount.ToString() } }).ToArray(), userdata = new { ContractNo = InnoSoft.LS.Resources.Labels.Total, FineAmount = data.Sum(s => s.FineAmount) } }; return Json(ret, JsonRequestBehavior.AllowGet); }
public JsonResult LoadContractDeliverPlansGrid(string sidx, string sord, int page, int rows, string contractId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<ContractDeliverPlan> listPlan = contract.LoadContractDeliverPlans(long.Parse(contractId), LoginAccountId, LoginStaffName, out strErrText); if (listPlan == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listPlan.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "PlanNo") + " " + (sord ?? "ASC"); var data = listPlan.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from p in data select new { id = p.Id, cell = new string[] { p.Id.ToString(), p.PlanId.ToString(), p.PlanNo, p.CustomerName, p.ShipmentNo, p.DeliveryNo, p.ReceiverName, p.ReceiverCity + p.ReceiverAddress, p.ReceiveType, p.PlanType, p.Packages.ToString(), p.Tunnages.ToString("#0.######"), p.Piles.ToString("#0.######"), p.TenThousands.ToString("#0.######"), p.TransportPrice.ToString("#0.######"), p.TransportCharges.ToString(), p.Remark, p.TransportChargeExpression, p.TransportPriceExpression, p.KM.ToString() } }).ToArray(), userdata = new { PlanNo = InnoSoft.LS.Resources.Labels.Total, Packages = data.Sum(s => s.Packages), Tunnages = data.Sum(s => s.Tunnages), Piles = data.Sum(s => s.Piles), TenThousands = data.Sum(s => s.TenThousands), TransportCharges = data.Sum(s => s.TransportCharges) } }; return Json(ret, JsonRequestBehavior.AllowGet); }
public JsonResult LoadApproveContractsOwnOrgansByTimespan(string startTime, string endTime) { string strErrText; ContractSystem contract = new ContractSystem(); List<Organization> listOrgan = contract.LoadApproveContractsOwnOrgansByTimespan(startTime, endTime, LoginAccountId, LoginStaffName, out strErrText); if (listOrgan == null) { throw new Exception(strErrText); } var ret = from o in listOrgan select new { Id = o.Id.ToString(), FullName = o.FullName }; return Json(ret, JsonRequestBehavior.AllowGet); }
public ActionResult ExportFines() { string strErrText; #region 提取参数 var request = HttpContext.Request; string strStartTime = request.QueryString["startTime"] ?? string.Empty; string strEndTime = request.QueryString["endTime"] ?? string.Empty; string strCreatorId = request.QueryString["creatorId"] ?? string.Empty; #endregion #region 读取罚款数据 ContractSystem contract = new ContractSystem(); List<Contract> listContract = contract.LoadContractFinesByConditions(strStartTime, strEndTime, strCreatorId, LoginAccountId, LoginStaffName, out strErrText); if (listContract == null) { throw new Exception(strErrText); } #endregion #region 输出Excel //生成GridView BoundField colStaffName = new BoundField(); colStaffName.HeaderText = InnoSoft.LS.Resources.Labels.StaffName; colStaffName.DataField = "CreatorName"; BoundField colFineTime = new BoundField(); colFineTime.HeaderText = InnoSoft.LS.Resources.Labels.FineTime; colFineTime.DataField = "FineTime"; BoundField colContractNo = new BoundField(); colContractNo.HeaderText = InnoSoft.LS.Resources.Labels.ContractNo; colContractNo.DataField = "ContractNo"; BoundField colOriginalContractNo = new BoundField(); colOriginalContractNo.HeaderText = InnoSoft.LS.Resources.Labels.OriginalContractNo; colOriginalContractNo.DataField = "OriginalContractNo"; BoundField colFineAmount = new BoundField(); colFineAmount.HeaderText = InnoSoft.LS.Resources.Labels.FineAmount; colFineAmount.DataField = "FineAmount"; var grid = new GridView(); grid.Columns.Add(colStaffName); grid.Columns.Add(colFineTime); grid.Columns.Add(colContractNo); grid.Columns.Add(colOriginalContractNo); grid.Columns.Add(colFineAmount); grid.AutoGenerateColumns = false; grid.DataSource = from c in listContract select new { CreatorName = c.CreatorName, FineTime = c.FineTime.ToString("yyyy-MM-dd"), ContractNo = c.ContractNo, OriginalContractNo = c.OriginalContractNo, FineAmount = c.FineAmount.ToString("N") }; grid.DataBind(); //导出GridView Response.ClearContent(); Response.Charset = InnoSoft.LS.Resources.Encoding.ExcelCharset; Response.ContentEncoding = System.Text.Encoding.GetEncoding(InnoSoft.LS.Resources.Encoding.ExcelContent); Response.ContentType = "application/ms-excel"; Response.Write("<meta http-equiv=Content-Type content=text/html charset=" + InnoSoft.LS.Resources.Encoding.ExcelCharset + ">"); Response.AddHeader("content-disposition", "attachment; filename=ContractFines.xls"); StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); grid.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); #endregion return View("SearchFines"); }
public ActionResult NewContract(ContractViewModel model) { if (ModelState.IsValid) { //创建数据 Contract data = new Contract(); data.DispatchBillId = model.DispatchBillId; data.CarNo = model.CarNo; data.TrailerNo = model.TrailerNo; data.CarType = model.CarType; data.DriverName = model.DriverName; data.DriverLicenseNo = model.DriverLicenseNo; data.DriverMobileTel = model.DriverMobileTel; data.DriverHomeTel = model.DriverHomeTel; data.CarrierId = model.CarrierId; data.CarrierName = model.CarrierName; data.GoodsName = model.GoodsName; data.Packing = model.Packing; data.StartPlace = model.StartPlace; data.DestPlace = model.DestPlace; data.ShipmentTime = DateTime.Parse(model.ShipmentTime); data.ArrivalTime = DateTime.Parse(model.ArrivalTime); data.TotalPackages = model.TotalPackages; data.TotalTunnages = model.TotalTunnages; data.TotalPiles = model.TotalPiles; data.TotalTenThousands = model.TotalTenThousands; data.TotalTransportCharges = model.TotalTransportCharges; data.PrepayTransportCharges = model.PrepayTransportCharges; data.ResidualTransportCharges = model.ResidualTransportCharges; data.OriginalContractNo = model.OriginalContractNo; data.IsPrestowage = true; List<ContractDeliverPlan> listPlan = new List<ContractDeliverPlan>(); if (model.DeliverPlans != null) { foreach (ContractDeliverPlanViewModel m in model.DeliverPlans) { ContractDeliverPlan p = new ContractDeliverPlan(); p.PlanId = m.PlanId; p.Packages = m.Packages; p.Tunnages = m.Tunnages; p.Piles = m.Piles; p.TenThousands = m.TenThousands; p.TransportChargeExpression = m.TransportChargeExpression; p.TransportPriceExpression = m.TransportPriceExpression; p.KM = m.KM; p.TransportPrice = m.TransportPrice; p.TransportCharges = m.TransportCharges; p.Remark = m.Remark; listPlan.Add(p); } } //保存数据 string strErrText; ContractSystem contract = new ContractSystem(); if (contract.InsertContract(data, listPlan, LoginAccountId, LoginStaffName, out strErrText) > 0) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
public ActionResult ModifyContractGoods(ContractDeliverPlanViewModel model) { if (ModelState.IsValid) { //创建数据 ContractDeliverPlan data = new ContractDeliverPlan(); data.Id = model.Id; data.ContractId = model.ContractId; data.DispatchBillId = model.DispatchBillId; data.PlanId = model.PlanId; data.Packages = model.Packages; data.Tunnages = model.Tunnages; data.Piles = model.Piles; data.TenThousands = model.TenThousands; data.TransportChargeExpression = model.TransportChargeExpression; data.TransportPriceExpression = model.TransportPriceExpression; data.KM = model.KM; data.TransportPrice = model.TransportPrice; data.TransportCharges = model.TransportCharges; data.Remark = model.Remark; List<ContractGoods> listGoods = new List<ContractGoods>(); if (model.Goods != null) { foreach (ContractGoodsViewModel m in model.Goods) { ContractGoods g = new ContractGoods(); g.DispatchBillId = model.DispatchBillId; g.PlanId = model.PlanId; g.GoodsId = m.GoodsId; g.GoodsNo = m.GoodsNo; g.BatchNo = m.BatchNo; g.Packing = m.Packing; g.Location = m.Location; g.Packages = m.Packages; g.PieceWeight = m.PieceWeight; g.Tunnages = m.Tunnages; g.Piles = m.Piles; g.TenThousands = m.TenThousands; g.ProductionDate = m.ProductionDate; g.EnterWarehouseBillId = m.EnterWarehouseBillId; g.EnterWarehouseBillNo = m.EnterWarehouseBillNo; listGoods.Add(g); } } //保存数据 string strErrText; ContractSystem contract = new ContractSystem(); if (contract.UpdateContractDeliverPlan(data, listGoods, LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
public ActionResult ModifyContract(ContractViewModel model) { if (ModelState.IsValid) { //创建数据 Contract data = new Contract(); data.Id = model.Id; data.DispatchBillId = model.DispatchBillId; data.ContractNo = model.ContractNo; data.CarNo = model.CarNo; data.TrailerNo = model.TrailerNo; data.CarType = model.CarType; data.DriverName = model.DriverName; data.DriverLicenseNo = model.DriverLicenseNo; data.DriverMobileTel = model.DriverMobileTel; data.DriverHomeTel = model.DriverHomeTel; data.CarrierId = model.CarrierId; data.CarrierName = model.CarrierName; data.GoodsName = model.GoodsName; data.Packing = model.Packing; data.StartPlace = model.StartPlace; data.DestPlace = model.DestPlace; data.ShipmentTime = DateTime.Parse(model.ShipmentTime); data.ArrivalTime = DateTime.Parse(model.ArrivalTime); data.TotalPackages = model.TotalPackages; data.TotalTunnages = model.TotalTunnages; data.TotalPiles = model.TotalPiles; data.TotalTenThousands = model.TotalTenThousands; data.TotalTransportCharges = model.TotalTransportCharges; data.PrepayTransportCharges = model.PrepayTransportCharges; data.ResidualTransportCharges = model.ResidualTransportCharges; data.OriginalContractNo = model.OriginalContractNo; //保存数据 string strErrText; ContractSystem contract = new ContractSystem(); if (contract.UpdateContract(data, LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
public JsonResult LoadSearchContractReverseDetailsGrid(string sidx, string sord, int page, int rows, string reverseId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<ContractReverseDetail> listDetail = contract.LoadContractReverseDetailsByReverseId(long.Parse(reverseId), LoginAccountId, LoginStaffName, out strErrText); if (listDetail == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listDetail.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "ContractNo") + " " + (sord ?? "ASC"); var data = listDetail.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from d in data select new { id = d.Id, cell = new string[] { d.Id.ToString(), d.ContractId.ToString(), d.ContractNo, d.OriginalContractNo, d.GoodsName, d.StartPlace, d.DestPlace, d.ShipmentTime.ToString("yyyy-MM-dd"), d.CarNo, d.TrailerNo, d.DriverName, d.DriverMobileTel, d.TotalTunnages.ToString("#0.######"), d.TotalPiles.ToString("#0.######"), d.TotalTransportCharges.ToString(), d.ReverseAmount.ToString(), d.WithholdAmount.ToString(), d.FactpaymentAmount.ToString() } }).ToArray(), userdata = new { ContractNo = InnoSoft.LS.Resources.Labels.Total, TotalTransportCharges = data.Sum(s => s.TotalTransportCharges), ReverseAmount = data.Sum(s => s.ReverseAmount), WithholdAmount = data.Sum(s => s.WithholdAmount), FactpaymentAmount = data.Sum(s => s.FactpaymentAmount) } }; return Json(ret, JsonRequestBehavior.AllowGet); }
public JsonResult LoadSearchContractFinesGrid(string sidx, string sord, int page, int rows, string startTime, string endTime, string creatorId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<Contract> listContract = contract.LoadContractFinesByConditions(startTime, endTime, creatorId, LoginAccountId, LoginStaffName, out strErrText); if (listContract == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listContract.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "FineTime") + " " + (sord ?? "ASC"); var data = listContract.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.CreatorName, c.FineTime.ToString("yyyy-MM-dd"), c.ContractNo, c.OriginalContractNo, c.FineAmount.ToString() } }).ToArray(), userdata = new { CreatorName = InnoSoft.LS.Resources.Labels.Total, FineAmount = data.Sum(s => s.FineAmount) } }; return Json(ret, JsonRequestBehavior.AllowGet); }
public JsonResult LoadSaveReversesGrid(string sidx, string sord, int page, int rows, string saveReverses) { //读取数据 List<Contract> listReverseContract = new List<Contract>(); if (saveReverses != string.Empty) { //生成冲帐明细数据 List<ContractReverseDetail> listReverseDetail = new List<ContractReverseDetail>(); string[] reverses = saveReverses.Split(','); foreach (string reverse in reverses) { if (reverse != string.Empty) { string[] s = reverse.Split('|'); ContractReverseDetail detail = new ContractReverseDetail(); detail.ContractId = long.Parse(s[0]); detail.ReverseAmount = decimal.Parse(s[1]); detail.WithholdAmount = decimal.Parse(s[2]); detail.FactpaymentAmount = decimal.Parse(s[3]); listReverseDetail.Add(detail); } } //读取冲帐合同数据 string strErrText; var strContractIds = string.Join(",", (from d in listReverseDetail select d.ContractId).ToArray<long>()); ContractSystem contract = new ContractSystem(); List<Contract> listContract = contract.LoadReverseContractsByContractIds(strContractIds, LoginAccountId, LoginStaffName, out strErrText); if (listContract == null) { throw new Exception(strErrText); } //过滤数据 foreach (ContractReverseDetail detail in listReverseDetail) { Contract o = listContract.Find(delegate(Contract c) { return c.Id == detail.ContractId; }); if (o == null) { throw new Exception(InnoSoft.LS.Resources.Strings.FindReverseContractDataFaild); } o.ReverseAmount = detail.ReverseAmount; o.WithholdAmount = detail.WithholdAmount; o.FactpaymentAmount = detail.FactpaymentAmount; listReverseContract.Add(o); } } //提取当前页面数据 int nTotalRows = listReverseContract.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "ContractNo") + " " + (sord ?? "ASC"); var data = listReverseContract.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.ContractNo, c.OriginalContractNo, c.CarNo, c.TrailerNo, c.DriverName, c.DriverMobileTel, c.ReverseAmount.ToString(), c.WithholdAmount.ToString(), c.FactpaymentAmount.ToString() } }).ToArray(), userdata = new { ContractNo = InnoSoft.LS.Resources.Labels.Total, ReverseAmount = data.Sum(s => s.ReverseAmount), WithholdAmount = data.Sum(s => s.WithholdAmount), FactpaymentAmount = data.Sum(s => s.FactpaymentAmount) } }; return Json(ret, JsonRequestBehavior.AllowGet); }
public ActionResult PrintContract(string id) { string strErrText; //读取公司名称 OrganizationSystem organ = new OrganizationSystem(); List<Organization> listOrgan = organ.LoadOrganizations(LoginAccountId, LoginStaffName, out strErrText); if (listOrgan == null) { throw new Exception(strErrText); } Organization root = listOrgan.Find(delegate(Organization o) { return o.ParentId == 0; }); ViewData["CompanyName"] = root.Name; //读取合同数据 ContractSystem contract = new ContractSystem(); Contract data = contract.LoadContract(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } //创建Model ContractViewModel model = new ContractViewModel(); model.Id = data.Id; model.DispatchBillId = data.DispatchBillId; model.ContractNo = data.ContractNo; model.CarNo = data.CarNo; model.TrailerNo = data.TrailerNo; model.DriverName = data.DriverName; model.DriverLicenseNo = data.DriverLicenseNo; model.DriverMobileTel = data.DriverMobileTel; model.DriverHomeTel = data.DriverHomeTel; model.CarrierId = data.CarrierId; model.CarrierName = data.CarrierName; model.GoodsName = data.GoodsName; model.Packing = data.Packing; model.StartPlace = data.StartPlace; model.DestPlace = data.DestPlace; model.ShipmentTime = data.ShipmentTime.ToString("yyyy-MM-dd"); model.ArrivalTime = data.ArrivalTime.ToString("yyyy-MM-dd"); model.TotalPackages = data.TotalPackages; model.TotalTunnages = data.TotalTunnages; model.TotalPiles = data.TotalPiles; model.TotalTenThousands = data.TotalTenThousands; model.TotalTransportCharges = data.TotalTransportCharges; model.PrepayTransportCharges = data.PrepayTransportCharges; model.ResidualTransportCharges = data.ResidualTransportCharges; model.OriginalContractNo = data.OriginalContractNo; return View(model); }
public JsonResult LoadApproveContractsGrid(string sidx, string sord, int page, int rows, string startTime, string endTime, string contractNo, string originalContractNo, string destCountry, string destProvince, string destCity, string carNo, string organId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<Contract> listContract = contract.LoadApproveContractsByConditions(startTime, endTime, contractNo, originalContractNo, destCountry, destProvince, destCity, carNo, organId, LoginAccountId, LoginStaffName, out strErrText); if (listContract == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listContract.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "ShipmentTime") + " " + (sord ?? "DESC"); var data = listContract.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.ContractNo, c.OriginalContractNo, c.ShipmentTime.ToString("yyyy-MM-dd"), c.CarNo, c.TrailerNo, c.CarType, c.DriverName, c.DriverMobileTel, c.GoodsName, c.TotalTunnages.ToString("#0.######"), c.TotalPiles.ToString("#0.######"), c.TotalTransportCharges.ToString() } }).ToArray() }; return Json(ret, JsonRequestBehavior.AllowGet); }
public ActionResult ReturnModifyContract(string id) { string strErrText; ContractSystem contract = new ContractSystem(); if (contract.ReturnModifyContract(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } }
public JsonResult LoadContractApproveCommentsGrid(string sidx, string sord, int page, int rows, string contractId, string planId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<ContractApproveComment> listComment = contract.LoadContractApproveComments(long.Parse(contractId), long.Parse(planId), LoginAccountId, LoginStaffName, out strErrText); if (listComment == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listComment.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "ApproveTime") + " " + (sord ?? "ASC"); var data = listComment.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from p in data select new { id = p.Id, cell = new string[] { p.Id.ToString(), p.ApproveTime.ToString("yyyy-MM-dd"), p.ApproverName, p.ApprovedTransportPrice.ToString("#0.######"), p.ApprovedTransportCharges.ToString() } }).ToArray() }; return Json(ret, JsonRequestBehavior.AllowGet); }
public ActionResult ReverseContracts(ContractReverseViewModel model) { if (ModelState.IsValid) { //创建数据 ContractReverse data = new ContractReverse(); data.Id = model.Id; data.ReverseAmount = model.ReverseAmount; data.WithholdAmount = model.WithholdAmount; data.FactpaymentAmount = model.FactpaymentAmount; data.CreatorId = model.CreatorId; data.CreatorName = model.CreatorName; List<ContractReverseDetail> listDetail = new List<ContractReverseDetail>(); if (model.Details != null) { foreach (ContractReverseDetailViewModel m in model.Details) { ContractReverseDetail d = new ContractReverseDetail(); d.Id = m.Id; d.ReverseId = 0; d.ContractId = m.ContractId; d.ReverseAmount = m.ReverseAmount; d.WithholdAmount = m.WithholdAmount; d.FactpaymentAmount = m.FactpaymentAmount; listDetail.Add(d); } } //保存数据 string strErrText; ContractSystem contract = new ContractSystem(); if (contract.InsertContractReverse(data, listDetail, LoginAccountId, LoginStaffName, out strErrText) > 0) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }
public JsonResult LoadContractReverseDetailsGrid(string sidx, string sord, int page, int rows, string contractId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<ContractReverseDetail> listReverseDetail = contract.LoadContractReverseDetails(long.Parse(contractId), LoginAccountId, LoginStaffName, out strErrText); if (listReverseDetail == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listReverseDetail.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "CreateTime") + " " + (sord ?? "ASC"); var data = listReverseDetail.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from d in data select new { id = d.Id, cell = new string[] { d.Id.ToString(), d.CreateTime.ToString("yyyy-MM-dd"), d.CreatorName, d.ReverseAmount.ToString(), d.WithholdAmount.ToString(), d.FactpaymentAmount.ToString() } }).ToArray(), userdata = new { CreateTime = InnoSoft.LS.Resources.Labels.Total, ReverseAmount = data.Sum(s => s.ReverseAmount), WithholdAmount = data.Sum(s => s.WithholdAmount), FactpaymentAmount = data.Sum(s => s.FactpaymentAmount) } }; return Json(ret, JsonRequestBehavior.AllowGet); }
public JsonResult LoadReverseContractsGrid(string sidx, string sord, int page, int rows, string startTime, string endTime, string contractNo, string originalContractNo, string carrierName, string carNo, string organId) { //读取数据 string strErrText; ContractSystem contract = new ContractSystem(); List<Contract> listContract = contract.LoadReverseContractsByConditions(startTime, endTime, contractNo, originalContractNo, carrierName, carNo, organId, LoginAccountId, LoginStaffName, out strErrText); if (listContract == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listContract.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "ContractNo") + " " + (sord ?? "ASC"); var data = listContract.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.ContractNo, c.OriginalContractNo, c.GoodsName, c.StartPlace, c.DestPlace, c.ShipmentTime.ToString("yyyy-MM-dd"), c.CarNo, c.TrailerNo, c.DriverName, c.DriverMobileTel, c.TotalTunnages.ToString("#0.######"), c.TotalPiles.ToString("#0.######"), c.TotalTransportCharges.ToString(), c.PrepayTransportCharges.ToString(), c.ResidualTransportCharges.ToString(), c.ReverseAmount.ToString(), (c.TotalTransportCharges - c.ReverseAmount).ToString() } }).ToArray(), userdata = new { ContractNo = InnoSoft.LS.Resources.Labels.Total, TotalTransportCharges = data.Sum(s => s.TotalTransportCharges), PrepayTransportCharges = data.Sum(s => s.PrepayTransportCharges), ResidualTransportCharges = data.Sum(s => s.ResidualTransportCharges), ReverseAmount = data.Sum(s => s.ReverseAmount), ResidualReverseAmount = data.Sum(s => s.TotalTransportCharges - s.ReverseAmount) } }; return Json(ret, JsonRequestBehavior.AllowGet); }