/// <summary> /// 新增 /// </summary> /// <param name="tran"></param> /// <param name="projectinfo"></param> /// <param name="operationBy"></param> /// <returns></returns> private Manager InnerAdd(SqlTransaction tran, Manager manager, string operationBy) { List <CmdParameter> cmds = new List <CmdParameter>(); cmds.Add(new CmdParameter("@LoginName", manager.LoginName)); cmds.Add(new CmdParameter("@ManagerNo", "", System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@Infor", "", System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@Ok", 0, System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@UserName", manager.UserName)); cmds.Add(new CmdParameter("@UserType", manager.UserType)); cmds.Add(new CmdParameter("@OrgNo", manager.OrgNo)); cmds.Add(new CmdParameter("@OrgName", manager.OrgName)); cmds.Add(new CmdParameter("@ProjectName", manager.ProjectName)); cmds.Add(new CmdParameter("@ProjectNo", manager.ProjectNo)); cmds.Add(new CmdParameter("@OperationBy", operationBy)); cmds.Add(new CmdParameter("@Id", 0, System.Data.ParameterDirection.Output)); ParameterResult pResult = new ParameterResult() { Parameters = cmds.ToArray() }; hdDbCmdManager.Execute("[ERP_Subpay].[dbo].[Cmn_Manager_Add]", CommandType.StoredProcedure, pResult.Parameters, tran); if (!Convert.ToBoolean(pResult["@Ok"])) { throw new FaultException <ApplicationServiceError>(new ApplicationServiceError() { ErrorMessage = pResult["@Infor"].ToString() }); } return(manager); }
/// <summary> /// 新增 /// </summary> /// <param name="tran"></param> /// <param name="projectinfo"></param> /// <param name="operationBy"></param> /// <returns></returns> //private XMBProjectInfo InnerAdd(SqlTransaction tran, XMBProjectInfo period, string operationBy) //{ // List<CmdParameter> cmds = new List<CmdParameter>(); // cmds.Add(new CmdParameter("@PeriodsNum", period.PeriodsNum)); // cmds.Add(new CmdParameter("@PeriodsNumber", period.PeriodsNumber)); // cmds.Add(new CmdParameter("@StartingDate", period.StartingDate)); // cmds.Add(new CmdParameter("@EndingDate", period.EndingDate)); // cmds.Add(new CmdParameter("@Remark", period.Remark)); // cmds.Add(new CmdParameter("@OperationBy", operationBy)); // cmds.Add(new CmdParameter("@Id", 0, System.Data.ParameterDirection.Output)); // cmds.Add(new CmdParameter("@PeriodsNo", "", System.Data.ParameterDirection.Output)); // cmds.Add(new CmdParameter("@Infor", "", System.Data.ParameterDirection.Output)); // cmds.Add(new CmdParameter("@Ok", 0, System.Data.ParameterDirection.Output)); // ParameterResult pResult = new ParameterResult() { Parameters = cmds.ToArray() }; // hdDbCmdManager.Execute("[ERP_Project].[dbo].[Project_Project_Add]", CommandType.StoredProcedure, pResult.Parameters, tran); // if (!Convert.ToBoolean(pResult["@Ok"])) // throw new FaultException<ApplicationServiceError>(new ApplicationServiceError() // { // ErrorMessage = pResult["@Infor"].ToString() // }); // return period; //} /// <summary> /// 更新 /// </summary> /// <param name="tran"></param> /// <param name="period"></param> /// <param name="operationBy"></param> /// <returns></returns> private XMBProjectInfo InnerUpdate(SqlTransaction tran, XMBProjectInfo period, string operationBy) { List <CmdParameter> cmds = new List <CmdParameter>(); cmds.Add(new CmdParameter("@ProjectNo", period.ProjectNo)); cmds.Add(new CmdParameter("@ProjectNoNew", period.ProjectNoNew)); cmds.Add(new CmdParameter("@AdjustNewNo", 0)); cmds.Add(new CmdParameter("@OrgNo", period.OrgNo)); cmds.Add(new CmdParameter("@OrgName", period.OrgName)); cmds.Add(new CmdParameter("@ProjectCode", period.ProjectCode)); cmds.Add(new CmdParameter("@ProjectName", period.ProjectName)); cmds.Add(new CmdParameter("@Catalog", period.Catalog)); cmds.Add(new CmdParameter("@ProjectClass", period.ProjectClass)); cmds.Add(new CmdParameter("@Duration", period.Duration)); cmds.Add(new CmdParameter("@ProjectDuration", period.ProjectDuration)); cmds.Add(new CmdParameter("@Currency", period.Currency)); cmds.Add(new CmdParameter("@CurrencyCode", period.CurrencyCode)); cmds.Add(new CmdParameter("@CtrctCurrencyCode", period.CtrctCurrencyCode)); cmds.Add(new CmdParameter("@CtrctCurrency", period.CtrctCurrency)); cmds.Add(new CmdParameter("@CtrctExChangeRate", period.CtrctExChangeRate)); cmds.Add(new CmdParameter("@DomOvsea", period.DomOvsea)); //cmds.Add(new CmdParameter("@AddressId", period.AddressId)); cmds.Add(new CmdParameter("@AddressName", period.AddressName)); cmds.Add(new CmdParameter("@Country", period.Country)); cmds.Add(new CmdParameter("@District", period.District)); cmds.Add(new CmdParameter("@Province", period.Province)); cmds.Add(new CmdParameter("@City", period.City)); //cmds.Add(new CmdParameter("@Address", period.Address)); //cmds.Add(new CmdParameter("@ParentprojectNo", period.ParentprojectNo)); //cmds.Add(new CmdParameter("@ParentprojectName", period.ParentprojectName)); cmds.Add(new CmdParameter("@Description", period.Description)); cmds.Add(new CmdParameter("@ContractAmount", period.ContractAmount)); cmds.Add(new CmdParameter("@ProjectManager", period.ProjectManager)); cmds.Add(new CmdParameter("@BidDate", period.BidDate)); cmds.Add(new CmdParameter("@SignDate", period.SignDate)); cmds.Add(new CmdParameter("@BeginningDate", period.BeginningDate)); cmds.Add(new CmdParameter("@Endingdate", period.Endingdate)); cmds.Add(new CmdParameter("@ActualBeginningDate", period.ActualBeginningDate)); cmds.Add(new CmdParameter("@ActualEndingDate", period.ActualEndingDate)); cmds.Add(new CmdParameter("@PlanDate", period.PlanDate)); cmds.Add(new CmdParameter("@StageNo", period.StageNo)); cmds.Add(new CmdParameter("@Stage", period.Stage)); //cmds.Add(new CmdParameter("@ProjectphaseNo", period.ProjectphaseNo)); //cmds.Add(new CmdParameter("@ProjectphaseName", period.ProjectphaseName)); cmds.Add(new CmdParameter("@ProjectBalanceNo", period.ProjectBalanceNo)); cmds.Add(new CmdParameter("@ProjectBalance", period.ProjectBalance)); cmds.Add(new CmdParameter("@Remark", period.Remark)); cmds.Add(new CmdParameter("@ndReport", period.ndReport)); //cmds.Add(new CmdParameter("@needReport", period.needReport)); //cmds.Add(new CmdParameter("@CustomerId", period.CustomerId)); cmds.Add(new CmdParameter("@CustomerNo", period.CustomerNo)); cmds.Add(new CmdParameter("@CustomerName", period.CustomerName)); cmds.Add(new CmdParameter("@SignDeptNo", period.SignDeptNo)); cmds.Add(new CmdParameter("@SignDept", period.SignDept)); cmds.Add(new CmdParameter("@EngnrDeptNo", period.EngnrDeptNo)); cmds.Add(new CmdParameter("@EngnrDept", period.EngnrDept)); cmds.Add(new CmdParameter("@EngnrDeptRecord", period.EngnrDeptRecord)); cmds.Add(new CmdParameter("@DesignDept", period.DesignDept)); cmds.Add(new CmdParameter("@ResponseDept", period.ResponseDept)); cmds.Add(new CmdParameter("@PrepDept", period.PrepDept)); cmds.Add(new CmdParameter("@Scale", period.Scale)); cmds.Add(new CmdParameter("@PlanScale", period.PlanScale)); cmds.Add(new CmdParameter("@Probability", period.Probability)); cmds.Add(new CmdParameter("@SourceProject", period.SourceProject)); cmds.Add(new CmdParameter("@ProjectStat", period.ProjectStat)); cmds.Add(new CmdParameter("@ProjectLevel", period.ProjectLevel)); cmds.Add(new CmdParameter("@Important", period.Important)); cmds.Add(new CmdParameter("@PrjType", period.PrjType)); cmds.Add(new CmdParameter("@Region", period.Region)); cmds.Add(new CmdParameter("@OvTypeNo", period.OvTypeNo)); cmds.Add(new CmdParameter("@OvType", period.OvType)); cmds.Add(new CmdParameter("@ProjectTypeNo", period.ProjectTypeNo)); cmds.Add(new CmdParameter("@ProjectType", period.ProjectType)); cmds.Add(new CmdParameter("@ProjectType1No", period.ProjectType1No)); cmds.Add(new CmdParameter("@ProjectType1", period.ProjectType1)); cmds.Add(new CmdParameter("@isClosed", period.isClosed)); //cmds.Add(new CmdParameter("@isClosedC", period.isClosedC)); cmds.Add(new CmdParameter("@CloseReason", period.CloseReason)); cmds.Add(new CmdParameter("@EditFlag", period.EditFlag)); cmds.Add(new CmdParameter("@DeptName", period.DeptName)); cmds.Add(new CmdParameter("@DeptNo", period.DeptNo)); //cmds.Add(new CmdParameter("@DeptId", period.DeptId)); cmds.Add(new CmdParameter("@ConnectProject", period.ConnectProject)); cmds.Add(new CmdParameter("@ApprovalStat", period.ApprovalStat)); cmds.Add(new CmdParameter("@TenderOpenDate", period.TenderOpenDate)); //cmds.Add(new CmdParameter("@BidDeptId", period.BidDeptId)); cmds.Add(new CmdParameter("@TenderOpenYear", period.TenderOpenYear)); cmds.Add(new CmdParameter("@TenderOpenQuarter", period.TenderOpenQuarter)); cmds.Add(new CmdParameter("@TenderOpenMonth", period.TenderOpenMonth)); cmds.Add(new CmdParameter("@CloseType", period.CloseType)); cmds.Add(new CmdParameter("@FromProjects", period.FromProjects)); cmds.Add(new CmdParameter("@isShow", period.isShow)); cmds.Add(new CmdParameter("@ProjectSchedule", period.ProjectSchedule)); //cmds.Add(new CmdParameter("@CreatedByUserId", period.CreatedByUserId)); cmds.Add(new CmdParameter("@isOutputValue", period.isOutputValue)); cmds.Add(new CmdParameter("@isGroupAdmin", period.isGroupAdmin)); cmds.Add(new CmdParameter("@IsBadDebts", period.IsBadDebts)); cmds.Add(new CmdParameter("@IsThree", period.IsThree)); cmds.Add(new CmdParameter("@RowPointer", "", System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@OperationBy", operationBy)); cmds.Add(new CmdParameter("@Infor", "", System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@Ok", 0, System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@OwnerAttribute", period.OwnerAttribute)); cmds.Add(new CmdParameter("@PaymentRatio", period.PaymentRatio)); cmds.Add(new CmdParameter("@WarrantyRatio", period.WarrantyRatio)); cmds.Add(new CmdParameter("@VATRate", period.VATRate)); cmds.Add(new CmdParameter("@WarrantyStartingDate", period.WarrantyStartingDate)); cmds.Add(new CmdParameter("@WarrantyPeriod", period.WarrantyPeriod)); cmds.Add(new CmdParameter("@AcceptanceDate", period.AcceptanceDate)); cmds.Add(new CmdParameter("@SettlementDate", period.SettlementDate)); cmds.Add(new CmdParameter("@CompletedAccDate", period.CompletedAccDate)); cmds.Add(new CmdParameter("@PrjManager", period.PrjManager)); ParameterResult pResult = new ParameterResult() { Parameters = cmds.ToArray() }; hdDbCmdManager.Execute("[ERP_Project].[dbo].[Project_Project_Update]", CommandType.StoredProcedure, pResult.Parameters, tran); if (!Convert.ToBoolean(pResult["@Ok"])) { throw new FaultException <ApplicationServiceError>(new ApplicationServiceError() { ErrorMessage = pResult["@Infor"].ToString() }); } return(period); }
/// <summary> /// 更新 /// </summary> /// <param name="tran"></param> /// <param name="period"></param> /// <param name="operationBy"></param> /// <returns></returns> private XMBContractInfo InnerUpdate(SqlTransaction tran, XMBContractInfo XMBContractInfo, string operationBy) { List <CmdParameter> cmds = new List <CmdParameter>(); cmds.Add(new CmdParameter("@ContractNo", XMBContractInfo.ContractNo)); cmds.Add(new CmdParameter("@CustomerName", XMBContractInfo.CustomerName)); cmds.Add(new CmdParameter("@Amount", XMBContractInfo.Amount)); cmds.Add(new CmdParameter("@AftAmount", XMBContractInfo.AftAmount)); cmds.Add(new CmdParameter("@Currency", XMBContractInfo.Currency)); cmds.Add(new CmdParameter("@TotalAmount", XMBContractInfo.TotalAmount)); cmds.Add(new CmdParameter("@SignDate", XMBContractInfo.SignDate)); cmds.Add(new CmdParameter("@SignDeptNo", XMBContractInfo.SignDeptNo)); cmds.Add(new CmdParameter("@SignDeptName", XMBContractInfo.SignDeptName)); cmds.Add(new CmdParameter("@EngnrDeptNo", XMBContractInfo.EngnrDeptNo)); cmds.Add(new CmdParameter("@EngnrDeptName", XMBContractInfo.EngnrDeptName)); cmds.Add(new CmdParameter("@ContractCode", XMBContractInfo.ContractCode)); cmds.Add(new CmdParameter("@ProjectType", XMBContractInfo.ProjectType)); cmds.Add(new CmdParameter("@Duration", XMBContractInfo.Duration)); cmds.Add(new CmdParameter("@StartingDate", XMBContractInfo.StartingDate)); cmds.Add(new CmdParameter("@PlanEndingDate", XMBContractInfo.PlanEndingDate)); cmds.Add(new CmdParameter("@Leader", XMBContractInfo.Leader)); cmds.Add(new CmdParameter("@FileLocation", XMBContractInfo.FileLocation)); cmds.Add(new CmdParameter("@ProjectClass", XMBContractInfo.ProjectClass)); cmds.Add(new CmdParameter("@ReceiveCntrctFileDate", XMBContractInfo.ReceiveCntrctFileDate)); cmds.Add(new CmdParameter("@DeptNo", XMBContractInfo.DeptNo)); cmds.Add(new CmdParameter("@DeptName", XMBContractInfo.DeptName)); cmds.Add(new CmdParameter("@InnerContractCode", XMBContractInfo.InnerContractCode)); cmds.Add(new CmdParameter("@isShow", XMBContractInfo.isShow)); cmds.Add(new CmdParameter("@BidApplicationNo", XMBContractInfo.BidApplicationNo)); cmds.Add(new CmdParameter("@BidApplicationCode", XMBContractInfo.BidApplicationCode)); cmds.Add(new CmdParameter("@DomOvsea", XMBContractInfo.DomOvsea)); cmds.Add(new CmdParameter("@isFocus", XMBContractInfo.isFocus)); cmds.Add(new CmdParameter("@ProjectType1", XMBContractInfo.ProjectType1)); cmds.Add(new CmdParameter("@EngnrPhase", XMBContractInfo.EngnrPhase)); cmds.Add(new CmdParameter("@CompanyNo", XMBContractInfo.CompanyNo)); cmds.Add(new CmdParameter("@CompanyName", XMBContractInfo.CompanyName)); cmds.Add(new CmdParameter("@ProjectAddr", XMBContractInfo.ProjectAddr)); cmds.Add(new CmdParameter("@ContractName", XMBContractInfo.ContractName)); cmds.Add(new CmdParameter("@EngnrStructure", XMBContractInfo.EngnrStructure)); cmds.Add(new CmdParameter("@DesignDeptNo", XMBContractInfo.DesignDeptNo)); cmds.Add(new CmdParameter("@DesignDeptName", XMBContractInfo.DesignDeptName)); cmds.Add(new CmdParameter("@SupervisionDeptNo", XMBContractInfo.SupervisionDeptNo)); cmds.Add(new CmdParameter("@SupervisionDeptName", XMBContractInfo.SupervisionDeptName)); cmds.Add(new CmdParameter("@PrjDeputyManager", XMBContractInfo.PrjDeputyManager)); cmds.Add(new CmdParameter("@PrjAudit", XMBContractInfo.PrjAudit)); cmds.Add(new CmdParameter("@AcceptanceDate", XMBContractInfo.AcceptanceDate)); cmds.Add(new CmdParameter("@CompleteDate", XMBContractInfo.CompleteDate)); cmds.Add(new CmdParameter("@Continent", XMBContractInfo.Continent)); cmds.Add(new CmdParameter("@ProjectNo", XMBContractInfo.ProjectNo)); cmds.Add(new CmdParameter("@Area", XMBContractInfo.Area)); cmds.Add(new CmdParameter("@Country", XMBContractInfo.Country)); cmds.Add(new CmdParameter("@Region", XMBContractInfo.Region)); cmds.Add(new CmdParameter("@Province", XMBContractInfo.Province)); cmds.Add(new CmdParameter("@City", XMBContractInfo.City)); cmds.Add(new CmdParameter("@District", XMBContractInfo.District)); cmds.Add(new CmdParameter("@PrjClassType", XMBContractInfo.PrjClassType)); cmds.Add(new CmdParameter("@Overview", XMBContractInfo.Overview)); cmds.Add(new CmdParameter("@PayoutRatio", XMBContractInfo.PayoutRatio)); cmds.Add(new CmdParameter("@WarrantyPeriod", XMBContractInfo.WarrantyPeriod)); cmds.Add(new CmdParameter("@ProjectCode", XMBContractInfo.ProjectCode)); cmds.Add(new CmdParameter("@RetentionPeriod", XMBContractInfo.RetentionPeriod)); cmds.Add(new CmdParameter("@PaymentDate", XMBContractInfo.PaymentDate)); cmds.Add(new CmdParameter("@Remark", XMBContractInfo.Remark)); cmds.Add(new CmdParameter("@ApprovalStat", XMBContractInfo.ApprovalStat)); cmds.Add(new CmdParameter("@ExecuteStat", XMBContractInfo.ExecuteStat)); cmds.Add(new CmdParameter("@WfdefId", XMBContractInfo.WfdefId)); cmds.Add(new CmdParameter("@RefCategory", XMBContractInfo.RefCategory)); cmds.Add(new CmdParameter("@OperationBy", operationBy)); cmds.Add(new CmdParameter("@Infor", "", System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@Ok", "", System.Data.ParameterDirection.Output)); cmds.Add(new CmdParameter("@ProjectName", XMBContractInfo.ProjectName)); cmds.Add(new CmdParameter("@CustomerNo", XMBContractInfo.CustomerNo)); cmds.Add(new CmdParameter("@CustomerCode", XMBContractInfo.CustomerCode)); ParameterResult pResult = new ParameterResult() { Parameters = cmds.ToArray() }; hdDbCmdManager.Execute("[ERP_SalesMarketing].[dbo].[Ctrct_PrjContract_Update]", CommandType.StoredProcedure, pResult.Parameters, tran); if (!Convert.ToBoolean(pResult["@Ok"])) { throw new FaultException <ApplicationServiceError>(new ApplicationServiceError() { ErrorMessage = pResult["@Infor"].ToString() }); } return(XMBContractInfo); }