1、//DAL层FileDAL类
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model;
namespace DAL
{
public class FileDAL
{
///
/// 上传文件
///
/// 文件模型
///
public int OnLoad(FileInfo mod)
{
string sql = $“insert into FileInfo values(’{mod.FName}’,{mod.FSize},’{mod.FileUrl}’)”;
return DBHelper.ExecuteNonQuery(sql);
}
/// <summary>
/// 显示列表
/// </summary>
/// <returns></returns>
public List<FileInfo> GetFileInfos()
{
string sql = "select * from FileInfo";
return DBHelper.GetList<FileInfo>(sql);
}
}
}
2、控制器
using System;