public EQUIPMENT_MASTER getData(int eqID)
{
EQUIPMENT_MASTER obj = new EQUIPMENT_MASTER();
SqlConnection con = MSSQLDBUtils.GetDBConnection();
con.Open();
String sql = "select EquipmentNumber,EquipmentTypeID,EquipmentName,CommissionDate,DesignCodeID,SiteID,FacilityID,ManufacturerID,PFDNo,ProcessDescription,EquipmentDesc from rbi.dbo.EQUIPMENT_MASTER where EquipmentID = '" + eqID + "'";
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Connection = con;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj.EquipmentNumber = reader.GetString(0);
obj.EquipmentTypeID = reader.GetInt32(1);
obj.EquipmentName = reader.GetString(2);
obj.CommissionDate = reader.GetDateTime(3);
obj.DesignCodeID = reader.GetInt32(4);
obj.SiteID = reader.GetInt32(5);
obj.FacilityID = reader.GetInt32(6);
obj.ManufacturerID = reader.GetInt32(7);
if (!reader.IsDBNull(8))
{
obj.PFDNo = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
obj.ProcessDescription = reader.GetString(9);
}
if (!reader.IsDBNull(10))
{
obj.EquipmentDesc = reader.GetString(10);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Get DateTime Fail------->" + ex.ToString(), "Get Data Fail");
}
finally
{
con.Close();
con.Dispose();
}
return(obj);
}
public EQUIPMENT_MASTER getDataEquipmentMaster()
{
EQUIPMENT_MASTER eqMaster = new EQUIPMENT_MASTER();
foreach (FACILITY f in listFacility)
{
if (f.FacilityName == cbFacility.Text)
{
eqMaster.FacilityID = f.FacilityID;
}
}
foreach (SITES s in listSite)
{
if (s.SiteName == cbSite.Text)
{
eqMaster.SiteID = s.SiteID;
}
}
foreach (EQUIPMENT_TYPE e in listEquipType)
{
if (e.EquipmentTypeName == cbEquipmentType.Text)
{
eqMaster.EquipmentTypeID = e.EquipmentTypeID;
}
}
foreach (DESIGN_CODE d in listDesignCode)
{
if (d.DesignCode == cbDesignCode.Text)
{
eqMaster.DesignCodeID = d.DesignCodeID;
}
}
foreach (MANUFACTURER m in listManufacture)
{
if (m.ManufacturerName == cbManufacturer.Text)
{
eqMaster.ManufacturerID = m.ManufacturerID;
}
}
eqMaster.EquipmentNumber = txtEquipmentNumber.Text;
eqMaster.EquipmentName = txtEquipmentName.Text;
eqMaster.CommissionDate = dateCommission.DateTime;
eqMaster.PFDNo = txtPDFNo.Text;
eqMaster.ProcessDescription = txtProcessDescription.Text;
eqMaster.EquipmentDesc = txtDescription.Text;
eqMaster.IsArchived = 1;
eqMaster.Archived = DateTime.Now;
return(eqMaster);
}
public void showDatatoControl(int ID)
{
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
EQUIPMENT_MASTER_BUS equipmentMasterBus = new EQUIPMENT_MASTER_BUS();
DESIGN_CODE_BUS designCodeBus = new DESIGN_CODE_BUS();
SITES_BUS siteBus = new SITES_BUS();
FACILITY_BUS facilityBus = new FACILITY_BUS();
MANUFACTURER_BUS manuBus = new MANUFACTURER_BUS();
RW_ASSESSMENT_BUS rwAssBus = new RW_ASSESSMENT_BUS();
COMPONENT_MASTER_BUS comMaBus = new COMPONENT_MASTER_BUS();
COMPONENT_TYPE__BUS comTypeBus = new COMPONENT_TYPE__BUS();
API_COMPONENT_TYPE_BUS apiComponentBus = new API_COMPONENT_TYPE_BUS();
int[] equipmentID_componentID = rwAssBus.getEquipmentID_ComponentID(ID);
EQUIPMENT_MASTER eqMa = equipmentMasterBus.getData(equipmentID_componentID[0]);
COMPONENT_MASTER comMa = comMaBus.getData(equipmentID_componentID[1]);
RW_ASSESSMENT ass = rwAssBus.getData(ID);
txtAssessmentName.Text = ass.ProposalName;
dateAssessmentDate.DateTime = ass.AssessmentDate;
txtRiskAnalysisPeriod.Text = ass.RiskAnalysisPeriod.ToString();
txtEquipmentNumber.Text = eqMa.EquipmentNumber;
txtEquipmentType.Text = eqTypeBus.getEquipmentTypeName(eqMa.EquipmentTypeID);
txtSites.Text = siteBus.getSiteName(eqMa.SiteID);
txtDesignCode.Text = designCodeBus.getDesignCodeName(eqMa.DesignCodeID);
txtFacility.Text = facilityBus.getFacilityName(eqMa.FacilityID);
txtManufacturer.Text = manuBus.getManuName(eqMa.ManufacturerID);
dateComissionDate.DateTime = eqMa.CommissionDate;
txtEquipmentName.Text = eqMa.EquipmentName;
txtProcessDesciption.Text = eqMa.ProcessDescription;
txtComponentNumber.Text = comMa.ComponentNumber;
txtComponentType.Text = comTypeBus.getComponentTypeName(comMa.ComponentTypeID);
txtAPIComponentType.Text = apiComponentBus.getAPIComponentTypeName(comMa.APIComponentTypeID);
txtComponentName.Text = comMa.ComponentName;
chkRiskLinksEquipmentRisk.Checked = comMa.IsEquipmentLinked == 1 ? true : false;
for (int i = 0; i < itemsAssessmentMethod.Length; i++)
{
if (ass.AssessmentMethod == i)
{
cbAsessmentMethod.SelectedIndex = i + 1;
break;
}
}
}
private EQUIPMENT_MASTER getDataEquipmentMaster()
{
EQUIPMENT_MASTER eqMaster = new EQUIPMENT_MASTER();
if (doubleEditClicked)
{
eqMaster.EquipmentID = this.EquipmentID;
}
eqMaster.SiteID = siteBus.getIDbyName(cbSite.Text);
eqMaster.FacilityID = faciBus.getIDbyName_SiteID(eqMaster.SiteID, cbFacility.Text);
eqMaster.EquipmentTypeID = equipType.getIDbyName(cbEquipmentType.Text);
eqMaster.DesignCodeID = designCodeBus.getIDbyName(cbDesignCode.Text);
eqMaster.ManufacturerID = manuBus.getIDbyName(cbManufacturer.Text);
eqMaster.EquipmentNumber = txtEquipmentNumber.Text;
eqMaster.EquipmentName = txtEquipmentName.Text;
eqMaster.CommissionDate = dateCommission.DateTime;
eqMaster.PFDNo = txtPDFNo.Text;
eqMaster.ProcessDescription = txtProcessDescription.Text;
eqMaster.EquipmentDesc = txtDescription.Text;
eqMaster.IsArchived = 1;
eqMaster.Archived = DateTime.Now;
return(eqMaster);
}
public List <EQUIPMENT_MASTER> getDataSource()
{
List <EQUIPMENT_MASTER> list = new List <EQUIPMENT_MASTER>();
EQUIPMENT_MASTER obj = null;
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = " Use [rbi] Select [EquipmentID]" +
",[EquipmentNumber]" +
",[EquipmentTypeID]" +
",[EquipmentName]" +
",[CommissionDate]" +
",[DesignCodeID]" +
",[SiteID]" +
",[FacilityID]" +
",[ManufacturerID]" +
",[PFDNo]" +
",[ProcessDescription]" +
",[EquipmentDesc]" +
",[IsArchived]" +
",[Archived]" +
",[ArchivedBy]" +
"From [rbi].[dbo].[EQUIPMENT_MASTER]";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj = new EQUIPMENT_MASTER();
obj.EquipmentID = reader.GetInt32(0);
obj.EquipmentNumber = reader.GetString(1);
obj.EquipmentTypeID = reader.GetInt32(2);
obj.EquipmentName = reader.GetString(3);
obj.CommissionDate = reader.GetDateTime(4);
obj.DesignCodeID = reader.GetInt32(5);
obj.SiteID = reader.GetInt32(6);
obj.FacilityID = reader.GetInt32(7);
obj.ManufacturerID = reader.GetInt32(8);
if (!reader.IsDBNull(9))
{
obj.PFDNo = reader.GetString(9);
}
if (!reader.IsDBNull(10))
{
obj.ProcessDescription = reader.GetString(10);
}
if (!reader.IsDBNull(11))
{
obj.EquipmentDesc = reader.GetString(11);
}
obj.IsArchived = reader.GetOrdinal("IsArchived");
if (!reader.IsDBNull(13))
{
obj.Archived = reader.GetDateTime(13);
}
if (!reader.IsDBNull(14))
{
obj.ArchivedBy = reader.GetString(14);
}
list.Add(obj);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL!");
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
public void delete(EQUIPMENT_MASTER obj)
{
DAL.delete(obj.EquipmentID);
}
public void edit(EQUIPMENT_MASTER obj)
{
DAL.edit(obj.EquipmentID, obj.EquipmentNumber, obj.EquipmentTypeID, obj.EquipmentName, obj.CommissionDate, obj.DesignCodeID, obj.SiteID, obj.FacilityID, obj.ManufacturerID, obj.PFDNo, obj.ProcessDescription, obj.EquipmentDesc, obj.IsArchived, obj.Archived, obj.ArchivedBy);
}
private void ShowDatatoControl(int ID)
{
EQUIPMENT_MASTER eq = equipMasterBus.getData(ID);
//lay toan bo equipment type name
List <string> eqTypeName = equipType.getListEquipmentTypeName();
txtEquipmentNumber.Text = eq.EquipmentNumber;
cbEquipmentType.Properties.Items.Add("", -1, -1);
for (int i = 0; i < eqTypeName.Count; i++)
{
cbEquipmentType.Properties.Items.Add(eqTypeName[i], i, i);
if (eqTypeName[i] == equipType.getEquipmentTypeName(eq.EquipmentTypeID))
{
cbEquipmentType.SelectedIndex = i + 1;
}
}
txtEquipmentName.Text = eq.EquipmentName;
//Site
List <string> listSite = siteBus.getListSiteName();
cbSite.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listSite.Count; i++)
{
cbSite.Properties.Items.Add(listSite[i], i, i);
if (siteBus.getSiteName(eq.SiteID) == listSite[i])
{
cbSite.SelectedIndex = i + 1;
}
}
cbSite.Enabled = false;
//Facility
List <string> listFacility = faciBus.getListFacilityName(eq.SiteID);
cbFacility.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listFacility.Count; i++)
{
cbFacility.Properties.Items.Add(listFacility[i], i, i);
if (listFacility[i] == faciBus.getFacilityName(eq.FacilityID))
{
cbFacility.SelectedIndex = i + 1;
}
}
cbFacility.Enabled = false;
//Design Code
List <string> listDesignCode = designCodeBus.getListDesignCodeName();
cbDesignCode.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listDesignCode.Count; i++)
{
cbDesignCode.Properties.Items.Add(listDesignCode[i], i, i);
if (listDesignCode[i] == designCodeBus.getDesignCodeName(eq.DesignCodeID))
{
cbDesignCode.SelectedIndex = i + 1;
}
}
//Manu
List <string> listManu = manuBus.getListManufactureName();
cbManufacturer.Properties.Items.Add("", -1, -1);
for (int i = 0; i < listManu.Count; i++)
{
cbManufacturer.Properties.Items.Add(listManu[i], i, i);
if (listManu[i] == manuBus.getManuName(eq.ManufacturerID))
{
cbManufacturer.SelectedIndex = i + 1;
}
}
dateCommission.DateTime = eq.CommissionDate;
txtPDFNo.Text = eq.PFDNo;
txtProcessDescription.Text = eq.ProcessDescription;
txtDescription.Text = eq.EquipmentDesc;
}
public void showDatatoControl(int ID)
{
EQUIPMENT_TYPE_BUS eqTypeBus = new EQUIPMENT_TYPE_BUS();
EQUIPMENT_MASTER_BUS equipmentMasterBus = new EQUIPMENT_MASTER_BUS();
DESIGN_CODE_BUS designCodeBus = new DESIGN_CODE_BUS();
SITES_BUS siteBus = new SITES_BUS();
FACILITY_BUS facilityBus = new FACILITY_BUS();
MANUFACTURER_BUS manuBus = new MANUFACTURER_BUS();
RW_ASSESSMENT_BUS rwAssBus = new RW_ASSESSMENT_BUS();
COMPONENT_MASTER_BUS comMaBus = new COMPONENT_MASTER_BUS();
COMPONENT_TYPE__BUS comTypeBus = new COMPONENT_TYPE__BUS();
API_COMPONENT_TYPE_BUS apiComponentBus = new API_COMPONENT_TYPE_BUS();
int[] equipmentID_componentID = rwAssBus.getEquipmentID_ComponentID(ID);
EQUIPMENT_MASTER eqMa = equipmentMasterBus.getData(equipmentID_componentID[0]);
COMPONENT_MASTER comMa = comMaBus.getData(equipmentID_componentID[1]);
RW_ASSESSMENT ass = rwAssBus.getData(ID);
txtAssessmentName.Text = ass.ProposalName;
dateAssessmentDate.DateTime = ass.AssessmentDate;
txtRiskAnalysisPeriod.Text = ass.RiskAnalysisPeriod.ToString();
txtEquipmentNumber.Text = eqMa.EquipmentNumber;
txtEquipmentType.Text = eqTypeBus.getEquipmentTypeName(eqMa.EquipmentTypeID);
txtSites.Text = siteBus.getSiteName(eqMa.SiteID);
txtDesignCode.Text = designCodeBus.getDesignCodeName(eqMa.DesignCodeID);
txtFacility.Text = facilityBus.getFacilityName(eqMa.FacilityID);
txtManufacturer.Text = manuBus.getManuName(eqMa.ManufacturerID);
dateComissionDate.DateTime = eqMa.CommissionDate;
txtEquipmentName.Text = eqMa.EquipmentName;
txtProcessDesciption.Text = eqMa.ProcessDescription;
txtComponentNumber.Text = comMa.ComponentNumber;
txtComponentType.Text = comTypeBus.getComponentTypeName(comMa.ComponentTypeID);
txtAPIComponentType.Text = apiComponentBus.getAPIComponentTypeName(comMa.APIComponentTypeID);
txtComponentName.Text = comMa.ComponentName;
chkRiskLinksEquipmentRisk.Checked = comMa.IsEquipmentLinked == 1 ? true : false;
//foreach(RW_ASSESSMENT a in listAssessment)
//{
// if(a.ID == ID)
// {
// txtAssessmentName.Text = a.ProposalName;
// ProposalName = a.ProposalName;
// dateAssessmentDate.DateTime = a.AssessmentDate;
// txtRiskAnalysisPeriod.Text = a.RiskAnalysisPeriod.ToString();
// foreach (EQUIPMENT_MASTER e in listEquipmentMaster)
// {
// if (e.EquipmentID == a.EquipmentID)
// {
// txtEquipmentNumber.Text = e.EquipmentNumber;
// dateComissionDate.DateTime = e.CommissionDate;
// txtEquipmentName.Text = e.EquipmentName;
// foreach (EQUIPMENT_TYPE t in listEquipmentType)
// {
// if (t.EquipmentTypeID == e.EquipmentTypeID)
// txtEquipmentType.Text = t.EquipmentTypeName;
// }
// foreach (DESIGN_CODE d in listDesignCode)
// {
// if (d.DesignCodeID == e.DesignCodeID)
// txtDesignCode.Text = d.DesignCode;
// }
// foreach (FACILITY f in listFacility)
// {
// if (e.FacilityID == f.FacilityID)
// txtFacility.Text = f.FacilityName;
// }
// foreach (SITES s in listSite)
// {
// if (s.SiteID == e.SiteID)
// txtSites.Text = s.SiteName;
// }
// foreach (MANUFACTURER m in listManu)
// {
// if (m.ManufacturerID == e.ManufacturerID)
// txtManufacturer.Text = m.ManufacturerName;
// }
// }
// break;
// }
// foreach (COMPONENT_MASTER c in listComMa)
// {
// if (c.ComponentID == a.ComponentID)
// {
// txtComponentNumber.Text = c.ComponentNumber;
// foreach (COMPONENT_TYPE t in listComponentType)
// {
// if (c.ComponentTypeID == t.ComponentTypeID)
// {
// txtComponentType.Text = t.ComponentTypeName;
// }
// }
// txtComponentName.Text = c.ComponentName;
// foreach (API_COMPONENT_TYPE a1 in listAPICom)
// {
// if (a1.APIComponentTypeID == c.APIComponentTypeID)
// {
// txtAPIComponentType.Text = a1.APIComponentTypeName;
// }
// }
// }
// break;
// }
//}
//foreach (RW_ASSESSMENT a in listAssessment)
//{
// if (a.ID == assID)
// {
// txtAssessmentName.Text = a.ProposalName;
// }
//}
//đổ dữ liệu lên control cho Equipment
}