public int Delete(UserPriceProductEntity userBalanceHistory, Dictionary<string, string> conditionDic) { try { if (conditionDic == null) { return 0; } StringBuilder sql = new StringBuilder("Delete from ").Append(tableName); int i = 0, len = conditionDic.Keys.Count - 1; foreach (KeyValuePair<string, string> item in conditionDic) { if (i == len) { sql.Append(item.Key).Append("=").Append(item.Value); } else { sql.Append(item.Key).Append("=").Append(item.Value).Append(" and "); } } int result = 1; using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction tran = conn.BeginTransaction(); try { db.ExecuteNonQuery(tran, CommandType.Text, sql.ToString()); tran.Commit(); } catch (Exception) { tran.Rollback(); result = 0; } finally { conn.Close(); } } return result; } catch (Exception ex) { throw new DalException("系统异常!", ex); } }
/// <summary> /// 充值历史不提供修改的功能 /// </summary> /// <param name="product"></param> /// <param name="conditionDic"></param> /// <returns></returns> public int Update(UserPriceProductEntity userBalanceHistory, Dictionary<string, string> conditionDic) { //if (conditionDic == null) //{ // return 0; //} //StringBuilder sql = new StringBuilder("Update ").Append(tableName); //sql.Append(" set "); //sql.Append("UserID=@uid,"); //sql.Append("Balance=@balance,"); //sql.Append("Remark=@remark"); //int i = 0, len = conditionDic.Keys.Count - 1; //foreach (KeyValuePair<string, string> item in conditionDic) //{ // if (i == len) // { // sql.Append(item.Key).Append("=").Append(item.Value); // } // else // { // sql.Append(item.Key).Append("=").Append(item.Value).Append(" and "); // } //} //int result = db.ExecuteNonQuery(CommandType.Text, sql.ToString()); //return result; return 0; }