czx20241211接口更新

chenzx

2024-12-11 4043a2fe2103c7960b74acbccdcc876d11f83f0f

 GasolineBlend.DAL/TreeDiagramRecordDAL.cs

@@ -24,8 +24,6 @@
                return connection.Query<TreeDiagramRecord>(sql).ToList();
            }
        }


        public bool AddTreeDiagramRecord(TreeDiagramRecord treeDiagramRecord)
        {
            using (IDbConnection connection = new MySqlConnection(connectionString))
@@ -45,6 +43,27 @@
                return affectedRows > 0;
            }
        }
        public bool UpdateTreeDiagramRecord(TreeDiagramRecord treeDiagramRecord)
        {
            using (IDbConnection connection = new MySqlConnection(connectionString))
            {
                var sql = @"
                update treediagramrecord 
                set content=@Content,
                modificationtime=NOW()
                where companyname=@CompanyName";

                var parameters = new
                {
                    CompanyName = treeDiagramRecord.CompanyName,
                    Content = treeDiagramRecord.Content
                };

                connection.Open(); // 打开数据库连接
                int affectedRows = connection.Execute(sql, parameters); // 执行更新操作
                return affectedRows > 0;
            }
        }

    }
}