internal Taobao_send_noticeretlog GetSendRetLogByQrcode(string qrcode)
{
string sql = "SELECT top 1 * FROM [taobao_send_noticeretlog] where verify_codes like '%" + qrcode + "%' order by id desc";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
Taobao_send_noticeretlog log = null;
if (reader.Read())
{
log = new Taobao_send_noticeretlog
{
id = reader.GetValue <int>("id"),
order_id = reader.GetValue <string>("order_id"),
verify_codes = reader.GetValue <string>("verify_codes"),
token = reader.GetValue <string>("token"),
codemerchant_id = reader.GetValue <string>("codemerchant_id"),
qr_images = reader.GetValue <string>("qr_images"),
ret_code = reader.GetValue <string>("ret_code"),
ret_time = reader.GetValue <DateTime>("ret_time")
};
}
return(log);
}
}
public int Editsendnoticeretlog(Taobao_send_noticeretlog mretlog)
{
using (var helper = new SqlHelper())
{
int r = new InternalTaobao_send_noticeretlog(helper).Editsendnoticeretlog(mretlog);
return(r);
}
}
internal int Editsendnoticeretlog(Taobao_send_noticeretlog log)
{
if (log.id == 0)
{
var sql = @"INSERT INTO [taobao_send_noticeretlog]
([order_id]
,[verify_codes]
,[token]
,[codemerchant_id]
,[qr_images]
,[ret_code]
,[ret_time])
VALUES
(@order_id
,@verify_codes
,@token
,@codemerchant_id
,@qr_images
,@ret_code
,@ret_time);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@order_id", log.order_id);
cmd.AddParam("@verify_codes", log.verify_codes);
cmd.AddParam("@token", log.token);
cmd.AddParam("@codemerchant_id", log.codemerchant_id);
cmd.AddParam("@qr_images", log.qr_images);
cmd.AddParam("@ret_code", log.ret_code);
cmd.AddParam("@ret_time", log.ret_time);
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
else
{
string sql = @"UPDATE [taobao_send_noticeretlog]
SET [order_id] = @order_id
,[verify_codes] = @verify_codes
,[token] = @token
,[codemerchant_id] = @codemerchant_id
,[qr_images] = @qr_images
,[ret_code] = @ret_code
,[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("@verify_codes", log.verify_codes);
cmd.AddParam("@token", log.token);
cmd.AddParam("@codemerchant_id", log.codemerchant_id);
cmd.AddParam("@qr_images", log.qr_images);
cmd.AddParam("@ret_code", log.ret_code);
cmd.AddParam("@ret_time", log.ret_time);
cmd.ExecuteNonQuery();
return(log.id);
}
}
