public int Editretlog(Taobao_reverse_retlog log)
{
using (var helper = new SqlHelper())
{
int r = new InternalTaobao_reverse_retlog(helper).EditRetLog(log);
return(r);
}
}
internal int EditRetLog(Taobao_reverse_retlog log)
{
if (log.id == 0)
{
string sql = @"INSERT INTO [taobao_reverse_retlog]
([order_id]
,[reverse_code]
,[reverse_num]
,[consume_secial_num]
,[verify_codes]
,[qr_images]
,[token]
,[codemerchant_id]
,[posid]
,[ret_code]
,[item_title]
,[left_num]
,[ret_time])
VALUES
(@order_id
,@reverse_code
,@reverse_num
,@consume_secial_num
,@verify_codes
,@qr_images
,@token
,@codemerchant_id
,@posid
,@ret_code
,@item_title
,@left_num
,@ret_time );select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@order_id", log.order_id);
cmd.AddParam("@reverse_code", log.reverse_code);
cmd.AddParam("@reverse_num", log.reverse_num);
cmd.AddParam("@consume_secial_num", log.consume_secial_num);
cmd.AddParam("@verify_codes", log.verify_codes);
cmd.AddParam("@qr_images", log.qr_images);
cmd.AddParam("@token", log.token);
cmd.AddParam("@codemerchant_id", log.codemerchant_id);
cmd.AddParam("@posid", log.posid);
cmd.AddParam("@ret_code", log.ret_code);
cmd.AddParam("@item_title", log.item_title);
cmd.AddParam("@left_num", log.left_num);
cmd.AddParam("@ret_time", log.ret_time);
try
{
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
catch
{
sqlHelper.Dispose();
return(0);
}
}
else
{
string sql = @"UPDATE [taobao_reverse_retlog]
SET [order_id] = @order_id
,[reverse_code] = @reverse_code
,[reverse_num] = @reverse_num
,[consume_secial_num] = @consume_secial_num
,[verify_codes] = @verify_codes
,[qr_images] = @qr_images
,[token] = @token
,[codemerchant_id] = @codemerchant_id
,[posid] = @posid
,[ret_code] = @ret_code
,[item_title] = @item_title
,[left_num] = @left_num
,[ret_time] = @ret_time
WHERE id=@id;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", log.id);
cmd.AddParam("@order_id", log.order_id);
cmd.AddParam("@reverse_code", log.reverse_code);
cmd.AddParam("@reverse_num", log.reverse_num);
cmd.AddParam("@consume_secial_num", log.consume_secial_num);
cmd.AddParam("@verify_codes", log.verify_codes);
cmd.AddParam("@qr_images", log.qr_images);
cmd.AddParam("@token", log.token);
cmd.AddParam("@codemerchant_id", log.codemerchant_id);
cmd.AddParam("@posid", log.posid);
cmd.AddParam("@ret_code", log.ret_code);
cmd.AddParam("@item_title", log.item_title);
cmd.AddParam("@left_num", log.left_num);
cmd.AddParam("@ret_time", log.ret_time);
cmd.ExecuteNonQuery();
return(log.id);
}
}
