///<summary> ///添加: ///</summary> /// <param name="model">要添加的model</param> /// <returns>受影响的行数</returns> public Result <int> AddTzDesignScheme(Epm_TzDesignScheme model) { Result <int> result = new Result <int>(); try { int rows = 0; bool isAdd = false; //根据批复信息自动生成一条方案信息,如果已经存在==修改 var reveiews = DataOperateBusiness <Epm_TzDesignScheme> .Get().GetList(t => t.ProjectId == model.ProjectId && t.State != (int)PreProjectApprovalState.ApprovalFailure && t.State != (int)PreProjectApprovalState.Closed).FirstOrDefault(); #region receiews if (reveiews == null)//没有-新增 { isAdd = true; reveiews = new Epm_TzDesignScheme(); SetCreateUser(reveiews); } ///所属项目ID reveiews.ProjectId = model.ProjectId; ///项目编码 reveiews.ProjectCode = model.ProjectCode; ///项目名称 reveiews.ProjectName = model.ProjectName; ///项目批复号 reveiews.ApprovalNo = model.ApprovalNo; ///项目性质(数据字典) reveiews.Nature = model.Nature; ///项目性质名称 reveiews.NatureName = model.NatureName; ///项目提出日期(冗余) reveiews.ApplyTime = model.ApplyTime; //库站ID reveiews.StationId = model.StationId; ///库站协同编码 reveiews.StationCodeXt = model.StationCodeXt; ///库站名称 reveiews.StationName = model.StationName; ///地市公司ID reveiews.CompanyId = model.CompanyId; ///地市公司协同编码 reveiews.CompanyCodeXt = model.CompanyCodeXt; ///地市公司名称 reveiews.CompanyName = model.CompanyName; ///初步设计单位 reveiews.DesignUnit = model.DesignUnit; ///示范/标注数据字典编码 reveiews.StandarCode = model.StandarCode; ///示范名称 reveiews.StandarName = model.StandarName; ///上报概算 reveiews.Estimate = model.Estimate; ///总工程费用(冗余) reveiews.TotalInvestment = model.TotalInvestment; ///其它工程费用(冗余) reveiews.OtheInvestment = model.OtheInvestment; ///设计单位招标日期 reveiews.InviteTime = model.InviteTime; ///设计单位负责人 reveiews.DesignUnitCharge = model.DesignUnitCharge; //设计单位负责人职务 reveiews.DesignJob = model.DesignJob; ///项目经理(冗余) reveiews.ProjectManager = model.ProjectManager; ///项目经理职务(冗余) reveiews.ProjectJob = model.ProjectJob; ///占地面积 reveiews.LandArea = model.LandArea; ///加油机(台) reveiews.MachineofOilStage = model.MachineofOilStage; ///加气机(台) reveiews.MachineofGasStage = model.MachineofGasStage; ///储气机 reveiews.GasWells = model.GasWells; ///油罐 reveiews.OilTank = model.OilTank; ///罩棚面积(冗余) reveiews.Shelter = model.Shelter; ///站房面积(冗余) reveiews.StationRoom = model.StationRoom; ///便利店面积--暂时没有 reveiews.ConvenienceRoom = model.ConvenienceRoom; ///批复概算投资(冗余) reveiews.ReleaseInvestmentAmount = model.ReleaseInvestmentAmount; ///其他工程内容 reveiews.OtherProject = model.OtherProject; ///项目信息是否同步:是、否 reveiews.IsSynchro = model.IsSynchro; ///状态:暂存、待审核、审批通过、不通过 reveiews.State = model.State; ///工程费用 reveiews.EngineeringCost = model.EngineeringCost; ///其它费用 reveiews.OtherExpenses = model.OtherExpenses; ///土地费用 reveiews.LandCosts = model.LandCosts; ///估算投资 reveiews.PredictMoney = model.PredictMoney; ///地区公司 reveiews.RegionCompany = model.RegionCompany; //项目类型 reveiews.ProjectType = model.ProjectType; #endregion SetCurrentUser(reveiews); #region 设计方案流程申请 暂时注释 勿删!!! var XtWorkFlow = System.Configuration.ConfigurationManager.AppSettings.Get("XtWorkFlow"); if (model.State == (int)PreProjectState.WaitApproval && XtWorkFlow == "1") { TzDesignSchemeWorkFlowView view = new TzDesignSchemeWorkFlowView(); view.ApprovalNo = model.ApprovalNo; view.CompanyName = model.CompanyName; view.ConvenienceRoom = model.ConvenienceRoom.ToString(); view.DesignJob = model.DesignJob; view.DesignUnit = model.DesignUnit; view.DesignUnitCharge = model.DesignUnitCharge; view.Estimate = model.Estimate.ToString(); view.GasWells = model.GasWells.ToString(); view.InviteTime = string.Format("{0:yyyy-MM-dd}", model.InviteTime); view.IsSynchro = model.IsSynchro; view.LandArea = model.LandArea.ToString(); view.MachineofGasStage = model.MachineofGasStage.ToString(); view.MachineofOilStage = model.MachineofOilStage.ToString(); view.NatureName = model.NatureName; view.OilTank = model.OilTank.ToString(); view.OtheInvestment = model.OtheInvestment.ToString(); view.OtherProject = model.OtherProject; view.PredictMoney = model.PredictMoney.ToString(); view.ProjectCode = model.ProjectCode; view.ProjectJob = model.ProjectJob; view.ProjectManager = model.ProjectManager; view.ProjectName = model.ProjectName; view.ProvinceName = model.RegionCompany; view.ReleaseInvestmentAmount = model.ReleaseInvestmentAmount.ToString(); view.Shelter = model.Shelter.ToString(); view.StandarName = model.StandarName; view.StationName = model.StationName; view.StationRoom = model.StationRoom.ToString(); view.StationTypeName = model.ProjectType; view.TotalInvestment = model.TotalInvestment.ToString(); view.LandCosts = model.LandCosts.ToString(); view.EngineeringCost = model.EngineeringCost.ToString(); var baseUser = DataOperateBasic <Base_User> .Get().GetModel(reveiews.CreateUserId); if (baseUser == null) { throw new Exception("未找到申请人相关信息!"); } view.hr_sqr = baseUser.ObjeId; //上传附件 if (model.TzAttachs != null && model.TzAttachs.Any()) { //string baseFaleUrl = System.Configuration.ConfigurationManager.AppSettings.Get("XtDownloadUrl"); //foreach (var item in model.TzAttachs) //{ // string fileUrl = string.Format("{0}?fileId={1}&type={2}", baseFaleUrl, item.Id, item.TypeNo); // view.Temp_TzAttachs = fileUrl + '|' + view.Temp_TzAttachs; //} //if (view.Temp_TzAttachs != null) //{ // view.Temp_TzAttachs = view.Temp_TzAttachs.Substring(0, view.Temp_TzAttachs.Length - 1); //} view.Temp_TzAttachs = XtWorkFlowSubmitService.CreateXtAttachPath(model.TzAttachs); } reveiews.WorkFlowId = XtWorkFlowService.CreateDesignSchemeWorkFlow(view); } #endregion if (isAdd) { rows = DataOperateBusiness <Epm_TzDesignScheme> .Get().Add(reveiews); } else { rows = DataOperateBusiness <Epm_TzDesignScheme> .Get().Update(reveiews); } //上传附件 AddFilesBytzTable(reveiews, model.TzAttachs); result.Data = rows; result.Flag = EResultFlag.Success; // WriteLog(AdminModule.TzDesignScheme.GetText(), SystemRight.Add.GetText(), "新增: " + model.Id); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "AddTzDesignScheme"); } return(result); }
///<summary> ///修改: ///</summary> /// <param name="model">要修改的model</param> /// <returns>受影响的行数</returns> public Result <int> UpdateTzDesignScheme(Epm_TzDesignScheme model) { Result <int> result = new Result <int>(); try { var scheme = DataOperateBusiness <Epm_TzDesignScheme> .Get().Single(p => p.ProjectId == model.ProjectId); if (scheme == null) { throw new Exception("修改的数据不存在或者已被删除!"); } //生成设计方案信息 //scheme.ProjectId = model.ProjectId; //scheme.ProjectCode = model.ProjectCode; //scheme.ProjectName = model.ProjectName; //scheme.ApprovalNo = model.ApprovalNo; //scheme.Nature = model.Nature; //scheme.NatureName = model.NatureName; //scheme.ApplyTime = model.ApplyTime; //scheme.StationId = model.StationId; //scheme.StationCodeXt = model.StationCodeXt; //scheme.StationName = model.StationName; //scheme.CompanyId = model.CompanyId; //scheme.CompanyCodeXt = model.CompanyCodeXt; //scheme.CompanyName = model.CompanyName; //scheme.PredictMoney = model.PredictMoney; //scheme.DesignUnit = model.DesignUnit; //scheme.StandarCode = model.StandarCode; //scheme.StandarName = model.StandarName; //scheme.Estimate = model.Estimate; //scheme.TotalInvestment = model.TotalInvestment; //scheme.OtheInvestment = model.OtheInvestment; //scheme.InviteTime = model.InviteTime; //scheme.DesignUnitCharge = model.DesignUnitCharge; //scheme.DesignJob = model.DesignJob; //scheme.ProjectManager = model.ProjectManager; //scheme.ProjectJob = model.ProjectJob; //scheme.ConvenienceRoom = model.ConvenienceRoom; //scheme.ReleaseInvestmentAmount = model.ReleaseInvestmentAmount; //scheme.OtherProject = model.OtherProject; //scheme.IsSynchro = model.IsSynchro; //scheme.EngineeringCost = model.EngineeringCost; //scheme.OtherExpenses = model.OtherExpenses; //scheme.LandCosts = model.LandCosts; //scheme.RegionCompany = model.RegionCompany; //scheme.ProjectType = model.ProjectType; //scheme.LandArea = model.LandArea;//占地面积 //scheme.MachineofOilStage = model.MachineofOilStage;//加油机 //scheme.MachineofGasStage = model.MachineofGasStage;//加气机 //scheme.GasWells = model.GasWells;//储气井 //scheme.OilTank = model.OilTank;//油罐 //scheme.Shelter = model.Shelter;//罩棚面积 //scheme.StationRoom = model.StationRoom;//站房面积 //scheme.TotalInvestment = model.TotalInvestment;//批复概算投资 //scheme.ApprovalNo = model.ApprovalNo;//批复文号 SetCurrentUser(model); //上传附件 AddFilesBytzTable(model, model.TzAttachs); #region 设计方案流程申请 暂时注释 勿删!!! var XtWorkFlow = System.Configuration.ConfigurationManager.AppSettings.Get("XtWorkFlow"); if (model.State == (int)PreProjectState.WaitApproval && XtWorkFlow == "1") { TzDesignSchemeWorkFlowView view = new TzDesignSchemeWorkFlowView(); view.ApprovalNo = model.ApprovalNo; view.CompanyName = model.CompanyName; view.ConvenienceRoom = model.ConvenienceRoom.ToString(); view.DesignJob = model.DesignJob; view.DesignUnit = model.DesignUnit; view.DesignUnitCharge = model.DesignUnitCharge; view.Estimate = model.Estimate.ToString(); view.GasWells = model.GasWells.ToString(); view.InviteTime = string.Format("{0:yyyy-MM-dd}", model.InviteTime); view.IsSynchro = model.IsSynchro; view.LandArea = model.LandArea.ToString(); view.MachineofGasStage = model.MachineofGasStage.ToString(); view.MachineofOilStage = model.MachineofOilStage.ToString(); view.NatureName = model.NatureName; view.OilTank = model.OilTank.ToString(); view.OtheInvestment = model.OtheInvestment.ToString(); view.OtherProject = model.OtherProject; view.PredictMoney = model.PredictMoney.ToString(); view.ProjectCode = model.ProjectCode; view.ProjectJob = model.ProjectJob; view.ProjectManager = model.ProjectManager; view.ProjectName = model.ProjectName; view.ProvinceName = model.RegionCompany; view.ReleaseInvestmentAmount = model.ReleaseInvestmentAmount.ToString(); view.Shelter = model.Shelter.ToString(); view.StandarName = model.StandarName; view.StationName = model.StationName; view.StationRoom = model.StationRoom.ToString(); view.StationTypeName = model.ProjectType; view.TotalInvestment = model.TotalInvestment.ToString(); view.LandCosts = model.LandCosts.ToString(); view.EngineeringCost = model.EngineeringCost.ToString(); var baseUser = DataOperateBasic <Base_User> .Get().GetModel(model.CreateUserId); if (baseUser == null) { throw new Exception("未找到申请人相关信息!"); } view.hr_sqr = baseUser.ObjeId; //上传附件 if (model.TzAttachs != null && model.TzAttachs.Any()) { //string baseFaleUrl = System.Configuration.ConfigurationManager.AppSettings.Get("XtDownloadUrl"); //foreach (var item in model.TzAttachs) //{ // //string fileUrl = string.Format("{0}?fileId={1}&type={2}", baseFaleUrl, item.Id, item.TypeNo); // //view.Temp_TzAttachs = fileUrl + '|' + view.Temp_TzAttachs; // string fileUrl = XtWorkFlowService.GetXtAttachPaht(item.FilePath); // view.Temp_TzAttachs = fileUrl + '|' + view.Temp_TzAttachs; //} //if (view.Temp_TzAttachs != null) //{ // view.Temp_TzAttachs = view.Temp_TzAttachs.Substring(0, view.Temp_TzAttachs.Length - 1); //} view.Temp_TzAttachs = XtWorkFlowSubmitService.CreateXtAttachPath(model.TzAttachs); } model.WorkFlowId = XtWorkFlowService.CreateDesignSchemeWorkFlow(view); } #endregion var rows = DataOperateBusiness <Epm_TzDesignScheme> .Get().Update(model); result.Data = rows; result.Flag = EResultFlag.Success; // WriteLog(AdminModule.TzDesignScheme.GetText(), SystemRight.Modify.GetText(), "修改: " + model.Id); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "UpdateTzDesignScheme"); } return(result); }