XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgDbMgt/CoreClientParamMgt.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Collections;

using CoreFS.CA06;


namespace Core.LgMes.Client.lgDbMgt
{
    /// <summary>
    /// CoreClientParam 
    /// </summary>
   public class CoreClientParamMgt
    {

       // 数据源常量

       // 三期
       private const string SQ_MES_DAO = "SqDao";
       // 2.5级
       private const string EJGZ_MES_DAO = "KgDao";
       //Lgmes
       private const string LG_MES_DAO = "coredao";
       /// <summary>
        /// 返回CoreClientParam，传入list 和dt
       /// </summary>
       /// <param name="list"></param>
       /// <param name="dt"></param>
       /// <returns></returns>
       public static CoreClientParam ReturnCoreClientParamWithListConditionForQuery(ArrayList array, ArrayList sqlList, DataTable dt)
       {
           CoreClientParam param = new CoreClientParam();
           object[] obj = new object[] { array, sqlList };
           param.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
           param.MethodName = "doQuery";
           param.ServerParams = obj;
           param.SourceDataTable = dt;
           return param;
       }

      /// <summary>
       ///  返回CoreClientParam，传入list 和dt,服务名，方法名
      /// </summary>
      /// <param name="array"></param>
      /// <param name="sqlList"></param>
      /// <param name="dt"></param>
      /// <param name="serverName"></param>
      /// <param name="methodName"></param>
      /// <returns></returns>

       public static CoreClientParam ReturnCoreClientParamWithListConditionForQuery(ArrayList array, ArrayList sqlList, ref DataTable dt, string serverName, string methodName)
       {
           CoreClientParam param = new CoreClientParam();
           object[] obj = new object[] { array, sqlList };
           param.ServerName = serverName;
           param.MethodName = methodName;
           param.ServerParams = obj;
           param.SourceDataTable = dt;
           return param;
       }


       /// <summary>
       /// 查询传入sql,返回CoreClientParam
       /// </summary>
       /// <param name="sqlStr"></param>
       /// <param name="dt"></param>
       /// <returns></returns>

       public static CoreClientParam ReturnCoreClientParamForQuery(string sqlStr, DataTable dt)
       {
           CoreClientParam CCP_Query = new CoreClientParam();
           CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
           CCP_Query.MethodName = "doSimpleQuery";
           CCP_Query.ServerParams = new object[] { sqlStr };
           CCP_Query.SourceDataTable = dt;
           return CCP_Query;
       }

       /// <summary>
       /// 
       /// </summary>
       /// <param name="sqlStr"></param>
       /// <param name="dt"></param>
       /// <returns></returns>
       public static CoreClientParam ReturnSqMesDbCoreClientParamForQuery(string sqlStr, DataTable dt)
       {
           try
           {
               CoreClientParam CCP_Query = new CoreClientParam();
               CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
               CCP_Query.MethodName = "doSimpleQuery";
               CCP_Query.ServerParams = new object[] { sqlStr, SQ_MES_DAO };
               CCP_Query.SourceDataTable = dt;
               return CCP_Query;
           }
           catch { return null; }
       }


       /// <summary>
       /// 查询传入完整sql
       /// </summary>
       /// <param name="serverName"></param>
       /// <param name="methodName"></param>
       /// <param name="sqlStr"></param>
       /// <param name="dt"></param>
       /// <returns></returns>

       public static CoreClientParam ReturnCoreClientParamForQuery(string serverName, string methodName, string sqlStr, DataTable dt)
       {
           CoreClientParam CCP_Query = new CoreClientParam();
           CCP_Query.ServerName = serverName;
           CCP_Query.MethodName = methodName;
           CCP_Query.ServerParams = new object[] { sqlStr };
           CCP_Query.SourceDataTable = dt;
           return CCP_Query;
       }

       /// <summary>
       /// 返回dml的CoreClientParam
       /// </summary>
       /// <param name="serverName"></param>
       /// <param name="methodName"></param>
       /// <param name="sqlStr"></param>
       /// <param name="dt"></param>
       /// <returns></returns>

       public static CoreClientParam ReturnCoreClientParamForExecuteNoQuery(string sqlStr)
       {

           CoreClientParam param = new CoreClientParam();
           param.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
           param.MethodName = "ExcuteNoParameter";
           param.ServerParams = new Object[] { sqlStr };
           return param;
       }

    }
}