XinYu_LG2MES/ClientSolution/Core.Mes.Client.Common/lgCommon/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 Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;


namespace Core.Mes.Client.Common
{
    /// <summary>
    /// CoreClientParam 
    /// </summary>
   public class CoreClientParamMgt
    {
       /// <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;
       }

       public static CoreClientParam ReturnLgMesDbCoreClientParamForQuery(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, "coredao"};
           CCP_Query.SourceDataTable = dt;
           return CCP_Query;
       }


       /// <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;
       }

    }
}