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