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 QueryScanData(int?id)
{
///赋值ViewModel
AdidasScanDataViewModel ASDViewModel = new AdidasScanDataViewModel();
ASDViewModel.PageIndex = 0;
ASDViewModel.PageCount = 0;
ASDViewModel.SearchCondition = new AdidasScanDataSearchCondition(); ///查询条件
///获取查询结果
return(View(ASDViewModel));
}
