public void AddDistricQuantity() { MongoRepository <District> districts = new MongoRepository <District>(); MongoRepository <Age> ages = new MongoRepository <Age>(); MongoRepository <Sex> sexs = new MongoRepository <Sex>(); MongoRepository <Job> jobs = new MongoRepository <Job>(); MongoRepository <DistrictQuantity> districtQuantities = new MongoRepository <DistrictQuantity>(); var year = 2016; Random rnd = new Random(); foreach (var district in districts) { foreach (var age in ages) { foreach (var sex in sexs) { foreach (var job in jobs) { DistrictQuantity item = new DistrictQuantity { DistrictId = district.Id, AgeId = age.Id, SexId = sex.Id, JobId = job.Id, Year = year, Quantity = rnd.Next(1, 50) }; districtQuantities.Add(item); } } } } }
public static void Set(DistrictQuantity districtQuantity) { var key = new DistrictQuantityKeys { DistrictId = districtQuantity.DistrictId, SexId = districtQuantity.SexId, JobId = districtQuantity.JobId, AgeId = districtQuantity.AgeId }; if (!Memory.DicDistrictQuantity.ContainsKey(districtQuantity.Year)) { Memory.DicDistrictQuantity[districtQuantity.Year] = new Dictionary <DistrictQuantityKeys, DistrictQuantity>(); } Memory.DicDistrictQuantity[districtQuantity.Year][key] = districtQuantity; }
public BsonDocument GetBson(DistrictQuantity districtQuantity) { return(new BsonDocument { { DistrictQuantity.DistrictQuantityFields.DistrictId.ToString(), districtQuantity.DistrictId }, { DistrictQuantity.DistrictQuantityFields.AgeId.ToString(), districtQuantity.AgeId }, { DistrictQuantity.DistrictQuantityFields.SexId.ToString(), districtQuantity.SexId }, { DistrictQuantity.DistrictQuantityFields.JobId.ToString(), districtQuantity.JobId }, { DistrictQuantity.DistrictQuantityFields.Year.ToString(), districtQuantity.Year }, { DistrictQuantity.DistrictQuantityFields.Quantity.ToString(), districtQuantity.Quantity } }); }
public static void Remove(DistrictQuantity districtQuantity) { var key = new DistrictQuantityKeys { DistrictId = districtQuantity.DistrictId, SexId = districtQuantity.SexId, JobId = districtQuantity.JobId, AgeId = districtQuantity.AgeId }; if (Memory.DicDistrictQuantity.ContainsKey(districtQuantity.Year)) { if (Memory.DicDistrictQuantity[districtQuantity.Year].ContainsKey(key)) { Memory.DicDistrictQuantity[districtQuantity.Year].Remove(key); } } }
public static DistrictQuantity CheckExistDistrictQuantity(DistrictQuantity districtQuantity) { if (!EntityDic.DistrictQuantityDic.ContainsKey(districtQuantity.Year)) { return(null); } DistrictQuantityKeys key = new DistrictQuantityKeys { DistrictId = districtQuantity.DistrictId, AgeId = districtQuantity.AgeId, SexId = districtQuantity.SexId, JobId = districtQuantity.JobId }; if (EntityDic.DistrictQuantityDic[districtQuantity.Year].ContainsKey(key)) { return(EntityDic.DistrictQuantityDic[districtQuantity.Year][key].Clone() as DistrictQuantity); } return(null); }
public string UploadDistrictQuantity(List <DistrictQuantityExcel> listDistrictQuantityExcels) { List <DistrictQuantity> listInsert = new List <DistrictQuantity>(); List <DistrictQuantity> listUpdate = new List <DistrictQuantity>(); foreach (var districtQuantityExcel in listDistrictQuantityExcels) { DistrictQuantity districtQuantity = new DistrictQuantity(); //set DistrictId District district = MemoryOperator.GetDistrictByName(districtQuantityExcel.Name); if (district == null) { continue; } districtQuantity.DistrictId = district.Id; //set AgeId Age age = MemoryOperator.GetAgeByAgeStart(districtQuantityExcel.Age); if (age == null) { continue; } districtQuantity.AgeId = age.Id; //set SexId Sex sex = MemoryOperator.GetSexBySexName(districtQuantityExcel.Sex); if (sex == null) { continue; } districtQuantity.SexId = sex.Id; //set JobId Job job = MemoryOperator.GetJobByJobName(districtQuantityExcel.Job); if (job == null) { continue; } districtQuantity.JobId = job.Id; //set year int year; if (int.TryParse(districtQuantityExcel.Year, out year)) { districtQuantity.Year = year; } else { continue; } //set quantity long quantity; if (long.TryParse(districtQuantityExcel.Quantity, out quantity)) { districtQuantity.Quantity = quantity; } else { continue; } //check insert or update var checkDistrictQuantity = MemoryOperator.CheckExistDistrictQuantity(districtQuantity); if (checkDistrictQuantity == null) { listInsert.Add(districtQuantity); } else { districtQuantity.Id = checkDistrictQuantity.Id; listUpdate.Add(districtQuantity); } } MemoryOperator.UpdateMemberThread(listUpdate, listInsert); return("1"); }
public static void Init() { #region Age var listAge = SelectDatabase.Select(new Age().EntityName()); foreach (var item in listAge) { Age age = new Age { AgeId = item[0].AsObjectId, AgeStart = item[1].AsInt32, AgeEnd = item[2].AsInt32 }; SetMemory.Set(age); } #endregion #region Sex var listSex = SelectDatabase.Select(new Sex().EntityName()); foreach (var item in listSex) { Sex sex = new Sex { SexId = item[0].AsObjectId, SexName = item[1].AsString }; SetMemory.Set(sex); } #endregion #region Job var listJob = SelectDatabase.Select(new Job().EntityName()); foreach (var item in listJob) { Job job = new Job { JobId = item[0].AsObjectId, JobName = item[1].AsString }; SetMemory.Set(job); } #endregion #region Area var listArea = SelectDatabase.Select(new Area().EntityName()); foreach (var item in listArea) { Area area = new Area { AreaId = item[0].AsObjectId, AreaName = item[1].AsString }; SetMemory.Set(area); } #endregion #region AreaQuantity var listAreaQuantity = SelectDatabase.Select(new AreaQuantity().EntityName()); foreach (var item in listAreaQuantity) { AreaQuantity areaQuantity = new AreaQuantity { AreaId = item[1].AsObjectId, AgeId = item[2].AsObjectId, SexId = item[3].AsObjectId, JobId = item[4].AsObjectId, Year = item[5].AsInt32, Quantity = item[6].AsInt64 }; SetMemory.Set(areaQuantity); } #endregion #region Branch var listBranch = SelectDatabase.Select(new Branch().EntityName()); foreach (var item in listBranch) { Branch branch = new Branch { BranchId = item[0].AsObjectId, BranchName = item[1].AsString, AreaId = item[3].AsObjectId }; SetMemory.Set(branch); } #endregion #region BranchQuantity var listBranchQuantity = SelectDatabase.Select(new BranchQuantity().EntityName()); foreach (var item in listBranchQuantity) { BranchQuantity branchQuantity = new BranchQuantity { BranchId = item[1].AsObjectId, AgeId = item[2].AsObjectId, SexId = item[3].AsObjectId, JobId = item[4].AsObjectId, Year = item[5].AsInt32, Quantity = item[6].AsInt64 }; SetMemory.Set(branchQuantity); } #endregion #region Province var listProvince = SelectDatabase.Select(new Province().EntityName()); foreach (var item in listProvince) { Province province = new Province { ProvinceId = item[0].AsObjectId, ProvinceName = item[1].AsString, BranchId = item[3].AsObjectId }; SetMemory.Set(province); } #endregion #region ProvinceQuantity var listProvinceQuantity = SelectDatabase.Select(new ProvinceQuantity().EntityName()); foreach (var item in listProvinceQuantity) { ProvinceQuantity provinceQuantity = new ProvinceQuantity { ProvinceId = item[1].AsObjectId, AgeId = item[2].AsObjectId, SexId = item[3].AsObjectId, JobId = item[4].AsObjectId, Year = item[5].AsInt32, Quantity = item[6].AsInt64 }; SetMemory.Set(provinceQuantity); } #endregion #region District var listDistrict = SelectDatabase.Select(new District().EntityName()); foreach (var item in listDistrict) { District district = new District { DistrictId = item[0].AsObjectId, DistrictName = item[1].AsString, ProvinceId = item[3].AsObjectId }; SetMemory.Set(district); } #endregion #region DistrictQuantity var listDistrictQuantity = SelectDatabase.Select(new DistrictQuantity().EntityName()); foreach (var item in listDistrictQuantity) { DistrictQuantity districtQuantity = new DistrictQuantity { DistrictId = item[1].AsObjectId, AgeId = item[2].AsObjectId, SexId = item[3].AsObjectId, JobId = item[4].AsObjectId, Year = item[5].ToInt32(), Quantity = item[6].ToInt64() }; SetMemory.Set(districtQuantity); } #endregion }