/// <summary>
///根据结算ID数组得到预交金对象集（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountID"></param>
/// <returns></returns>
public List <ZY_ChargeList> GetChargeListData(int[] AccountIDs)
{
string strWhere = " DELETE_FLAG in (select costmasterid from zy_costmaster where accountid in (" + CommMethod.ToString(AccountIDs) + ") ) ";
return(BindEntity <ZY_ChargeList> .CreateInstanceDAL(oleDb).GetListArray(strWhere));
}
/// <summary>
/// 根据结算ID数组得到结算对象集（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountID"></param>
/// <returns></returns>
public List <ZY_CostMaster> GetCostData(int[] AccountIDs)
{
string strWhere = "ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + ")" + oleDb.OrderBy("ACCOUNTID");
return(BindEntity <ZY_CostMaster> .CreateInstanceDAL(oleDb).GetListArray(strWhere));
}
/// <summary>
/// 根据结算ID数组得到得到废票张数（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountID"></param>
/// <returns></returns>
public int GetBadTicketCount(int[] AccountIDs)
{
string strWhere = "ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + ")";
return(Convert.ToInt32(BindEntity <object> .CreateInstanceDAL(oleDb, "ZY_BADTICKET").GetFieldValue("count(*)", strWhere)));
}
/// <summary>
/// 根据结算ID数组得到交款对象集（交款表汇总-打印结算交款表用）
/// </summary>
/// <param name="AccountIDs">结算ID数组</param>
/// <returns>交款对象集</returns>
public List <ZY_Account> GetAccounts(int[] AccountIDs, int type)
{
List <ZY_Account> zyAccounts = BindEntity <ZY_Account> .CreateInstanceDAL(oleDb).GetListArray(" AccountType=" + type + " and accountid in (" + CommMethod.ToString(AccountIDs) + ")");
for (int i = 0; i < zyAccounts.Count; i++)
{
zyAccounts[i].AccountName = BaseNameFactory.GetName(baseNameType.用户名称, zyAccounts[i].AccountCode);
}
return(zyAccounts);
}
public System.Data.DataTable GetTicketTotle(int[] AccountIDs)
{
string strsql = @"select itemname,sum(tolal_fee) as tolal_fee
from
(select (select itemname from (select a.CODE,b.ITEM_NAME as itemname from {base_stat_item as a},{base_stat_zyfp as b} where a.ZYFP_CODE = b.code ) aa where aa.code = BIGITEMCODE ) itemname ,
SUM(TOTAL_FEE) as tolal_fee
from {ZY_COSTORDER}
where COSTID IN( (select COSTMASTERID from {ZY_COSTMASTER} where ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + @") ) )
Group BY BIGITEMCODE ) a group by itemname ";
//strsql = String.Format(strsql, AccountID);
return(oleDb.GetDataTable(strsql));
}
public decimal[] GetTotleType(int[] AccountIDs)
{
decimal[] dec = new decimal[3];
string strsql = @"select sum(TOTAL_FEE) as tolal_fee
from {ZY_COSTORDER} where COSTID IN( (select COSTMASTERID from {ZY_COSTMASTER} where ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + @") ) ) and BIGITEMCODE in ('00','01','02','03')";
object obj = oleDb.GetDataResult(strsql);
dec[0] = obj == null ? 0 : Convert.ToDecimal(obj);
strsql = @"select sum(TOTAL_FEE) as tolal_fee
from {ZY_COSTORDER} where COSTID IN( (select COSTMASTERID from {ZY_COSTMASTER} where ACCOUNTID in (" + CommMethod.ToString(AccountIDs) + @") ) ) and BIGITEMCODE not in ('00','01','02','03')";
obj = oleDb.GetDataResult(strsql);
dec[1] = obj == null ? 0 : Convert.ToDecimal(obj);
dec[2] = 0;
return(dec);
}