//绑定下拉
public List <PingjiaModel> Band()
{
using (var conn = new SqlConnection(SQL))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select distinct Amessage ,case Amessage when 1 then '满意' when 2 then '一般' else '不满意' end Apj from Ashop ";
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
List <PingjiaModel> amodels = new List <PingjiaModel>();
foreach (DataRow dr in dt.Rows)
{
PingjiaModel a = new PingjiaModel();
a.Apj = dr["Apj"].ToString();
a.Amessage = Convert.ToInt32(dr["Amessage"].ToString());
amodels.Add(a);
}
return(amodels);
}
}
// POST: api/Pingjia
public int Post([FromBody] PingjiaModel m)
{
return(dal.Add(m));
}
//添加
public int Add(PingjiaModel m)
{
string sql = string.Format("insert into Ashop values('{0}','{1}','{2}','{3}','{4}')", m.Pid, m.Uname, m.Amessage, m.Ainfor, m.Atime);
return(DBHelper.ExecuteNonQuery(sql));
}