Пример #1
0
        public static UserFunctionCollection SelectAll()
        {
            UserFunctionCollection List = new UserFunctionCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblUserFunction_Select_SelectAll_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Пример #2
0
        public static UserFunctionCollection SelecbyLayOutId(Int32 LayID)
        {
            UserFunctionCollection List = new UserFunctionCollection();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("LAY_ID", LayID);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblUserFunction_Select_byLayOutId_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }