public DataTable P_GET_COUNT_COUNTEST_BY_USERID()
{
DataCollections col = new DataCollections("P_GET_COUNT_COUNTEST_BY_USERID");
col.Add(DataTypes.Number, "@userid", FieldTypes.Criterion, CGlobal.GetUserID(), "=");
return(dao.exeSelectPro(col, "P_GET_COUNT_COUNTEST_BY_USERID"));
}
public DataTable LoadByUserID()
{
DataCollections _col = new DataCollections("P_AllContest");
_col.Add(DataTypes.NVarchar, "UserId", FieldTypes.Criterion, CGlobal.GetUserID(), "=");
return(dao.exeSelectPro(_col, "P_AllContest"));
}
public DataTable LoadBySearch(int status)
{
DataCollections col = new DataCollections("P_GetAllMyNotiByUser");
col.Add(DataTypes.Number, "@userid", FieldTypes.Criterion, CGlobal.GetUserID(), "=");
col.Add(DataTypes.Number, "@notiStatus", FieldTypes.Criterion, (status + 1), "=");
return(dao.exeSelectPro(col, "P_GetAllMyNotiByUser"));
}