MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/Balance/SlmBalanceMnysubt.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 SlmBalanceMnysubt : SaleBusinessMgt.BllBase.BaseBll
    {

       private string QUERY = "select * from Slm_Balance_Mnysubt   where 1 = 1  {0} ";
       public SlmBalanceMnysubt(OpeBase ob)
            : base(ob)
        {
           
        }

       private DataSet GetSlmBalanceMnySubt(string sqlCondition)
       {
           string sql = string.Format(QUERY,sqlCondition);
           return base.ExecuteQuery(sql);
       }


       public DataSet GetSlmBalanceMnySubtByCreateTime(DateTime dtBegin,DateTime dtEnd)
       {
           string sqlcondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("CREATE_TIME",dtBegin,dtEnd);
           return GetSlmBalanceMnySubt( sqlcondition); 
       }

       public DataSet GetSlmBalanceMnySubtByBuyerCodeAndForeCode(string buyercode,string forecode)
       {
           string sqlcondition = string.Format("  and buyercode = '{0}'  and forecorpcode = '{1}' ",buyercode,forecode);
           return GetSlmBalanceMnySubt(sqlcondition);
       }

       public DataSet GetCanBeUsedSlmBalanceMnySubtByBuyerCodeAndForeCode(string buyercode, string forecode)
       {
           string sqlcondition = string.Format("  and buyercode = '{0}'  and forecorpcode = '{1}' and status_cd = '1'  ", buyercode, forecode);
           return GetSlmBalanceMnySubt(sqlcondition);
       }

       public DataSet GetSlmBalanceMnySubtByInvoiceNo(string invoiceno )
       {
           string sqlcondition = string.Format("  and INVOICENO = '{0}'   ", invoiceno);
           return GetSlmBalanceMnySubt(sqlcondition);
       }


       public void Insert(System.Collections.Hashtable hs,out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "insert", new object[] { hs });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
           
       }

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

       public void Update(System.Collections.Hashtable hs, out string errMsg)
       {
           errMsg = "";
           CoreClientParam param = base.GetCoreClientParam(_ServerName, "update", new object[] { hs });
           CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
           errMsg = base.GetReturnErrorInfo(result);
       }

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

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

       private string _ServerName = "core.stlmes.server.sale.service.balance.SlmBalanceMnySubt";
     
    }
}