public static int update(DBInstance dbmgr, List <Param> request, int id = 0)
{
//id=0为插入新字段
using (DbConnection conn = dbmgr.GetDbConnection())
{
conn.Open();
using (DbTransaction tx = conn.BeginTransaction())
{
string sql = "";
if (id == 0)
{
id = dbmgr.getNewId("tb_notify_log");
sql = "insert into tb_notify_log (id,created_user,created_date,updated_user,updated_date,`notify_time`,`log_request`,`log_url` ) values (" + id.ToString() + ",-2,now(),-2,now(),@notify_time ,@log_request ,@log_url )";
}
else
{
sql = "update tb_notify_log set updated_user=-2, updated_date=now() ,`notify_time`=@notify_time ,`log_request`=@log_request ,`log_url`=@log_url where id=" + id.ToString();
}
dbmgr.ExecuteNonQuery(tx, sql, request);
tx.Commit();
return(id);
}
}
}
public static int update(DBInstance dbmgr, List <Param> request, int id = 0)
{
//id=0为插入新字段
using (DbConnection conn = dbmgr.GetDbConnection())
{
conn.Open();
using (DbTransaction tx = conn.BeginTransaction())
{
string sql = "";
if (id == 0)
{
id = dbmgr.getNewId("tb_payment");
sql = "insert into tb_payment (id,created_user,created_date,updated_user,updated_date,`orderno`,`time_end`,`openid`,`total_fee`,`trade_type`,`transaction_id`,`result_code` ) values (" + id.ToString() + ",-2,now(),-2,now(),@orderno ,@time_end ,@openid ,@total_fee ,@trade_type ,@transaction_id ,@result_code )";
}
else
{
sql = "update tb_payment set updated_user=-2, updated_date=now() ,`orderno`=@orderno ,`time_end`=@time_end ,`openid`=@openid ,`total_fee`=@total_fee ,`trade_type`=@trade_type ,`transaction_id`=@transaction_id ,`result_code`=@result_code where id=" + id.ToString();
}
dbmgr.ExecuteNonQuery(tx, sql, request);
tx.Commit();
return(id);
}
}
}