Exemplo n.º 1
0
        /// <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));
        }
Exemplo n.º 2
0
        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));
        }