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.FundBusiNessInfoDAL
{
    public class SelFundBusinessinfoDAL:BaseDAL.BaseDAL
    {
        public SelFundBusinessinfoDAL(OpeBase ob)
            : base(ob)
        { 
        }
        const string SQL_STR = @"select busiseq,
                                                busitype,
                                                balancesubject,
                                                buyercode,
                                                secondaccount,
                                                pactno,
                                                money,
                                                importor,
                                                importtime,
                                                remark from sel_fund_businessinfo where 1 = 1 {0}";

        const string SQL_INSERT = @"insert into sel_fund_businessinfo( busiseq,
                                                busitype,
                                                balancesubject,
                                                buyercode,
                                                secondaccount,
                                                pactno,
                                                money,
                                                importor,
                                                importtime,
                                                remark) values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}','{8}','{9}')";

        public System.Data.DataSet GetSelFundBusinessInfo(string sqlConditon)
        {
            string sqlStr = string.Format(SQL_STR,sqlConditon);
            return base.ExecuteReader(sqlConditon);
        }


        /// <summary>
        /// 通过业务类型返回其数据
        /// </summary>
        /// <param name="busiType"></param>
        /// <returns></returns>
        public System.Data.DataSet GetSelFundBusinessInfoByBusiType(string busiType)
        {
            string sqlConditon = string.Format("  and busitype = '{0}' ",busiType);
            return GetSelFundBusinessInfo(sqlConditon);
        }

        private string GetInsertSql(Model.SEL_FUND_BUSINESSINFO busi)
        {
            try
            {
                string str = string.Format(SQL_INSERT,busi.BUSISEQ,
                                                     busi.BUSITYPE,
                                                     busi.BALANCESUBJECT,
                                                     busi.BUYERCODE,
                                                     busi.SECONDACCOUNT,
                                                     busi.PACTNO,
                                                     busi.MONEY,
                                                     busi.IMPORTOR,
                                                     busi.IMPORTTIME,
                                                     busi.REMARK);
                return str;
            }
            catch
            {
                return "";
            }
        }



        public void Insert(Model.SEL_FUND_BUSINESSINFO busi)
        {
         
            try
            {
                base.ExecuteNoReader(GetInsertSql(busi));
            }
            catch(Exception ex)
            {
               
            }
           
        }


        public void Delete()
        {
 
        }
    }
}