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;
}
