MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/Balance/SlmBalanceInfo.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CoreFS.CA06;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using ColumnDefine = Core.StlMes.Client.Sale.Common.TbColumnDefine.TbColumnDefine;

namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Balance
{
   public   class SlmBalanceInfo : SaleBusinessMgt.BllBase.BaseBll
    {
       //private static  string Query = "select * from slm_balanceinfo  where 1 = 1 {0}";
       private static string Query1 = "select t.*,k.delete_time,k.supply_unit,k.SUPPLY_UNIT_DESC,(SELECT DISTINCT l.TON_PRICE FROM SLM_ORDER_LINE l WHERE l.ORD_LN_PK = t.ORD_LN_PK) TON_PRICE,"
           + "( SELECT DISTINCT l.CREATE_NAME FROM SLM_ORDER_HEAD l WHERE l.ORD_PK = t.ORD_PK ) CREATE_NAME,"
           + "(SELECT MAX( C.IN_TIME_F ) FROM YDM_ZC_BILL_C T INNER JOIN YDM_ZC_INLIST C ON T.MAT_NO = C.MAT_NO WHERE T.BILL_NO = t.askplan_id GROUP BY T.BILL_NO ) IN_TIME_F "
           + ",nvl(t.DELVRY_WHEREABOUTS，K.DELVRY_WHEREABOUTS) DELVRY_WHEREABOUTS,nvl(t.IS_USE,1) IS_USE,t.MEMO,DECODE(k.BILL_STATUS,'4','是','5','是','否') BILL_STATUS_FLAG "
           + "from slm_balanceinfo t, ydm_zc_bill_m k where 1 = 1 and t.askplan_id = k.bill_no(+) and t.ord_pk = k.ord_pk(+) and t.ord_ln_pk = k.ord_ln_pk(+) and t.ord_ln_dly_pk = k.ord_ln_dly_pk(+) {0}";
       private static string Query = "select t.*,k.delete_time,k.supply_unit,k.SUPPLY_UNIT_DESC,(SELECT DISTINCT l.TON_PRICE FROM SLM_ORDER_LINE l WHERE l.ORD_LN_PK = t.ORD_LN_PK) TON_PRICE, "
           + "( SELECT DISTINCT l.CREATE_NAME FROM SLM_ORDER_HEAD l WHERE l.ORD_PK = t.ORD_PK ) CREATE_NAME,"
           + "nvl(t.DELVRY_WHEREABOUTS，K.DELVRY_WHEREABOUTS) DELVRY_WHEREABOUTS,nvl(t.IS_USE,1) IS_USE,t.MEMO,DECODE(k.BILL_STATUS,'4','是','5','是','否') BILL_STATUS_FLAG "
           + "from slm_balanceinfo t, ydm_zc_bill_m k where 1 = 1 and t.askplan_id = k.bill_no(+) and t.ord_pk = k.ord_pk(+) and t.ord_ln_pk = k.ord_ln_pk(+) and t.ord_ln_dly_pk = k.ord_ln_dly_pk(+) {0}";
       private static string Query_TRANS = "select * from slm_balance_transmoney  where 1 = 1 {0}";
       private static string Query_Detail = "select * from slm_balancedetail_all  where 1 = 1 {0}";
       public SlmBalanceInfo(OpeBase ob)
            : base(ob)
        {
           
        }

       private DataSet GetSlmBalaneInfo(string sqlCondition)
       {
           string sqlStr = string.Format(Query,sqlCondition);
           return base.ExecuteQuery(sqlStr);
       }

       private DataSet GetSlmBalanceTransMoney(string sqlCondition)
       {
           string sqlStr = string.Format(Query_TRANS, sqlCondition);
           return base.ExecuteQuery(sqlStr);
       }

       private DataSet GetSlmBalanceDetailAll(string sqlCondition)
       {
           string sqlStr = string.Format(Query_Detail, sqlCondition);
           return base.ExecuteQuery(sqlStr);
       }

       public DataSet GetSlmBalanceDetailAllByAskPlanIdAndSeqAndOrderNoAndSeqAndSteelKeyAndSpetKey(String orderNo,
            String orderSeq, String orderDlvSeq, String askPlanId,
            String askPlanIdSeq, String spetKey, String steelCodeKey)
       {
           string str = orderNo + orderSeq + orderDlvSeq + spetKey + steelCodeKey + askPlanId + askPlanIdSeq;
           string sqlCondition = string.Format("  and ord_no||ord_seq||ord_ln_dly||spetkey||steelcodekey||askplan_id||askplan_id_seq = '{0}' ", str);
           return GetSlmBalanceDetailAll(sqlCondition);

       }

       public DataSet GetSlmBalanceDetailAllGroupByBatchNo(String orderNo,
          String orderSeq, String orderDlvSeq, String askPlanId,
          String askPlanIdSeq, String spetKey, String steelCodeKey)
       {
           string str = orderNo + orderSeq + orderDlvSeq + spetKey + steelCodeKey + askPlanId + askPlanIdSeq;
           string sql = @"select askplan_id,
                                       tallysheet_no,
                                       batch_no,
                                       min(plid) plid,
                                       sum(prd_qty) quantity,
                                       sum(nvl(SEND_NUM,0)) SEND_NUM,
                                       sum(nvl(act_wgt,0)) act_wgt,
                                       sum(round(nvl(case when ISPRECLOSE = '0' then outstockmny else 0 end,0),3)) outstockmny,max(money_type)  money_type,
                                          RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL
                                  from slm_balancedetail_all a  where 1 = 1 {0} group by  askplan_id,tallysheet_no,batch_no,  RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL
                                  ";
           string sqlCondition = string.Format("  and ord_no||ord_seq||ord_ln_dly||spetkey||steelcodekey||askplan_id||askplan_id_seq = '{0}' ", str);
           return base.ExecuteQuery(string.Format(sql, sqlCondition));

       }


       private DataSet GetBaseCustomberInfo(string sqlCondition)
       {
           string sql = @"select a.customer_no,
                                   a.customer_nm,
                                   a.bigarea,
                                   c.basename,
                                   a.region_no,
                                   d.region_nm,
                                   a.user_grp,
                                   a.org,
                                   a.py,
                                   a.validflag,
                                   a.create_time,
                                   a.create_name,
                                   b.sale_org,
                                   b.custm_use,
                                    a.ABRVITION 
                              from slm_base_customer a
                              left join slm_base_custm_use b on a.customer_no = b.customer_no
                                                            and b.validflag = '1'
                              left join Com_Base_Info c on a.bigarea = c.basecode
                              left join SEL_ADMIN_REGION d on a.region_no = d.region_no
                             where a.validflag = '1' {0}
                            ";
           sql = string.Format(sql, sqlCondition);
           return base.ExecuteQuery(sql);
                             
       }

       public DataSet GetBaseCustomberInfoBySaleOrg(string saleOrg)
       {
           string sqlConditon = string.Format("  and b.sale_org = '{0}' ",saleOrg);
           return GetBaseCustomberInfo(sqlConditon);
       }

       public DataSet GetBaseCustomberInfoBySaleOrgAndCustUse(string saleOrg,string custUse)
       {
           string sqlConditon = string.Format("  and b.sale_org = '{0}' and b.custm_use = '{1}' ", saleOrg, custUse);
           return GetBaseCustomberInfo(sqlConditon);
       }


       public DataSet GetSlmBalanceDetailAllGroupByAskPlanId(String askPlanId )
       {
          
           string sql = @"select askplan_id,
                                       tallysheet_no,
                                       batch_no,
                                        sum(prd_qty) quantity,
                                       sum(nvl(act_wgt,0)) act_wgt,
                                         sum(round(nvl(case when ISPRECLOSE = '0' then outstockmny else 0 end,0),3)) outstockmny,max(money_type)  money_type
                                  from slm_balancedetail_all a  where 1 = 1 {0} group by  askplan_id,tallysheet_no,batch_no
                                  ";
           string sqlStr = @"select askplan_id,
                                       tallysheet_no,
                                       batch_no,
                                        sum(prd_qty) quantity,
                                       sum(nvl(act_wgt,0)) act_wgt,
                                         sum(round(nvl(case when ISPRECLOSE = '0' then outstockmny else 0 end,0),3)) outstockmny,max(money_type)  money_type,
                                  RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL
                                  from slm_balancedetail_all a  where 1 = 1 {0}
                                 group by  askplan_id,tallysheet_no,batch_no,RECEIV_ADDR,DELVRY_ADDR,AGENCY_FL
                                  ";
           string sqlCondition = string.Format("  and askplan_id  = '{0}' ", askPlanId);
           return base.ExecuteQuery(string.Format(sqlStr, sqlCondition));

       }

       public DataSet GetInvoiceSlmBalanceTransMoney(DateTime dtBegin, DateTime dtEnd)
       {

           string sql = @"    select sum(a.money) money,a.invoiceno ,max(invoice_id) invoiceperson,max(invoicedate) invoicedate,a.buyercode, buyername,forecorpname FORECORPCODE,  MONEY_TYPE REMARK,sum(weight) weight  from SLM_BALANCE_TRANSMONEY  a
                                          where a.status_cd = '2'  {0}
                                      group by a.invoiceno,a.buyercode,forecorpname ,MONEY_TYPE,buyername     ";
           string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE", dtBegin, dtEnd);
           return base.ExecuteQuery(string.Format(sql, sqlCondition));

       }

       public DataSet GetInvoiceSlmBalanceTransMoneyOrg(DateTime dtBegin, DateTime dtEnd)
       {

           string sql = @"    select sum(a.money) money,a.INVOICENO_ORG ,max(invoiceperson_org) invoiceperson_org,
                                  max(invoicedate_org) invoicedate_org,a.buyercode, buyername,forecorpname FORECORPCODE,  
                                   MONEY_TYPE REMARK,sum(weight) weight   from SLM_BALANCE_TRANSMONEY  a
                                          where INVOICENO_ORG is not null  {0}
                                      group by a.INVOICENO_ORG,a.buyercode,forecorpname ,MONEY_TYPE,buyername     ";
           string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE_ORG", dtBegin, dtEnd);
           return base.ExecuteQuery(string.Format(sql, sqlCondition));

       }

       public DataSet GetInvoiceSlmBalanceTransMoneyAndOutStockMoney(DateTime dtBegin, DateTime dtEnd)
       {

           string sql = @"    select sum(a.money) money,a.invoiceno,money_type  from SLM_BALANCE_TRANSMONEY  a
                                          where a.status_cd = '2'   and  invoice_sts = '0' {0}
                                      group by a.invoiceno,money_type   ";
           string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE", dtBegin, dtEnd);
           return base.ExecuteQuery(string.Format(sql, sqlCondition));

       }

       public DataSet GetInvoiceSlmBalanceTransMoneyAndOutStockMoneyIncludeTax(DateTime dtBegin, DateTime dtEnd)
       {

           string sql = @"    select sum(a.weight * (decode(a.trans_type, '铁运', 23, 10))) money,a.invoiceno,money_type  from SLM_BALANCE_TRANSMONEY  a
                                          where a.status_cd = '2'  {0}
                                      group by a.invoiceno,money_type   ";
           string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("INVOICEDATE", dtBegin, dtEnd);
           return base.ExecuteQuery(string.Format(sql, sqlCondition));

       }






     

       public DataSet GetSlmBalanceTransMoneyByLoadTime(DateTime dtBegin, DateTime dtEnd)
       {
           string sqlConditin = Util.ConverObject.ConvertDateTimeValueToDbLanguage("LOAD_TIME",dtBegin,dtEnd);
           return GetSlmBalanceTransMoney(sqlConditin);
       }

       public DataSet GetSlmBalanceTransMoneyByRegeditTime(DateTime dtBegin, DateTime dtEnd)
       {
           string sqlConditin = Util.ConverObject.ConvertDateTimeValueToDbLanguage("REG_DTIME", dtBegin, dtEnd);
           return GetSlmBalanceTransMoney(sqlConditin);
       }

       public DataSet GetSlmBalanceTransMoneyAskPlanid(string askPlanId)
       {
           string sqlCondition = string.Format("  and  askplan_id = '{0}'   ", askPlanId);
           return GetSlmBalanceTransMoney(sqlCondition);
       }


       public DataSet GetSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime, bool flag)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}' ", planBeginDate, planEndDate);
           string sqlStr = string.Format(flag ? Query : Query1, sqlCondition);
           return base.ExecuteQuery(sqlStr);
       }

       public DataSet GetSlmBalaneInfoByPlanMonth(string strMonth, bool flag)
       {
           string sqlCondition = string.Format("  and  T.INVOICE_MONTH = '{0}'", strMonth);
           string sqlStr = string.Format(flag ? Query : Query1, sqlCondition);
           return base.ExecuteQuery(sqlStr);
       }
 

       public DataSet GetunAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}' and ticketstatus = '0' ", planBeginDate, planEndDate);
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetUnAffrimVirtualTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}' and ISPRECLOSE = '是' and nvl(ISREALCLOSE,'否') = '是' ", planBeginDate, planEndDate);
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetAffrimTicketsSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}' and ticketstatus = '1' ", planBeginDate, planEndDate);
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetUnAffrimSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime,String suppunit)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}'   and balancestatus = '0' and ticketstatus = '1' ", planBeginDate, planEndDate);
           if (suppunit == "120504")
               sqlCondition += " and t.fst_drawee_unit='120607' and supply_unit='120504' ";
           else
               sqlCondition += " and t.fst_drawee_unit !='120607'  ";
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetAffrimSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime, String suppunit)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}'   and balancestatus = '2' ", planBeginDate, planEndDate);
           if (suppunit == "120504")
               sqlCondition += " and t.fst_drawee_unit='120607' and supply_unit='120504' ";
           else
               sqlCondition += " and t.fst_drawee_unit !='120607'  ";
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetUnAffrimSlmBalaneInfoByPlanBeginDateAndEndDateOrg(DateTime dtBegiin, DateTime dtEndTime)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}'   and balancestatus_org = '0' and ticketstatus = '1' ", planBeginDate, planEndDate);
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetAffrimSlmBalaneInfoByPlanBeginDateAndEndDateOrg(DateTime dtBegiin, DateTime dtEndTime)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}'   and balancestatus_org = '2' ", planBeginDate, planEndDate);
           return GetSlmBalaneInfo(sqlCondition);
       }

  

       public DataSet GeOrgtInvoiceSlmBalaneInfoByInvoiceBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime)
       {
           string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate_org", dtBegiin, dtEndTime);
           sqlconditon += "   and balancestatus_org = '3'  ";
           return GetSlmBalaneInfo(sqlconditon);
       }

       public DataSet GetInvoiceSlmBalaneInfoByInvoiceBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime,bool flag)
       {
           string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate", dtBegiin, dtEndTime);
           sqlconditon += "   and balancestatus = '3'  ";
           string sqlStr = string.Format(flag ? Query : Query1, sqlconditon);
           return base.ExecuteQuery(sqlStr);
       }

       public DataSet GetInvoiceSlmBalaneInfoByStdAndStell(string str, bool flag)
       {
           //string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate", dtBegiin, dtEndTime);
           string sqlStr = string.Format(flag ? Query : Query1, str);
           //sqlStr += str;
           return base.ExecuteQuery(sqlStr);
       }

       public DataSet GetInvoiceSlmBalaneInfoByDateAndStatus(DateTime dtBegiin, DateTime dtEndTime,String suppUnit)
       {
           string sqlconditon = Util.ConverObject.ConvertDateTimeValueToDbLanguage("invoicedate", dtBegiin, dtEndTime);
           sqlconditon += "   and balancestatus = '3'  ";
           if (suppUnit == "120504")
               sqlconditon += " and t.fst_drawee_unit='120607' and k.supply_unit='120504' ";
           else
               sqlconditon += " and t.fst_drawee_unit !='120607'  ";
           return GetSlmBalaneInfo(sqlconditon);
       }


       public DataSet GetInvoiceSlmBalaneInfoByPlanBeginDateAndEndDate(DateTime dtBegiin, DateTime dtEndTime)
       {
           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegiin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtEndTime);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}'   and balancestatus = '3' ", planBeginDate, planEndDate);
           return GetSlmBalaneInfo(sqlCondition);
       }



       public DataSet GetInvoiceSlmBalanceInfoByInvoiceDate(DateTime dtBegiin, DateTime dtEndTime)
       {
           return null;
       }

       public DataSet GetInvoicedSlmBalanceInfoByListInvoiceNo(List<string> listInvoiceNo)
       {
           string sqlStr = @"select b.taxno,
                                       b.address,
                                       b.account,
                                       a.*,
                                       a.spet spec,
                                       round(a.money * 0.13/ 1.13, 2) taxmoney
                                  from (select sum(money) money,
                                               max(price) price,
                                               sum(weight) weight,
                                               max(steelcodekey) steelcode,
                                               max(category) category,
                                               max(buyercode) buyercode,
                                               max(a.buyername) buyername,
                                               max(spetkey) spet,
                                               invoiceno || '.' || invoiceno_seq invoiceno,
                                               max(invoiceno) invoicenoz,
                                               max('') auditingperson,
                                               max(invoiceperson) invoiceperson,
                                               max(fst_drawee_unit) fst_drawee_unit,
                                               max(remark) remark
                                          from slm_balanceinfo a
                                         where 1 = 1   {0}
                                           and a.balancestatus = '3'
                                         group by invoiceno || '.' || invoiceno_seq
                                        union all
                                        select sum(money) money,
                                               max(0) price,
                                               sum(0) weight,
                                               max('') steelcode,
                                               max('运费,出库费') category,
                                               max(buyercode) buyercode,
                                               max(a.buyername) buyername,
                                               max('') spet,
                                               invoiceno || '.' || '1' invoiceno,
                                               max(invoiceno) invoicenoz,
                                               max('') auditingperson,
                                               max(invoice_id) invoiceperson,
                                            max(a.fst_drawee_unit) fst_drawee_unit,
                                               max(MONEY_TYPE) remark
                                          from slm_balance_transmoney a                             
                                         where 1 = 1  {0}
                                           and a.status_cd = '2'
                                           and tickettype = '应收'
                                         group by invoiceno) a
                                  join (select b.customer_no,
                                               min(address) address,
                                               min(bank) bank,
                                               min(account) account,
                                               min(tax_id) taxno,
                                               min(phone) phone,
                                               min(fax) fax
                                          from slm_base_order_unit b
                                         group by customer_no) b on a.buyercode = b.customer_no  order by a.invoiceno ";
           string sqlConditon = Util.ConverObject.ConvertListStringValueToSqlCondition("INVOICENO", listInvoiceNo);
           sqlStr = string.Format(sqlStr, sqlConditon);
           return base.ExecuteQuery(sqlStr);
       }

       public DataSet GetInvoicedSlmBalanceInfoByListInvoiceNoOrg(List<string> listInvoiceNo)
       {
           string sqlStr = @"select b.taxno,
                                       b.address,
                                       b.account,
                                       a.*,
                                       a.spet spec,
                                       round(a.money * 0.13 / 1.13, 2) taxmoney
                                  from (select sum(money_org) money,
                                               max(price_org) price,
                                               sum(weight) weight,
                                               max(steelcodekey) steelcode,
                                               max(category) category,
                                               max(fst_drawee_unit) buyercode,
                                               max(fst_drawee_unit) buyername,
                                               max(spetkey) spet,
                                               invoiceno_org || '.' || invoiceno_seq_org invoiceno,
                                               max(invoiceno_org) invoicenoz,
                                               max('') auditingperson,
                                               max(invoiceperson) invoiceperson,
                                               max(fst_drawee_unit) fst_drawee_unit,
                                               max(remark) remark
                                          from slm_balanceinfo a
                                         where 1 = 1   {0}
                                           and a.balancestatus_org = '3'
                                         group by invoiceno_org || '.' || invoiceno_seq_org
                                        union all
                                        select sum(money) money,
                                               max(0) price,
                                               sum(0) weight,
                                               max('') steelcode,
                                               max(MONEY_TYPE) category,
                                               max(buyercode) buyercode,
                                               max(a.buyername) buyername,
                                               max('') spet,
                                               invoiceno || '.' || '1' invoiceno,
                                               max(invoiceno) invoicenoz,
                                               max('') auditingperson,
                                               max(invoice_id) invoiceperson,
                                            max(fst_drawee_unit) fst_drawee_unit,
                                               max(MONEY_TYPE) remark
                                          from slm_balance_transmoney a
                                         where 1 = 1  and 1 = 2  
                                           and a.status_cd = '2'
                                           and tickettype = '应收'
                                         group by invoiceno) a
                               left   join (select b.customer_no,
                                               min(address) address,
                                               min(bank) bank,
                                               min(account) account,
                                               min(tax_id) taxno,
                                               min(phone) phone,
                                               min(fax) fax
                                          from slm_base_order_unit b
                                         group by customer_no) b on a.buyercode = b.customer_no  order by a.invoiceno ";
           string sqlConditon = Util.ConverObject.ConvertListStringValueToSqlCondition("invoiceno_org", listInvoiceNo);
           sqlStr = string.Format(sqlStr, sqlConditon);
           return base.ExecuteQuery(sqlStr);
       }


       

       

       public DataSet GetSlmBalaneInfoByAskPlanId(String askPlanId)
       {

           string sqlCondition = string.Format("  and  askplan_id = '{0}' ", askPlanId);
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetSlmBalaneInfoByOrderNo(String orderNo)
       {

           string sqlCondition = string.Format("  and  ord_no = '{0}' ", orderNo);
           return GetSlmBalaneInfo(sqlCondition);
       }

       public DataSet GetSlmBalaneInfoByBuyerCode(String buyercode)
       {

           string sqlCondition = string.Format("  and  buyercode = '{0}' ", buyercode);
           return GetSlmBalaneInfo(sqlCondition);
       }


       public DataSet GetUnAcceptTransAndOutStockTicket()
       {
           string sqlConditon = "  and  ticketstatus =  '0' ";
           string sql = string.Format(GetBalanceTransMoney(),sqlConditon);
           return base.ExecuteQuery(sql);
       }

       public DataSet GetUnAcceptTicketAndTransAndOutStockTicket(DateTime dtBegin, DateTime deEnd,String cusInfo,String suppunit)
       {
           string conditon1 = "  ";
           string conditon2 = "  ";
           if (cusInfo == "2")
           {
               if (suppunit == "120504")
               {
                   conditon1 = " where exists (select 1 from ydm_zc_bill_m b where b.supply_unit='120504')  ";
                   conditon2=" and a.fst_drawee_unit='120607' ";
               }
               else
                   conditon2 += " and a.fst_drawee_unit !='120607'  ";
           }
           else
           {
               if (suppunit == "120504")
                   conditon1 += " where exists (select 1 from ydm_zc_bill_m b where b.supply_unit='120504') ";
               else
                   conditon1 += " where exists (select 1 from ydm_zc_bill_m b where b.supply_unit='120501')  ";
           }
           string sql = GetSlmBalanceInfo(dtBegin, deEnd, "0", conditon1, conditon2);
           return base.ExecuteQuery(sql);
       }

       public DataSet GetAcceptTransAndOutStockTicket()
       {
           string sqlConditon = "  and  ticketstatus =  '1' ";
           string sql = string.Format(GetBalanceTransMoney(), sqlConditon);
           return base.ExecuteQuery(sql);

       }

       public DataSet GetAcceptAndAffrimTransAndOutStockTicket(string suppunit)
       {
           string sqlConditon = "  and  ticketstatus =  '1'   and status_cd = '1' ";
           if (suppunit == "120504")
               sqlConditon += " and a.fst_drawee_unit='120607' and b.supply_unit='120504' ";
           else
               sqlConditon += " and a.fst_drawee_unit !='120607'  ";
           string sql = string.Format(GetBalanceTransMoney(), sqlConditon);
           return base.ExecuteQuery(sql);

       }

       public DataSet GetAcceptAndUnAffrimTransAndOutStockTicket(string suppunit)
       {
           string sqlConditon = "  and  ticketstatus =  '1'   and status_cd = '0' ";
           if (suppunit == "120504")
               sqlConditon += " and a.fst_drawee_unit='120607' and b.supply_unit='120504' ";
           else
               sqlConditon += " and a.fst_drawee_unit !='120607'  ";
           string sql = string.Format(GetBalanceTransMoney(), sqlConditon);
           return base.ExecuteQuery(sql);

       }

       public DataSet GetAcceptAndAffrimTransAndOutStockTicketOrg()
       {
           string sqlConditon = "  and  ticketstatus =  '1'   and status_cd_org = '1' ";
           string sql = string.Format(GetBalanceTransMoney(), sqlConditon);
           return base.ExecuteQuery(sql);

       }

       public DataSet GetAcceptAndUnAffrimTransAndOutStockTicketOrg()
       {
           string sqlConditon = "  and  ticketstatus =  '1'   and status_cd_org = '0' ";
           string sql = string.Format(GetBalanceTransMoney(), sqlConditon);
           return base.ExecuteQuery(sql);

       }


       private string GetSlmBalanceInfo(DateTime dtBegin, DateTime deEnd, string ticketype, string condition1, string condition2)
       {
           string sql = @"
                        select min(t.askplan_id) askplan_id,
                               (select distinct t.supply_unit from ydm_zc_bill_m t where t.bill_no=askplan_id) supply_unit,
                                ( SELECT DISTINCT t.SUPPLY_UNIT_DESC FROM ydm_zc_bill_m t WHERE t.bill_no = askplan_id ) SUPPLY_UNIT_DESC,
                               min(t.buyername) buyername,
                               t.listnumber,
                               min(t.trans_type_name) trans_type_name,
                               min(t.sale_area_desc) sale_area_desc,
                               min(t.create_dept) create_dept,
                               sum(case
                                     when MONEY_TYPE = '货款' then
                                      quantity
                                     else
                                      0
                                   end) quantity,
                               sum(case
                                     when MONEY_TYPE = '货款' then
                                      weight
                                     else
                                      0
                                   end) weight,
                               0 money,
                               sum(case
                                     when MONEY_TYPE = '出库费' then
                                      weight
                                     else
                                      0
                                   end) outweight,
                               sum(case
                                     when MONEY_TYPE = '出库费' then
                                      money
                                     else
                                      0
                                   end) OUTSTOCKMNY,
                               sum(case
                                     when MONEY_TYPE = '运费' then
                                      money
                                     else
                                      0
                                   end) transmoney,
                                     sum(t.send_num) send_num,min(t.inceptcorpcode) inceptcorpcode
                          from (select min(a.askplan_id) askplan_id,
                                       a.buyername,
                                       sum(a.quantity) quantity,
                                       sum(a.weight) weight,
                                       a.sale_area_desc,
                                       a.create_dept,
                                       a.listnumber,
                                       '货款' MONEY_TYPE,
                                       0 money,
                                        sum(a.send_num) send_num,
                                       min(a.trans_type_name) trans_type_name,min(a.inceptcorpcode) inceptcorpcode
                                  from Slm_Balanceinfo a
                                 where a.ticketstatus = '{0}'
                                  {1}
                                  {3}
                                 group by listnumber, a.buyername, a.sale_area_desc, a.create_dept
                                union all
                                
                                select min(b.askplan_id) askplan_id,
                                       min(b.buyername) buyername,
                                       0,
                                       sum(b.weight) weight,
                                       min(sale_area_desc) sale_area_desc,
                                       min(a.create_dept) create_dept,
                                       b.listnumber,
                                       b.money_type,
                                       sum(b.money) money,
                                       0,
                                       min(b.trans_type) trans_type_name, min(inceptcorpcode) inceptcorpcode
                                  from Slm_Balance_Transmoney b
                                  join (select min(b.create_dept) create_dept,
                                               min(b.create_name) create_name,
                                               min(b.sale_area_desc) sale_area_desc,
                                               bill_no
                                          from ydm_zc_bill_m m
                                          join slm_order_head b on m.ord_pk = b.ord_pk
                                         group by bill_no) a on bill_no = b.askplan_id
                                 where  b.ticketstatus = '{0}'
                                   and b.tickettype = '应收'
                                   and b.money > 0
                                   and listnumber is not null
                                 group by b.listnumber, b.money_type) t
                            {2}
                         group by listnumber,askplan_id
                        ";

           string planBeginDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(dtBegin);
           string planEndDate = Util.ConverObject.ConverDateTimeToyyyyMMdd(deEnd);
           string sqlCondition = string.Format("  and  plandate >= '{0}'  and  plandate <= '{1}' ", planBeginDate, planEndDate);
           sql = string.Format(sql, ticketype, sqlCondition, condition1, condition2);
           return sql;
       }


       private string GetBalanceTransMoney()
       {
           string sql = @" 
                              select a.askplan_id,
                               a.listnumber,
                               a.buyercode,
                               a.buyername,
                               min(a.order_no) ORD_NO,
                               min(a.order_seq) ORD_SEQ,
                               a.forecorpname forecorpcode,
                               a.fst_drawee_unit,
                               a.inceptcorpcode,
                               a.trans_type TRANS_TYPE_NAME,
                               a.tickettype,
                               a.MONEY_TYPE,
                               sum(a.money) money,
                               sum(a.weight) weight,
                               a.ord_pk,
                               a.ord_ln_pk,
                               a.ord_ln_dly_pk,
                               min(a.status_cd) BALANCESTATUS,
                                 min(a.status_cd_org) BALANCESTATUS_org,
                               min(a.ticketdate) ticketdate,
                               min(a.ticketperson) ticketperson,
                               min(a.reg_id) reg_id,
                               min(a.reg_dtime) reg_dtime,
                               min(b.sale_area_desc) sale_area_desc,
                               min(b.create_dept) create_dept,
                               min(b.create_name) create_name,
                               b.supply_unit
                          from Slm_Balance_Transmoney a
                          join (select min(b.create_dept) create_dept,
               min(b.create_name) create_name,
               min(b.sale_area_desc) sale_area_desc,
               bill_no,
               min(m.supply_unit) supply_unit
          from ydm_zc_bill_m m
          join slm_order_head b on m.ord_pk = b.ord_pk
         group by bill_no) b on a.askplan_id = b.bill_no
                         where 1=1
                               {0}
                           and a.tickettype = '应收'
                         group by a.askplan_id,
                                  a.listnumber,
                                  a.buyercode,
                                  a.buyername,
                                  a.ord_pk,
                                  a.ord_ln_pk,
                                  a.ord_ln_dly_pk,
                                  a.forecorpcode,
                                  a.forecorpname,
                                  a.fst_drawee_unit,
                                  a.inceptcorpcode,
                                  a.trans_type,
                                  a.tickettype,
                                  a.money_type,
                                  b.supply_unit

                                                    ";
           return sql;
       }

     


       public void UpdatePrice(string ord_no, string ord_seq, string ord_ln_dly, string askplan_id, string askplan_id_seq,
        string spetkey, string steelcodekey,double price,string reason,string  person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "updatePrice", new object[] { ord_no,
         ord_seq,ord_ln_dly,askplan_id, askplan_id_seq,spetkey,steelcodekey,price.ToString(), reason,person});
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void inputPrice(string ord_no, string ord_seq, string ord_ln_dly, string askplan_id, string askplan_id_seq,
      string spetkey, string steelcodekey, double price, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "inputPrice", new object[] { ord_no,
         ord_seq,ord_ln_dly,askplan_id, askplan_id_seq,spetkey,steelcodekey,price.ToString(),person});
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void SetBalPrice(System.Collections.ArrayList list, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "setBalPrice", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void SetBalPriceOrg(System.Collections.ArrayList list, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "setBalPriceOrg", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void Affrim(System.Collections.ArrayList list,string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
 
       }

       public void Affrim(System.Collections.ArrayList list, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void AffrimOrg(System.Collections.ArrayList list, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "affrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void AffrimOrg(System.Collections.ArrayList list, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "affrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void UnAffrim(System.Collections.ArrayList list, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "unaffrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void UnAffrim(System.Collections.ArrayList list, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "unaffrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void UnAffrimOrg(System.Collections.ArrayList list, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "unaffrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void UnAffrimOrg(System.Collections.ArrayList list, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "unaffrim", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void Invoice(System.Collections.ArrayList list, string forecode,string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoice", new object[] { list, forecode,person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void InvoiceLightly(System.Collections.ArrayList list, string forecode, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightly", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void InvoiceLightly(System.Collections.ArrayList list, string forecode, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightly", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void InvoiceLightlyGuoM(System.Collections.ArrayList list, string forecode, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightlyForGuoM", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void InvoiceLightlyGuoM(System.Collections.ArrayList list, string forecode, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeInvoiceLightlyForGuoM", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void InvoiceLightlyOrg(System.Collections.ArrayList list, string forecode, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "makeInvoiceLightly", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void InvoiceLightlyOrg(System.Collections.ArrayList list, string forecode, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "makeInvoiceLightly", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void InvoiceWithTranMny(System.Collections.ArrayList list, string forecode, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "makeInvoiceTransMoney", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void InvoiceWithOutStockMny(System.Collections.ArrayList list, string forecode, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "makeInvoiceOutStockMoney", new object[] { list, forecode, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);

       }

       public void RollBaskAskPlanId(string askPlanId,  string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "rollBackAskPlanId", new object[] { askPlanId, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
       }

       public void AffrimTicket(string askPlanId, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrimTicket", new object[] { askPlanId, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
       }

       public void AffrimAcceptTicket(System.Collections.ArrayList list, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "affrimTicketByListNumber", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UnAffrimAcceptTicket(string listnumber, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "unaffrimTicketByListNumber", new object[] { listnumber, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UnAffrimTicket(string askPlanId, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "unAffrimTicket", new object[] { askPlanId, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
       }

   

       public void RollBaskInvoiceNo(string invoiceNo, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "rollBackInvoiceNo", new object[] { invoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
       }

       public void RollBaskInvoiceNo(string invoiceNo, string person,out string errMsg)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "rollBackInvoiceNo", new object[] { invoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void RollBaskInvoiceNoOrg(string invoiceNo, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "rollBackInvoiceNo", new object[] { invoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
       }

       public void SaveTransMoney(List<Hashtable> lisths, string person)
       {
           foreach (Hashtable hs in lisths)
           {
               CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "saveTransMoney", new object[] { hs, person });
               CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           }
          
       }

       public void SaveTransMoneyWithAlineTicket(String billno,
         String transMny, String ticketType, String AGENCY_FL,
         String delvaddr, String ordpk, String ordLnPk, String ordLndPk,
         String indexNo, String person, string weight, string disburasesbill, string transNo, string stampDutyMoney, out string errMsg)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "saveTransMoneyWithBillNoAndTransMny",
               new object[] { billno, transMny, ticketType, AGENCY_FL, delvaddr,
                   ordpk, ordLnPk, ordLndPk, indexNo, person,weight,disburasesbill,transNo,stampDutyMoney });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
        
           

       }

       public void SaveTransMoney(List<Hashtable> lisths, string person,out string errMsg)
       {
           errMsg = "";
           foreach (Hashtable hs in lisths)
           {
               CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "saveTransMoney", new object[] { hs, person });
               CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
               errMsg = base.GetReturnErrorInfo(result);
               if (errMsg.Length > 0)
                   return;
           }

       }

       public void AffrimTransMnyTicket(string askPlanId, string person)
       {
           CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "affrimTransMnyByAskPlanId", new object[] { askPlanId, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
       }

       /// <summary>
       /// 修改费用信息
       /// </summary>
       /// <param name="transeq">主键</param>
       /// <param name="money">金额</param>
       /// <param name="ticketno">单据号</param>
       /// <param name="moneyType">类型，应收，应付</param>
       /// <param name="person">操作人</param>

       public void EditTransMoney(string transeq,string money,string ticketnum, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "editTransMoney", new object[] { transeq, ticketnum, money, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void DeleteTransMoney(string transeq, string person,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameTrans, "deleteTransMoney", new object[] { transeq, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UpdateRealInvoiceNO(string invoiceNO, string realInvoiceNo, String person ,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateRealInvoiceNo", new object[] { invoiceNO, realInvoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UpdateRealInvoiceNoOrg(string invoiceNO, string realInvoiceNo, String person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateRealInvoiceNoOrg", new object[] { invoiceNO, realInvoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       // 冲减
       public void Credit(System.Collections.ArrayList list, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "credit", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       // 集团冲减


       public void CreditOrg(System.Collections.ArrayList list, string person,  out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "credit", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UpdateSendNum(string ord_no, string ord_seq, string ord_ln_dly, string askplan_id, string askplan_id_seq,
       string spetkey, string steelcodekey, string sendNum, ArrayList list,string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateSendNum", new object[] { ord_no,
         ord_seq,ord_ln_dly,askplan_id, askplan_id_seq,spetkey,steelcodekey,sendNum,list,person});
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UpdateInvoiceStatusToLocked(ArrayList list, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateInvoiceStatusToLocked", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void MakeLastInvoiceForTransMnyAndOutStockMoney(ArrayList list, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeLastInvoiceForTransMny", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void MakeFirstInvoiceForTransMnyAndOutStockMoney(ArrayList list, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "makeFirstInvoiceForTransMny", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UpdateRealInvoiceDate(ArrayList list, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "updateRealInvoiceDate", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       public void UpdateRealInvoiceDateOrg(ArrayList list, string person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerNameOrg, "updateRealInvoiceDate", new object[] { list, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

       /// <summary>
       /// 
       /// </summary>
       /// <param name="list"></param>
       /// <param name="person"></param>
       public void AcceptRollBackAndCreaditRecord(System.Collections.ArrayList list, string askPlanid,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "acceptRollBackAndCreditRecords", new object[] { askPlanid, list });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void CreditByAddNewTicketsWithSameWgt(string invoiceNo,String person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "creditByAddNewTicketsWithSameWgt", new object[] { invoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }

       public void CreditByAddNewTicketsWithSameWgtOrg(string invoiceNo, String person, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "creditByAddNewTicketsWithSameWgtOrg", new object[] { invoiceNo, person });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);

       }


       private string _ServerName = "core.stlmes.server.sale.service.balance.SlmBalanceTickets";
       private string _ServerNameTrans = "core.stlmes.server.sale.service.balance.SlmBalanceTransMgt";
       private string _ServerNameOrg = "core.stlmes.server.sale.service.balance.SlmBalanceTicketsOrg";

    }
}