public static DataTable GetBIPagerByProtypeYear(string protype, string year, int pageIndex, int PageSize, out int RecordCount) { DataTable dt = new DataTable(); RecordCount = 0; try { string sqlStr = "SELECT BG_BudItems.*, BG_Department.DepName FROM BG_BudItems INNER JOIN BG_Department ON BG_BudItems.DepID = BG_Department.DepID"; string filter = " WHERE (BG_BudItems.BudSta = '审核通过') AND (BG_BudItems.BIProType = '{0}') AND (YEAR(BG_BudItems.BIStaTime) = {1})"; string oderStr = " ORDER BY BG_BudItems.BudID DESC"; filter = string.Format(filter, protype, year); sqlStr += filter; sqlStr += oderStr; string sqlRecord = "SELECT count(*) FROM BG_BudItems INNER JOIN BG_Department ON BG_BudItems.DepID = BG_Department.DepID"; sqlRecord += filter; RecordCount = common.IntSafeConvert(DBUnity.ExecuteScalar(CommandType.Text, sqlRecord, null)); dt = DBUnity.GetAspNetPager(sqlStr, pageIndex, PageSize); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BGBudItemsService--GetBIPagerByProtypeYear"); } return(dt); }
/// <summary> /// 按项目类型汇总 /// </summary> /// <param name="arid">预算信息</param> /// <returns>BGUser</returns> public static DataTable GetSummaryBudInfoPager(string sta, int pageIndex, int pageSize, out int RecordCount, int CurrentYear) { DataTable dt = new DataTable(); RecordCount = 0; try { string sqlStr = string.Format("select *, year(BIStaTime) as StaYear from BG_BudItems where BudSta='{0}'and year(BIStaTime)={1} order by biprotype,BudID desc", sta, CurrentYear); string sqlRecord = string.Format("select count(*) from BG_BudItems where BudSta='{0}'", sta); RecordCount = common.IntSafeConvert(DBUnity.ExecuteScalar(CommandType.Text, sqlRecord, null)); dt = DBUnity.GetAspNetPager(sqlStr, pageIndex, pageSize); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BGBudItemsService--GetSummaryBudInfo"); } return(dt); }
/// <summary> /// 查询指定BudID的所有历史操作轨迹 /// </summary> /// <param name="budid"></param> /// <returns></returns> public static DataTable GetDtBIHisByBudid(int budid, int PageSize, int pageIndex, out int RecordCount) { DataTable dt = null; RecordCount = 0; string sqlStr = "select * from BG_BudItemHis"; string filter = " where BudID ={0} order by BudID asc"; filter = string.Format(filter, budid); sqlStr += filter; try { string sql_bc = "select count(*) from BG_BudItemHis where BudID = " + budid.ToString(); string CountStr = DBUnity.ExecuteScalar(CommandType.Text, sql_bc, null); RecordCount = common.IntSafeConvert(CountStr); dt = DBUnity.GetAspNetPager(sqlStr, pageIndex, PageSize); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BG_BudItemHisService--GetDtBIHisByBudid"); } return(dt); }
/// <summary> /// 查询指定部门下所有预算信息 /// </summary> /// <param name="arid">预算信息</param> /// <returns>BGUser</returns> public static DataTable GetApplyReimburByDepIDPager(int DepID, int pageIndex, int PageSize, out int RecordCount) { DataTable dt = new DataTable(); RecordCount = 0; try { string sqlStr = string.Format("select * from BG_BudItems where DepID={0} order by BudID desc", DepID); string sqlRecord = string.Format("select count(*) from BG_BudItems where DepID={0} ", DepID); if (DepID == 0) { sqlStr = string.Format("select * from BG_BudItems order by BudID desc"); sqlRecord = string.Format("select count(*) from BG_BudItems"); } RecordCount = common.IntSafeConvert(DBUnity.ExecuteScalar(CommandType.Text, sqlRecord, null)); dt = DBUnity.GetAspNetPager(sqlStr, pageIndex, PageSize); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BGBudItemsService--GetApplyReimburByDepID"); } return(dt); }