protected override void OnFlowEnd(T_I_EngineeringBuildChange EngineeringInfo, S_WF_InsTaskExec taskExec, S_WF_InsDefRouting routing)
{
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
string EngineeringID = EngineeringInfo.EngineeringID;
var model = epcentity.Set <T_I_EngineeringBuild>().FirstOrDefault(a => a.ID == EngineeringID);
if (model != null && CurrentUserInfo != null)
{
model.Name = EngineeringInfo.Name;
model.CustomerInfo = EngineeringInfo.CustomerInfo;
model.CustomerInfoName = EngineeringInfo.CustomerInfoName;
model.SerialNumber = EngineeringInfo.SerialNumber;
model.ProjectClass = EngineeringInfo.ProjectClass;
model.BusinessSector = EngineeringInfo.BusinessSector;
model.ProjectStatus = EngineeringInfo.ProjectStatus;
model.MarketingMinorsReason = EngineeringInfo.MarketingMinorsReason;
model.ProjectLevelDesign = EngineeringInfo.ProjectLevelDesign;
model.ProjectLevelContract = EngineeringInfo.ProjectLevelContract;
model.ProjectManagementCategory = EngineeringInfo.ProjectManagementCategory;
model.Country = EngineeringInfo.Country;
model.Province = EngineeringInfo.Province;
model.City = EngineeringInfo.City;
model.ConstructionSite = EngineeringInfo.ConstructionSite;
model.Country = EngineeringInfo.Country;
model.BoxCategory = EngineeringInfo.BoxCategory;
model.Province = EngineeringInfo.Province;
model.City = EngineeringInfo.City;
model.IsNeedBid = EngineeringInfo.IsNeedBid;
model.ExpectedTenderDate = EngineeringInfo.ExpectedTenderDate;
model.IsNewEnergy = EngineeringInfo.IsNewEnergy;
model.NewEnergyType = EngineeringInfo.NewEnergyType;
model.AllEstimateInvestmentMoney = EngineeringInfo.AllEstimateInvestmentMoney;
model.EstimatedContractMoney = EngineeringInfo.EstimatedContractMoney;
model.CoverageArea = EngineeringInfo.CoverageArea;
model.ConstructionArea = EngineeringInfo.ConstructionArea;
model.ConstructionFeatures = EngineeringInfo.ConstructionFeatures;
model.WorkshopComposition = EngineeringInfo.WorkshopComposition;
model.ConstructionStandard = EngineeringInfo.ConstructionStandard;
model.OrganizationResources = EngineeringInfo.OrganizationResources;
model.ConstructionMode = EngineeringInfo.ConstructionMode;
model.Programme = EngineeringInfo.Programme;
model.ProductOrModels = EngineeringInfo.ProductOrModels;
model.Remark = EngineeringInfo.Remark;
model.ProjectManagerLeader = EngineeringInfo.ProjectManagerLeader;
// model.IndustryType = EngineeringInfo.IndustryType;
model.Code = EngineeringInfo.Code;
model.CodeName = EngineeringInfo.CodeName;
model.IndustryOne = EngineeringInfo.IndustryOne;
model.IndustryTwo = EngineeringInfo.IndustryTwo;
model.IndustryThree = EngineeringInfo.IndustryThree;
model.IndustryFour = EngineeringInfo.IndustryFour;
model.IndustryFive = EngineeringInfo.IndustryFive;
model.IsImpoartProject = EngineeringInfo.IsImpoartProject;
model.ProjectStartTime = EngineeringInfo.ProjectStartTime;
model.ProjectEndTime = EngineeringInfo.ProjectEndTime;
model.ProjectUpdateTime = EngineeringInfo.ProjectUpdateTime;
epcentity.SaveChanges();
}
}
public ActionResult Log()
{
string sql = "select Date,IsHoliday from S_C_Holiday where Year='" + DateTime.Now.Year + "' ";
var db = SQLHelper.CreateSqlHelper(ConnEnum.Base);
var engineeringInfoID = Request["EngineeringInfoID"];
var dt = db.ExecuteDataTable(sql);
ViewBag.Holiday = JsonHelper.ToJson(dt);
var entities = new EPCEntities();
var dateList = entities.T_C_ConstructionLog.Where(d => d.EngineeringInfo == engineeringInfoID).Select(d => d.DateD).Distinct().ToList();
ViewBag.FilledDate = String.Join(",", dateList);
return(View());
}
//
// GET: /Manage/DemandTaskNoticeView/
public JsonResult SetSubsidy(string ids, string val)
{
if (!string.IsNullOrEmpty(ids) && !string.IsNullOrEmpty(val))
{
ids = ids.Trim(',');
string[] strid = ids.Split(',');
EPCEntities epcent = FormulaHelper.GetEntities <EPCEntities>();
var lists = epcent.Set <T_I_DemandTaskNotice>().Where(c => ids.Contains(c.ID));
foreach (T_I_DemandTaskNotice item in lists)
{
item.IsSubsidy = val;
}
epcent.SaveChanges();
}
return(Json(""));
}
//
// GET: /Manage/EngineeringChange/
protected override void AfterGetData(DataTable dt, bool isNew, string upperVersionID)
{
if (isNew)
{
string EngineeringID = GetQueryString("EngineeringID");
if (!string.IsNullOrEmpty(EngineeringID))
{
int maxNumber = 0;
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
var EngineeringInfo = epcentity.Set <T_I_EngineeringBuild>().FirstOrDefault(a => a.ID == EngineeringID);
var Engineerings = epcentity.Set <T_I_EngineeringBuildChange>().Where(c => c.EngineeringID == EngineeringID);
if (Engineerings != null && Engineerings.Count() > 0)
{
maxNumber = Engineerings.ToList().Max(c => Convert.ToInt32(c.VersionNumber));
}
maxNumber++;
if (EngineeringInfo != null)
{
Type tp = EngineeringInfo.GetType();
var ps = tp.GetProperties();
DataRow dtr = dt.Rows[0];
foreach (PropertyInfo item in ps)
{
string cname = item.Name;
string type = item.PropertyType.Name;
if (type != "ICollection`1" && cname != "EngineeringID" && cname != "VersionNumber" && dt.Columns.Contains(cname))
{
object value = item.GetValue(EngineeringInfo, null);
if (cname == "ID")
{
dtr.SetField("EngineeringID", value);
}
else
{
dtr.SetField(cname, value);
}
}
dtr.SetField("VersionNumber", maxNumber);
}
}
}
}
}
//
// GET: /Manage/CustomerClassification/
protected override void BeforeSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
if (dic != null && dic.ContainsKey("CustomerIDs") && dic.ContainsKey("CustomerClassification"))
{
string ids = dic["CustomerIDs"];
string value = dic["CustomerClassification"];
if (!string.IsNullOrEmpty(ids))
{
ids = ids.Trim(',');
string[] eids = ids.Split(',');
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
var ctms = epcentity.Set <S_M_CustomerInfo>().Where(c => eids.Contains(c.ID));
foreach (S_M_CustomerInfo item in ctms)
{
item.CustomerClassification = value;
}
epcentity.SaveChanges();
}
}
}
public JsonResult GetDataListDetail(QueryBuilder qb, string T_M_ContractInfo)
{
//QueryBuilder qb = new QueryBuilder();
foreach (ConditionItem item in qb.Items)
{
if (item.Method == QueryMethod.IsEmpty)
{
item.Method = QueryMethod.Equal;
item.Value = "";
}
}
qb.Items.Add(new ConditionItem()
{
Field = "T_M_ContractInfo", Value = T_M_ContractInfo, Method = 0
});
EPCEntities epc = FormulaHelper.GetEntities <EPCEntities>();
var data = epc.Set <S_M_ContractInfo_Supplementary>().WhereToGridData <S_M_ContractInfo_Supplementary>(qb);
return(Json(data));
}
//如果竞争对手时新增数据 反写竞争对手列表
protected override void BeforeSaveDetail(Dictionary <string, string> dic, string subTableName, Dictionary <string, string> detail, List <Dictionary <string, string> > detailList, S_UI_Form formInfo)
{
if (subTableName == "Competitors")
{
string EnterprisenameID = "";
if (detail.ContainsKey("EnterprisenameID"))
{
EnterprisenameID = detail["EnterprisenameID"];
}
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
var Peerinfomanagement = epcentity.Set <S_M_Peerinfomanagement>();
S_M_Peerinfomanagement model = new S_M_Peerinfomanagement();
if (string.IsNullOrEmpty(EnterprisenameID))
{
model.ID = FormulaHelper.CreateGuid();
model.Name = detail["Enterprisename"];
model.CreateUser = CurrentUserInfo.UserName;
model.CreateUserID = CurrentUserInfo.UserID;
model.CreateDate = DateTime.Now;
model.OrgID = CurrentUserInfo.UserOrgID;
model.CompanyID = CurrentUserInfo.UserCompanyID;
model.FlowPhase = "Start";
model.ModifyDate = DateTime.Now;
model.ModifyUserID = CurrentUserInfo.UserID;
model.ModifyUser = CurrentUserInfo.UserName;
model.Companyprofile = detail["Companyprofile"];
model.Operatingconditions = detail["Operatingconditions"];
model.Businessqualification = detail["Businessqualification"];
model.Technicalability = detail["Technicalability"];
model.Projectperformance = detail["Projectperformance"];
model.Certificationsystem = detail["Certificationsystem"];
Peerinfomanagement.Add(model);
epcentity.SaveChanges();
}
}
}
protected override void AfterGetData(DataTable dt, bool isNew, string upperVersionID)
{
if (isNew)
{
string ContractInfoID = GetQueryString("ContractInfoID");
if (!string.IsNullOrEmpty(ContractInfoID))
{
int maxNumber = 0;
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
var ContractInfo = epcentity.Set <T_M_ContractInfo>().FirstOrDefault(a => a.ID == ContractInfoID);
var Contracts = epcentity.Set <T_M_ContractInfoChange>().Where(c => c.ContractInfoID == ContractInfoID);
if (Contracts != null && Contracts.Count() > 0)
{
maxNumber = Contracts.ToList().Max(c => Convert.ToInt32(c.VersionNumber));
}
maxNumber++;
if (ContractInfo != null)
{
Type tp = ContractInfo.GetType();
var ps = tp.GetProperties();
DataRow dtr = dt.Rows[0];
var ContractInfoReceivePlan = epcentity.Set <T_M_ContractInfo_ReceivePlan>().Where(a => a.T_M_ContractInfoID == ContractInfoID);
var HTEAFPFJ = epcentity.Set <T_M_ContractInfo_HTEAFPFJ>().Where(a => a.T_M_ContractInfoID == ContractInfoID);
string lms = "";
string strht = "";
if (HTEAFPFJ != null && HTEAFPFJ.Count() > 0)
{
List <T_M_ContractInfo_HTEAFPFJ> smcil = HTEAFPFJ.ToList();
List <T_M_ContractInfoChange_HTEAFPFJ> tcclm = new List <T_M_ContractInfoChange_HTEAFPFJ>();
var psc = typeof(T_M_ContractInfoChange_ReceivePlan).GetProperties();
foreach (T_M_ContractInfo_HTEAFPFJ item in smcil)
{
T_M_ContractInfoChange_HTEAFPFJ smclk = new T_M_ContractInfoChange_HTEAFPFJ();
foreach (PropertyInfo pc in psc)
{
string cname = pc.Name;
string type = pc.PropertyType.Name;
object value = pc.GetValue(item, null);
if (type != "ICollection`1" && cname != "ID" && value != null)
{
pc.SetValue(smclk, value, null);
}
}
tcclm.Add(smclk);
}
strht = JsonConvert.SerializeObject(tcclm);
}
if (ContractInfoReceivePlan != null && ContractInfoReceivePlan.Count() > 0)
{
List <T_M_ContractInfo_ReceivePlan> smcil = ContractInfoReceivePlan.ToList();
List <T_M_ContractInfoChange_ReceivePlan> tcclm = new List <T_M_ContractInfoChange_ReceivePlan>();
var psc = typeof(T_M_ContractInfoChange_ReceivePlan).GetProperties();
foreach (T_M_ContractInfo_ReceivePlan item in smcil)
{
T_M_ContractInfoChange_ReceivePlan smclk = new T_M_ContractInfoChange_ReceivePlan();
foreach (PropertyInfo pc in psc)
{
string cname = pc.Name;
string type = pc.PropertyType.Name;
object value = pc.GetValue(item, null);
if (type != "ICollection`1" && cname != "ID" && value != null)
{
pc.SetValue(smclk, value, null);
}
}
tcclm.Add(smclk);
}
lms = JsonConvert.SerializeObject(tcclm);
}
foreach (PropertyInfo item in ps)
{
string cname = item.Name;
string type = item.PropertyType.Name;
if (type != "ICollection`1" && cname != "ContractInfoID" && cname != "VersionNumber" && dt.Columns.Contains(cname))
{
object value = item.GetValue(ContractInfo, null);
if (cname == "ID")
{
dtr.SetField("ContractInfoID", value);
}
else
{
dtr.SetField(cname, value);
}
}
}
dtr.SetField("VersionNumber", maxNumber);
dtr.SetField("ReceivePlan", lms);
dtr.SetField("HTEAFPFJ", HTEAFPFJ);
}
}
}
}
protected override void OnFlowEnd(T_C_CustomerinfoChange CustomerInfo, S_WF_InsTaskExec taskExec, S_WF_InsDefRouting routing)
{
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
string CustomerID = CustomerInfo.CustomerID;
var model = epcentity.Set <S_M_CustomerInfo>().FirstOrDefault(a => a.ID == CustomerID);
if (model != null && CurrentUserInfo != null)
{
model.Name = CustomerInfo.Name;
model.Socialcreditcode = CustomerInfo.Socialcreditcode;
model.Highunit = CustomerInfo.Highunit;
model.HighunitName = CustomerInfo.HighunitName;
model.SimpleName = CustomerInfo.SimpleName;
model.Englishname = CustomerInfo.Englishname;
model.Usedname1 = CustomerInfo.Usedname1;
model.Usedname2 = CustomerInfo.Usedname2;
model.Customersite = CustomerInfo.Customersite;
model.Related = CustomerInfo.Related;
model.JuridicalPerson = CustomerInfo.JuridicalPerson;
model.Registered = CustomerInfo.Registered;
model.Registeredcapital = CustomerInfo.Registeredcapital;
model.Enterprisenature = CustomerInfo.Enterprisenature;
model.Industrystatus = CustomerInfo.Industrystatus;
model.Setupdate = CustomerInfo.Setupdate;
model.Country = CustomerInfo.Country;
model.Businesstypes = CustomerInfo.Businesstypes;
model.ZipCode = CustomerInfo.ZipCode;
model.Province = CustomerInfo.Province;
model.City = CustomerInfo.City;
model.Primarycontact = CustomerInfo.Primarycontact;
model.Contactphone = CustomerInfo.Contactphone;
model.Fax = CustomerInfo.Fax;
model.Email = CustomerInfo.Email;
model.Companyprofile = CustomerInfo.Companyprofile;
model.Enterpriseculture = CustomerInfo.Enterpriseculture;
model.Registrar = CustomerInfo.Registrar;
model.RegistrarName = CustomerInfo.RegistrarName;
model.Registrationdate = CustomerInfo.Registrationdate;
model.InvoiceName = CustomerInfo.InvoiceName;
model.TaxAccounts = CustomerInfo.TaxAccounts;
model.BankName = CustomerInfo.BankName;
model.BankAccounts = CustomerInfo.BankAccounts;
model.BankAddress = CustomerInfo.BankAddress;
model.Telephone = CustomerInfo.Telephone;
model.Attachments = CustomerInfo.Attachments;
model.Remark = CustomerInfo.Attachments;
model.Businessscope = CustomerInfo.Businessscope;
var linkmans = epcentity.Set <S_M_CustomerInfo_LinkMan>().Where(a => a.S_M_CustomerInfoID == CustomerID);
if (linkmans != null && linkmans.Count() > 0)
{
var listmo = linkmans.ToList();
listmo.ForEach(c => {
epcentity.Set <S_M_CustomerInfo_LinkMan>().Remove(c);
});
}
var lkms = CustomerInfo.T_C_CustomerinfoChange_LinkMan;
if (lkms != null)
{
List <T_C_CustomerinfoChange_LinkMan> listlm = lkms.ToList();
foreach (T_C_CustomerinfoChange_LinkMan item in listlm)
{
S_M_CustomerInfo_LinkMan smclk = new S_M_CustomerInfo_LinkMan();
smclk.Name = item.Name;
smclk.Position = item.Position;
smclk.Sex = item.Sex;
smclk.Phone = item.Phone;
smclk.EMail = item.EMail;
smclk.ID = FormulaHelper.CreateGuid();
smclk.S_M_CustomerInfoID = CustomerID;
epcentity.Set <S_M_CustomerInfo_LinkMan>().Add(smclk);
}
}
epcentity.SaveChanges();
}
}
//
// GET: /Manage/CustomerChange
protected override void AfterGetData(DataTable dt, bool isNew, string upperVersionID)
{
if (isNew)
{
string CustomerID = GetQueryString("CustomerID");
if (!string.IsNullOrEmpty(CustomerID))
{
int maxNumber = 0;
EPCEntities epcentity = FormulaHelper.GetEntities <EPCEntities>();
var CustomerInfo = epcentity.Set <S_M_CustomerInfo>().FirstOrDefault(a => a.ID == CustomerID);
var Customers = epcentity.Set <T_C_CustomerinfoChange>().Where(c => c.CustomerID == CustomerID);
if (Customers != null && Customers.Count() > 0)
{
maxNumber = Customers.ToList().Max(c => Convert.ToInt32(c.VersionNumber));
}
maxNumber++;
if (CustomerInfo != null)
{
Type tp = CustomerInfo.GetType();
var ps = tp.GetProperties();
DataRow dtr = dt.Rows[0];
var CustomerInfoLinkMan = epcentity.Set <S_M_CustomerInfo_LinkMan>().Where(a => a.S_M_CustomerInfoID == CustomerID);
string lms = "";
if (CustomerInfoLinkMan != null && CustomerInfoLinkMan.Count() > 0)
{
List <S_M_CustomerInfo_LinkMan> smcil = CustomerInfoLinkMan.ToList();
List <T_C_CustomerinfoChange_LinkMan> tcclm = new List <T_C_CustomerinfoChange_LinkMan>();
foreach (S_M_CustomerInfo_LinkMan item in smcil)
{
T_C_CustomerinfoChange_LinkMan smclk = new T_C_CustomerinfoChange_LinkMan();
smclk.Name = item.Name;
smclk.Position = item.Position;
smclk.Sex = item.Sex;
smclk.Phone = item.Phone;
smclk.EMail = item.EMail;
tcclm.Add(smclk);
}
lms = JsonConvert.SerializeObject(tcclm);
// JavaScriptSerializer js = new JavaScriptSerializer();
//lms=js.Serialize(smcil);
}
foreach (PropertyInfo item in ps)
{
string cname = item.Name;
string type = item.PropertyType.Name;
if (type != "ICollection`1" && cname != "CustomerID" && cname != "VersionNumber" && dt.Columns.Contains(cname))
{
object value = item.GetValue(CustomerInfo, null);
if (cname == "ID")
{
dtr.SetField("CustomerID", value);
}
else
{
dtr.SetField(cname, value);
}
}
}
dtr.SetField("VersionNumber", maxNumber);
dtr.SetField("LinkMan", lms);
}
}
}
}
