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(); } }
// // 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/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/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); } } } }