public ActionResult Add(TzResearchView model)
{
Result <int> result = new Result <int>();
string fileDataJson = Request.Form["fileDataJsonFile"];//获取上传文件json字符串
if (!string.IsNullOrEmpty(fileDataJson))
{
model.TzAttachs = JsonConvert.DeserializeObject <List <Epm_TzAttachs> >(fileDataJson);//将文件信息json字符
}
using (ClientSiteClientProxy proxy = new ClientSiteClientProxy(ProxyEx(Request)))
{
result = proxy.AddTzSiteSurvey(model);
}
return(Json(result.ToResultView()));
}
public Result <int> UpdateReformRecordState(List <long> ids, string state)
{
Result <int> result = new Result <int>();
try
{
foreach (var item in ids)
{
var model = DataOperateBusiness <Epm_ReformRecord> .Get().GetModel(item);
var userModel = DataOperateBasic <Base_User> .Get().GetModel(model.OperateUserId);
if (model != null)
{
//SetCurrentUser(model);
model.State = (int)state.ToEnumReq <PreProjectApprovalState>();
var rows = DataOperateBusiness <Epm_ReformRecord> .Get().Update(model);
if (model.State == (int)PreProjectState.ApprovalSuccess)
{
TzResearchView view = new TzResearchView();
view.ProjectId = model.Id;
view.State = (int)PreProjectState.WaitSubmitted;
AddTzSiteSurvey(view);
}
result.Data = rows;
result.Flag = EResultFlag.Success;
#region 更新RPA数据
var hostAddress = System.Configuration.ConfigurationManager.AppSettings.Get("RPAPath");
var rpaModel = new RPA_ReformRecordHX();
var omadsModel = new OMADS_ReformRecordHX();
var tempModel = new TEMP_ReformRecordHX();
#region rpaModel
rpaModel.AnnexType = model.AnnexType;
rpaModel.Approver = model.Approver;
rpaModel.CompanyName = model.CompanyName;
rpaModel.ApproveRemark = model.ApproveRemark;
rpaModel.ApproveResult = model.ApproveResult == 0 ?"审批通过": model.ApproveResult == 1?"审批不通过":"";
rpaModel.ApproveTime = model.ApproveTime;
var files = GetFilesByTZTable("Epm_ReformRecord", 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.AreaCompanyCode = model.AreaCompanyCode;
rpaModel.AreaCompanyName = model.AreaCompanyName;
rpaModel.DecisionMaker = model.DecisionMaker;
rpaModel.InitialMoney = model.InitialMoney;
rpaModel.InitialNumber = model.InitialNumber;
rpaModel.InitialSalesOfGas = model.InitialSalesOfGas;
rpaModel.InitialSalesOfRefinedOil = model.InitialSalesOfRefinedOil;
rpaModel.ProjectName = model.ProjectName;
rpaModel.Investment = model.Investment;
rpaModel.IRR = model.IRR;
rpaModel.ItemMoney = model.ItemMoney;
rpaModel.ItemNumber = model.ItemNumber;
rpaModel.ItemTime = model.ItemTime;
rpaModel.ItemUnit = model.ItemUnit;
rpaModel.LeaderPerson = model.LeaderPerson;
rpaModel.LimitType = model.LimitType;
rpaModel.PipetteCoding = model.PipetteCoding;
rpaModel.ProjectContent = model.ProjectContent;
rpaModel.Remark = model.Remark;
rpaModel.RemarkEndTime = model.RemarkEndTime;
rpaModel.RemarkMoney = model.RemarkMoney;
rpaModel.RemarkSalesOfGas = model.RemarkSalesOfGas;
rpaModel.RemarkSalesOfRefinedOil = model.RemarkSalesOfRefinedOil;
rpaModel.RemarkStartTime = model.RemarkStartTime;
rpaModel.RemarkType = model.RemarkType;
rpaModel.SourceFund = model.SourceFund;
rpaModel.StationName = model.StationName;
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.FollowOperate = "";
rpaModel.FileNumber = files.Data.Count;
SetCreateUser(rpaModel);
SetCurrentUser(rpaModel);
#endregion
#region omadsModel
omadsModel.AnnexType = model.AnnexType;
omadsModel.Approver = model.Approver;
omadsModel.CompanyName = model.CompanyName;
omadsModel.ApproveRemark = model.ApproveRemark;
omadsModel.ApproveResult = model.ApproveResult == 0 ? "审批通过" : model.ApproveResult == 1 ? "审批不通过" : "";
omadsModel.ApproveTime = model.ApproveTime;
var ofiles = GetFilesByTZTable("Epm_ReformRecord", model.Id);
for (int i = 0; i < ofiles.Data.Count; i++)
{
omadsModel.FilePath += hostAddress + "?path=" + ofiles.Data[i].FilePath + "&fileName=" + ofiles.Data[i].Name + ',';
}
omadsModel.AreaCompanyCode = model.AreaCompanyCode;
omadsModel.AreaCompanyName = model.AreaCompanyName;
omadsModel.DecisionMaker = model.DecisionMaker;
omadsModel.InitialMoney = model.InitialMoney;
omadsModel.InitialNumber = model.InitialNumber;
omadsModel.InitialSalesOfGas = model.InitialSalesOfGas;
omadsModel.InitialSalesOfRefinedOil = model.InitialSalesOfRefinedOil;
omadsModel.ProjectName = model.ProjectName;
omadsModel.Investment = model.Investment;
omadsModel.IRR = model.IRR;
omadsModel.ItemMoney = model.ItemMoney;
omadsModel.ItemNumber = model.ItemNumber;
omadsModel.ItemTime = model.ItemTime;
omadsModel.ItemUnit = model.ItemUnit;
omadsModel.LeaderPerson = model.LeaderPerson;
omadsModel.LimitType = model.LimitType;
omadsModel.PipetteCoding = model.PipetteCoding;
omadsModel.ProjectContent = model.ProjectContent;
omadsModel.Remark = model.Remark;
omadsModel.RemarkEndTime = model.RemarkEndTime;
omadsModel.RemarkMoney = model.RemarkMoney;
omadsModel.RemarkSalesOfGas = model.RemarkSalesOfGas;
omadsModel.RemarkSalesOfRefinedOil = model.RemarkSalesOfRefinedOil;
omadsModel.RemarkStartTime = model.RemarkStartTime;
omadsModel.RemarkType = model.RemarkType;
omadsModel.SourceFund = model.SourceFund;
omadsModel.StationName = model.StationName;
omadsModel.username = rpaModel.username;
omadsModel.WriteMark = 0;
omadsModel.WriteResult = 0;
omadsModel.FollowOperate = "";
omadsModel.FileNumber = files.Data.Count;
SetCreateUser(omadsModel);
SetCurrentUser(omadsModel);
#endregion
#region tempModel
tempModel.AnnexType = model.AnnexType;
tempModel.Approver = model.Approver;
tempModel.CompanyName = model.CompanyName;
tempModel.ApproveRemark = model.ApproveRemark;
tempModel.ApproveResult = model.ApproveResult == 0 ? "审批通过" : model.ApproveResult == 1 ? "审批不通过" : "";
tempModel.ApproveTime = model.ApproveTime;
var tfiles = GetFilesByTZTable("Epm_ReformRecord", model.Id);
for (int i = 0; i < files.Data.Count; i++)
{
tempModel.FilePath += hostAddress + "?path=" + tfiles.Data[i].FilePath + "&fileName=" + tfiles.Data[i].Name + ',';
}
tempModel.AreaCompanyCode = model.AreaCompanyCode;
tempModel.AreaCompanyName = model.AreaCompanyName;
tempModel.DecisionMaker = model.DecisionMaker;
tempModel.InitialMoney = model.InitialMoney;
tempModel.InitialNumber = model.InitialNumber;
tempModel.InitialSalesOfGas = model.InitialSalesOfGas;
tempModel.InitialSalesOfRefinedOil = model.InitialSalesOfRefinedOil;
tempModel.ProjectName = model.ProjectName;
tempModel.Investment = model.Investment;
tempModel.IRR = model.IRR;
tempModel.ItemMoney = model.ItemMoney;
tempModel.ItemNumber = model.ItemNumber;
tempModel.ItemTime = model.ItemTime;
tempModel.ItemUnit = model.ItemUnit;
tempModel.LeaderPerson = model.LeaderPerson;
tempModel.LimitType = model.LimitType;
tempModel.PipetteCoding = model.PipetteCoding;
tempModel.ProjectContent = model.ProjectContent;
tempModel.Remark = model.Remark;
tempModel.RemarkEndTime = model.RemarkEndTime;
tempModel.RemarkMoney = model.RemarkMoney;
tempModel.RemarkSalesOfGas = model.RemarkSalesOfGas;
tempModel.RemarkSalesOfRefinedOil = model.RemarkSalesOfRefinedOil;
tempModel.RemarkStartTime = model.RemarkStartTime;
tempModel.RemarkType = model.RemarkType;
tempModel.SourceFund = model.SourceFund;
tempModel.StationName = model.StationName;
tempModel.username = rpaModel.username;
tempModel.WriteMark = 0;
tempModel.WriteResult = 0;
tempModel.FollowOperate = "";
tempModel.FileNumber = files.Data.Count;
SetCreateUser(tempModel);
SetCurrentUser(tempModel);
#endregion
DataOperateBusiness <RPA_ReformRecordHX> .Get().Add(rpaModel);
DataOperateBusiness <OMADS_ReformRecordHX> .Get().Add(omadsModel);
DataOperateBusiness <TEMP_ReformRecordHX> .Get().Add(tempModel);
#endregion
}
else
{
throw new Exception("该项目信息不存在");
}
}
}
catch (Exception ex)
{
result.Data = -1;
result.Flag = EResultFlag.Failure;
result.Exception = new ExceptionEx(ex, "UpdateReformRecordState");
}
return(result);
}
