MES_Client/TGMES/Core.StlMes.Client.Sale.SaleFundMgt/FundBLL/FundInAndOut/FundInAndOutMgt.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CoreFS.CA06;
using DbHelp = Core.StlMes.Client.Sale.DbHelp;

namespace Core.StlMes.Client.Sale.SaleFundMgt.FundBLL.FundInAndOut
{
   public class FundInAndOutMgt:FundBaseBLL.FundBaseBLL
    {

       private OpeBase _ob = null;

       public FundInAndOutMgt(OpeBase ob):base(ob)
       {
           _ob = ob;
          
       }

     
       /// <summary>
       /// 返回数据集
       /// </summary>
       /// <param name="sqlConditoin"></param>
       /// <returns></returns>
       public DataSet GetSelFundCustFundInOut(string sqlConditoin)
       {
           
           return this.GetFundInOutInstance().GetSelFundCustFundInOut(sqlConditoin,true);
       }

       /// <summary>
       /// 通过结算单位，客户单位返回其数据集
       /// </summary>
       /// <param name="balance"></param>
       /// <param name="buyercode"></param>
       /// <returns></returns>
       public DataSet GetSelFundCustFundInOutByBalanceAndBuyercode(string balance, string buyercode)
       {
           return base.GetFundInOutInstance().GetSelFundCustFundInOutByBalanceSubjectAndBuyerCode(balance, buyercode, true);
       }

       public DataSet GetSelFundCustFundInOutByBalanceAndBuyercodeAndTime(string balanceSubject, string buyerCode, string begintime, string endtime)
       {
           return this.GetFundInOutInstance().GetSelFundCustFundInOutByBalanceSubjectAndBuyerCodeAndInOutDate(balanceSubject, buyerCode, begintime, endtime);
       }

       public DataSet GetSelFundCustFundInOutByBalanceAndTime(string balanceSubject, string begintime, string endtime)
       {
           return this.GetFundInOutInstance().GetSelFundCustFundInOutByBalanceSubjectAndInOutDate(balanceSubject, begintime, endtime);
       }

       public List<Model.SEL_FUND_CUST_FUNDINOUT> GetGetSelFundCustFundInOutModelByBalanceSubjectAndBuyerCode(string balanceSubject, string buyerCode)
       {
           return this.GetFundInOutInstance().GetGetSelFundCustFundInOutModelByBalanceSubjectAndBuyerCode(balanceSubject, buyerCode);
       }

     

       /// <summary>
       /// 删除一条记录
       /// </summary>
       /// <param name="busiSeq"></param>
       public void DeleteFundInAndOutRecord(string busiSeq)
       {
           string err = "";
           this.GetFundInOutInstance().Update_SelFundCustFundinout(busiSeq, out err);
       }

       private Model.SEL_FUND_CUST_FUNDINOUT GetSelFundCustInout(string balancesubject, string buyercode, string fundtype, string billno, double money, string importor, string importtime, string inouttime,string remark,string orderno)
       {
           Model.SEL_FUND_CUST_FUNDINOUT inout = new Model.SEL_FUND_CUST_FUNDINOUT();
           inout.BALANCESUBJECT = balancesubject;
           inout.BUYERCODE = buyercode;
           inout.FUNDTYPE = fundtype;
           inout.BILLNO = billno;
           inout.INOUTMONEY = money;
           inout.IMPORTOR = importor;
           inout.IMPORTTIME = importtime;
           inout.INOUTTIME = inouttime;
           inout.REMARK = remark;
           inout.ORDERNO = orderno;
           return inout;
       }



       //private Model.SEL_FUND_CUST_FUNDINOUT GetSelFundCustInout(string balancesubject, string buyercode, string fundtype, string billno, double money, string importor, string importtime, string inouttime, string remark, string secondact)
       //{
       //    Model.SEL_FUND_CUST_FUNDINOUT inout = new Model.SEL_FUND_CUST_FUNDINOUT();
       //    inout.BALANCESUBJECT = balancesubject;
       //    inout.BUYERCODE = buyercode;
       //    inout.FUNDTYPE = fundtype;
       //    inout.BILLNO = billno;
       //    inout.INOUTMONEY = money;
       //    inout.IMPORTOR = importor;
       //    inout.IMPORTTIME = importtime;
       //    inout.INOUTTIME = inouttime;
       //    inout.REMARK = remark;
       //    inout.SECONDACCOUNT = secondact;
       //    return inout;
       //}

