protected static IEnumerable <Employee> InitEmployeesWithData()
{
var countryNL = new Country {
Id = 1, Code = "NL", Name = "The Netherlands"
};
var countryBE = new Country {
Id = 2, Code = "BE", Name = "Belgium"
};
var mainCompany1 = new MainCompany {
Id = 1, Name = "m-1"
};
var mainCompany2 = new MainCompany {
Id = 2, Name = "m-2"
};
var companyA = new Company {
Id = 1, Name = "A", MainCompany = mainCompany1
};
var companyB = new Company {
Id = 2, Name = "B", MainCompany = mainCompany1
};
var companyC = new Company {
Id = 3, Name = "C", MainCompany = mainCompany2
};
return(InitEmployees(countryNL, countryBE, companyA, companyB, companyC));
}
//获取未被克隆的品牌列表
public List <BrandByMainCom> GetBrandByMainComList(int PageIndex, int PageSize, out int TotalRecord, string Keyword)
{
//获取所有未被克隆的品牌
var query = (from x in db.Material
where true
&&
Keyword == string.Empty ? true : x.MatBrand.Contains(Keyword)
&&
x.MatBrandID != Guid.Empty
&&
x.IsClone <= 0
group x by x.MatBrandID into g
select new {
BrandID = g.Key,
ProCount = g.Count(),
ProIsPriceCount = g.Where(c => c.CostPrice > 0).Count()
}).AsQueryable();
TotalRecord = query.Count();
List <BrandByMainCom> BML = new List <BrandByMainCom>();
BrandByMainCom BM = new BrandByMainCom();
Brand B = new Brand();
foreach (var x in query.OrderByDescending(s => s.ProCount).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList())
{
B = db.Brand.Find(x.BrandID);
if (B != null)
{
BM = new BrandByMainCom();
BM.BID = B.BID;
BM.BrandName = B.BrandName;
BM.BrandType = B.BrandType;
BM.ProCount = x.ProCount;
BM.ProIsPriceCount = x.ProIsPriceCount;
BM.FromType = "分销商";
BM.LinkMainCID = B.LinkMainCID;
BM.LinkMainComName = string.Empty;
BML.Add(BM);
}
}
MainCompany MCom = new MainCompany();
foreach (var x in BML.GroupBy(x => x.LinkMainCID).Select(x => x.Key))
{
MCom = db.MainCompany.Find(x);
if (MCom != null)
{
foreach (var xx in BML.Where(c => c.LinkMainCID == x).ToList())
{
xx.LinkMainComName = MCom.MainCompanyName;
}
}
}
return(BML);
}
public ActionResult DeleteConfirmed(int id)
{
MainCompany mainCompany = db.MainCompanies.Find(id);
db.MainCompanies.Remove(mainCompany);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,EstimatedAnnualEarnings")] MainCompany mainCompany)
{
if (ModelState.IsValid)
{
db.Entry(mainCompany).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mainCompany));
}
public ActionResult Create([Bind(Include = "Id,Name,EstimatedAnnualEarnings")] MainCompany mainCompany)
{
if (ModelState.IsValid)
{
db.MainCompanies.Add(mainCompany);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mainCompany));
}
static void Main(string[] args)
{
var connection = DbConnectionFactory.CreateTransient();
using (var context = new KendoGridDbContext(connection))
{
context.KendoGridCountry.Add(new Country {
Id = 1000, Code = "NL", Name = "Nederland"
});
var main1 = new MainCompany {
Name = "Main1"
};
context.KendoGridMainCompany.Add(main1);
var main2 = new MainCompany {
Name = "Main2"
};
context.KendoGridMainCompany.Add(main2);
var company = new Company {
Name = "Other", MainCompany = main1
};
context.KendoGridCompany.Add(company);
context.SaveChanges();
}
using (var context = new KendoGridDbContext(connection))
{
foreach (var c in context.KendoGridCountry.AsNoTracking().Where(c => c.Code.StartsWith("N")))
{
Console.WriteLine(JsonConvert.SerializeObject(c, Formatting.Indented));
}
var main2Id = context.KendoGridMainCompany.First(mc => mc.Name == "Main2").Id;
var company = context.KendoGridCompany.First();
company.MainCompanyId = main2Id;
context.SaveChanges();
}
using (var context = new KendoGridDbContext(connection))
{
foreach (var c in context.KendoGridCompany.AsNoTracking())
{
Console.WriteLine(c.Name + " " + c.MainCompany.Name);
}
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MainCompany mainCompany = db.MainCompanies.Find(id);
if (mainCompany == null)
{
return(HttpNotFound());
}
return(View(mainCompany));
}
static void Main(string[] args)
{
Company company1 = new CompanyNoSubsidiary();
company1.AddVehicle();
Company company2 = new CompanyNoSubsidiary();
company2.AddVehicle();
company2.AddVehicle();
Company group = new MainCompany();
group.AddSubsidiary(company1);
group.AddSubsidiary(company2);
group.AddVehicle();
Console.WriteLine($"Coste de mantenimiento total del grupo {group.CalculateMaintenanceCost()}");
Console.ReadKey();
}
public static MainCompany Create()
{
Console.Write("Enter your company name... ");
string name = Console.ReadLine();
Console.Write("Enter your bulstat... ");
string bulstat = Console.ReadLine();
Console.Write("Enter the owner first name...");
string ownerFirstName = Console.ReadLine();
Console.Write("Enter the owner last name...");
string ownerLastName = Console.ReadLine();
Console.Write("Enter owner years of experience...");
double ownerYearsOfExperience = double.Parse(Console.ReadLine());
Console.WriteLine(ownerYearsOfExperience);
Employee owner = new Employee()
{
FirstName = ownerFirstName,
LastName = ownerLastName,
ExperienceInYears = ownerYearsOfExperience,
Position = Position.Owner
};
MainCompany company = new MainCompany()
{
Name = name,
Bulstat = bulstat,
Owner = owner
};
company.Employees.Add(owner);
return(company);
}
private void Seed(MyDataContext context)
{
var roleAdmin = new Role {
Id = 1, Name = "Administrator", Description = "Administrator"
};
var roleSuperUser = new Role {
Id = 2, Name = "SuperUser", Description = "Super User"
};
var roleApplicationUser = new Role {
Id = 4, Name = "ApplicationUser", Description = "Application User"
};
context.Roles.Add(roleAdmin);
context.Roles.Add(roleSuperUser);
context.Roles.Add(roleApplicationUser);
context.SaveChanges();
var userAdmin = new User {
Id = 1, IdentityName = "admin", DisplayName = "admin", EmailAddress = "*****@*****.**", Roles = new List <Role>()
};
userAdmin.Roles.Add(roleAdmin);
userAdmin.Roles.Add(roleSuperUser);
userAdmin.Roles.Add(roleApplicationUser);
context.Users.Add(userAdmin);
var superUser = new User {
Id = 2, IdentityName = "super user", DisplayName = "super user", EmailAddress = "*****@*****.**", Roles = new List <Role>()
};
superUser.Roles.Add(roleSuperUser);
superUser.Roles.Add(roleApplicationUser);
context.Users.Add(superUser);
var appUser = new User {
Id = 3, IdentityName = "app user", DisplayName = "app user", EmailAddress = "*****@*****.**", Roles = new List <Role>()
};
appUser.Roles.Add(roleApplicationUser);
context.Users.Add(appUser);
context.SaveChanges();
var functionIct = new Function {
Id = 1, Code = "ICT", Name = "ICT"
};
var functionManagement = new Function {
Id = 2, Code = "MAN", Name = "Management"
};
var functions = new List <Function> {
functionIct, functionManagement
};
functions.ForEach(s => context.Functions.Add(s));
context.SaveChanges();
for (int i = 1; i <= 10; i++)
{
var subFunctionIct = new SubFunction {
Id = 1, Code = "ICT-" + i, Name = "ICT - " + i, Function = functionIct
};
context.SubFunctions.Add(subFunctionIct);
}
for (int i = 1; i <= 5; i++)
{
var subFunctionManagement = new SubFunction {
Id = 1, Code = "MAN-" + i, Name = "Management - " + i, Function = functionManagement
};
context.SubFunctions.Add(subFunctionManagement);
}
context.SaveChanges();
var countryNL = new Country {
Id = 1, Code = "NL", Name = "The Netherlands"
};
var countryBE = new Country {
Id = 2, Code = "BE", Name = "Belgium"
};
var countries = new List <Country> {
countryNL, countryBE
};
countries.ForEach(c => context.Countries.Add(c));
context.SaveChanges();
var mainCompany1 = new MainCompany {
Id = 10, Name = "M - 1"
};
var mainCompany2 = new MainCompany {
Id = 20, Name = "M - 2"
};
var mainCompanies = new List <MainCompany> {
mainCompany1, mainCompany2
};
mainCompanies.ForEach(x => context.MainCompanies.Add(x));
context.SaveChanges();
var companyA = new Company {
Id = 1, Name = "A", MainCompany = mainCompany1
};
var companyB = new Company {
Id = 2, Name = "B", MainCompany = mainCompany1
};
var companyC = new Company {
Id = 3, Name = "C", MainCompany = mainCompany2
};
var companies = new List <Company> {
companyA, companyB, companyC
};
companies.ForEach(x => context.Companies.Add(x));
context.SaveChanges();
var employees = new List <Employee>
{
new Employee {
Id = 1, Assigned = null, Country = countryNL, Company = companyA, FirstName = "Bill", LastName = "Smith", Email = "*****@*****.**", EmployeeNumber = 1001, HireDate = Convert.ToDateTime("01/12/1990"), Function = functionManagement, SubFunction = functionManagement.SubFunctions.First()
},
new Employee {
Id = 2, Assigned = 1, Country = countryNL, Company = companyB, FirstName = "Jack", LastName = "Smith", Email = "*****@*****.**", EmployeeNumber = 1002, HireDate = Convert.ToDateTime("12/12/1997"), Function = functionManagement, SubFunction = functionManagement.SubFunctions.First()
},
new Employee {
Id = 3, Assigned = 2, Country = countryNL, Company = companyC, FirstName = "Mary", LastName = "Gates", Email = "*****@*****.**", EmployeeNumber = 1003, HireDate = Convert.ToDateTime("03/03/2000"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[1]
},
new Employee {
Id = 4, Assigned = null, Country = countryNL, Company = companyA, FirstName = "John", LastName = "Doe", Email = "*****@*****.**", EmployeeNumber = 1004, HireDate = Convert.ToDateTime("11/11/2011"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[2]
},
new Employee {
Id = 5, Assigned = 0, Country = countryBE, Company = companyB, FirstName = "Chris", LastName = "Cross", Email = "*****@*****.**", EmployeeNumber = 1005, HireDate = Convert.ToDateTime("05/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[3]
},
new Employee {
Id = 6, Assigned = 1, Country = countryBE, Company = companyC, FirstName = "Niki", LastName = "Myers", Email = "*****@*****.**", EmployeeNumber = 1006, HireDate = Convert.ToDateTime("06/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[4]
},
new Employee {
Id = 7, Assigned = null, Country = countryBE, Company = companyA, FirstName = "Joseph", LastName = "Hall", Email = "*****@*****.**", EmployeeNumber = 1007, HireDate = Convert.ToDateTime("07/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[5]
},
new Employee {
Id = 8, Assigned = 0, Country = countryBE, Company = companyB, FirstName = "Daniel", LastName = "Wells", Email = "*****@*****.**", EmployeeNumber = 1008, HireDate = Convert.ToDateTime("08/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[6]
},
new Employee {
Id = 9, Assigned = 1, Country = countryNL, Company = companyC, FirstName = "Robert", LastName = "Lawrence", Email = "*****@*****.**", EmployeeNumber = 1009, HireDate = Convert.ToDateTime("09/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[7]
},
new Employee {
Id = 10, Assigned = 0, Country = countryNL, Company = companyA, FirstName = "Reginald", LastName = "Quinn", Email = "*****@*****.**", EmployeeNumber = 1010, HireDate = Convert.ToDateTime("10/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[8]
},
new Employee {
Id = 11, Assigned = 2, Country = countryNL, Company = companyB, FirstName = "Quinn", LastName = "Quick", Email = "*****@*****.**", EmployeeNumber = 1011, HireDate = Convert.ToDateTime("11/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[9]
},
new Employee {
Id = 12, Assigned = null, Country = countryNL, Company = companyC, FirstName = "Test", LastName = "User", Email = "*****@*****.**", EmployeeNumber = 1012, HireDate = Convert.ToDateTime("11/05/2012"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[0]
},
};
employees.ForEach(x => context.Employees.Add(x));
context.SaveChanges();
var products = new List <Product>
{
new Product {
Id = 1, Code = "AR-5381", Name = "Adjustable Race"
},
new Product {
Id = 2, Code = "BA-8327", Name = "Bearing Ball"
},
new Product {
Id = 3, Code = "BE-2349", Name = "BB Ball Bearing"
},
new Product {
Id = 4, Code = "BE-2908", Name = "Headset Ball Bearings"
},
new Product {
Id = 316, Code = "BL-2036", Name = "Blade"
},
new Product {
Id = 317, Code = "CA-5965", Name = "LL Crankarm"
},
new Product {
Id = 318, Code = "CA-6738", Name = "ML Crankarm"
},
new Product {
Id = 319, Code = "CA-7457", Name = "HL Crankarm"
},
new Product {
Id = 320, Code = "CB-2903", Name = "Chainring Bolts"
},
new Product {
Id = 321, Code = "CN-6137", Name = "Chainring Nut"
},
new Product {
Id = 322, Code = "CR-7833", Name = "Chainring"
}
};
products.ForEach(x => context.Products.Add(x));
context.SaveChanges();
const int numOUs = 5000;
var generator = new LipsumGenerator();
var list = new List <OU>();
for (int i = 1000000; i < 1000000 + numOUs; i++)
{
var ou = new OU
{
Code = i.ToString(CultureInfo.InvariantCulture),
Name = string.Join(" ", generator.GenerateWords(3))
};
list.Add(ou);
}
BulkInsert(context, context.OUs, list);
}
public static void Main()
{
MainCompany company = CompanyCreator.Create();
company.Employees = CompanyCreator.SeedEmployees();
}
//获取未被克隆的品牌列表
public List<BrandByMainCom> GetBrandByMainComList(int PageIndex, int PageSize, out int TotalRecord, string Keyword)
{
//获取所有未被克隆的品牌
var query = (from x in db.Material
where true
&&
Keyword == string.Empty ? true : x.MatBrand.Contains(Keyword)
&&
x.MatBrandID != Guid.Empty
&&
x.IsClone <= 0
group x by x.MatBrandID into g
select new {
BrandID = g.Key,
ProCount = g.Count(),
ProIsPriceCount = g.Where(c=>c.CostPrice > 0).Count()
}).AsQueryable();
TotalRecord = query.Count();
List<BrandByMainCom> BML = new List<BrandByMainCom>();
BrandByMainCom BM = new BrandByMainCom();
Brand B = new Brand();
foreach (var x in query.OrderByDescending(s => s.ProCount).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList())
{
B = db.Brand.Find(x.BrandID);
if (B != null)
{
BM = new BrandByMainCom();
BM.BID = B.BID;
BM.BrandName = B.BrandName;
BM.BrandType = B.BrandType;
BM.ProCount = x.ProCount;
BM.ProIsPriceCount = x.ProIsPriceCount;
BM.FromType = "分销商";
BM.LinkMainCID = B.LinkMainCID;
BM.LinkMainComName = string.Empty;
BML.Add(BM);
}
}
MainCompany MCom = new MainCompany();
foreach(var x in BML.GroupBy(x=>x.LinkMainCID).Select(x=>x.Key))
{
MCom = db.MainCompany.Find(x);
if(MCom != null)
{
foreach (var xx in BML.Where(c => c.LinkMainCID == x).ToList())
{
xx.LinkMainComName = MCom.MainCompanyName;
}
}
}
return BML;
}
