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.FundDAL.FundPactAccountDAL
{
    /// <summary>
    /// 合同资金调拨明细记录
    /// </summary>
   public class FundPactTransDetailDAL:FundDAL.BaseDAL.BaseDAL
    {
       public FundPactTransDetailDAL(OpeBase ob)
            : base(ob)
        { 
        }
       private const string SQL_QUERY = @" select trans_seq,trans_type,balancesubject,buyercode,
                                                            secondaccount,pactno,round(money,3)money,round(leavemoney,3) leavemoney,otheraccount,
                                                            trans_time,trans_person,remark,updatetime  from sel_fund_pact_transdetail where 1 = 1 {0}";

       private const string SQL_INSERT = @"insert into sel_fund_pact_transdetail(trans_seq,trans_type,balancesubject,buyercode,
                                                            secondaccount,pactno,money,leavemoney,otheraccount, trans_time,trans_person,
                                                            remark,updatetime) 
                                                            values('{0}','{1}','{2}','{3}',
                                                            '{4}','{5}',{6},{7},'{8}',sysdate,'{9}',
                                                            '{10}',sysdate)";

       public DataSet GetSelFundPactTransDetail(string sqlConditon)
       {
           string sqlStr = string.Format(SQL_QUERY,sqlConditon);
           return base.ExecuteReaderForSaleFund(sqlStr);
       }

       public DataSet GetSelFundPactTransDetail(string sqlConditon, Boolean isSetCaption)
       {
           DataSet ds = GetSelFundPactTransDetail(sqlConditon);
           if (isSetCaption)
           {
               base.SetDataSetCaption(ref ds,base.GetColumnNameAndCaption());
           }
           return ds;
       }

       /// <summary>
       /// 通过结算单位，客户单位，二级单位，合同号获取一合同资金调拨信息
       /// </summary>
       /// <param name="balancesubject"></param>
       /// <param name="buyercode"></param>
       /// <param name="secondact"></param>
       /// <param name="pactno"></param>
       /// <returns></returns>
       public DataSet GetSelFundPactTransDetailByBalAndBuyercodeAndSecondAndPactno(string balancesubject, string buyercode, string secondact, string pactno)
       {
           string sqlConditon = base.GetSqlConditon(balancesubject,buyercode,secondact,pactno);
           return GetSelFundPactTransDetail(sqlConditon, true);
       }

       /// <summary>
       /// 写入明细数据
       /// </summary>
       /// <param name="detail"></param>
       /// <param name="errMsg"></param>
       public void Insert(Model.SEL_FUND_PACT_TRANSDETAIL detail, out string errMsg)
       {

           errMsg = "";
           try
           {
               string sqlStr = string.Format(SQL_INSERT,
                                                         detail.TRANS_SEQ, detail.TRANS_TYPE, detail.BALANCESUBJECT, detail.BUYERCODE,
                                                          detail.SECONDACCOUNT, detail.PACTNO, detail.MONEY, detail.LEAVEMONEY, detail.OTHERACCOUNT,
                                                          detail.TRANS_PERSON,
                                                          detail.REMARK);
               base.ExecuteNoReaderForSaleFund(sqlStr,out errMsg);
           }
           catch(Exception ex)
           {
               errMsg = ex.Message;
           }
       }


       /// <summary>
       /// 写入合同转移明细数据，带事务处理
       /// </summary>
       /// <param name="detail"></param>
       /// <param name="transaction"></param>
       public void Insert(Model.SEL_FUND_PACT_TRANSDETAIL detail, DbHelp.DbTransaction transaction)
       {
           try
           {
               string sqlStr = string.Format(SQL_INSERT,
                                                         detail.TRANS_SEQ, detail.TRANS_TYPE, detail.BALANCESUBJECT, detail.BUYERCODE,
                                                          detail.SECONDACCOUNT, detail.PACTNO, detail.MONEY, detail.LEAVEMONEY, detail.OTHERACCOUNT,
                                                          detail.TRANS_PERSON,
                                                          detail.REMARK);
               base.ExecuteNoReaderForSaleFund(sqlStr, transaction);
           }
           catch(Exception ex)
           {
               transaction.ErrMsg = ex.Message;
           }
       }

       public string Sql_Insert(Model.SEL_FUND_PACT_TRANSDETAIL detail)
       {
         
               string sqlStr = string.Format(SQL_INSERT,
                                                         detail.TRANS_SEQ, detail.TRANS_TYPE, detail.BALANCESUBJECT, detail.BUYERCODE,
                                                          detail.SECONDACCOUNT, detail.PACTNO, detail.MONEY, detail.LEAVEMONEY, detail.OTHERACCOUNT,
                                                          detail.TRANS_PERSON,
                                                          detail.REMARK);
               return sqlStr;
          
       }



      
    }
}