public List <RW_INSPECTION_DETAIL> getListInsp(String path) { List <RW_INSPECTION_DETAIL> list = new List <RW_INSPECTION_DETAIL>(); OleDbConnection conn = getConnect(path); try { conn.Open(); String sql = "SELECT * FROM [Inspections$] "; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader.HasRows) { if (!(reader.IsDBNull(2) || reader.IsDBNull(3) || reader.IsDBNull(4) || reader.IsDBNull(6))) { obj = new RW_INSPECTION_DETAIL(); //obj.ID = 1; obj.InspPlanName = reader[0].ToString(); //obj.Ins = reader[1].ToString(); //obj.EquipmentID = reader[2].ToInt32(); //obj.ComponentID = reader[3].ToInt32(); //obj.DMItemID = reader[4](); //obj.InspectionDate = reader[5].ToString(); try { obj.InspectionDate = Convert.ToDateTime(reader[6].ToString()); } catch { obj.InspectionDate = DateTime.Now; } try { //obj.InspectionEffective = reader[7].ToString(); } catch { //obj.InspectionEffective = "E"; } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show("ERROR!" + e.ToString()); } finally { conn.Close(); conn.Dispose(); } return(list); }
private List <RW_INSPECTION_DETAIL> getDataInspectionHistory() { RW_INSPECTION_HISTORY_BUS busInspHis = new RW_INSPECTION_HISTORY_BUS(); List <RW_INSPECTION_DETAIL> listInspHis = busInspHis.getDataSource(); List <RW_INSPECTION_DETAIL> listData = new List <RW_INSPECTION_DETAIL>(); EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS(); SITES_BUS busSite = new SITES_BUS(); FACILITY_BUS busFacility = new FACILITY_BUS(); foreach (RW_INSPECTION_DETAIL inspHis in listInspHis) { int eqID = inspHis.EquipmentID; RW_INSPECTION_DETAIL rwInspHis = inspHis; rwInspHis.SiteName = busSite.getSiteName(busEqMaster.getSiteID(eqID)); rwInspHis.FacilityName = busFacility.getFacilityName(busEqMaster.getFacilityID(eqID)); listData.Add(rwInspHis); } return(listData); }
public Boolean checkExist(RW_INSPECTION_DETAIL obj) { return(DAL.checkExist(obj.ComponentID, obj.DMItemID, obj.InspectionDate)); }
public void delete(RW_INSPECTION_DETAIL obj) { DAL.delete(obj.ID); }
public void edit(RW_INSPECTION_DETAIL obj) { DAL.edit(obj.ID, obj.DetailID, obj.EquipmentID, obj.ComponentID, obj.Coverage_DetailID, obj.InspPlanName, obj.InspectionDate, obj.DMItemID, obj.EffectivenessCode, obj.InspectionSummary, obj.IsCarriedOut, obj.CarriedOutDate, obj.IsActive); }
public List <RW_INSPECTION_DETAIL> getDataComp(int CompID) { List <RW_INSPECTION_DETAIL> list = new List <RW_INSPECTION_DETAIL>(); RW_INSPECTION_DETAIL obj = null; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "SELECT [ID]" + ",[DetailID] " + ",[EquipmentID]" + ",[ComponentID]" + ",[Coverage_DetailID]" + ",[InspPlanName]" + ",[InspectionDate]" + ",[DMItemID]" + ",[EffectivenessCode]" + ",[InspectionSummary]" + ",[IsCarriedOut]" + ",[CarriedOutDate]" + ",[IsActive]" + " FROM [rbi].[dbo].[RW_INSPECTION_DETAIL] WHERE [ComponentID] ='" + CompID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = conn; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new RW_INSPECTION_DETAIL(); obj.ID = reader.GetInt32(0); obj.DetailID = reader.GetInt32(1); obj.EquipmentID = reader.GetInt32(2); obj.ComponentID = reader.GetInt32(3); obj.Coverage_DetailID = reader.GetInt32(4); obj.InspPlanName = reader.GetString(5); obj.InspectionDate = reader.GetDateTime(6); obj.DMItemID = reader.GetInt32(7); obj.EffectivenessCode = reader.GetString(8); obj.IsCarriedOut = reader.GetInt32(9); obj.CarriedOutDate = reader.GetDateTime(10); obj.IsActive = reader.GetInt32(11); list.Add(obj); } } } } catch { // do nothing } finally { conn.Close(); conn.Dispose(); } return(list); }