private void frmMain_Load(object sender, EventArgs e) { UseWaitCursor = true; string sql = "SELECT * FROM tblTemp WHERE DATE(date_Temp) = CURDATE()"; var manage = new db_manage(); DataTable dt = manage.getData(sql); this.chartTemp.Series["Temperature"].Points.AddXY(convertDate(dt), dt.Rows.Count == 0 ? 0 : dt.Rows[0][1]); sql = "SELECT * FROM tblDamp WHERE DATE(date_Damp) = CURDATE()"; dt = manage.getData(sql); this.chartTemp.Series["Humidity"].Points.AddXY(convertDate(dt), dt.Rows.Count == 0 ? 0 : dt.Rows[0][1]); sql = "SELECT * FROM tblTemp WHERE DATE(date_Temp) = CURDATE() - 1"; dt = manage.getData(sql); this.chartTemp.Series["Temperature"].Points.AddXY(convertDate(dt), dt.Rows.Count == 0 ? 0 : dt.Rows[0][1]); sql = "SELECT * FROM tblDamp WHERE DATE(date_Damp) = CURDATE() - 1"; dt = manage.getData(sql); this.chartTemp.Series["Humidity"].Points.AddXY(convertDate(dt), dt.Rows.Count == 0 ? 0 : dt.Rows[0][1]); sql = "SELECT * FROM tblTemp WHERE DATE(date_Temp) = CURDATE() - 2"; dt = manage.getData(sql); this.chartTemp.Series["Temperature"].Points.AddXY(convertDate(dt), dt.Rows.Count == 0 ? 0 : dt.Rows[0][1]); sql = "SELECT * FROM tblDamp WHERE DATE(date_Damp) = CURDATE() - 2"; dt = manage.getData(sql); this.chartTemp.Series["Humidity"].Points.AddXY(convertDate(dt), dt.Rows.Count == 0 ? 0 : dt.Rows[0][1]); picEmp.Image = imgEmp; lblNmeEmp.Text = nameEmp; var db_conn = new db_connect(); if (db_conn.OpenConnection()) { lblDBName.Text = db_conn.connection.Database; lblDataSrc.Text = db_conn.connection.DataSource; lblIP.Text = Program.GetIP(); lblServThread.Text = db_conn.connection.ServerThread.ToString(); lblServVersion.Text = db_conn.connection.ServerVersion; lblServState.Text = db_conn.connection.State.ToString(); lblHosting.Text = "www.ppakorni.info"; db_conn.CloseConnection(); } else { lblDBName.Text = $"Unknown"; lblDataSrc.Text = $"Unknown"; lblIP.Text = Program.GetIP(); lblServThread.Text = $"Unknown"; lblServVersion.Text = $"Unknown"; lblServState.Text = $"Unknown"; lblHosting.Text = $"Unknown"; } UseWaitCursor = false; }
private void frmImg_Load(object sender, EventArgs e) { string sql = "SELECT date_Img,img_Name FROM tblObjectImg WHERE id_obj = '" + barCode + "' " + "and date_Img IN (SELECT MAX(date_Img) FROM tblObjectImg) GROUP BY img_Name"; var manage = new db_manage(); string url = manage.lastImg(sql); if (url == "") { return; } pictureBox1.Load("http://www.ppakorn.info/siam_summaryDoc/img/coding2/" + url); }
private void btnLogin_Click(object sender, EventArgs e) { string sql = string.Format("SELECT User_Emp,Pass_Emp,Name_Emp,img_Emp FROM tblEmployees WHERE " + "User_Emp = '{0}' and Pass_Emp = '{1}'", txtUser.Text.Trim(), txtPass.Text.Trim()); var manage = new db_manage(); var emp = manage.chkUser(sql); if (emp.Rows.Count > 0) { this.Hide(); var f = new frmMain(); f.nameEmp = emp.Rows[0][2].ToString(); byte[] bits = (byte[])emp.Rows[0][3]; MemoryStream mem = new MemoryStream(bits); f.imgEmp = Image.FromStream(mem); emp.Dispose(); f.ShowDialog(); this.Close(); } }
public frmManage() { InitializeComponent(); this.ActiveControl = txtBarCode; manage = new db_manage(); }
private async void insertOfDay() { lblStatus.Text = "Checking..."; var manage = new db_manage(); List <DataTable> dts; dts = manage.getLastData(); for (int i = 0; i < dts.Count; i++) { if (dts[i].Rows.Count > 0) { //ถ้าความชื้นยังไม่ได้บันทึก if ((dts[i].TableName == "tblTemp") && (dts.Count == 1)) { lblStatus.Text = "Saving..."; await Task.Delay(2000); manage.insertDamp(damp); } //ถ้าอุณหภูมิยังไม่ได้บันทึก else if ((dts[i].TableName == "tblDamp") && (dts.Count == 1)) { lblStatus.Text = "Saving..."; await Task.Delay(2000); manage.insertTemp(temp); } DateTime date = Convert.ToDateTime(dts[i].Rows[0][0].ToString()); //ถ้ายังไม่ได้บันทึกข้อมูลในวันนี้ if (date.Date != DateTime.Now.Date) { if (dts[i].TableName == "tblTemp") { lblStatus.Text = "Saving..."; await Task.Delay(2000); manage.insertTemp(temp); } else if (dts[i].TableName == "tblDamp") { lblStatus.Text = "Saving..."; await Task.Delay(2000); manage.insertDamp(damp); } } } } if (dts.Count == 1) { //ถ้าไม่ได้เชื่อมต่ออินเทอร์เน็ต if (dts[0].TableName == "No table") { lblStatus.Text = "Connect to Internet for save today."; } else { lblStatus.Text = ""; lblStatus.Hide(); } } //ยังไม่มีข้อมูลอะไรเลย else if (dts.Count == 0) { lblStatus.Text = "Saving..."; await Task.Delay(2000); manage.insertDamp(damp); manage.insertTemp(temp); lblStatus.Text = ""; lblStatus.Hide(); } else { lblStatus.Text = ""; lblStatus.Hide(); } }