简单数据操作

/// <summary>
  /// 添加链接信息
  /// </summary>
  /// <param name="promotionInfo"></param>
  /// <param name="state"></param>
  /// <returns></returns>
  public static int addLinkSql(string promotionInfo,string state)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("insert into Lottery_Promotion_LinkManage(PromotionInfo,State)");
   strSql.Append(" values (");
   strSql.Append("'"+promotionInfo+"',"+state+")");
   return executeSql(strSql.ToString());
  }
  

  /// <summary>
  /// 根据ID更新链接信息
  /// </summary>
  /// <param name="id"></param>
  /// <param name="promotionInfo"></param>
  /// <param name="state"></param>
  /// <returns></returns>
  public static int updataLinkSql(string id,string promotionInfo,string state)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("update Lottery_Promotion_LinkManage set ");
   strSql.Append("PromotionInfo='"+promotionInfo+"',State="+state);
   strSql.Append(" where ID="+id);
   return executeSql(strSql.ToString());
  }
  
  /// <summary>
  /// 根据条件删除记录
  /// </summary>
  /// <param name="table">表名</param>
  /// <param name="fileWhere">条件</param>
  public static int deleteInfo(string table,string fileWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("delete "+table);
   strSql.Append(" where "+fileWhere);
   return executeSql(strSql.ToString());
  }
  
  /// <summary>
  /// 执行SQL 语句
  /// </summary>
  /// <param name="sql">sql 语句</param>
  /// <returns></returns>
  public static int executeSql(string sql)
  {
   object obj = jetlau.DBUtility.DbHelperSQL.ExecuteSql(sql);
   if (obj == null)
   {
    return 1;
   }
   else
   {
    return Convert.ToInt32(obj);
   }
  }