public override string ToString() { if (Employee == null) { using (var db = new OBContext()) { Employee = db.Employee.Find(EmployeeId); } } return Employee + "_" + School + "_" + Major; }
public override string ToString() { if (Employee == null) { using (var db = new OBContext()) { Employee = db.Employee.Find(EmployeeId); } } return(Employee + "_" + Name); }
public override string ToString() { if (Client == null) { using (var db = new OBContext()) { Client = db.Client.Find(ClientId); } } return(Client + "_" + Name); }
public override string ToString() { if (WeightClient == null) { using (var db = new OBContext()) { WeightClient = db.Client.Find(WeightClientId); } } return(WeightClient + "权重"); }
public override string ToString() { if (Client == null) { using (var db = new OBContext()) { Client = db.Client.Find(ClientId); } } return Client + "_" + Name; }
public override string ToString() { if (Employee == null) { using (var db = new OBContext()) { Employee = db.Employee.Find(EmployeeId); Document = db.Document.Find(DocumentId); } } return Employee + "_" + Document; }
public override string ToString() { if (Employee == null) { using (var db = new OBContext()) { Employee = db.Employee.Find(EmployeeId); Document = db.Document.Find(DocumentId); } } return(Employee + "_" + Document); }
public override string ToString() { if (Client == null) { using (var db = new OBContext()) { Client = db.Client.Find(ClientId); PensionCity = db.City.Find(PensionCityId); } } return(Client + "_" + PensionCity + "_" + "资料"); }
public override string ToString() { if (Client == null) { using (var db = new OBContext()) { Client = db.Client.Find(ClientId); PensionCity = db.City.Find(PensionCityId); } } return Client + "_" + PensionCity + "_" + "资料"; }
public override string ToString() { if (Client == null || City == null || Supplier == null) { using (var db = new OBContext()) { Client = db.Client.Find(ClientId); City = db.City.Find(CityId); Supplier = db.Supplier.Find(SupplierId); } } return(Client + "_" + City + "_" + Supplier + "_" + HukouType); }
public JsonResult ClientCustomField(int employeeId) { using (OBContext db = new OBContext()) { var clientId = db.Employee.Where(a => a.Id == employeeId).Select(a => a.ClientId).SingleOrDefault(); Object ob = (from a in db.CustomField where a.ClientId == clientId select new { BasicInfo1 = a.BasicInfo1.Trim(), BasicInfo2 = a.BasicInfo2.Trim(), BasicInfo3 = a.BasicInfo3.Trim(), BasicInfo4 = a.BasicInfo4.Trim(), BasicInfo5 = a.BasicInfo5.Trim(), BasicInfo6 = a.BasicInfo6.Trim(), BasicInfo7 = a.BasicInfo7.Trim(), BasicInfo8 = a.BasicInfo8.Trim(), BasicInfo9 = a.BasicInfo9.Trim(), BasicInfo10 = a.BasicInfo10.Trim(), //// PensionInfo1 = a.PensionInfo1.Trim(), PensionInfo2 = a.PensionInfo2.Trim(), PensionInfo3 = a.PensionInfo3.Trim(), PensionInfo4 = a.PensionInfo4.Trim(), PensionInfo5 = a.PensionInfo5.Trim(), //// HireInfo1 = a.HireInfo1.Trim(), HireInfo2 = a.HireInfo2.Trim(), HireInfo3 = a.HireInfo3.Trim(), HireInfo4 = a.HireInfo4.Trim(), HireInfo5 = a.HireInfo5.Trim(), HireInfo6 = a.HireInfo6.Trim(), HireInfo7 = a.HireInfo7.Trim(), HireInfo8 = a.HireInfo8.Trim(), HireInfo9 = a.HireInfo9.Trim(), HireInfo10 = a.HireInfo10.Trim(), HireInfo11 = a.HireInfo11.Trim(), HireInfo12 = a.HireInfo12.Trim(), HireInfo13 = a.HireInfo13.Trim(), HireInfo14 = a.HireInfo14.Trim(), HireInfo15 = a.HireInfo15.Trim(), HireInfo16 = a.HireInfo16.Trim(), HireInfo17 = a.HireInfo17.Trim(), HireInfo18 = a.HireInfo18.Trim(), HireInfo19 = a.HireInfo19.Trim(), HireInfo20 = a.HireInfo20.Trim() } ).AsNoTracking().FirstOrDefault(); return(this.Json(ob, JsonRequestBehavior.AllowGet)); } }
protected void Application_Start() { //建立数据库 Database.SetInitializer<OBContext>(new OBInitializer()); using (var context = new OBContext()) { System.Data.Objects.ObjectContext objcontext = ((IObjectContextAdapter)context).ObjectContext; } //调用WebSecurity的方法前需先调用InitializeDatabaseConnection初始化 if (!WebSecurity.Initialized) WebSecurity.InitializeDatabaseConnection("OB", "User", "Id", "Name", autoCreateTables: true); AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); AuthConfig.RegisterAuth(); }
protected void Application_Start() { //建立数据库 Database.SetInitializer <OBContext>(new OBInitializer()); using (var context = new OBContext()) { System.Data.Objects.ObjectContext objcontext = ((IObjectContextAdapter)context).ObjectContext; } //调用WebSecurity的方法前需先调用InitializeDatabaseConnection初始化 if (!WebSecurity.Initialized) { WebSecurity.InitializeDatabaseConnection("OB", "User", "Id", "Name", autoCreateTables: true); } AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); AuthConfig.RegisterAuth(); }
public string GetPercent() { // 取权重 Weight weight; using (var db = new OBContext()) { weight = db.Weight.Where(a => a.WeightClientId == ClientId).SingleOrDefault(); if (weight == null) { weight = db.Weight.Where(a => a.WeightClientId == null).Single(); } } // 取得普通权重 PropertyInfo[] fs = typeof(Weight).GetProperties(); decimal count = 0; decimal total = 0; string[] exclude = { "Id", "WeightClientId", "WeightClient", "IsDeleted" }; string[] collection = { "Educations", "Works", "Families" }; foreach (PropertyInfo item in fs) { if (exclude.Contains(item.Name)) { continue; } else { var t = typeof(Employee).GetProperty(item.Name); var v = t.GetValue(this); if ((collection.Contains(item.Name) && Convert.ToInt32(v.GetType().GetProperty("Count").GetValue(v)) > 0) || (!(collection.Contains(item.Name)) && v != null)) { count += Convert.ToInt32(typeof(Weight).GetProperty(item.Name).GetValue(weight)); } } total += Convert.ToInt32(typeof(Weight).GetProperty(item.Name).GetValue(weight)); } // 取得上传文件权重 var clientPensionCityDocument = Client.ClientPensionCityDocuments.Where(a => (a.PensionCityId == null && PensionCityId == null) || (a.PensionCityId == PensionCityId)).SingleOrDefault(); if (clientPensionCityDocument == null) { return("0%"); } foreach (var item in clientPensionCityDocument.Documents) { var doc = EmployeeDocs.Where(a => a.DocumentId == item.Id).SingleOrDefault(); if (doc != null && !String.IsNullOrWhiteSpace(doc.ImgPath)) { count += item.Weight; } total += item.Weight; } if (total == 0) { return("0%"); } else { return(String.Format("{0:P2}.", (count / total))); } }
public string GetPercent() { // 取权重 Weight weight; using (var db = new OBContext()) { weight = db.Weight.Where(a => a.WeightClientId == ClientId).SingleOrDefault(); if (weight == null) { weight = db.Weight.Where(a => a.WeightClientId == null).Single(); } } // 取得普通权重 PropertyInfo[] fs = typeof(Weight).GetProperties(); decimal count = 0; decimal total = 0; string[] exclude = { "Id", "WeightClientId", "WeightClient", "IsDeleted" }; string[] collection = { "Educations", "Works", "Families" }; foreach (PropertyInfo item in fs) { if (exclude.Contains(item.Name)) { continue; } else { var t = typeof(Employee).GetProperty(item.Name); var v = t.GetValue(this); if ((collection.Contains(item.Name) && Convert.ToInt32(v.GetType().GetProperty("Count").GetValue(v)) > 0) || (!(collection.Contains(item.Name)) && v != null)) { count += Convert.ToInt32(typeof(Weight).GetProperty(item.Name).GetValue(weight)); } } total += Convert.ToInt32(typeof(Weight).GetProperty(item.Name).GetValue(weight)); } // 取得上传文件权重 var clientPensionCityDocument = Client.ClientPensionCityDocuments.Where(a => (a.PensionCityId == null && PensionCityId == null) || (a.PensionCityId == PensionCityId)).SingleOrDefault(); if (clientPensionCityDocument == null) { return "0%"; } foreach (var item in clientPensionCityDocument.Documents) { var doc = EmployeeDocs.Where(a => a.DocumentId == item.Id).SingleOrDefault(); if (doc != null && !String.IsNullOrWhiteSpace(doc.ImgPath)) { count += item.Weight; } total += item.Weight; } if (total == 0) { return "0%"; } else { return String.Format("{0:P2}.", (count / total)); } }
public ExampleContextAdapter(OBContext context) : base(context) { this.context = context; }
public override string ToString() { if (Client == null || City == null || Supplier == null) { using (var db = new OBContext()) { Client = db.Client.Find(ClientId); City = db.City.Find(CityId); Supplier = db.Supplier.Find(SupplierId); } } return Client + "_" + City + "_" + Supplier + "_" + HukouType; }
public JsonResult ClientCustomField(int employeeId) { using (OBContext db = new OBContext()) { var clientId = db.Employee.Where(a => a.Id == employeeId).Select(a => a.ClientId).SingleOrDefault(); Object ob = (from a in db.CustomField where a.ClientId == clientId select new { BasicInfo1 = a.BasicInfo1.Trim(), BasicInfo2 = a.BasicInfo2.Trim(), BasicInfo3 = a.BasicInfo3.Trim(), BasicInfo4 = a.BasicInfo4.Trim(), BasicInfo5 = a.BasicInfo5.Trim(), BasicInfo6 = a.BasicInfo6.Trim(), BasicInfo7 = a.BasicInfo7.Trim(), BasicInfo8 = a.BasicInfo8.Trim(), BasicInfo9 = a.BasicInfo9.Trim(), BasicInfo10 = a.BasicInfo10.Trim(), //// PensionInfo1 = a.PensionInfo1.Trim(), PensionInfo2 = a.PensionInfo2.Trim(), PensionInfo3 = a.PensionInfo3.Trim(), PensionInfo4 = a.PensionInfo4.Trim(), PensionInfo5 = a.PensionInfo5.Trim(), //// HireInfo1 = a.HireInfo1.Trim(), HireInfo2 = a.HireInfo2.Trim(), HireInfo3 = a.HireInfo3.Trim(), HireInfo4 = a.HireInfo4.Trim(), HireInfo5 = a.HireInfo5.Trim(), HireInfo6 = a.HireInfo6.Trim(), HireInfo7 = a.HireInfo7.Trim(), HireInfo8 = a.HireInfo8.Trim(), HireInfo9 = a.HireInfo9.Trim(), HireInfo10 = a.HireInfo10.Trim(), HireInfo11 = a.HireInfo11.Trim(), HireInfo12 = a.HireInfo12.Trim(), HireInfo13 = a.HireInfo13.Trim(), HireInfo14 = a.HireInfo14.Trim(), HireInfo15 = a.HireInfo15.Trim(), HireInfo16 = a.HireInfo16.Trim(), HireInfo17 = a.HireInfo17.Trim(), HireInfo18 = a.HireInfo18.Trim(), HireInfo19 = a.HireInfo19.Trim(), HireInfo20 = a.HireInfo20.Trim() } ).AsNoTracking().FirstOrDefault(); return this.Json(ob, JsonRequestBehavior.AllowGet); } }
public override string ToString() { if (WeightClient == null) { using (var db = new OBContext()) { WeightClient = db.Client.Find(WeightClientId); } } return WeightClient + "权重"; }