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
}
