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")); }