示例#1
0
        public static CustomList <Gen_FY> GetAllGen_FY(String OrgKey)
        {
            ConnectionManager   conManager       = new ConnectionManager(ConnectionName.HR);
            CustomList <Gen_FY> Gen_FYCollection = new CustomList <Gen_FY>();
            IDataReader         reader           = null;
            String sql = string.Format("Select * from Gen_FY Where OrgKey={0}", OrgKey.ToInt());

            try
            {
                conManager.OpenDataReader(sql, out reader);
                while (reader.Read())
                {
                    Gen_FY newGen_FY = new Gen_FY();
                    newGen_FY.SetData(reader);
                    Gen_FYCollection.Add(newGen_FY);
                }
                Gen_FYCollection.InsertSpName = "spInsertGen_FY";
                Gen_FYCollection.UpdateSpName = "spUpdateGen_FY";
                Gen_FYCollection.DeleteSpName = "spDeleteGen_FY";
                return(Gen_FYCollection);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                if (reader != null && !reader.IsClosed)
                {
                    reader.Close();
                }
            }
        }
示例#2
0
 public static CustomList<Gen_FY> GetAllGen_FY(String OrgKey)
 {
     ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
     CustomList<Gen_FY> Gen_FYCollection = new CustomList<Gen_FY>();
     IDataReader reader = null;
     String sql = string.Format("Select * from Gen_FY Where OrgKey={0}", OrgKey.ToInt());
     try
     {
         conManager.OpenDataReader(sql, out reader);
         while (reader.Read())
         {
             Gen_FY newGen_FY = new Gen_FY();
             newGen_FY.SetData(reader);
             Gen_FYCollection.Add(newGen_FY);
         }
         Gen_FYCollection.InsertSpName = "spInsertGen_FY";
         Gen_FYCollection.UpdateSpName = "spUpdateGen_FY";
         Gen_FYCollection.DeleteSpName = "spDeleteGen_FY";
         return Gen_FYCollection;
     }
     catch (Exception ex)
     {
         throw (ex);
     }
     finally
     {
         if (reader != null && !reader.IsClosed)
             reader.Close();
     }
 }