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