public int InsertByHashtable(string tableName, Hashtable paramlist) { StringBuilder sb = new StringBuilder("insert into {0}({1}) values({2})"); StringBuilder sbColumns = new StringBuilder(); StringBuilder sbValues = new StringBuilder(); foreach (DictionaryEntry item in paramlist) { if (sbColumns.Length == 0) { sbColumns.Append(item.Key); } else { sbColumns.Append("," + item.Key); } if (sbValues.Length == 0) { sbValues.Append("@" + item.Key); } else { sbValues.Append(",@" + item.Key); } } string sql = string.Format("insert into {0}({1}) values({2})", tableName, sbColumns.ToString(), sbValues.ToString()); return(DbHelperSQL2.ExecuteSql(sql, paramlist)); }
public int InsertTable(Hashtable ht, string tableName) { StringBuilder sb = new StringBuilder(); StringBuilder sbVal = new StringBuilder(); foreach (DictionaryEntry item in ht) { sb.AppendFormat("{0},", item.Key); sbVal.AppendFormat("@{0},", item.Key); } string InsertSql = string.Format("insert into {0}({1}) values({2})", tableName, sb.ToString().Trim(','), sbVal.ToString().Trim(',')); return(DbHelperSQL2.ExecuteSql(InsertSql, ht)); }
public int UpdateTable(Hashtable ht, string tableName, string idName = "id") { StringBuilder sb = new StringBuilder(); foreach (DictionaryEntry item in ht) { if (!item.Key.ToString().Equals(idName, StringComparison.CurrentCultureIgnoreCase)) { sb.AppendFormat(" {0} = @{0},", item.Key); } } string UpdateSql = string.Format("update {0} set {1} where {2}=@{2}", tableName, sb.ToString().Trim(','), idName); return(DbHelperSQL2.ExecuteSql(UpdateSql, ht)); }
public int UID(string sql, Hashtable pararm = null) { // SqlParameter[] parameters = BuildSqlParameters(pararm); return(DbHelperSQL2.ExecuteSql(sql, pararm)); }
public int UID(string Sql) { return(DbHelperSQL2.ExecuteSql(Sql)); }