public int UpdateById(UsersPermissionModle modle)
{
String sql = "UPDATE UsersPermission 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(UsersPermissionModle modle)
{
String sql = "INSERT INTO UsersPermission VALUES(@RolesId,@SystemMenuId)";
return(dbo.NoQuery(sql, new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@RolesId",
SqlDbType = SqlDbType.Int,
Value = modle.RolesId
},
new SqlParameter()
{
ParameterName = "@SystemMenuId",
SqlDbType = SqlDbType.Int,
Value = modle.SystemMenuId
}
}));
}
public int Insert(UsersPermissionModle modle)
{
return(dal.Insert(modle));
}
public int UpdateById(UsersPermissionModle modle)
{
return(dal.UpdateById(modle));
}
