public int UpdateById(UsersModle modle) { String sql = "UPDATE Users SET TITLE=@TITLE WHERE(ID=@ID)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@ID", SqlDbType = SqlDbType.Int, Value = modle.Id, }, new SqlParameter() { ParameterName = "@TITLE", SqlDbType = SqlDbType.Int, Value = modle.Id, }, })); }
public int Insert(UsersModle modle) { String sql = "INSERT INTO Users VALUES(@EMAIL,@PASSWORD,@NICKNAME,@PHOTO,@CREATETIME,@RolesId)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@EMAIL", SqlDbType = SqlDbType.NVarChar, Value = modle.Email }, new SqlParameter() { ParameterName = "@PASSWORD", SqlDbType = SqlDbType.NVarChar, Value = modle.Password }, new SqlParameter() { ParameterName = "@NICKNAME", SqlDbType = SqlDbType.NVarChar, Value = modle.NickName }, new SqlParameter() { ParameterName = "@PHOTO", SqlDbType = SqlDbType.NVarChar, Value = modle.Photo }, new SqlParameter() { ParameterName = "@CREATETIME", SqlDbType = SqlDbType.NVarChar, Value = modle.CreateTime }, new SqlParameter() { ParameterName = "@RolesId", SqlDbType = SqlDbType.NVarChar, Value = modle.RolesId }, })); }
public int UpdateById(UsersModle modle) { return(dal.UpdateById(modle)); }
public int Insert(UsersModle modle) { return(dal.Insert(modle)); }