Beispiel #1
0
 //功能:读取信息
 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();
 }
Beispiel #2
0
        //功能:获得整备场所有终端管理信息
        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);
        }