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