private void lsTimeSheet_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (rbTMAll.IsChecked == false && rbTMRecent.IsChecked == false) { if (lsTimeSheet.SelectedItems.Count > 0) { CS_TimeSheetPROD timesheet = lsTimeSheet.SelectedItem as CS_TimeSheetPROD; if (timesheet != null) { dpEndDate.IsEnabled = true; dpStartDate.IsEnabled = false; txtOdp.Text = timesheet.MONo; txtPhase.Text = timesheet.Phase; dpStartDate.SelectedTime = timesheet.StartDate; tm.Id = timesheet.Id; tm.Line = timesheet.Line; tm.MOId = timesheet.MOId; tm.MONo = timesheet.MONo; tm.Phase = timesheet.Phase; tm.RtgStep = timesheet.RtgStep; tm.StartDate = timesheet.StartDate; tm.StatusODP = timesheet.StatusODP; tm.UserIdOP = Menu.usermanager.Id; dpEndDate.IsEnabled = true; } } } else { dpEndDate.IsEnabled = false; dpStartDate.IsEnabled = true; } }
public List <CS_TimeSheetPROD> getTimeSheetRecent(int userid) { try { List <CS_TimeSheetPROD> list = new List <CS_TimeSheetPROD>(); string sql = @"SELECT * FROM CS_TimeSheetPROD WHERE StartDate >= DATEADD(day,-7, GETDATE()) AND UserIdOP = " + userid; conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { CS_TimeSheetPROD tsp = new CS_TimeSheetPROD(); tsp.Id = (int)reader["Id"]; tsp.Line = (int)reader["Line"]; tsp.MOId = (int)reader["MOId"]; tsp.Phase = reader["Phase"].ToString(); tsp.RtgStep = (int)reader["RtgStep"]; if (!string.IsNullOrEmpty(reader["StartDate"].ToString())) { tsp.StartDate = Convert.ToDateTime(reader["StartDate"]); } if (!string.IsNullOrEmpty(reader["EndDate"].ToString())) { tsp.EndDate = Convert.ToDateTime(reader["EndDate"]); } tsp.IsFinalized = reader["IsFinalized"].ToString(); tsp.StatusODP = (int)reader["StatusODP"]; tsp.UserIdOP = (int)reader["UserIdOP"]; list.Add(tsp); } conn.Close(); reader.Close(); if (list.Count > 0) { foreach (var item in list) { item.MONo = getMONo((short)item.MOId); } } return(list); } catch (Exception ex) { conn.Close(); throw ex; } }
public void Insert(CS_TimeSheetPROD obj) { try { string sql = @"INSERT INTO CS_TimeSheetPROD (Id ,Line ,MOId ,Phase ,StartDate ,StatusODP ,RtgStep ,UserIdOP ,TBCreated ,TBModified ,TBCreatedID ,TBModifiedID ,TBGuid) VALUES (" + $"{ obj.Id }," + $"{ obj.Line }," + $"{ obj.MOId }," + $"'{ obj.Phase }'," + $"'{ obj.StartDate }'," + $"{ obj.StatusODP }," + $"{ obj.RtgStep }," + $"{ obj.UserIdOP }," + $"'{ DateTime.Now }'," + $"'{ DateTime.Now }'," + $"{ 1 }," + $"{ 1 }," + $"'{ Guid.NewGuid() }')"; conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { conn.Close(); throw ex; } }
public List <CS_TimeSheetPROD> getTimeSheetOpen(int userid) { try { List <CS_TimeSheetPROD> list = new List <CS_TimeSheetPROD>(); string sql = @"SELECT * FROM CS_TimeSheetPROD WHERE IsFinalized = '0' AND StartDate IS NOT NULL AND UserIdOP = " + userid; conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { CS_TimeSheetPROD tsp = new CS_TimeSheetPROD(); tsp.Id = (int)reader["Id"]; tsp.Line = (int)reader["Line"]; tsp.MOId = (int)reader["MOId"]; tsp.Phase = reader["Phase"].ToString(); tsp.RtgStep = (int)reader["RtgStep"]; if (!string.IsNullOrEmpty(reader["StartDate"].ToString())) { tsp.StartDate = Convert.ToDateTime(reader["StartDate"]); } if (!string.IsNullOrEmpty(reader["EndDate"].ToString())) { tsp.EndDate = Convert.ToDateTime(reader["EndDate"]); } tsp.IsFinalized = reader["IsFinalized"].ToString(); tsp.StatusODP = (int)reader["StatusODP"]; tsp.UserIdOP = (int)reader["UserIdOP"]; if (Convert.ToDateTime(reader["EndDate"]).ToShortDateString() == "31/12/1799") { tsp.EndDate = Convert.ToDateTime("01/01/0001"); } tsp.Status = (tsp.StatusODP == 20578305) ? "Em processamento" : "Terminada"; list.Add(tsp); } conn.Close(); reader.Close(); if (list.Count > 0) { foreach (var item in list) { item.MONo = getMONo((short)item.MOId); } } return(list); } catch (Exception ex) { conn.Close(); throw ex; } }