MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/BllBase/BaseBll.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CoreFS.CA06;

namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BllBase
{
    public class BaseBll
    {
        private Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute = null;
        protected string DateTimeTocharFormat = "yyyy-mm-dd hh24:mi:ss";

        private string daoNameJgcx = "KgDao";
        private string daoNameQlty = "KgDao";

        protected string Trans_typeCar = "汽车";
        protected string Trans_typeShip = "水运";

       
        protected string GetDaoName_Jgcx()
        {
            return daoNameJgcx;
        }

        protected string GetDaoName_Qlty()
        {
            return daoNameQlty;
        }
     
        private CoreFS.CA06.OpeBase _ob = null;
    
        public BaseBll(OpeBase ob)
        {
            this._ob = ob;
            fr.ob = ob;
            dbExecute = new Core.StlMes.Client.Sale.DbHelp.DbExecute(ob);    
        }

        protected CoreFS.CA06.FrmBase fr = new FrmBase();

        protected Core.StlMes.Client.Sale.DbHelp.DbTransaction GetTransaction()
        {
            return new Core.StlMes.Client.Sale.DbHelp.DbTransaction(this._ob);
        }

        protected CoreClientParam GetCoreClientParam(string serverName,string methodName,object[] args)
        {
            CoreClientParam param = new CoreClientParam();
            param.ServerName = serverName;
            param.MethodName = methodName;
            param.ServerParams = args;
         //   param.IfShowErrMsg = false;
            return param;
        }

        public DataSet ExecuteQuery(string sqlStr)
        {
            DataSet ds = dbExecute.ExecuteQuery(sqlStr);
            return ds;
        }

        public DataSet ExecuteQuery(string sqlStr,string daoName)
        {
            DataSet ds = dbExecute.ExecuteQuery(sqlStr, daoName);
            return ds;
        }

        public void ExecuteNoQuery(string sqlStr)
        {
            dbExecute.ExecuteNoQuery(sqlStr);
        }

        public void ExecuteNoQuery(string sqlStr, out string errMsg)
        {
            errMsg = "";
            dbExecute.ExecuteNoQuery(sqlStr, out errMsg);
        }

        public void ExecuteNoQueryTransaction(string sqlStr, Core.StlMes.Client.Sale.DbHelp.DbTransaction transaction)
        {
            dbExecute.ExecuteNoQueryTransaction(sqlStr, transaction);
        }


        public string GetSqlConditionByColumnNameAndListStringValue( string columnName,System.Collections.ArrayList value)
        {
           if(value == null || value.Count == 0)
            return "  and 1 = 2";
           StringBuilder sb = new StringBuilder();
           sb.Append("  and (");
           foreach (String s in value)
           {
               sb.Append(string.Format(" {1} = '{0}' ", columnName,s)).Append( "  or  ");
           }
           sb.Append("  1 = 2 )");
           return sb.ToString();
        }

        /// <summary>
        /// 获取返回的错误信息
        /// </summary>
        /// <param name="result"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public string GetReturnErrorInfo(CoreClientParam result)
        {
            
            if (result == null)
                return "网络异常";
            if (result.ReturnCode == -1)
                return result.ReturnInfo+"";
            return "";
        }




    }
}