       /// <summary>
       /// 进账,出账资金则为负数，用同样的方法
       /// </summary>
       /// <param name="balancesubject">结算单位</param>
       /// <param name="buyercode">客户编码</param>
       /// <param name="fundtype">类型</param>
       /// <param name="billno">票号</param>
       /// <param name="money">金额</param>
       /// <param name="importor">录入人</param>
       /// <param name="importtime">操作时间</param>
       /// <param name="inouttime">进账时间</param>
       public void AddFundRecord(string balancesubject, string buyercode, string fundtype,
           string billno, double money, string importor, string importtime, string inouttime, string remark, string orderno, double leavemny, out string errMsg)
       {
           errMsg = "";
           Model.SEL_FUND_CUST_FUNDINOUT inout = null;
           inout = GetSelFundCustInout(balancesubject, buyercode, fundtype, billno, money, importor, importtime, inouttime, remark,orderno);
           Model.SEL_FUND_CUST_ACCOUNT acct = new Model.SEL_FUND_CUST_ACCOUNT();
           acct.BALANCESUBJECT = balancesubject;
           acct.BUYERCODE = buyercode;
           inout.IMPORTOR = importor;
           inout.LEAVEMONEY = leavemny;
           // 开启事务处理
           // 先更新总资金
           System.Collections.ArrayList sqlList = new System.Collections.ArrayList();
           sqlList.Add(base.GetFundCustAccountInstance().Sql_AddMoneyToCustAccount(acct,money));
           sqlList.Add(base.GetFundInOutInstance().Sql_Insert_SelFundCustFundinout(inout));
           base.ExecuteNoReader(sqlList, out errMsg);
           // 写明细
       //    base.GetFundInOutInstance().Insert_SelFundCustFundinout(inout,transaction);
           // 提交
 
       }
       public void AddFundRecord(string balancesubject, string buyercode, string fundtype, string billno, double money, string importor, string importtime, string inouttime, string remark, string orderno, double leavemny, string seccount, out string errMsg)
       {
           errMsg = "";
           FundBLL.FundTransferMgt.FundTransferMgt FundTransferMgt =  new FundBLL.FundTransferMgt.FundTransferMgt(_ob);
           Model.SEL_FUND_CUST_FUNDINOUT inout = null;
           inout = GetSelFundCustInout(balancesubject, buyercode, fundtype, billno, money, importor, importtime, inouttime, remark, orderno);
           Model.SEL_FUND_CUST_ACCOUNT acct = new Model.SEL_FUND_CUST_ACCOUNT();
           acct.BALANCESUBJECT = balancesubject;
           acct.BUYERCODE = buyercode;
           inout.IMPORTOR = importor;
           inout.LEAVEMONEY = leavemny;
           inout.SECONDACCOUNT = seccount;
           

           Model.SEL_FUND_TRANS_SECONDACCOUNT sceact = null;
              System.Collections.ArrayList lists = null;

          
         //  if (money < 0)
         //  {

         //      sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, -money,
         //    importor, importtime, inouttime, remark, seccount);
         //      lists = FundTransferMgt.GetTransferMoneySecondAccountToCust(sceact, out errMsg);
         //  }
         //  else
         //  {
         //      sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, money,
         //importor, importtime, inouttime, remark, seccount);
         //      lists = FundTransferMgt.GetTransferMoneyCustToSecondAccount(sceact, out errMsg);
         //  }
        

           // 开启事务处理
           // 先更新总资金
           System.Collections.ArrayList sqlList = new System.Collections.ArrayList();
        //  sqlList.Add(base.GetFundCustAccountInstance().Sql_AddMoneyToCustAccount(acct, money));
           sqlList.Add(base.GetFundInOutInstance().Sql_Insert_SelFundCustFundinout(inout));
       //   sqlList.AddRange(lists);
           base.ExecuteNoReader(sqlList, out errMsg);
           // 写明细
           //    base.GetFundInOutInstance().Insert_SelFundCustFundinout(inout,transaction);
           // 提交

       }

