public JsonResult GetChartData() { DBBusinessLayer dBBusinessLayer = new DBBusinessLayer(); DataTable bangData = dBBusinessLayer.SelectCmd("trangthai", "nhietDo,doAm", "tenChuong='ChuongGa1'"); var chartData = new object[101]; chartData[0] = new object[] { "Thời gian", "Nhiệt độ ", "Độ ẩm ", }; //if (Dem < 10) //{ try { for (Int16 j = 1; j <= 100; j++) { chartData[j] = new object[] { DateTime.Now.ToString(), bangData.Rows[0][0], bangData.Rows[0][1] }; } } catch { } return(Json(chartData, JsonRequestBehavior.AllowGet)); }
public JsonResult Update(HomeModel model) { DBBusinessLayer updateLM = new DBBusinessLayer(); //if (updateLM.SelectCmd(model.nhietDo, model.id) != 0) //{ // return Json(new { Status = "Ok" }, JsonRequestBehavior.AllowGet); //} return(Json(new { Status = "Fail" }, JsonRequestBehavior.AllowGet)); }
//Locahost/Home/Get/12 /// <summary> /// Đọc DB lấy các giá trị realTime lên để hiển thị. /// </summary> /// <returns></returns> public JsonResult GetRealTimeValues() { DBBusinessLayer dbBusinessLayer = new DBBusinessLayer(); DataTable bangData = dbBusinessLayer.SelectCmd("trangthai", "*", "tenChuong='ChuongGa1'"); HomeModel model = new HomeModel() { id = Convert.ToInt32(bangData.Rows[0][0].ToString()), tenChuong = bangData.Rows[0][1].ToString(), nhietDo = Convert.ToDouble(bangData.Rows[0][2].ToString()), doAm = Convert.ToDouble(bangData.Rows[0][3].ToString()), tanSo = Convert.ToDouble(bangData.Rows[0][4].ToString()), o2 = Convert.ToDouble(bangData.Rows[0][5].ToString()), co2 = Convert.ToDouble(bangData.Rows[0][6].ToString()), nh3 = Convert.ToDouble(bangData.Rows[0][7].ToString()), }; return(Json(model, JsonRequestBehavior.AllowGet)); }
public frmSinhVienTheoKhoa() { InitializeComponent(); ds = new DataSet(); db = new DBBusinessLayer(); }
} //mã khóa học public frmLopTheoNganh() { InitializeComponent(); ds = new DataSet(); db = new DBBusinessLayer(); }
//địa chỉ của image //string imgLoc = ""; //private byte[] img = null; //image //private object txtgioitinh; public frmQuanLySinhVien() { InitializeComponent(); ds = new DataSet(); db = new DBBusinessLayer(); }
public frmQuanLyNganhHoc() { InitializeComponent(); ds = new DataSet(); db = new DBBusinessLayer(); }
public frmQuanLyKhoaHoc() { ds = new DataSet(); db = new DBBusinessLayer(); InitializeComponent(); }
public frmGiaoVienTheoMonHoc() { InitializeComponent(); ds = new DataSet(); db = new DBBusinessLayer(); }
public MainForm() { InitializeComponent(); db = new DBBusinessLayer(); ds = new DataSet(); }