public DataSet QueryDataSet(IUnitOfData unitData)
{
//if (ParamList != null && ParamList.Count > 0)
//{
return(unitData.QueryDataSet(SqlTxt, ParamList.ToArray()));
//}
//return null;
}
public IEnumerable <ToDoItem> GetToDoWork()
{
string sql = @"SELECT FID,APPLICATION_ID,BODY,TYPE,CATEGORY,RECEIVE_ID,SOURCE_ID,PRIVACY,CREATE_TIME FROM ATAW_MESSAGES
WHERE TYPE=@TYPE AND RECEIVE_ID=@USERID AND (ISHANDLED!=1 OR ISHANDLED IS NULL) ORDER BY CREATE_TIME DESC";
var paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@TYPE", MessageType.ToDo.ToString()));
paras.Add(new SqlParameter("@USERID", AtawAppContext.Current.UserId));
var dt = fUnitOfData.QueryDataSet(sql, paras.ToArray()).Tables[0];
var result = new List <ToDoItem>();
var delRows = new List <DataRow>();
if (dt.Rows.Count > 0)
{
result = GetToDoItems(dt.Select().ToList());
}
return(result);
}
public DataSet Query(IUnitOfData unitOfData)
{
int count = unitOfData.QueryObject(CountSql, Params.ToArray()).Value <int>();
Page.TotalCount = count;
Params.Add(new SqlParameter("@PageNo", SqlDbType.Int)
{
SqlValue = Page.PageIndex
});
Params.Add(new SqlParameter("@pageSize", SqlDbType.Int)
{
SqlValue = Page.PageSize
});
return(unitOfData.QueryDataSet(Sql, Params.ToArray()));
}
