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 + "权重";
}
