//功能:读取信息
private static void Read(MBManage mbm, DataRow Row)
{
mbm.nApanageID = PageBase.static_ext_int(Row["nApanageID"].ToString());
mbm.nUnitID = PageBase.static_ext_int(Row["nUnitID"].ToString());
mbm.nID = PageBase.static_ext_int(Row["nID"].ToString());
mbm.nEquipmentType = PageBase.static_ext_int(Row["nEquipmentType"].ToString());
mbm.bIsSpares = PageBase.static_ext_int(Row["bIsSpares"].ToString());
mbm.strID = Row["strID"].ToString();
mbm.strEquipmentNumber = Row["strEquipmentNumber"].ToString();
mbm.strHolderNumber = Row["strHolderNumber"].ToString();
}
//功能:获得整备场所有终端管理信息
public static List <MBManage> getMBManageList(int nApanageID, int nUnitID)
{
List <MBManage> MBManageList = new List <MBManage>();
string strSql = "select * from TAB_MBManage where nApanageID=@nApanageID and nUnitID=@nUnitID";
SqlParameter[] sqlParams =
{
new SqlParameter("nApanageID", nApanageID),
new SqlParameter("nUnitID", nUnitID)
};
DataTable dtZbAreaConfig = SqlHelper.ExecuteDataset(searchmaster.GetSqlConnConfig("57"), CommandType.Text, strSql, sqlParams).Tables[0];
foreach (DataRow dr in dtZbAreaConfig.Rows)
{
MBManage mbm = new MBManage();
MBManage.Read(mbm, dr);
MBManageList.Add(mbm);
}
return(MBManageList);
}