/// <summary> /// 通过Hashtable修改数据 /// </summary> /// <param name="tableName">表名</param> /// <param name="pkName">字段主键</param> /// <param name="pkValue"></param> /// <param name="ht">Hashtable</param> /// <returns>int</returns> public static int UpdateByHashtable(string connectionString, string tableName, string pkName, string pkVal, Dictionary <string, string> ht) { StringBuilder sb = new StringBuilder(); sb.Append(" Update "); sb.Append(tableName); sb.Append(" Set "); bool isFirstValue = true; foreach (string key in ht.Keys) { if (isFirstValue) { isFirstValue = false; sb.Append(key); sb.Append("="); sb.Append("?" + key); } else { sb.Append("," + key); sb.Append("="); sb.Append("?" + key); } } sb.Append(" Where ").Append(pkName).Append("=").Append("?" + pkName); ht[pkName] = pkVal; MySqlParameter[] _params = MySqlHelper.GetParameter(ht); object _object = MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sb.ToString(), _params); return((_object == DBNull.Value) ? 0 : Convert.ToInt32(_object)); }
/// <summary> /// 通过Dictionary插入数据 /// </summary> /// <param name="tableName">表名</param> /// <param name="ht">Hashtable</param> /// <returns>int</returns> public static int InsertByHashtable(string connectionString, string tableName, Dictionary <string, string> ht) { StringBuilder sb = new StringBuilder(); sb.Append(" Insert Into "); sb.Append(tableName); sb.Append("("); StringBuilder sp = new StringBuilder(); StringBuilder sb_prame = new StringBuilder(); foreach (string key in ht.Keys) { sb_prame.Append("," + key); sp.Append(",?" + key); } sb.Append(sb_prame.ToString().Substring(1, sb_prame.ToString().Length - 1) + ") Values ("); sb.Append(sp.ToString().Substring(1, sp.ToString().Length - 1) + ")"); int _object = MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sb.ToString(), MySqlHelper.GetParameter(ht)); return(_object); }