public void Dispose()
{
_context.Database.EnsureDeleted();
_context.Dispose();
_emptyContext.Database.EnsureDeleted();
_emptyContext.Dispose();
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
protected virtual void CleabData(bool disposing)
{
if (_disposed)
{
return;
}
if (disposing)
{
}
_context.Dispose();
_disposed = true;
}
public void EFDBContextTest()
{
var db = new EFDBContext();
//编辑用户组
//var role = db.SysRoles.Where(p => p.ID == 2).Include(s => s.SysRoleRoutes.Select(y => y.SysRoute)).FirstOrDefault();
//添加测试路由
//int[] power = { (int)DataCore.Entity.SysRouteType.add, (int)DataCore.Entity.SysRouteType.delete, (int)DataCore.Entity.SysRouteType.select };
//int[] power2 = { (int)DataCore.Entity.SysRouteType.update, (int)DataCore.Entity.SysRouteType.upload };
//var route1 = new DataCore.Entity.SysRoute() { AddTime = DateTime.Now, Desc = "测试路由", Route = "/home/index", Tag = "其他", RouteType = power };
//var route2 = new DataCore.Entity.SysRoute() { AddTime = DateTime.Now, Desc = "测试路由2", Route = "/home/test", Tag = "其他2", RouteType = power2 };
//db.SysRoutes.Add(route1);
//db.SysRoutes.Add(route2);
//添加组对应权限
//var roleroute = new DataCore.Entity.SysRoleRoute() { SysRoleID = role.ID, SysRoute = route1 };
//var roleroute2 = new DataCore.Entity.SysRoleRoute() { SysRoleID = role.ID, SysRoute = route2 };
//db.SysRoleRoutes.Add(roleroute);
//db.SysRoleRoutes.Add(roleroute2);
//添加用户
var entity = db.SysRoles.Find(2);
string pwd = SecureHelper.MD5("admin");
for (int i = 0; i < 30; i++)
{
var user = new Entity.SysUser()
{
Avatar = "",
Gender = Entity.UserGender.男,
LastLoginTime = DateTime.Now,
NickName = "编辑用户" + (i + 1).ToString(),
Password = pwd,
RegTime = DateTime.Now,
Status = true,
SysRole = entity,
UserName = "******" + (i + 1).ToString()
};
db.SysUsers.Add(user);
}
db.SaveChanges();
//var group = db.SysRoutes.GroupBy(p => p.Tag).ToList();
db.Dispose();
Assert.AreEqual(1, 1);
}
public void TestMethod1()
{
var db = new EFDBContext();
var category_list = db.CusCategorys.AsNoTracking().ToList();
db.Dispose();
List <Entity.CusCategory> new_list = new List <Entity.CusCategory>();
GetChilds(category_list, new_list, null);
StringBuilder tree_str = new StringBuilder();
foreach (var item in new_list)
{
tree_str.Append(StringHelper.StringOfChar(item.Depth - 1, " ") + "├ " + StringHelper.StringOfChar(item.Depth - 1, " ") + item.Title + "\r\n");
//if(item.Depth == 1)
// tree_str.Append(item.Title +"\r\n");
//else
// tree_str.Append(StringHelper.StringOfChar(item.Depth - 1, " ")+"├ " + StringHelper.StringOfChar(item.Depth - 1, " ") + item.Title +"\r\n");
}
Assert.AreEqual(1, 1);
}
private List <string> SaveToBaseCSV(string nameCSV, string nameConfig)
{
// Load Data from csv file
List <string> str = new List <string>();
DataTable csvData = GetDataCSV(nameCSV);
// Load config from xml file
DataSet ds = new DataSet();
ds.ReadXml(nameConfig);
DataTable xmlData = new DataTable();
xmlData = ds.Tables[0];
// ReLoad Data from csv table to DB by field from xml config file
using (EFDBContext dbContext = new EFDBContext())
{
var st = from myZip in csvData.AsEnumerable()
where myZip.Field <string>("Бренд") == "555"
select myZip;
IEnumerable <string> fldVendor = from p in xmlData.AsEnumerable()
where p.Field <string>("FIELD") == "Vendor"
select p.Field <string>("SOURCE");
IEnumerable <string> fldNumber = from p in xmlData.AsEnumerable()
where p.Field <string>("FIELD") == "Number"
select p.Field <string>("SOURCE");
IEnumerable <string> fldDescription = from p in xmlData.AsEnumerable()
where p.Field <string>("FIELD") == "Description"
select p.Field <string>("SOURCE");
IEnumerable <string> fldPrice = from p in xmlData.AsEnumerable()
where p.Field <string>("FIELD") == "Price"
select p.Field <string>("SOURCE");
IEnumerable <string> fldCount = from p in xmlData.AsEnumerable()
where p.Field <string>("FIELD") == "Count"
select p.Field <string>("SOURCE");
foreach (DataRow row in csvData.Rows)
{
string vendor = row.Field <string>(fldVendor.First());
string number = row.Field <string>(fldNumber.First());
string schVendor = Regex.Replace(row.Field <string>(fldVendor.First()), @"[^A-Za-zА-Яа-я0-9]+", "").ToUpper();
string schNumber = Regex.Replace(row.Field <string>(fldNumber.First()), @"[^A-Za-zА-Яа-я0-9]+", "").ToUpper();
string description = row.Field <string>(fldDescription.First());
string strPrice = row.Field <string>(fldPrice.First()).Replace(",", ".");
int count = Convert.ToInt32(Regex.Match(row.Field <string>(fldCount.First()), @"[0-9]+$").Value);
string query = $"INSERT INTO ZipItems (Vendor, Number, SearchVendor, SearchNumber, Description, Price, Count) VALUES (N'{vendor}', N'{number}', N'{schVendor}', N'{schNumber}', N'{description}', {strPrice}, {count})";
int qan = dbContext.Database.ExecuteSqlCommand(query);
}
//"INSERT INTO ZipItems (Vendor, Number, Description, Price, Count) VALUES (@vendor, 'SA-1712L', '666', 'SA1712L', 'Рычаг подвески | перед лев |', '1343', '2')";
//int qan = dbContext.Database.ExecuteSqlCommand(query);
dbContext.Dispose();
}
ViewBag.Table = xmlData;
return(str);
}
public void Dispose()
{
_context.Dispose();
}