public void GetEntitysTest()
{
string _sql = "SELECT [CustomerID],[CompanyName],[ContactName],[ContactTitle],[Address],[City],[Region],[PostalCode],[Country],[Phone],[Fax] FROM [Customers]";
//IDataReader _reader = sqlHelper.ExecuteReader(_sql, null);
//IEnumerable<Customers> _customers = _reader.GetEntitys<Customers>();
IEnumerable <Customers> _customers = sqlHelper.ExecuteReader <Customers>(_sql, null);
Assert.IsNotNull(_customers);
}
public void ExecuteReaderTest()
{
ExecuteNonQueryTest();
string _sql = "select * from dbo.Person where PName=@pname";
IDataReader _reader = SqlHelper.ExecuteReader(_sql, new DbParameter[1] {
new SqlParameter("@pname", "YanZhiwei")
});
Assert.IsTrue(_reader.Read());
}
public void ToDataTableTest()
{
SqlServerDataOperator _sqlHelper = new SqlServerDataOperator(@"server=YANZHIWEI-PC\SQLEXPRESS;database=AdventureWorks2014;uid=sa;pwd=sasa;");
string _sql = @"SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
,[rowguid]
,[ModifiedDate]
FROM [Person].[Address]";
List <Address> _result = _sqlHelper.ExecuteReader <Address>(_sql, null);
DataTable _actual = GeneralMapper.ToDataTable <Address>(_result);
Assert.IsTrue(_actual.Rows.Count > 0);
}
/// <summary>
/// 根据角色名称模糊查询
/// </summary>
/// <typeparam name="T">泛型</typeparam>
/// <param name="name">角色名称</param>
/// <returns></returns>
/// 时间：2015-11-26 11:37
/// 备注：
public List <T> FuzzySearchRolesByName <T>(string name)
where T : Role, new()
{
string _sql = "select [R_Code],[R_Name],[R_Sort],[R_Visible] from Roles where r_visible=1 and R_Name like @name";
SqlParameter[] _paramter = new SqlParameter[1];
_paramter[0] = new SqlParameter("@name", "%" + name + "%");
using (IDataReader reader = sqlHelper.ExecuteReader(_sql, _paramter))
{
List <T> _roles = new List <T>();
while (reader.Read())
{
T _singleRole = new T();
_singleRole.Code = reader.GetValue <string>("R_Code", string.Empty);
_singleRole.Name = reader.GetValue <string>("R_Name", string.Empty);
_singleRole.Sort = reader.GetValue <int>("R_Sort", 0);
_singleRole.Visible = reader.GetValue <bool>("R_Visible", false);
_roles.Add(_singleRole);
}
return(_roles);
};
}