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