//数据库连接
string str = "Data Source=.;Initial Catalog=Day14;Integrated Security=True";
//添加
[HttpPost]
public int Add(ModelInfo mf)
{
using (SqlConnection conn = new SqlConnection(str))
{
string sql = $"insert into Goods values ('{mf.Name}','{mf.Pwd}','{mf.Img}')";
return conn.Execute(sql, mf);
}
}
//显示
[HttpGet]
public List<ModelInfo> Show()
{
using (SqlConnection conn = new SqlConnection(str))
{
ModelInfo mf = new ModelInfo();
string sql = $"select * from Goods";
return conn.Query<ModelInfo>(sql, mf).ToList();
}
}
//查询
[HttpGet]
public List<ModelInfo> Select(string name)
{
using (SqlConnection conn = new SqlConnection(str))
{
string sql = $"select * from Goods where Name like '%{name}%'";
return conn.Query<ModelInfo>(sql, name).ToList();
}
}
//删除
//vs的BUG 删除不用Get出不来
[HttpGet]
public int Del(string id)
{
using (SqlConnection conn = new SqlConnection(str))
{
string sql = $"delete Goods where ID = {id}";
return conn.Execute(sql, id);
}
}
//修改
[HttpPut]
public int Upd(ModelInfo mf)
{
using (SqlConnection conn = new SqlConnection(str))
{
string sql = $"update Goods set Pwd = '{mf.Pwd}' where ID = {mf.ID} ";
return conn.Execute(sql, mf);
}
}
APIFileHelp help = new APIFileHelp();
//导出
[HttpGet]
public void Export1()
{
List<ModelInfo> list = Show().ToList();
Dictionary<string, string> dis = new Dictionary<string, string>();
dis.Add("ID", "编号"); //需要导出的字段
dis.Add("Name", "用户名"); //需要导出的字段
dis.Add("Pwd", "密码"); //需要导出的字段
dis.Add("Img", "图片"); //需要导出的字段
help.ExportExcel<ModelInfo>("Wupin.xls", list, dis);
}
// 上传文件 控制器端
[HttpPost]
public FileResult UpLoad()
{
return help.UpLoad();
}