public int UpdateWDetaile(WarnInfoDetailModel model) { string sql = "update T_Mid_WarnInfoDetail set StationCode='" + model.StationCode + "',AQI='" + model.AQI + "',QualityLevelID='" + model.QualityLevelID + "',"; sql += "FirstP='" + model.FirstP + "' where ID='" + model.id + "'"; int rows = bill.ExecuteSQLNonQuery(sql); return(rows); }
public int InSertWDetaile(WarnInfoDetailModel model) { string sql = "insert into T_Mid_WarnInfoDetail(StationCode,AQI,QualityLevelID,FirstP) values('" + model.StationCode + "',"; sql += "'" + model.AQI + "','" + model.QualityLevelID + "','" + model.FirstP + "')"; int rows = bill.ExecuteSQLNonQuery(sql); return(rows); }