private void dgvWorkOrderStates_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { WorkOrderState wos = new WorkOrderState(); wos = _workOrderStateService.GetLast(Machine); if (wos.Id != 0) { if (wos.State.ToLower() == "start") { int i = 0; foreach (DataGridViewRow row in dgvWorkOrderStates.Rows) { if (i == 0) { row.DefaultCellStyle.BackColor = Color.FromArgb(102, 187, 106); } else { row.DefaultCellStyle.BackColor = Color.FromArgb(239, 83, 80); } i++; } } else { foreach (DataGridViewRow row in dgvWorkOrderStates.Rows) { row.DefaultCellStyle.BackColor = Color.FromArgb(239, 83, 80); } } } else { } }
public WorkOrderState GetLast(Machine machine) { string connString = string.Format("server={0};user=root;database={1};port=3306;password=root;Connection Timeout=1", machine.Ip, _raspiDb); WorkOrderState workOrderState = new WorkOrderState(); try { using (_conn = new MySqlConnection(connString)) { string query = string.Format("select * from {0} order by Id desc limit 1", _raspiWorkOrderStateTableName); using (MySqlCommand cmd = new MySqlCommand(query, _conn)) { _conn.Open(); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { workOrderState.Id = reader.GetInt32(0); workOrderState.WorkOrderNo = reader.GetString(1); workOrderState.State = reader.GetString(2); workOrderState.Date = reader.GetDateTime(3); } } } } } catch (Exception e) { Console.WriteLine("workorderstate getlast'de sıkıntı var\n" + e); } return(workOrderState); }
private void btnBasla_click(object sender, EventArgs e) { Button btn = sender as Button; int index = Convert.ToInt32(btn.Name.ToString()); if (!string.IsNullOrWhiteSpace(_tbWorkOrderNo[index].Text)) { List <Machine> machines = new List <Machine>(); machines = GetMachines(); Machine machine = machines[index]; Log lastLog = _logService.GetLastLog(machine.Ip, _raspiDb, "Logs"); TimeSpan time = DateTime.Now.Subtract(lastLog.Date); Log log = new Log { Name = lastLog.Name, LastState = lastLog.State, LastDate = lastLog.Date, State = lastLog.State, Time = time, Shift = lastLog.Shift }; _logService.Add(log, machine); int id = lastLog.Id + 1; string workOrderNo = _tbWorkOrderNo[index].Text; WorkOrderState workOrderState = new WorkOrderState { Id = id, WorkOrderNo = workOrderNo, State = "start" }; _workOrderStateService.Add(workOrderState, machine); _tbWorkOrderNo[index].Text = ""; } }
private void btnBitir_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(tbWorkOrderNo.Text)) { WorkOrderState wos = new WorkOrderState(); wos = _workOrderStateService.GetLast(Machine); if (wos.State.ToLower() != "finish") { if (wos.WorkOrderNo == tbWorkOrderNo.Text) { Machine machine = Machine; Log lastLog = _logService.GetLastLog(machine.Ip, _raspiDb, "Logs"); TimeSpan time = DateTime.Now.Subtract(lastLog.Date); Log log = new Log { Name = lastLog.Name, LastState = lastLog.State, LastDate = lastLog.Date, State = lastLog.State, Time = time, Shift = lastLog.Shift }; _logService.Add(log, machine); int id = lastLog.Id + 1; string workOrderNo = tbWorkOrderNo.Text; WorkOrderState workOrderState = new WorkOrderState { Id = id, WorkOrderNo = workOrderNo, State = "finish" }; _workOrderStateService.Add(workOrderState, machine); tbWorkOrderNo.Text = ""; } else { MessageBox.Show(string.Format("{0} numaralı bir iş emri başlatılmamış", tbWorkOrderNo.Text)); } FillWos(); } else { MessageBox.Show("Devam etmekte olan iş emri yok !"); } } else { MessageBox.Show("Lütfen İş Emri No Giriniz !"); } tbWorkOrderNo.Text = ""; WorkOrders(); }
private void btnBaslat_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(tbWorkOrderNo.Text)) { WorkOrderState wos = new WorkOrderState(); wos = _workOrderStateService.GetLast(Machine); Console.WriteLine("wos.id = {0}", wos.Id); Console.WriteLine("wos.state = {0}", wos.State); if (wos.State.ToLower() == "start") { MessageBox.Show(string.Format("{0} numaralı iş emri hala devam etmekte !", wos.WorkOrderNo)); } else { Machine machine = Machine; Log lastLog = _logService.GetLastLog(machine.Ip, _raspiDb, "Logs"); TimeSpan time = DateTime.Now.Subtract(lastLog.Date); Log log = new Log { Name = lastLog.Name, LastState = lastLog.State, LastDate = lastLog.Date, State = lastLog.State, Time = time, Shift = lastLog.Shift }; _logService.Add(log, machine); int id = lastLog.Id + 1; string workOrderNo = tbWorkOrderNo.Text; WorkOrderState workOrderState = new WorkOrderState { Id = id, WorkOrderNo = workOrderNo, State = "start" }; _workOrderStateService.Add(workOrderState, machine); tbWorkOrderNo.Text = ""; MessageBox.Show("iş emri başlatıldı"); } FillWos(); } else { MessageBox.Show("Lütfen İş Emri No Giriniz !"); } tbWorkOrderNo.Text = ""; WorkOrders(); }
public void WorkOrders() { WorkOrderState wos = new WorkOrderState(); wos = _workOrderStateService.GetLast(Machine); if (wos.Id == 0) { lblWorkOrder.Text = "Bu Makinede Hiç Bir İş Emri Bulunamadı"; } else { bool isWorkOrderFinish = _workOrderStateService.IsWorkOrderFinish(Machine, wos.WorkOrderNo); if (isWorkOrderFinish) { List <WorkOrderState> workOrderStates = new List <WorkOrderState>(); workOrderStates = _workOrderStateService.GetByWorkOrderNo(Machine, wos.WorkOrderNo); DateTime start = workOrderStates[1].Date; DateTime finish = workOrderStates[0].Date; TimeSpan duration = finish - start; string wo = string.Format("{0} numaralı iş emri {1} zamanında bitti ", wos.WorkOrderNo, duration); lblWorkOrder.Text = wo; int startId = workOrderStates[0].Id; int finishId = workOrderStates[1].Id; //dgvWorkOrdersDetails.DataSource = _logService.GetById(Machine.Ip, "Machine", "Logs", startId, finishId); } else { List <WorkOrderState> workOrderStates = new List <WorkOrderState>(); workOrderStates = _workOrderStateService.GetByWorkOrderNo(Machine, wos.WorkOrderNo); int startId = workOrderStates[0].Id; DateTime start = workOrderStates[0].Date; string wo = string.Format("{0} tarihinde başlayan {1} numaralı iş emri hala devam ediyor", start, wos.WorkOrderNo); lblWorkOrder.Text = wo; //dgvWorkOrdersDetails.DataSource = _logService.GetById(Machine.Ip, "Machine", "Logs", startId, 0); } } }
public List <WorkOrderState> GetAllByMachine(Machine machine) { string connString = string.Format("server={0};user=root;database={1};port=3306;password=root;Connection Timeout=1", machine.Ip, _raspiDb); List <WorkOrderState> workOrderStates = new List <WorkOrderState>(); try { using (_conn = new MySqlConnection(connString)) { string query = string.Format("select * from {0} order by Id desc", _raspiWorkOrderStateTableName); using (MySqlCommand cmd = new MySqlCommand(query, _conn)) { _conn.Open(); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { WorkOrderState workOrderState = new WorkOrderState { Id = reader.GetInt32(0), WorkOrderNo = reader.GetString(1), State = reader.GetString(2), Date = reader.GetDateTime(3) }; workOrderStates.Add(workOrderState); } } } } } catch (Exception e) { Console.WriteLine("workorderstate getAllByMachine'de sıkıntı var\n" + e); } return(workOrderStates); }
public void Add(WorkOrderState workOrderState, Machine machine) { string connString = string.Format("server={0};user=root;database={1};port=3306;password=root;Connection Timeout=1;Allow User Variables=True", machine.Ip, _raspiDb); try { using (MySqlConnection _conn = new MySqlConnection(connString)) { string query = string.Format("insert into {0} (Id,WorkOrderNo,State) values (@Id,@WorkOrderNo,@State) ", _raspiWorkOrderStateTableName); using (MySqlCommand cmd = new MySqlCommand(query, _conn)) { _conn.Open(); cmd.Parameters.AddWithValue("@Id", workOrderState.Id); cmd.Parameters.AddWithValue("@WorkOrderNo", workOrderState.WorkOrderNo); cmd.Parameters.AddWithValue("@State", workOrderState.State); cmd.ExecuteNonQuery(); } } } catch (Exception e) { Console.WriteLine("add workorderstate'de sıkıntı var" + e); } }
public void Add(WorkOrderState workOrderState, Machine machine) { _workOrderStateDal.Add(workOrderState, machine); }