//功能:读取版本信息 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); }