public ActionResult Edit(Epm_TzConDrawing model)
{
Result <int> result = new Result <int>();
List <Base_Files> fileListFile = new List <Base_Files>();
string fileDataJson = Request.Form["fileDataJsonFile"];//获取上传文件json字符串
if (!string.IsNullOrEmpty(fileDataJson))
{
model.TzAttachs = JsonConvert.DeserializeObject <List <Epm_TzAttachs> >(fileDataJson);//将文件信息json字符
}
if (model.TzAttachs != null && model.TzAttachs.Count != 0)
{
var res = model.TzAttachs.Where(p => p.TypeNo.Contains("SGTZSHTZ")).FirstOrDefault();
if (res != null)
{
fileListFile = JsonConvert.DeserializeObject <List <Base_Files> >(fileDataJson);//将文件信息json字符---上传到图纸管理
}
}
using (ClientSiteClientProxy proxy = new ClientSiteClientProxy(ProxyEx(Request)))
{
result = proxy.UpdateTzConDrawing(model, fileListFile);
}
return(Json(result.ToResultView()));
}
public bool drawingToDraw(Epm_TzConDrawing model, List <Base_Files> fileListFile)
{
Epm_Draw ed = new Epm_Draw();
SetCreateUser(ed);
ed.ProjectId = model.ProjectId;
ed.ProjectName = model.ProjectName;
// ed.Name = model.;
//ed.Desciption = model.
//ed.VersionOrder = model.Desciption;
ed.VersionNo = "FirstVersion";
ed.VersionName = "首版本";
ed.SubmitUserId = CurrentUser.Id;
ed.SubmitUserName = CurrentUser.UserName;
ed.SubmitCompanyId = CurrentCompanyID.ToLongReq();
ed.SubmitCompanyName = CurrentCompanyName;
ed.SubmitDate = DateTime.Now;
ed.DesignCompanyId = model.CompanyId;
ed.DesignCompanyName = model.CompanyName;
ed.IsNew = true;
ed.State = (int)ApprovalState.ApprSuccess; //设置状态为已审核
ed.Remark = model.Remark;
ed.CrtCompanyId = model.CompanyId;
ed.CrtCompanyName = model.CompanyName;
ed.IsDelete = false;
ed.OperateTime = DateTime.Now;
ed.OperateUserId = CurrentUser.Id;
ed.OperateUserName = CurrentUser.UserName;
ed.IsValidate = false;
ed.CrtCompanyId = CurrentCompanyID.ToLongReq();
ed.CrtCompanyName = CurrentCompanyName;
var result = AddDraw(ed, fileListFile);//调用图纸管理新增服务-同步数据
if (result.Data < 1)
{
return(false);
}
return(true);
}
public TzConDrawingView()
{
TzProjectApproval = new Epm_TzProjectApprovalInfo();
TzConDrawing = new Epm_TzConDrawing();
}
/// <summary>
/// 修改设计方案状态
/// </summary>
/// <param name="id"></param>
/// <param name="state"></param>
/// <returns></returns>
public Result <int> UpdateTzDesignSchemeState(List <long> ids, string state)
{
Result <int> result = new Result <int>();
try
{
foreach (var item in ids)
{
var model = DataOperateBusiness <Epm_TzDesignScheme> .Get().GetModel(item);
if (model != null)
{
//SetCurrentUser(model);
model.State = (int)state.ToEnumReq <PreProjectApprovalState>();
var rows = DataOperateBusiness <Epm_TzDesignScheme> .Get().Update(model);
//如果状态是已经提交，自动生成施工图纸信息
if (model.State == (int)PreProjectApprovalState.ApprovalSuccess)
{
Epm_TzConDrawing tzdrawing = new Epm_TzConDrawing();//图纸实体
List <Base_Files> filesList = new List <Base_Files>();
tzdrawing.ProjectId = model.ProjectId; //项目ID
tzdrawing.State = (int)PreProjectState.WaitSubmitted; //状态
tzdrawing.ProjectCode = model.ProjectCode;
tzdrawing.ProjectName = model.ProjectName;
tzdrawing.ProjectId = model.ProjectId; //项目id
tzdrawing.ProjectCode = model.ProjectCode; //项目编码
tzdrawing.ProjectName = model.ProjectName; //项目名称
tzdrawing.ApprovalNo = model.ApprovalNo; //批复号
tzdrawing.Nature = model.Nature; //项目性质
tzdrawing.NatureName = model.NatureName; //项目性质名称
tzdrawing.ApplyTime = model.ApplyTime; //项目提出日期
tzdrawing.StationId = model.StationId; //站库id
tzdrawing.StationCodeXt = model.StationCodeXt; //站库协同编码
tzdrawing.StationName = model.StationName; //站库名称
tzdrawing.CompanyId = model.CompanyId; //地市公司id
tzdrawing.CompanyCodeXt = model.CompanyCodeXt; //地市公司协同编码
tzdrawing.CompanyName = model.CompanyName; //地市公司名称
AddTzConDrawing(tzdrawing, filesList);
}
result.Data = rows;
result.Flag = EResultFlag.Success;
#region 更新RPA数据
var hostAddress = System.Configuration.ConfigurationManager.AppSettings.Get("RPAPath");
var rpaModel = new RPA_TzDesignScheme();
var omadsModel = new OMADS_TzDesignScheme();
#region rpaModel
rpaModel.ApplyTime = model.ApplyTime;
rpaModel.ApprovalNo = model.ApprovalNo;
rpaModel.CompanyName = model.CompanyName;
rpaModel.ConvenienceRoom = model.ConvenienceRoom;
rpaModel.DesignJob = model.DesignJob;
rpaModel.DesignUnit = model.DesignUnit;
var files = GetFilesByTZTable("Epm_TzDesignScheme", model.Id);
for (int i = 0; i < files.Data.Count; i++)
{
rpaModel.FilePath += hostAddress + "?path=" + files.Data[i].FilePath + "&fileName=" + files.Data[i].Name + ',';
}
rpaModel.NatureName = model.NatureName;
rpaModel.DesignUnitCharge = model.DesignUnitCharge;
rpaModel.Estimate = model.Estimate;
rpaModel.FileNumber = files.Data.Count;
rpaModel.FollowOperate = "";
rpaModel.GasWells = model.GasWells;
rpaModel.ProjectCode = model.ProjectCode;
rpaModel.ProjectName = model.ProjectName;
rpaModel.InviteTime = model.InviteTime;
rpaModel.IsSynchro = model.IsSynchro;
rpaModel.LandArea = model.LandArea;
rpaModel.MachineofGasStage = model.MachineofGasStage;
rpaModel.Remark = model.Remark;
rpaModel.MachineofOilStage = model.MachineofOilStage;
rpaModel.StationName = model.StationName;
rpaModel.OilTank = model.OilTank;
rpaModel.OtheInvestment = model.OtheInvestment;
rpaModel.OtherProject = model.OtherProject;
rpaModel.ProjectJob = model.ProjectJob;
rpaModel.ProjectManager = model.ProjectManager;
rpaModel.ReleaseInvestmentAmount = model.ReleaseInvestmentAmount;
rpaModel.Shelter = model.Shelter;
rpaModel.StandarName = model.StandarName;
rpaModel.State = model.State;
var strName = model.CompanyName.Substring(0, 2);
switch (strName)
{
case "西安":
rpaModel.username = "******";
break;
case "咸阳":
rpaModel.username = "******";
break;
case "渭南":
rpaModel.username = "******";
break;
case "宝鸡":
rpaModel.username = "******";
break;
case "铜川":
rpaModel.username = "******";
break;
case "商洛":
rpaModel.username = "******";
break;
case "汉中":
rpaModel.username = "******";
break;
case "安康":
rpaModel.username = "******";
break;
case "榆林":
rpaModel.username = "******";
break;
case "延安":
rpaModel.username = "******";
break;
default:
break;
}
rpaModel.WriteMark = 0;
rpaModel.WriteResult = 0;
rpaModel.StationRoom = model.StationRoom;
rpaModel.status1 = 0;
rpaModel.status2 = 0;
rpaModel.status3 = 0;
rpaModel.TotalInvestment = model.TotalInvestment;
//SetCreateUser(rpaModel);
//SetCurrentUser(rpaModel);
rpaModel.OperateUserId = model.CreateUserId;
rpaModel.OperateUserName = model.CreateUserName;
rpaModel.OperateTime = DateTime.Now;
rpaModel.CreateUserId = model.CreateUserId;
rpaModel.CreateUserName = model.CreateUserName;
rpaModel.OperateTime = DateTime.Now;
#endregion
#region omadsModel
omadsModel.ApplyTime = model.ApplyTime;
omadsModel.ApprovalNo = model.ApprovalNo;
omadsModel.CompanyName = model.CompanyName;
omadsModel.ConvenienceRoom = model.ConvenienceRoom;
omadsModel.DesignJob = model.DesignJob;
omadsModel.DesignUnit = model.DesignUnit;
omadsModel.FilePath = rpaModel.FilePath;
omadsModel.NatureName = model.NatureName;
omadsModel.DesignUnitCharge = model.DesignUnitCharge;
omadsModel.Estimate = model.Estimate;
omadsModel.FileNumber = files.Data.Count;
omadsModel.FollowOperate = "";
omadsModel.GasWells = model.GasWells;
omadsModel.ProjectCode = model.ProjectCode;
omadsModel.ProjectName = model.ProjectName;
omadsModel.InviteTime = model.InviteTime;
omadsModel.IsSynchro = model.IsSynchro;
omadsModel.LandArea = model.LandArea;
omadsModel.MachineofGasStage = model.MachineofGasStage;
omadsModel.Remark = model.Remark;
omadsModel.MachineofOilStage = model.MachineofOilStage;
omadsModel.StationName = model.StationName;
omadsModel.OilTank = model.OilTank;
omadsModel.OtheInvestment = model.OtheInvestment;
omadsModel.OtherProject = model.OtherProject;
omadsModel.ProjectJob = model.ProjectJob;
omadsModel.ProjectManager = model.ProjectManager;
omadsModel.ReleaseInvestmentAmount = model.ReleaseInvestmentAmount;
omadsModel.Shelter = model.Shelter;
omadsModel.StandarName = model.StandarName;
omadsModel.State = model.State;
omadsModel.username = rpaModel.username;
omadsModel.WriteMark = 0;
omadsModel.WriteResult = 0;
omadsModel.StationRoom = model.StationRoom;
omadsModel.status1 = 0;
omadsModel.status2 = 0;
omadsModel.status3 = 0;
omadsModel.TotalInvestment = model.TotalInvestment;
//SetCreateUser(rpaModel);
//SetCurrentUser(rpaModel);
omadsModel.OperateUserId = model.CreateUserId;
omadsModel.OperateUserName = model.CreateUserName;
omadsModel.OperateTime = DateTime.Now;
omadsModel.CreateUserId = model.CreateUserId;
omadsModel.CreateUserName = model.CreateUserName;
omadsModel.OperateTime = DateTime.Now;
#endregion
DataOperateBusiness <RPA_TzDesignScheme> .Get().Add(rpaModel);
DataOperateBusiness <OMADS_TzDesignScheme> .Get().Add(omadsModel);
#endregion
}
else
{
throw new Exception("该设计方案信息不存在");
}
}
}
catch (Exception ex)
{
result.Data = -1;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "UpdateTzDesignSchemeState");
}
return(result);
}
///<summary>
///添加:
///</summary>
/// <param name="model">要添加的model</param>
/// <returns>受影响的行数</returns>
public Result <int> AddTzConDrawing(Epm_TzConDrawing model, List <Base_Files> baseEntity)
{
Result <int> result = new Result <int>();
try
{
int rows = 0;
bool isAdd = false;
var reveiews = DataOperateBusiness <Epm_TzConDrawing> .Get().GetList(t => t.ProjectId == model.ProjectId).FirstOrDefault();
var ApprovalInfo = DataOperateBusiness <Epm_TzProjectApprovalInfo> .Get().GetList(t => t.ProjectId == model.ProjectId).FirstOrDefault();
if (reveiews == null)
{
isAdd = true;
reveiews = new Epm_TzConDrawing();
//当前创建人
SetCreateUser(reveiews);
}
reveiews.ProjectId = model.ProjectId; //项目id
reveiews.ProjectCode = model.ProjectCode; //项目编码
reveiews.ProjectName = model.ProjectName; //项目名称
reveiews.ApprovalNo = model.ApprovalNo; //批复号
reveiews.Nature = model.Nature; //项目性质
reveiews.NatureName = model.NatureName; //项目性质名称
reveiews.ApplyTime = model.ApplyTime; //项目提出日期
reveiews.StationId = model.StationId; //站库id
reveiews.StationCodeXt = model.StationCodeXt; //站库协同编码
reveiews.StationName = model.StationName; //站库名称
reveiews.CompanyId = model.CompanyId; //地市公司id
reveiews.CompanyCodeXt = model.CompanyCodeXt; //地市公司协同编码
reveiews.CompanyName = model.CompanyName; //地市公司名称
reveiews.ReviewTime = model.ReviewTime; //评审日期
reveiews.Moderator = model.Moderator; //主持人
reveiews.ReviewAddress = model.ReviewAddress; //评审地点
reveiews.ReviewExperts = model.ReviewExperts; //评审专家
reveiews.Participants = model.Participants; //参会人员
reveiews.Conclusion = model.Conclusion; //评审结论
reveiews.State = model.State; //状态
reveiews.Remark = model.Remark; //备注
reveiews.DrawingId = model.DrawingId; //图纸id
reveiews.ProjectDrawingID = model.ProjectDrawingID; //施工项目id
//当前操作人
SetCurrentUser(reveiews);
//上传附件
AddFilesBytzTable(reveiews, model.TzAttachs);
#region 施工图纸会审流程申请 暂时注释 勿删！！！
var XtWorkFlow = System.Configuration.ConfigurationManager.AppSettings.Get("XtWorkFlow");
if (model.State == (int)PreProjectState.WaitApproval && XtWorkFlow == "1")
{
TzConDrawingWorkFlowView view = new TzConDrawingWorkFlowView();
view.CompanyName = model.CompanyName;
view.Conclusion = model.CompanyName;
view.Moderator = model.Moderator;
view.NatureName = model.NatureName;
view.Participants = model.Participants;
view.PredictMoney = "";
view.ProjectCode = model.ProjectCode;
view.ProjectName = model.ProjectName;
view.ProvinceName = model.CompanyName;
view.ReviewAddress = model.ReviewAddress;
view.ReviewExperts = model.ReviewExperts;
view.ReviewTime = model.ReviewTime.ToString();
view.StationName = model.StationName;
view.StationTypeName = model.Nature;
view.LandCosts = ApprovalInfo.LandCosts.ToString();
view.OtherExpenses = ApprovalInfo.OtherExpenses.ToString();
view.EngineeringCost = ApprovalInfo.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;
// 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);
}
reveiews.WorkFlowId = XtWorkFlowService.CreateConDrawingWorkFlow(view);
}
#endregion
if (isAdd)
{
rows = DataOperateBusiness <Epm_TzConDrawing> .Get().Add(reveiews);
}
else
{
rows = DataOperateBusiness <Epm_TzConDrawing> .Get().Update(reveiews);
}
if (baseEntity.Count != 0 && model.State == (int)PreProjectApprovalState.ApprovalSuccess) //如果附件选择了图纸类型&&状态是通过了审核，往图纸管理同步一条数据
{
baseEntity = baseEntity.Where(p => p.ImageType == "SGTZSHTZ").ToList(); //筛选附件是图纸类型（SGTZSHTZ）
drawingToDraw(reveiews, baseEntity); //整理图纸管理数据
}
result.Data = rows;
result.Flag = EResultFlag.Success;
// WriteLog(AdminModule.TzConDrawing.GetText(), SystemRight.Add.GetText(), "新增: " + model.Id);
}
catch (Exception ex)
{
result.Data = -1;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "AddTzConDrawing");
}
return(result);
}
///<summary>
///修改:
///</summary>
/// <param name="model">要修改的model</param>
/// <returns>受影响的行数</returns>
public Result <int> UpdateTzConDrawing(Epm_TzConDrawing model, List <Base_Files> baseEntity)
{
Result <int> result = new Result <int>();
try
{
var drawing = DataOperateBusiness <Epm_TzConDrawing> .Get().Single(p => p.Id == model.Id);
model.ProjectId = drawing.ProjectId; //项目ID
model.ProjectCode = drawing.ProjectCode; //项目编码
model.ProjectName = drawing.ProjectName; //项目名称
model.ApprovalNo = drawing.ApprovalNo; //项目批复号
model.Nature = drawing.Nature; //项目性质
model.NatureName = drawing.NatureName; //项目性质名称
model.ApplyTime = drawing.ApplyTime; //项目提出时间
model.StationId = drawing.StationId; //站库id
model.StationCodeXt = drawing.StationCodeXt; //站库协同编码
model.StationName = drawing.StationName; //站库名称
model.CompanyId = drawing.CompanyId; //地市公司ID
model.CompanyCodeXt = drawing.CompanyCodeXt; //地市公司编码
model.CompanyName = drawing.CompanyName; //地市公司名称
SetCurrentUser(model);
//上传图纸
AddFilesBytzTable(model, model.TzAttachs);
#region 施工图纸会审流程申请 暂时注释 勿删！！！
var XtWorkFlow = System.Configuration.ConfigurationManager.AppSettings.Get("XtWorkFlow");
if (model.State == (int)PreProjectState.WaitApproval && XtWorkFlow == "1")
{
TzConDrawingWorkFlowView view = new TzConDrawingWorkFlowView();
var baseUser = DataOperateBasic <Base_User> .Get().GetModel(model.CreateUserId);
if (baseUser == null)
{
throw new Exception("未找到申请人相关信息！");
}
else
{
view.hr_sqr = baseUser.ObjeId;
}
view.CompanyName = model.CompanyName;
view.Conclusion = model.CompanyName;
view.Moderator = model.Moderator;
view.NatureName = model.NatureName;
view.Participants = model.Participants;
view.PredictMoney = "";
view.ProjectCode = model.ProjectCode;
view.ProjectName = model.ProjectName;
view.ProvinceName = model.CompanyName;
view.ReviewAddress = model.ReviewAddress;
view.ReviewExperts = model.ReviewExperts;
view.ReviewTime = model.ReviewTime.ToString();
view.StationName = model.StationName;
view.StationTypeName = model.Nature;
//上传附件
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.CreateConDrawingWorkFlow(view);
}
#endregion
var rows = DataOperateBusiness <Epm_TzConDrawing> .Get().Update(model);
//AddFilesBytzTable(reveiews, model.TzAttachs);
//if (model.TzAttachs != null)
//{
// //删除之前的附件
// DeleteFilesByTable(model.GetType().Name, new List<long>() { model.Id });
// //新增附件
// AddFilesBytzTable(model, model.TzAttachs);
//}
//else
//{
// //删除之前的附件
// DeleteFilesByTable(model.GetType().Name, new List<long>() { model.Id });
//}
if (baseEntity.Count != 0 && model.State == (int)PreProjectApprovalState.ApprovalSuccess)//如果附件选择了图纸类型&&状态是通过了审核，往图纸管理同步一条数据
{
baseEntity = baseEntity.Where(p => p.ImageType == "SGTZSHTZ").ToList();
drawingToDraw(model, baseEntity);
}
result.Data = rows;
result.Flag = EResultFlag.Success;
// WriteLog(AdminModule.TzConDrawing.GetText(), SystemRight.Modify.GetText(), "修改: " + model.Id);
}
catch (Exception ex)
{
result.Data = -1;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "UpdateTzConDrawing");
}
return(result);
}
