20241125czx接口更新

chenzx

2024-11-25 68f761dcdef9149f148508e5df8f1c2970934f15

 GasolineBlend.DAL/PushDataDAL.cs

@@ -20,7 +20,7 @@
        {
            using (IDbConnection connection = new MySqlConnection(connectionString))
            {
                var sql = $"SELECT id,ispolicy,isdeclarationnotice,ispublicannouncement,islawsandregulations,isemailpush,inbox,userid,modificationtime FROM pushdata WHERE userid= '{UserId}'";
                var sql = $"SELECT id,ispolicy,isdeclarationnotice,ispublicannouncement,islawsandregulations,isemailpush,email,userid,modificationtime,region,keyword FROM pushdata WHERE userid= '{UserId}'";
                return connection.Query<PushDataPage>(sql).ToList();
            }
        }
@@ -36,10 +36,12 @@
                   ispublicannouncement = @IsPublicAnnouncement,
                   islawsandregulations = @IsLawsAndRegulations,
                   isemailpush = @IsEmailPush,
                   inbox = @Inbox,
                   email = @Email,
                   keyword = @Keyword,
                   region = @Region,
                   modificationtime = NOW()
               WHERE userid = @UserId";

                 
                var parameters = new
                {
                    IsPolicy = pushDataPage.IsPolicy,
@@ -47,7 +49,9 @@
                    IsPublicAnnouncement = pushDataPage.IsPublicAnnouncement,
                    IsLawsAndRegulations = pushDataPage.IsLawsAndRegulations,
                    IsEmailPush = pushDataPage.IsEmailPush,
                    Inbox = pushDataPage.Inbox,
                    Email = pushDataPage.Email,
                    Keyword = pushDataPage.Keyword,
                    Region = pushDataPage.Region,
                    UserId = pushDataPage.UserId
                };

@@ -62,8 +66,8 @@
            using (IDbConnection connection = new MySqlConnection(connectionString))
            {
                var sql = @"
                INSERT INTO pushdata (ispolicy, isdeclarationnotice, ispublicannouncement, islawsandregulations, isemailpush, inbox,modificationtime,userid)
                VALUES ( 0, 0, 0,0, 0,NULL,NOW(),@UserId)";
                INSERT INTO pushdata (ispolicy, isdeclarationnotice, ispublicannouncement, islawsandregulations, isemailpush, inbox,modificationtime,region,keyword,userid)
                VALUES ( 0, 0, 0,0, 0,NULL,NOW(),NULL,NULL,@UserId)";

                var parameters = new
                {