XinYu_LG2MES/ClientSolution/Core.Mes.Client.Common/lgCommon/dbCommon.cs

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

namespace Core.Mes.Client.Common
{
   public class DbCommon
    {
       /// <summary>
       /// 执行sql返回对应ds
       /// </summary>
       /// <param name="sqlStr"></param>
       /// <param name="ob"></param>
       /// <returns></returns>
        public static DataSet returnDataSet(string sqlStr,OpeBase ob)
        {
            DataSet ds = new DataSet();
            try
            {
                CoreFS.CA06.FrmBase fr = new FrmBase();
                fr.ob = ob;               
                DataTable dt = new DataTable();
                CoreClientParam CCP_Query =  CoreClientParamMgt.ReturnCoreClientParamForQuery(sqlStr, dt);          
                fr.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal);
                ds.Tables.Add(dt);
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet returnDataSet(ClientParam param)
        {
            DataSet ds = new DataSet();
            try
            {
                CoreFS.CA06.FrmBase fr = new FrmBase();
                fr.ob = param.ob;            
                DataTable dt = new DataTable();
                CoreClientParam CCP_Query = CoreClientParamMgt.ReturnCoreClientParamForQuery(param.sqlStr, dt);                    
                fr.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal);
                ds.Tables.Add(dt);
            }
            catch
            {
            }
            return ds;
        }


       /// <summary>
       /// 通用执行dml语句方法
       /// </summary>
       /// <param name="sqlStr"></param>
       /// <param name="ob"></param>
       /// <returns></returns>
        public static string executeDbNoQuery(string sqlStr, OpeBase ob)
        {
            string strErr = "";
            try
            {
                CoreFS.CA06.FrmBase fr = new FrmBase();
                fr.ob = ob;
                CoreClientParam ccp_K = CoreClientParamMgt.ReturnCoreClientParamForExecuteNoQuery(sqlStr);
                try
                {
                    fr.ExecuteNonQuery(ccp_K, CoreInvokeType.Internal);
                }
                catch
                { 
                }
                strErr = ccp_K.ReturnInfo.ToString();
                return ccp_K.ReturnInfo.ToString();
            }
            catch
            { 
            }
            return strErr;
        }

      
    }
}