/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="newInfo"></param>
/// <returns></returns>
public bool AddInfo(EmployeeNewInfo newInfo)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "insert into T_News(Author,Title,Msg,ImagePath,SubDateTime) values(@Author,@Title,@Msg,@ImagePath,@SubDateTime)";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@Author", newInfo.Author),
dbOper.GetDataParameter("@Title", newInfo.Title),
dbOper.GetDataParameter("@Msg", newInfo.Msg),
dbOper.GetDataParameter("@ImagePath", newInfo.ImagePath),
dbOper.GetDataParameter("@SubDateTime", newInfo.SubDateTime)
};
return(dbOper.Exce(sql, paras, conn));
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
/// <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);
}
}
/// <summary>
/// 注册一个用户
/// </summary>
/// <param name="newInfo"></param>
/// <returns></returns>
public bool AddUser(UserInfo userinfo)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "insert into T_UserInfo(username,userpwd,usermail,regtime) values(@UserName,@UserPwd,@UserMail,@RegTime)";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@UserName", userinfo.UserName),
dbOper.GetDataParameter("@UserPwd", userinfo.UserPwd),
dbOper.GetDataParameter("@UserMail", userinfo.UserMail),
dbOper.GetDataParameter("@RegTime", userinfo.RegTime)
};
return(dbOper.Exce(sql, paras, conn));
}
}
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);
}
}
/// <summary>
/// 获取总的记录数
/// </summary>
/// <returns></returns>
public int GetRecordCount()
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "select count(*) from T_News";
return(Convert.ToInt32(dbOper.ExecuteScalar(sql, null, conn, null)));
}
}
catch (System.Exception ex)
{
throw new Exception.DalException(ex.Message);
}
}
/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteInfo(int id)
{
try
{
//获取数据库操作接口
IDBOper dbOper = DBOper.DBOperSingle;
//打开数据库连接
using (IDbConnection conn = dbOper.OpenConn())
{
string sql = "delete from T_News where id=@id";
IDataParameter[] paras = new IDataParameter[]
{
dbOper.GetDataParameter("@id", id),
};
return(dbOper.Exce(sql, paras, conn));
}
}
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);
}
}
