// GET: api/showApi
/// <summary>
/// 显示 查询
/// </summary>
/// <param name="name"></param>
/// <param name="type"></param>
/// <returns></returns>
[HttpGet]
public List<stuModel> show(string name,int type=0)
{
var p = new BLL.stuBLL().show(name,type);
return p.ToList();
}
/// <summary>
/// 下拉显示
/// </summary>
/// <returns></returns>
[HttpGet]
public List<stutype> xia()
{
var p = new BLL.stuBLL().xia();
return p.ToList();
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
[HttpPost]
public int add(stuModel m)
{
var p = new BLL.stuBLL().add(m);
return p;
}
/// <summary>
///登录
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
[HttpPost]
public int login(Login m)
{
var p = new BLL.stuBLL().login(m);
return p;
}
/// <summary>
///删除
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
[HttpDelete]
public int shan(int id)
{
var p = new BLL.stuBLL().shan(id);
return p;
}
/// <summary>
/// 一条语句
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[HttpGet]
public List<stuModel> dan(int id)
{
var p = new BLL.stuBLL().dan(id);
return p.ToList();
}
/// <summary>
/// 修改
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[HttpPut]
public int xiu(stuModel m)
{
var p = new BLL.stuBLL().xiu(m);
return p;
}
后台
public SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=yanglishuang;Integrated Security=True");
/// <summary>
/// 添加
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int add(stuModel m)
{
string sql = "insert into yonghu values('" + m.men + "','" + m.Sids + "','" + m.number + "','" + m.name + "','" + m.shijian + "')";
conn.Open();
SqlCommand cmd = new SqlCommand(sql,conn);
int i = cmd.ExecuteNonQuery();
conn.Close();
return i;
}
/// <summary>
/// 登录
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int login(Login m)
{
string sql = "select count(1) from deng where name='" + m.name + "' and pwd='" + m.pwd + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
object i = cmd.ExecuteScalar();
conn.Close();
return Convert.ToInt32(i);
}
/// <summary>
/// 显示
/// </summary>
/// <returns></returns>
public List<stuModel> show(string name, int type = 0)
{
string sql = "select * from yonghu s inner join shui p on s.Sids=p.Sids where 1=1";
if (!string.IsNullOrWhiteSpace(name))
sql += " and name like '%" + name + "%' ";
if (type > 0)
{
sql += " and s.Sids='" + type + "'";
}
SqlDataAdapter dr = new SqlDataAdapter(sql, conn);
DataTable ds = new DataTable();
dr.Fill(ds);
var p = JsonConvert.SerializeObject(ds);
var pp = JsonConvert.DeserializeObject<List<stuModel>>(p);
return pp;
}
/// <summary>
/// 下拉
/// </summary>
/// <returns></returns>
public List<stutype> xia()
{
string sql = "select * from shui ";
SqlDataAdapter dr = new SqlDataAdapter(sql, conn);
DataTable ds = new DataTable();
dr.Fill(ds);
var p = JsonConvert.SerializeObject(ds);
var pp = JsonConvert.DeserializeObject<List<stutype>>(p);
return pp;
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int shan(int id)
{
string sql = "delete from yonghu where id='" + id + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int i = cmd.ExecuteNonQuery();
conn.Close();
return i;
}
/// <summary>
/// 一条语句
/// </summary>
/// <returns></returns>
public List<stuModel> dan(int id)
{
string sql = "select * from yonghu s inner join shui p on s.Sids=p.Sids where s.id='" + id + "'";
SqlDataAdapter dr = new SqlDataAdapter(sql, conn);
DataTable ds = new DataTable();
dr.Fill(ds);
var p = JsonConvert.SerializeObject(ds);
var pp = JsonConvert.DeserializeObject<List<stuModel>>(p);
return pp;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int xiu(stuModel m)
{
string sql = "update yonghu set men='" + m.men + "',Sids='" + m.Sids + "',number='" + m.number + "',name='" + m.name + "',shijian='" + m.shijian + "' where id='" + m.id + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int i = cmd.ExecuteNonQuery();
conn.Close();
return i;
}
