public static DataView Run(string query) { var customSqlClient = new SqlClient(); customSqlClient.LoadFromRawSql(query); return customSqlClient.DefaultView; }
public static DataView GetTreeByItem(int ItemID, int UserID) { return(SqlClient.Run(HCMIS.Repository.Queries.Activity.SelectTreeByItem(ItemID, UserID))); }
public static DataView GetActivitiesForItem(int itemID, int unitID, int userID) { return(SqlClient.Run(HCMIS.Repository.Queries.Activity.SelectByItemAndUnit(itemID, unitID, userID))); }
/// <summary> /// Gets the account tree. /// </summary> /// <param name="userID">The user ID.</param> /// <returns></returns> public static DataView GetAccountTree(int userID) { var query = HCMIS.Repository.Queries.Activity.SelectGetAccountTree(userID); return(SqlClient.Run(query)); }