//功能:读取版本信息
private static void Read(EquipmentTypeFault etf, DataRow Row)
{
etf.nID = PageBase.static_ext_int(Row["nID"].ToString());
etf.strID = PageBase.static_ext_string(Row["strID"].ToString());
etf.nApanageID = PageBase.static_ext_int(Row["nApanageID"].ToString());
etf.nEquipmentType = PageBase.static_ext_int(Row["nEquipmentType"].ToString());
etf.nState = PageBase.static_ext_int(Row["nState"].ToString());
etf.nUnitID = PageBase.static_ext_int(Row["nUnitID"].ToString());
etf.strID = Row["strID"].ToString();
etf.strEquipmentNumber = PageBase.static_ext_string(Row["strEquipmentNumber"].ToString());
etf.strFaultReason = PageBase.static_ext_string(Row["strFaultReason"].ToString());
etf.strIntroducer = PageBase.static_ext_string(Row["strIntroducer"].ToString());
etf.dtPresentDate = PageBase.static_ext_date(Row["dtPresentDate"].ToString());
etf.dtRepairDate = PageBase.static_ext_date(Row["dtRepairDate"].ToString());
etf.dtTehdasasetuksetDate = PageBase.static_ext_date(Row["dtTehdasasetuksetDate"].ToString());
etf.dtReplacement = PageBase.static_ext_date(Row["dtReplacement"].ToString());
}
//功能:获得整备场历史更新信息
public static List <EquipmentTypeFault> getEquipmentTypeFaultList(int unitid, int apanageid)
{
List <EquipmentTypeFault> EquipmentTypeFaultList = new List <EquipmentTypeFault>();
string strSql = "select * from TAB_EquipmentTypeFault where nUnitID=@UnitID and nApanageID=@ApanageID";
SqlParameter[] sqlParams =
{
new SqlParameter("UnitID", unitid),
new SqlParameter("ApanageID", apanageid)
};
DataTable dtEquipmentTypeFault = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql, sqlParams).Tables[0];
foreach (DataRow dr in dtEquipmentTypeFault.Rows)
{
EquipmentTypeFault etf = new EquipmentTypeFault();
EquipmentTypeFault.Read(etf, dr);
EquipmentTypeFaultList.Add(etf);
}
return(EquipmentTypeFaultList);
}
