public ActionResult AddBAF(GetBAFMobile vm) { vm.abfRiceInfo.ProjectID = 1; vm.abfRiceInfo.ProjectName = "Runbow"; vm.abfRiceInfo.TragetID = 1; vm.abfRiceInfo.TragetName = "Adidas"; ABFPriceRequest SearchCondition = new ABFPriceRequest(); SearchCondition.Info = vm.abfRiceInfo; bool response = new AdidasService().addABFPrice(SearchCondition); if (response) { return(Redirect("/POD/Adidas/UpdateBAF")); } else { return(View("添加失败!")); } //new ABFPriceRequest // { //ProjectID = 1, //ProjectName = "Runbow", //TragetID = 1, //TragetName = "Adidas", //BAFPrice = vm.BAFPrice, //BAFStartTime = vm.BAFStartTime, //BAFEndTime = vm.BAFEndTime, //PageIndex = vm.PageIndex, //PageSize = UtilConstants.PAGESIZE ///每页的数据 // }); }
public ActionResult QueryScanData(AdidasScanDataViewModel ASDViewModel, int?PageIndex, string Action) { ///by tim 2015.12.16 增加判断,若角色为“承运商扫描数据查询”,则默认给指定承运商查询 if (UserInfo.ProjectRoleID == 50) { ASDViewModel.SearchCondition.Shipper = "ShipperID:" + UserInfo.CustomerOrShipperID.ToString(); //关键字标识,表示筛选的条件为承运商ID } var response = new AdidasService().GetQueryScanDatas(new QuerySearchConditionRequest { SearchCondition = ASDViewModel.SearchCondition, PageIndex = PageIndex ?? 0, PageSize = UtilConstants.PAGESIZE ///每页的数据 }); if (response.IsSuccess) { ASDViewModel.ScanInfoCollection = response.Result.ScanDataCollection; ASDViewModel.PageCount = response.Result.PageCount / UtilConstants.PAGESIZE + ((response.Result.PageCount % UtilConstants.PAGESIZE) == 0 ? 0 : 1);; ASDViewModel.PageIndex = response.Result.PageIndex; } if (response.IsSuccess && Action == "导出") { DataTable dt = new DataTable(); dt = EnumerableExtension.ToDataTable <ScanInfo>(ASDViewModel.ScanInfoCollection.ToList()); //List转化为Datatable ///对查询出来的列进行处理 dt.Columns.Remove("ID"); dt.Columns.Remove("ShipperID"); dt.Columns.Remove("Creater"); dt.Columns.Remove("CreateTime"); dt.Columns.Remove("Modifier"); dt.Columns.Remove("ModifyTime"); dt.Columns["CustomerOrderNumber"].ColumnName = "运单号"; dt.Columns["BoxNumber"].ColumnName = "运单箱数"; dt.Columns["ScanBoxNumber"].ColumnName = "实际扫描箱数"; dt.Columns["TrailerNo"].ColumnName = "拖号"; dt.Columns["PlateNumber"].ColumnName = "车牌号"; dt.Columns["Shipper"].ColumnName = "物流公司"; dt.Columns["CloseFlag"].ColumnName = "关闭状态(1为关闭)"; dt.Columns["CompleteFlag"].ColumnName = "确认完成次数(0为未完成)"; dt.Columns["Operator"].ColumnName = "操作人"; dt.Columns["OperateTime"].ColumnName = "操作时间"; dt.Columns["Remark"].ColumnName = "备注"; this.WriteExcel(dt, "Shipper_" + UserInfo.Name + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xls"); //生成Excel return(new EmptyResult()); } return(View(ASDViewModel)); }
public ActionResult UpdateBAF(GetBAFMobile vm) { var response = new AdidasService().GetABFPrice(new ABFPriceRequest { BAFStartTime = vm.BAFStartTime, BAFEndTime = vm.BAFEndTime, BAFPrice = vm.BAFPrice, PageSize = 100, PageIndex = 0 }); if (response.IsSuccess) { vm.abfRiceInfos = response.Result.bafPriceInfo; vm.PageCount = response.Result.PageCount; vm.PageIndex = response.Result.PageIndex; } return(View(vm)); }
public bool Edit(int id) { bool response = new AdidasService().del(id); return(true); }
public string ImportScanData() { if (Request.Files.Count > 0) { HttpPostedFileBase hpf = Request.Files[0] as HttpPostedFileBase; if (hpf.ContentLength > 0) { DataSet ds = this.GetDataFromExcel(hpf); if (ds != null && ds.Tables[0] != null) { DataTable dt = ds.Tables[0]; ///验证导入的表格式 if (dt.Columns.Contains("运单号") && dt.Columns.Contains("箱数") && dt.Columns.Contains("承运商") && dt.Columns.Count == 3) { StringBuilder sb = new StringBuilder(); IEnumerable <ScanInfo> scanInfoList = this.InitScanInfoFromDataTable(dt, sb); if (!string.IsNullOrEmpty(sb.ToString())) { return(new { result = "<h3>运单导入失败</h3><br/>" + sb.ToString(), IsSuccess = false }.ToJsonString()); } if (scanInfoList == null || !scanInfoList.Any()) { return(new { result = "<h3>Excel无数据</h3><br/>" + sb.ToString(), IsSuccess = false }.ToJsonString()); } IEnumerable <string> existsPodCustomerOrderNumbers = Enumerable.Empty <string>(); var response = new AdidasService().AddScanDatas(new AddScanDatasRequest() { scanInfos = scanInfoList }); if (response.IsSuccess) { StringBuilder successSB = new StringBuilder(); successSB.Append("<b>导入运单成功</b><br/>"); if (!string.IsNullOrEmpty(response.SuccessMessage.Split(',')[0])) { successSB.Append("<b>" + response.SuccessMessage.ToString().Split(',')[0] + "等运单有重复</b><br/>"); } if (!string.IsNullOrEmpty(response.SuccessMessage.Split(',')[1])) { successSB.Append("<b>" + response.SuccessMessage.ToString().Split(',')[1] + "等承运商有错误</b><br/>"); } successSB.Append("<table><thead><tr><th>").Append("运单号") .Append("</th><th>").Append("箱数") .Append("</th><th>").Append("承运商") .Append("</th></tr></thead><tbody>"); foreach (var o in response.Result) { successSB.Append("<tr><td>").Append(o.CustomerOrderNumber) .Append("</td><td>").Append(o.BoxNumber) .Append("</td><td>").Append(o.Shipper) .Append("</td></tr>"); } successSB.Append("</tbody></table>"); return(new { result = successSB.ToString(), IsSuccess = true }.ToJsonString()); } else { return(new { result = "<h3>导入数据失败</h3><br/>系统忙,请稍后再试", IsSuccess = false }.ToJsonString()); } } return(new { result = "<h3>导入数据失败</h3><br/>Excel文件表单1(Sheet1)的格式不正确,请检查", IsSuccess = false }.ToJsonString()); } return(new { result = "文件内容为空", IsSuccess = false }.ToJsonString()); } } return(new { result = "请选择文件", IsSuccess = false }.ToJsonString()); }