XinYu_LG2MES/ClientSolution/output/lgCommon/lgCommon.cs

using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Diagnostics;
using CoreFS.CA06;
using Core.Mes.Client.Common;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System.Collections.Generic;
using System.Net;

namespace Core.Mes.Client.Common
{
   public class lgCommon
    {
      
        public static DataSet returnDsForScmBase_Info(string sqlCondition,OpeBase ob)
        {
            DataSet ds = new DataSet();
            try
            {
                ds = Core.Mes.Client.Common.DbCommon.returnDataSet(SqlCollection.returnScm_Base_InfoByAllCondition(sqlCondition), ob);
            }
            catch
            { 
            }
            return ds;
        }

       /// <summary>
       /// 返回2钢基础数据sq by 分类编码
       /// </summary>
       /// <param name="sortCode"></param>
       /// <returns></returns>
        public static string returnScm_Base_InfoBySort_Code(string sortCode)
        {
            string sqlStr = SqlCollection.returnScm_Base_InfoByAllCondition(string.Format(" and sortcode = '{0}'", sortCode));           
            return sqlStr;
        }


       /// <summary>
       /// 获取某一电脑iP
       /// </summary>
       /// <returns></returns>
        public static List<string> returnLocalComputerIpAddress()
        {
            List<string> list = new List<string>();

            try
            {
                System.Net.IPAddress[] addressList = System.Net.Dns.GetHostByName(Dns.GetHostName()).AddressList;

                foreach (System.Net.IPAddress iplist in addressList)
                {
                    list.Add(iplist.ToString());
                }
            }
            catch
            { 
            }
  
            return list;
        }

       /// <summary>
       /// 从一个ds中获取某一字段值
       /// </summary>
       /// <param name="dsSource"></param>
       /// <param name="columnName"></param>
       /// <returns></returns>
        public static object returnColumnValueFromDsByColumnName(DataSet dsSource, string columnName)
        {
            try
            {
                if (!isDataSetDataFoundCheck(dsSource))
                    return "";
                return dsSource.Tables[0].Rows[0][columnName.ToUpper()];
            }
            catch
            {
            }

            return "";
        }

       /// <summary>
       /// 升序排一个ds
       /// </summary>
       /// <param name="dsSource">待排序ds</param>
       /// <param name="sortColumn">排序字段</param>
       /// <returns></returns>
        public static DataSet returnDsByAscOrderFromSourceDataSet(DataSet dsSource,string sortColumn)
        {
            DataSet ds = new DataSet();
            try
            {
                if (dsSource != null & dsSource.Tables.Count > 0)
                {
                    if (dsSource.Tables[0].Rows.Count == 0)
                        ds = dsSource.Clone();
                    else
                    {
                       DataView dv = new DataView(dsSource.Tables[0]);
                       dv.Sort = string.Format("{0} asc",sortColumn.ToUpper());
                       ds.Clear();
                       ds.Tables.Add(dv.ToTable());
                       
                    }
                }
            }
            catch
            {
 
            }
            return ds;
        }

       /// <summary>
        /// 降序排一个ds
       /// </summary>
        /// <param name="dsSource">待排序ds</param>
        /// <param name="sortColumn">排序字段</param>
       /// <returns></returns>

        public static DataSet returnDsByDescOrderFromSourceDataSet(DataSet dsSource, string sortColumn)
        {
            DataSet ds = new DataSet();
            try
            {
               
                if (dsSource != null & dsSource.Tables.Count > 0)
                {
                    if (dsSource.Tables[0].Rows.Count == 0)
                        ds = dsSource.Clone();
                    else
                    {
                        DataView dv = new DataView(dsSource.Tables[0]);
                        dv.Sort = string.Format("{0} desc", sortColumn.ToUpper());
                        ds.Clear();
                        ds.Tables.Add(dv.ToTable());

                    }
                }
            }
            catch
            {

            }
            return ds;
        }

       /// <summary>
       /// 通过传入值和字段组合一个查询条件,如(heatno = 'a' or heatno = 'b' or heatno = 'c')
       /// </summary>
       /// <param name="list"></param>
       /// <param name="columnName"></param>
       /// <returns></returns>
        public static string returnSqlWhereConditionByColumnListAndColumnName(ArrayList list,string columnName)
        {
            string sqlCondition = "";

            if (list == null)
                return sqlCondition;
            if (list.Count == 0)
                return sqlCondition;
            foreach (string s in list)
            {
                sqlCondition += string.Format("{0} = '{1}'" + " or ", columnName, s);
            }

            sqlCondition += " 1 = 2";

            sqlCondition = " and ( " + sqlCondition + " ) ";

            return sqlCondition;
 
        }

        public static string returnSqlWhereConditionByColumnListAndColumnName(List<string> list, string columnName)
        {
            string sqlCondition = "";

            if(list == null)
                return sqlCondition;
            if(list.Count == 0)
                return sqlCondition;
            foreach(string s in list)
            {
                sqlCondition += string.Format("{0} = '{1}'" + " or ", columnName, s);
            }

            sqlCondition += " 1 = 2";

            sqlCondition = " and ( " + sqlCondition + " ) ";

            return sqlCondition;

        }

       /// <summary>
       /// 检查Dataset值是否有效，包括null，no data,返回true 非空
       /// </summary>
       /// <param name="ds"></param>
       /// <returns></returns>
        public static Boolean isNullOrEmptyDataSetCheck(DataSet ds)
        {
            try
            {
                return (ds != null & ds.Tables.Count > 0);
               
            }
            catch
            {
                //为null or 无table 的情况，直接false
                return false;
            }
        }

       /// <summary>
       /// 检查dataset 是否 包含数据
       /// </summary>
       /// <param name="ds"></param>
       /// <returns></returns>
        public static Boolean isDataSetDataFoundCheck(DataSet ds)
        {
            try
            {
                return ds.Tables[0].Rows.Count > 0;
            }
            catch
            {
                return false;
            }
        }


       /// <summary>
       /// 对传进来的list，按顺序组合进字符串
       /// </summary>
       /// <param name="strSource"></param>
       /// <param name="list"></param>
       /// <returns></returns>
        public static string stringFormat(string strSource,ArrayList list)
        {
            string str = strSource;

            try
            {
                for (int i = 0; i < list.Count; i++)
                {
                    str = str.Replace("{" + i + "}", list[i].ToString());

                }
            }
            catch
            { 
            }
            return str;
              
        }




       



    }
}