Exemple #1
0
        public static LienHeCollection SelectAll()
        {
            LienHeCollection List = new LienHeCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienHe_Select_SelectAll_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Exemple #2
0
        public static LienHeCollection SelectByActive(bool active)
        {
            LienHeCollection list = new LienHeCollection();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("active", active);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienHe_Select_SelectByActive", obj))
            {
                while (rd.Read())
                {
                    list.Add(getFromReader(rd));
                }
            }
            return(list);
        }
Exemple #3
0
        public static LienHeCollection SelectByGH_ID(Int32 GH_ID) // manhtv
        {
            LienHeCollection list = new LienHeCollection();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("gh_id", GH_ID);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienHe_Select_SelectByGhId_hiennb", obj))
            {
                while (rd.Read())
                {
                    list.Add(getFromReader(rd));
                }
            }
            return(list);
        }