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());
}
