public v_RetentionWWoDisSchoolDistState GetSampleData(int STYP)
{
SampleDAL dal = new SampleDAL();
v_RetentionWWoDisSchoolDistState ds = dal.GetSampleData2(STYP);
this.sql = dal.SQL;
return(ds);
}
public v_RetentionWWoDisSchoolDistState GetSampleData2(int STYP)
{
v_RetentionWWoDisSchoolDistState ds = new v_RetentionWWoDisSchoolDistState();
StringBuilder sb = new StringBuilder();
sb.Append("select top 100 * from v_RetentionWWoDisSchoolDistState");
if (STYP != 0)
{
sb.AppendFormat(" where SchoolType = {0}", STYP);
}
base.GetDS(ds, sb.ToString(), ds._v_RetentionWWoDisSchoolDistState.TableName);
return(ds);
}