/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SmartTeaching.Entity.Base_UserRole model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_UserRole set ");
strSql.Append(" UserId = @UserId , ");
strSql.Append(" RoleId = @RoleId , ");
strSql.Append(" NewsTypeId = @NewsTypeId ");
strSql.Append(" where UserRoleId=@UserRoleId ");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@NewsTypeId", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.RoleId;
parameters[2].Value = model.NewsTypeId;
int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SmartTeaching.Entity.Base_UserRole GetModel(int UserRoleId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserRoleId, UserId, RoleId, NewsTypeId ");
strSql.Append(" from Base_UserRole ");
strSql.Append(" where UserRoleId=@UserRoleId ");
SqlParameter[] parameters =
{
new SqlParameter("@UserRoleId", SqlDbType.Int, 4)
};
parameters[0].Value = UserRoleId;
SmartTeaching.Entity.Base_UserRole model = new SmartTeaching.Entity.Base_UserRole();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UserRoleId"].ToString() != "")
{
model.UserRoleId = int.Parse(ds.Tables[0].Rows[0]["UserRoleId"].ToString());
}
if (ds.Tables[0].Rows[0]["UserId"].ToString() != "")
{
model.UserId = int.Parse(ds.Tables[0].Rows[0]["UserId"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleId"].ToString() != "")
{
model.RoleId = int.Parse(ds.Tables[0].Rows[0]["RoleId"].ToString());
}
if (ds.Tables[0].Rows[0]["NewsTypeId"].ToString() != "")
{
model.NewsTypeId = int.Parse(ds.Tables[0].Rows[0]["NewsTypeId"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(SmartTeaching.Entity.Base_UserRole model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_UserRole(");
strSql.Append("UserId,RoleId,NewsTypeId");
strSql.Append(") values (");
strSql.Append("@UserId,@RoleId,@NewsTypeId");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@RoleId", SqlDbType.Int, 4),
new SqlParameter("@NewsTypeId", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.RoleId;
parameters[2].Value = model.NewsTypeId;
SqlServerHelper.ExecuteSql(strSql.ToString(), parameters);
}