public void CRUD()
{
// 1.增删改
var fileTerm = new FileTerm()
{
ID = Guid.NewGuid(),
Title = "ado.net test",
Describe = "add from ado.net",
GenreID = Guid.Empty,
IsNotice = true,
CreateTime = DateTime.Now
};
this._fileDAL.Add(fileTerm);
var fileTerm1 = this._fileDAL.Get <FileTerm>(fileTerm.ID);
fileTerm1.CreateTime = DateTime.Now;
this._fileDAL.Update(fileTerm1);
int r = this._fileDAL.Delete <FileTerm>(fileTerm.ID);
// 2.查询数据集 - DataSet
DataSet dataSet = this._fileDAL.Get("SELECT TOP 100 * FROM FILETERMS ORDER BY ft_CREATETIME DESC");
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dataSet.Tables[0].Rows)
{
sb.Append(row["ft_ID"] + "," + row["ft_Title"] + "," + row["ft_CreateTime"] + Environment.NewLine);
}
Debug.WriteLine(sb.ToString());
// 3.查询数据集
//var fileTerms = this._fileDAL.Get(10);
var fileTerms = this._fileDAL.Get(0, 9, string.Empty, "ft_ID");
// 4.查询表行数
int count = this._fileDAL.Count();
// 5.查询是否存在数据
bool b = this._fileDAL.IsExists("t");
}
public void AddDatas()
{
Random rad = new Random();
for (int i = 0; i < 1000; i++)
{
var fileTerm = new FileTerm()
{
ID = Guid.NewGuid(),
Title = "ado.net test" + i,
Describe = "add from ado.net" + rad.NextDouble(),
GenreID = Guid.Empty,
IsNotice = true,
CreateTime = DateTime.Now,
Amounts = 100,
Type = Types.T2
};
this._fileDAL.Add(fileTerm);
}
}
