/// <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); } }