/// <summary> /// 新增或者修改合同 /// </summary> /// <param name="request"></param> /// <returns></returns> public Contract AddOrUpdateContract(AddOrUpdateContractRequest request, out string message) { ///定义表数据,作为参数传给存储过程 DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("CompanyCode"); dt.Columns.Add("CompanyName"); dt.Columns.Add("BusinessCode"); dt.Columns.Add("BusinessName"); dt.Columns.Add("DepartmentCode"); dt.Columns.Add("DepartmentName"); dt.Columns.Add("ContractTypeCode"); dt.Columns.Add("ContractTypeName"); dt.Columns.Add("ContractStartDate"); dt.Columns.Add("ContractNumber"); dt.Columns.Add("ContractContent"); dt.Columns.Add("BusinessPartnerName"); dt.Columns.Add("IsContractExtension"); dt.Columns.Add("ContractExpireDate"); dt.Columns.Add("IsContractExpired"); dt.Columns.Add("StampTax"); dt.Columns.Add("OldContractNumber"); dt.Columns.Add("QualificationCertificate"); dt.Columns.Add("PolStartDate"); dt.Columns.Add("PolEndDate"); dt.Columns.Add("IsPolExpired"); dt.Columns.Add("AttachmentGroupID"); dt.Columns.Add("Remark"); dt.Columns.Add("Creator"); dt.Columns.Add("CreateTime"); dt.Columns.Add("Updator"); dt.Columns.Add("UpdateTime"); dt.Rows.Add(request.Contract.ID, request.Contract.CompanyCode, request.Contract.CompanyName, request.Contract.BusinessCode, request.Contract.BusinessName , request.Contract.DepartmentCode, request.Contract.DepartmentName, request.Contract.ContractTypeCode, request.Contract.ContractTypeName , request.Contract.ContractStartDate == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.Contract.ContractStartDate , request.Contract.ContractNumber, request.Contract.ContractContent, request.Contract.BusinessPartnerName , request.Contract.IsContractExtension, request.Contract.ContractExpireDate == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.Contract.ContractExpireDate, request.Contract.IsContractExpired, request.Contract.StampTax , request.Contract.OldContractNumber, request.Contract.QualificationCertificate, request.Contract.PolStartDate == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.Contract.PolStartDate, request.Contract.PolEndDate == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.Contract.PolEndDate , request.Contract.IsPolExpired, request.Contract.AttachmentGroupID, request.Contract.Remark, request.Contract.Creator, request.Contract.CreateTime == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1) : request.Contract.CreateTime, request.Contract.Updator, request.Contract.UpdateTime == new DateTime(0001, 1, 1) ? new DateTime(1753, 1, 1):request.Contract.UpdateTime ); return(new ContractAccessor().AddOrUpdateContract(dt, out message)); }
public ActionResult Create(ContractOperationViewModel vm) { AddOrUpdateContractRequest request = new AddOrUpdateContractRequest(); GetContractRequest request1 = new GetContractRequest(); string message = ""; request.Contract = vm.Contract; switch (vm.ViewType) { case 0: //查看 vm.Contract = new ContractService().GetContractByID(request1); break; case 1: //新增操作 request.Contract.Creator = base.UserInfo.Name; request.Contract.CreateTime = DateTime.Now; if (vm.CertificateCodes != null) { ///若有选中证书,则导入 ///证书导入 foreach (var item in vm.CertificateCodes) { request.Contract.QualificationCertificate += item + "|"; } } ///获取到更新的那条数据 vm.Contract = new ContractService().AddOrUpdateContract(request, out message); break; case 2: //修改操作 request.Contract.Updator = base.UserInfo.Name; request.Contract.UpdateTime = DateTime.Now; if (vm.CertificateCodes != null) { ///若有选中证书,则导入 ///证书导入 foreach (var item in vm.CertificateCodes) { request.Contract.QualificationCertificate += item + "|"; } } ///获取到更新的那条数据 vm.Contract = new ContractService().AddOrUpdateContract(request, out message); break; default: break; } vm.ViewType = 0; //ViewType=0, 编辑或者新增后,直接进入查看页面 return(View(vm)); }