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