//添加历史记录 public int Add(historic m) { using (var conn = new SqlConnection(comStr)) { conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = string.Format("insert into historic values('{0}')", m.Hname); return(cmd.ExecuteNonQuery()); } }
//显示历史记录 public List <historic> Shows() { using (var conn = new SqlConnection(comStr)) { conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = "select distinct Hname from historic"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); var historiclist = new List <historic>(); foreach (DataRow dr in dt.Rows) { var m = new historic(); m.Hname = Convert.ToString(dr["Hname"]); historiclist.Add(m); } return(historiclist); } }
// POST: api/historic //历史记录添加 public int Post([FromBody] historic m) { return(dal.Add(m)); }