/// <summary>
/// a01.将数据表转换成泛型集合接口
/// </summary>
/// <param name="dt">数据表对象</param>
/// <returns>泛型集合接口</returns>
public IList<Company.Model.Users> Table2List(DataTable dt)
{
List<Company.Model.Users> list = null;
if (dt.Rows.Count > 0)
{
list = new List<Company.Model.Users>();
Company.Model.Users Model = null;
foreach (DataRow dr in dt.Rows)
{
Model = new Company.Model.Users();
LoadEntityData(Model, dr);
list.Add(Model);
}
return list;
}
return null;
}
/// <summary>
/// 根据ID获得实体对象
/// </summary>
/// <param name="intId">id值</param>
/// <returns>实体对象</returns>
public Company.Model.Users GetModel(int intId)
{
StringBuilder strSql = new StringBuilder("select uId,uLoginName,uPwd from Users ");
strSql.Append(" where uId=@intId ");
Company.Model.Users Model = new Company.Model.Users();
DataTable dt = SQLHelper.GetDataTable(strSql.ToString(), new SqlParameter("@intId", intId));
if (dt.Rows.Count > 0)
{
LoadEntityData(Model, dt.Rows[0]);
return Model;
}
else
{
return null;
}
}
/// <summary>
/// 根据用户登录名 查询用户
/// </summary>
/// <param name="strLoginName"></param>
/// <returns></returns>
public Company.Model.Users Login(string strLoginName)
{
DataTable dt = SQLHelper.GetDataTable("select * from Users where uLoginName=@uLoginName", new SqlParameter("@uLoginName", strLoginName));
if (dt != null && dt.Rows.Count > 0)
{
Company.Model.Users userModel = new Company.Model.Users();
LoadEntityData(userModel, dt.Rows[0]);
return userModel;
}
return null;
}
