From 39d9119158858fe83b28bdc78cd2ba75cf085cdf Mon Sep 17 00:00:00 2001
From: chenzx <m15572880737@163.com>
Date: 星期二, 26 十一月 2024 19:29:14 +0800
Subject: [PATCH] 20241126czx接口改动
---
GasolineBlend.DAL/DefaultCompanyDAL.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/GasolineBlend.DAL/DefaultCompanyDAL.cs b/GasolineBlend.DAL/DefaultCompanyDAL.cs
index 14792d9..d7bb5fd 100644
--- a/GasolineBlend.DAL/DefaultCompanyDAL.cs
+++ b/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
--
Gitblit v1.8.0