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