       public void AddFundRecord(string busiseq, string balancesubject, string buyercode, string fundtype, string billno, double money, string importor, string importtime, string inouttime, string remark, string orderno,
           double leavemny, string seccount, String moneyDe, string prebuyercode,out string errMsg)
       {
           errMsg = "";
           FundBLL.FundTransferMgt.FundTransferMgt FundTransferMgt = new FundBLL.FundTransferMgt.FundTransferMgt(_ob);
           Model.SEL_FUND_CUST_FUNDINOUT inout = null;
           inout = GetSelFundCustInout(balancesubject, buyercode, fundtype, billno, money, importor, importtime, inouttime, remark, orderno);
           Model.SEL_FUND_CUST_ACCOUNT acct = new Model.SEL_FUND_CUST_ACCOUNT();
           acct.BALANCESUBJECT = balancesubject;
           acct.BUYERCODE = buyercode;
           inout.IMPORTOR = importor;
           inout.LEAVEMONEY = leavemny;
           inout.SECONDACCOUNT = seccount;
           inout.BUSISEQ = busiseq;
           inout.MONEY_DELIVER = moneyDe;
           inout.PREBUYERCODE = prebuyercode;


           Model.SEL_FUND_TRANS_SECONDACCOUNT sceact = null;
           System.Collections.ArrayList lists = null;


           //  if (money < 0)
           //  {

           //      sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, -money,
           //    importor, importtime, inouttime, remark, seccount);
           //      lists = FundTransferMgt.GetTransferMoneySecondAccountToCust(sceact, out errMsg);
           //  }
           //  else
           //  {
           //      sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, money,
           //importor, importtime, inouttime, remark, seccount);
           //      lists = FundTransferMgt.GetTransferMoneyCustToSecondAccount(sceact, out errMsg);
           //  }


           // 开启事务处理
           // 先更新总资金
           System.Collections.ArrayList sqlList = new System.Collections.ArrayList();
           //  sqlList.Add(base.GetFundCustAccountInstance().Sql_AddMoneyToCustAccount(acct, money));
           sqlList.Add(base.GetFundInOutInstance().Sql_Insert_SelFundCustFundinout(inout));
           //   sqlList.AddRange(lists);
           base.ExecuteNoReader(sqlList, out errMsg);
           // 写明细
           //    base.GetFundInOutInstance().Insert_SelFundCustFundinout(inout,transaction);
           // 提交

       }

       public void AffrimFundRecord(string busiseq, string balancesubject, string buyercode, string fundtype, string billno, double money, string importor, string importtime, string inouttime, string remark, string orderno, double leavemny, string seccount, out string errMsg)
       {
           errMsg = "";
           FundBLL.FundTransferMgt.FundTransferMgt FundTransferMgt = new FundBLL.FundTransferMgt.FundTransferMgt(_ob);
           Model.SEL_FUND_CUST_FUNDINOUT inout = null;
           inout = GetSelFundCustInout(balancesubject, buyercode, fundtype, billno, money, importor, importtime, inouttime, remark, orderno);
           Model.SEL_FUND_CUST_ACCOUNT acct = new Model.SEL_FUND_CUST_ACCOUNT();
           acct.BALANCESUBJECT = balancesubject;
           acct.BUYERCODE = buyercode;
           inout.IMPORTOR = importor;
           inout.LEAVEMONEY = leavemny;
           inout.SECONDACCOUNT = seccount;

           Model.SEL_FUND_TRANS_SECONDACCOUNT sceact = null;
           System.Collections.ArrayList lists = null;


           if (money < 0)
           {

               sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, -money,
             importor, importtime, inouttime, remark, seccount);
               lists = FundTransferMgt.GetTransferMoneySecondAccountToCust(sceact, out errMsg);
           }
           else
           {
               sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, money,
         importor, importtime, inouttime, remark, seccount);
               lists = FundTransferMgt.GetTransferMoneyCustToSecondAccount(sceact, out errMsg);
           }


