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 Index(QueryContractViewModel vm, int?PageIndex, string Action) { BindDropDownList(ref vm); //重新绑定下拉 ///合同的查询功能 ///定义表数据,作为参数传给存储过程 GetContractByConditionRequest request = new GetContractByConditionRequest(); request.PageIndex = PageIndex ?? 0; request.SearchType1 = vm.SearchType1 ?? 0; //合同类型 request.SearchType2 = vm.SearchType2 ?? 0; //保单类型 request.PageSize = UtilConstants.PAGESIZE; //页数量 request.SearchCondition = vm.SearchCondition; var response = new ContractService().GetContractByCondition(request); vm.ContractCollection = response.Result.ContractCollection; vm.PageCount = response.Result.PageCount / UtilConstants.PAGESIZE + ((response.Result.PageCount % UtilConstants.PAGESIZE) == 0 ? 0 : 1); vm.PageIndex = response.Result.PageIndex; if (response.IsSuccess && Action == "导出") { DataTable dt = new DataTable(); dt = EnumerableExtension.ToDataTable <Contract>(response.Result.ContractCollection.ToList()); //List转化为Datatable ///对查询出来的列进行处理 dt.Columns.Remove("ID"); dt.Columns.Remove("CompanyCode"); dt.Columns.Remove("BusinessCode"); dt.Columns.Remove("DepartmentCode"); dt.Columns.Remove("ContractTypeCode"); dt.Columns.Remove("AttachmentGroupID"); dt.Columns.Remove("IsPolExpired"); dt.Columns.Remove("IsContractExpired"); dt.Columns.Remove("Creator"); dt.Columns.Remove("CreateTime"); dt.Columns.Remove("Updator"); dt.Columns.Remove("UpdateTime"); dt.Columns["CompanyName"].ColumnName = "公司名称"; dt.Columns["BusinessName"].ColumnName = "业务大类"; dt.Columns["DepartmentName"].ColumnName = "部门名称"; dt.Columns["ContractTypeName"].ColumnName = "合同种类"; dt.Columns["ContractStartDate"].ColumnName = "合同起始日期"; dt.Columns["ContractNumber"].ColumnName = "合同编号"; dt.Columns["ContractContent"].ColumnName = "合同内容"; dt.Columns["BusinessPartnerName"].ColumnName = "业务对方名称"; dt.Columns["IsContractExtension"].ColumnName = "是否顺延"; dt.Columns["ContractExpireDate"].ColumnName = "实际到期日期"; dt.Columns["StampTax"].ColumnName = "是否含印花税"; dt.Columns["OldContractNumber"].ColumnName = "老合同编号"; dt.Columns["PolStartDate"].ColumnName = "保单起始日期"; dt.Columns["PolEndDate"].ColumnName = "保单到期日期"; dt.Columns["Remark"].ColumnName = "备注"; dt.Columns["QualificationCertificate"].ColumnName = "证书"; this.WriteExcel(dt, "Contract_" + UserInfo.Name + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xls"); //生成Excel return(new EmptyResult()); } return(View(vm)); }