20241126czx接口改动

chenzx

2024-11-26 39d9119158858fe83b28bdc78cd2ba75cf085cdf

20241126czx接口改动

 GasolineBlend.DAL/DefaultCompanyDAL.cs

@@ -20,7 +20,7 @@
        {
            using (IDbConnection connection = new MySqlConnection(connectionString))
            {
                var sql = $"SELECT id,compose,userid,createtime FROM defaultcompany WHERE userid= '{UserId}'";
                var sql = $"SELECT id,company,userid,createtime FROM defaultcompany WHERE userid= '{UserId}'";
                return connection.Query<DefaultCompany>(sql).ToList();
            }
        }
@@ -31,13 +31,13 @@
                var sql = @"
               UPDATE defaultcompany
               SET
                   compose = @Compose,
                   company = @Company,
                   createtime = NOW()
               WHERE userid = @UserId";

                var parameters = new
                {
                    Compose = defaultCompany.Compose,
                    Company = defaultCompany.Company,
                    UserId = defaultCompany.UserId
                };

@@ -52,7 +52,7 @@
            using (IDbConnection connection = new MySqlConnection(connectionString))
            {
                var sql = @"
                INSERT INTO defaultcompany (compose,createtime,userid)
                INSERT INTO defaultcompany (company,createtime,userid)
                VALUES (NULL,NOW(),@UserId)";

                var parameters = new