/// <summary> /// 更新一条数据 /// </summary> public void UpdateAdSort(AdSortInfo sinfo) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ROYcms_Ad_Sort set "); strSql.Append("sortname=@sortname"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@sortname", SqlDbType.VarChar, 50) }; parameters[0].Value = sinfo.id; parameters[1].Value = sinfo.sortname; SqlHelper.ExecuteNonQuery(SqlHelper.Conn, CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void AddAdSort(AdSortInfo sinfo) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ROYcms_Ad_Sort("); strSql.Append("id,sortname)"); strSql.Append(" values ("); strSql.Append("@id,@sortname)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@sortname", SqlDbType.VarChar, 50) }; parameters[0].Value = sinfo.id; parameters[1].Value = sinfo.sortname; SqlHelper.ExecuteNonQuery(SqlHelper.Conn, CommandType.Text, strSql.ToString(), parameters); }