public IEnumerable <Department> GetInitData(int num = 10)
{
var departments = new List <Department>();
for (int i = 0; i < num; i++)
{
departments.Add(new Department
{
Id = i + 1,
CreateBy = "System",
UpdateBy = "System",
Name = ChineseCharacter.GenerateChineseName(),
CreateTime = DateTime.Now,
});
}
return(departments);
}
public IEnumerable <User> GetInitData()
{
var users = new List <User>();
users.Add(new User
{
Id = 1,
Account = "Admin",
Password = "******",
CreateBy = "System",
UpdateBy = "System",
CreateTime = DateTime.Now,
NickName = ChineseCharacter.GenerateChineseName(),
Name = ChineseCharacter.GenerateChineseName()
});
return(users);
}
public IEnumerable <Company> GetInitData(int num = 10)
{
var companies = new List <Company>();
for (int i = 0; i < num; i++)
{
companies.Add(new Company
{
Id = i + 1,
CreateBy = "System",
UpdateBy = "System",
Name = ChineseCharacter.GenerateChineseName(),
Fix = new Random().Next(100000, 999999).ToString(),
CreateTime = DateTime.Now,
});
}
return(companies);
}
public static int update(DistrictInfo info, ref string resultMsg)
{
if (info.Name.Trim().Length == 0)
{
resultMsg = "请填写名称";
return(0);
}
bool exist_name = IsExist("Name='" + info.Name.Trim() + "' and DistId<>" + info.DistId);
if (exist_name)
{
resultMsg = info.Name + "已存在";
return(0);
}
if (info.call_index != null && info.call_index.Trim().Length > 0)
{
bool exist_call_index = IsExist("call_index='" + info.call_index.Trim() + "' and DistId<>" + info.DistId);
if (exist_call_index)
{
resultMsg = "调用代码" + info.call_index + "已存在";
return(0);
}
}
info.PinYin = ChineseCharacter.HzConverToPy(info.Name);
info.PinYinInitials = info.PinYin.Trim().Length > 0 ? info.PinYin.Substring(0, 1) : "";
info.ParentIds = get_parentids(info.DistId);
int result = Update(info);
if (result > 0)
{
if (info.ParentId == 0)
{ //批量更新省份数据
Update("District", "ProvinceName='" + info.ProvinceName + "'", "ProvinceId=" + info.ProvinceId);
}
else if (info.AreaId == 0) //批量更新城市数据
{
Update("District", "CityName='" + info.CityName + "'", "CityId=" + info.CityId);
}
}
return(result);
}
public static int add(DistrictInfo info, ref string resultMsg)
{
if (info.Name.Trim().Length == 0)
{
resultMsg = "请填写名称";
return(0);
}
bool exist_name = IsExist("Name='" + info.Name.Trim() + "'");
if (exist_name)
{
resultMsg = info.Name + "已存在";
return(0);
}
if (info.call_index != null && info.call_index.Trim().Length > 0)
{
bool exist_call_index = IsExist("call_index='" + info.call_index.Trim() + "'");
if (exist_call_index)
{
resultMsg = "调用代码" + info.call_index + "已存在";
return(0);
}
}
info.PinYin = ChineseCharacter.HzConverToPy(info.Name);
info.PinYinInitials = info.PinYin.Trim().Length > 0 ? info.PinYin.Substring(0, 1) : "";
info.CreateTime = DateTime.Now;
if (info.ParentId > 0)
{
info.ParentIds = "," + info.ParentId + get_parentids(info.ParentId);
}
int result = Insert(info, BS.Components.Data.Entity.ReturnTypes.Identity);
if (result > 0)
{
info.DistId = result;
if (info.ParentId == 0)
{//是省份
info.ProvinceId = result;
info.ProvinceName = info.Name;
info.Level = 1;
}
else
{
DistrictInfo dismodel = GetModel(info.ParentId);//查父级
if (dismodel != null)
{
if (dismodel.ParentId == 0)
{//如果父级的父级ID为0，则父级为省，此行应为城市
info.Level = 2;
info.ProvinceId = dismodel.ProvinceId;
info.ProvinceName = dismodel.ProvinceName;
info.CityId = result;
info.CityName = info.Name;
}
else
{
if (dismodel.CityId > 0 && dismodel.AreaId <= 0)
{
//为区域
info.Level = 3;
info.ProvinceId = dismodel.ProvinceId;
info.ProvinceName = dismodel.ProvinceName;
info.CityId = dismodel.CityId;
info.CityName = dismodel.CityName;
info.AreaId = result;
info.AreaName = info.Name;
}
else
{
//为商区
info.Level = 4;
info.ProvinceId = dismodel.ProvinceId;
info.ProvinceName = dismodel.ProvinceName;
info.CityId = dismodel.CityId;
info.CityName = dismodel.CityName;
info.AreaId = dismodel.AreaId;
info.AreaName = dismodel.AreaName;
info.DistrictId = result;
info.DistrictName = info.Name;
}
}
}
}
Update(info);
}
return(result);
}