           // 开启事务处理
           // 先更新总资金
           System.Collections.ArrayList sqlList = new System.Collections.ArrayList();
           sqlList.Add(base.GetFundCustAccountInstance().Sql_AddMoneyToCustAccount(acct, money));
           sqlList.Add(base.GetFundInOutInstance().Sql_UpdateSelFundCustFundInoutStatusToValidt(busiseq, importor));
           sqlList.AddRange(lists);
           base.ExecuteNoReader(sqlList, out errMsg);
           // 写明细
           //    base.GetFundInOutInstance().Insert_SelFundCustFundinout(inout,transaction);
           // 提交

       }

       public void UnAffrimFundRecord(string busiseq, string balancesubject, string buyercode, string fundtype, string billno, double money, string importor, string importtime, string inouttime, string remark,string orderno, double leavemny, string seccount, out string errMsg)
       {
           errMsg = "";
           FundBLL.FundTransferMgt.FundTransferMgt FundTransferMgt = new FundBLL.FundTransferMgt.FundTransferMgt(_ob);
           Model.SEL_FUND_CUST_FUNDINOUT inout = null;
           inout = GetSelFundCustInout(balancesubject, buyercode, fundtype, billno, money, importor, importtime, inouttime, remark, orderno);
           Model.SEL_FUND_CUST_ACCOUNT acct = new Model.SEL_FUND_CUST_ACCOUNT();
           acct.BALANCESUBJECT = balancesubject;
           acct.BUYERCODE = buyercode;
           inout.IMPORTOR = importor;
           inout.LEAVEMONEY = leavemny;
           inout.SECONDACCOUNT = seccount;

           Model.SEL_FUND_TRANS_SECONDACCOUNT sceact = null;
           System.Collections.ArrayList lists = null;


       

               sceact = GetTransSecAccount(balancesubject, buyercode, fundtype, billno, -money,
             importor, importtime, inouttime, remark, seccount);
               lists = FundTransferMgt.GetTransferMoneySecondAccountToCust(sceact, out errMsg);
        


           // 开启事务处理
           // 先更新总资金
           System.Collections.ArrayList sqlList = new System.Collections.ArrayList();
           sqlList.Add(base.GetFundCustAccountInstance().Sql_AddMoneyToCustAccount(acct, money));
           sqlList.Add(base.GetFundInOutInstance().Sql_UpdateSelFundCustFundInoutStatusToUnValidt(busiseq, importor));
           sqlList.AddRange(lists);
           base.ExecuteNoReader(sqlList, out errMsg);
           // 写明细
           //    base.GetFundInOutInstance().Insert_SelFundCustFundinout(inout,transaction);
           // 提交

       }

       public void DeleteFundRecord(string busiseq,  string importor, out string errMsg)
       {
          


           // 开启事务处理
           // 先更新总资金
           System.Collections.ArrayList sqlList = new System.Collections.ArrayList();
           sqlList.Add(base.GetFundInOutInstance().Sql_DeleteSelFundCustFundInoutRecord(busiseq, importor));

           // 如果是钢贸的,同步把给销售的也删除掉
           sqlList.Add(base.GetFundInOutInstance().Sql_DeleteSelFundCustFundInoutRecord(busiseq+"-1", importor));
           base.ExecuteNoReader(sqlList, out errMsg);
           // 写明细
           //    base.GetFundInOutInstance().Insert_SelFundCustFundinout(inout,transaction);
           // 提交

       }

       private Model.SEL_FUND_TRANS_SECONDACCOUNT GetTransSecAccount(string balancesubject, string buyercode, string fundtype, string billno, double money,
           string importor, string importtime, string inouttime, string remark,string seccount)
       {
           Model.SEL_FUND_TRANS_CUST cust = GetTransCustAccount( balancesubject,  buyercode,  fundtype,  billno, importor,  importtime,  inouttime,  remark,  seccount,  money);
           if (cust == null)
               return null;


           string secondLevelAccount = seccount;

      
           Model.SEL_FUND_TRANS_SECONDACCOUNT sec = new Model.SEL_FUND_TRANS_SECONDACCOUNT();
           sec.FUND_TRANS_CUST = cust;
           sec.SECONDACCOUNT = secondLevelAccount;
           sec.TRANS_MONEY = money;
           return sec;
       }

       private Model.SEL_FUND_TRANS_CUST GetTransCustAccount(string balancesubject, string buyercode, string fundtype, string billno,  string importor, string importtime, string inouttime, string remark, string seccount,double money)
       {
          
           //     money = Convert.ToDouble(this.ultraNumericEditor1.Value);

           Model.SEL_FUND_TRANS_CUST cust = new Model.SEL_FUND_TRANS_CUST();
           cust.BALANCESUBJECT = balancesubject;
           cust.BUYERCODE = buyercode;
           cust.TRANS_MONEY = money;
           cust.TRANS_PERSON = importor;
           cust.TRANS_TIME = Util.DateTimeUtil.GetSystemDate();
           return cust;

       }

      

      
       
       
    }
}