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);
}
