/// <summary>
/// 根据查询条件分页得到合同
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public Response <GetContractByConditionResponse> GetContractByCondition(GetContractByConditionRequest request)
{
int count = 0;
///定义表，用于存储过程调用
DataTable dt = new DataTable();
//增加列
dt.Columns.Add("CompanyCode");
dt.Columns.Add("BusinessCode");
dt.Columns.Add("DepartmentCode");
dt.Columns.Add("ContractTypeCode");
dt.Columns.Add("ContractStartDate_start");
dt.Columns.Add("ContractStartDate_end");
dt.Columns.Add("IsContractExtension");
dt.Columns.Add("IsContractExpired");
dt.Columns.Add("StampTax");
dt.Columns.Add("Contract");
dt.Columns.Add("SearchType1");
dt.Columns.Add("SearchType2");
//增加行
dt.Rows.Add(request.SearchCondition.SCCompany, request.SearchCondition.SCBusiness, request.SearchCondition.SCDepartment,
request.SearchCondition.SCContractType,
//对日期类型的处理
request.SearchCondition.SCContractStart_start == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.SearchCondition.SCContractStart_start,
request.SearchCondition.SCContractStart_end == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.SearchCondition.SCContractStart_end,
request.SearchCondition.SCExtended, request.SearchCondition.SCExpired, request.SearchCondition.StampTax, request.SearchCondition.SCContract, request.SearchType1, request.SearchType2);
///初始化响应类
Response <GetContractByConditionResponse> response = new Response <GetContractByConditionResponse>();
response.Result = new GetContractByConditionResponse();
//为响应类赋值
response.Result.ContractCollection = new ContractAccessor().GetContractByCondition(dt, request.PageIndex, request.PageSize, out count);
response.Result.PageIndex = request.PageIndex;
response.Result.PageCount = count;
if (response.Result.ContractCollection.Count() > 0)
{
response.IsSuccess = true;
}
return(response);
}
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));
}
