/// <summary>
/// 获取一条记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public EmployeeNewInfo GetModel(int id)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "select * from T_News where id=@id";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@id", id),
};
DataTable dt = dbOper.Query(sql, paras, conn);
EmployeeNewInfo newInfo = null;
if (dt.Rows.Count > 0)
{
newInfo = new EmployeeNewInfo();
LoadEntity(dt.Rows[0], newInfo);
}
return(newInfo);
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
public UserInfo GetUser(string userName, string userPwd)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "select * from T_UserInfo where UserName=@UserName and UserPwd=@UserPwd";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@UserName", userName),
dbOper.GetDataParameter("@UserPwd", userPwd)
};
//读取数据
DataTable dt = dbOper.Query(sql, paras, conn);
UserInfo userInfo = null;
if (dt.Rows.Count > 0)
{
userInfo = new UserInfo();
LoadEntity(userInfo, dt.Rows[0]);
}
return(userInfo);
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
public List <EmployeeNewInfo> GetPageList(int start, int end)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "select * from (select row_number() over(order by id) as num,* from T_News) as t where t.num>=@start and t.num<=@end";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@start", start),
dbOper.GetDataParameter("@end", end)
};
DataTable dt = dbOper.Query(sql, paras, conn);
List <EmployeeNewInfo> list = null;
if (dt.Rows.Count > 0)
{
list = new List <EmployeeNewInfo>();
EmployeeNewInfo newInfo = null;
foreach (DataRow row in dt.Rows)
{
newInfo = new EmployeeNewInfo();
LoadEntity(row, newInfo);
list.Add(newInfo);
}
}
return(list);
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
