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