using System;
using System.Collections.Generic;
using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Security.Cryptography;
using System.Text;
using System.Diagnostics;
using System.Reflection;
using System.Web;
 
 
 


namespace DeiNiu.Utils
{

  //  public enum op_flag { add = 1, update, delete, getObj, queryAll, queryExample,queryActived,getPk, getCount}; 
//    public enum ProjectStatus { 新增未提交, 新增待预审, 新增预审通过, 新增预审未通过, 新增审核通过, 新增审核未通过, 新增考核通过, 新增考核未通过,删减未提交,删减待预审,删减预审通过,删减预审未通过,删减审核通过,删减审核未通过,删减考核通过,删减考核未通过,项目完成 };
    public enum FileType {Project,ProjectDetail,半年度总结,年度总结,半年度计划,年度计划 };
    public struct ProjectDetailStatus
    {
        public static string 审核未通过
        {
            get
            {
                return "审核未通过";
            }
        }

        public static string 考核通过
        {
            get
            {
                return "考核通过";
            }
        }
        public static string 考核未通过
        {
            get
            {
                return "考核未通过";
            }
        }

        public static string 月度未提交
        {
            get
            {
                return "月度未提交";
            }
        }

        public static string 月度已提交
        {
            get
            {
                return "月度已提交";
            }
        }
        public static string 待预审
        {
            get
            {
                return "待预审";
            }
        }
        public static string 预审通过
        {
            get
            {
                return "预审通过";
            }
        }
        public static string 预审未通过
        {
            get
            {
                return "预审未通过";
            }
        }
        public static string 审核通过
        {
            get
            {
                return "审核通过";
            }
        }
    }
    public struct ApproveRoles
    {
        public static string YuShen
        {
            get
            {
                return "项目预审";
            }
        }
        public static string ShenHe
        {
            get
            {
                return "项目审核";
            }
        }
        public static string KaoHe
        {
            get
            {
                return "项目考核";
            }
        }
        public static string 项目维护
        {
            get
            {
                return "项目维护";
            }
        }
    }
    public struct ProjectStatus
    {

        public static string 项目已分配
        {
            get
            {
                return "项目已分配";
            }
        }
        public static string 项目未分配
        {
            get
            {
                return "项目未分配";
            }
        }

        public static string 新增未提交
        {
            get
            {
                return "新增未提交";
            }
        }


        public static string 新增已提交
        {
            get
            {
                return "新增已提交";
            }
        }

         public static string 新增考核通过
        {
            get
            {
                return "新增考核通过";
            }
        }
        public static string 项目冻结
        {
            get
            {
                return "项目冻结";
            }
        }
        public static string 项目解冻
        {
            get
            {
                return "项目解冻";
            }
        }
         public static string 新增审核通过
        {
            get
            {
                return "新增审核通过";
            }
        }
            public static string 新增审核未通过
        {
            get
            {
                return "新增审核未通过";
            }
        }
         public static string 新增预审未通过
        {
            get
            {
                return "新增预审未通过";
            }
        }
         public static string 新增预审通过
        {
            get
            {
                return "新增预审通过";
            }
        }
        

          public static string 删减审核未通过
        {
            get
            {
                return "删减审核未通过";
            }
        }

         public static string 删减审核通过
        {
            get
            {
                return "删减审核通过";
            }
        }
         public static string 删减预审未通过
        {
            get
            {
                return "删减预审未通过";
            }
        }
            public static string 删减预审通过
        {
            get
            {
                return "删减预审通过";
            }
        }
       
         public static string 删减未提交
        {
            get
            {
                return "删减未提交";
            }
        }
        public static string 删减已提交
        {
            get
            {
                return "删减已提交";
            }
        }
         public static string 新增考核未通过
        {
            get
            {
                return "新增考核未通过";
            }
        }
            public static string 项目完成
        {
            get
            {
                return "项目完成";
            }
        }
        public static string 项目未完成
        {
            get
            {
                return "项目未完成";
            }
        }
         public static string 删减考核未通过
        {
            get
            {
                return "删减考核未通过";
            }
        }
         public static string 删减考核通过
        {
            get
            {
                return "删减考核通过";
            }
        }  
    }

 　  public struct appScope
    {
        /// <summary>
        /// used for  storing logic object in session
        /// when page changes in server side, logic object in session
        /// will be replaced by new one.
        /// </summary>
        public static string PagelevelObj
        {
            get
            {
                return "PageLevelObj";
            }
        }

      
    }

    public class MyTracer
    {
        private static TraceSwitch appSwitch = new TraceSwitch("TraceSwitch", "Switch in config file");

        private static string render(object clz, string msg)
        {
            //time
            StringBuilder sb = new StringBuilder();
            DateTime dt = DateTime.Now;
            sb.Append(dt.ToLongDateString()).Append(" ").Append(dt.ToLongTimeString()).Append(" - ");
            
            
            StackTrace stackTrace = new StackTrace();
            StackFrame stackFrame = stackTrace.GetFrame(2);

            //class name
            sb.Append(clz.GetType().FullName).Append(" [");
            
            //method name
            MethodBase methodBase = stackFrame.GetMethod();

            sb.Append(methodBase.Name).Append("] ");

            //the msg
            sb.Append(msg);

            return sb.ToString();
            
        }
        public static void Error(object clz, string msg)
        {
            Trace.WriteLineIf(appSwitch.TraceError, render(clz, "[ERROR] " + msg));
        }
        public static void Warning(object clz, string msg)
        {
            Trace.WriteLineIf(appSwitch.TraceWarning, render(clz, "[WARNING] " + msg));
        }
        public static void Info(object clz, string msg)
        {
            Trace.WriteLineIf(appSwitch.TraceInfo, render(clz, "[INFO] " + msg));
        }
        public static void Verbose(object clz, string msg)
        {
            Trace.WriteLineIf(appSwitch.TraceVerbose, render(clz, "[VERBOSE] " + msg));
        }
    }

    public class Util
    {
        public static string Encrypt(string password)//加密函数
        {
            Byte[] clearBytes = new UnicodeEncoding().GetBytes(password);
            Byte[] hashedBytes = ((HashAlgorithm)CryptoConfig.CreateFromName("MD5")).ComputeHash(clearBytes);
            return BitConverter.ToString(hashedBytes);
        }
       

        /// <summary>
        /// 组合in sql,return like " 1,2,3"
        /// </summary>
        /// <param name="al"></param>
        /// <returns></returns>
        public static string buildWhereIntIn(ArrayList al)
        {
            string whereString = string.Empty;

            for (int i = 0; i < al.Count; i++)
            {
                whereString += "'"+ al[i] + "',";
            }
            if (whereString.EndsWith(","))
            {
                whereString = whereString.Substring(0, whereString.Length - 1);
            }
            return whereString;
        }

        public static DataSet Excel2DataSet(string filepath)
        {
            DataSet ds = new DataSet();
            ArrayList SheeNames = ExcelSheetName(filepath);
            for(int i=0;i<SheeNames.Count;i++)
            {
                DataTable dt = (ExcelDataSource(filepath, SheeNames[i].ToString())).Tables[0].Copy();
                dt.TableName = SheeNames[i].ToString();
                dt.TableName = dt.TableName.Substring(0, dt.TableName.IndexOf("$"));
                ds.Tables.Add(dt); 
            }
            return ds;
        }
        //该方法实现从Excel中导出数据到DataSet中，其中filepath为Excel文件的绝对路径， sheetname为excel文件中的表名
        public static DataSet ExcelDataSource(string filepath, string sheetname)
        {
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            OleDbDataAdapter oada = new OleDbDataAdapter("select * from [" + sheetname + "]", strConn);
            DataSet ds = new DataSet();
            oada.Fill(ds);
            conn.Close();
            return ds;
        }

        //获得Excel中的所有sheetname。
        public static ArrayList ExcelSheetName(string filepath)
        {
            ArrayList al = new ArrayList();
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            DataTable sheetNames = conn.GetOleDbSchemaTable
            (System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            conn.Close();
            foreach (DataRow dr in sheetNames.Rows)
            {
                al.Add(dr[2]);
            }
            return al;
        }

        public　static　DataView　GetTopDataViewRows(DataView　dv,　int　n)
　  　　　　　{
　 　　　　　　　　　DataTable　dt　=　dv.Table.Clone();
　 　
　 　　　　　　　　　for　(int　i　=　0;　i　<　n　-　1;　i++)
　 　　　　　　　　　{
　 　　　　　　　　　　　　　if　(i　>=　dv.Count)
　 　　　　　　　　　　　　　{
　 　　　　　　　　　　　　　　　　　break;
 　　　　　　　　　　　　　}
 　　　　　　　　　　　　　dt.ImportRow(dv[i].Row);
 　　　　　　　　　 }
 　　　　　　　　return　new　DataView(dt,　dv.RowFilter,　dv.Sort,　 dv.RowStateFilter);
 　　　　　}


        /// <summary>
        /// 读取配置文件某项的值
        /// </summary>
        /// <param name="key">appSettings的key</param>
        /// <returns>appSettings的Value</returns>
        //public static string GetConfig(string key)
        //{
            //string _value = string.Empty;
            //System.Configuration.ConfigurationManager  config =  System.Configuration.ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            //if (config.AppSettings.Settings[key] != null)
            //{
            //    _value = config.AppSettings.Settings[key].Value;
            //}
            //return _value;
        //}


        //条形码转换
        public static string getCode128(string codeIn)
        {
            //string str ="";
            string result;
            int checksum = 104;
            for (int i = 0; i < codeIn.Length; i++)
            {
                if (codeIn[i] >= 32)
                {
                    checksum += (codeIn[i] - 32) * (i + 1);
                }
                else
                {
                    checksum += (codeIn[i] + 64) * (i + 1);
                }
            }
            checksum = checksum % 103;
            if (checksum < 95)
            {
                checksum += 32;
            }
            else
            {
                checksum += 100;
            }
            result = Convert.ToChar(204) + codeIn +
            Convert.ToChar(checksum) + Convert.ToChar(206);
            return result;
        }


        public static string getOrderNo(enumCreateOrderType orderType,int seq)
        {
            string prefix = "UN";
            switch (orderType)
            {
                case enumCreateOrderType.repOrderIn:
                    prefix = "RPI";
                    break;
                
                    
            }

            return string.Format("{0}{1:D2}{2:D10}",prefix,DateTime.Now.Month,seq);
        }


        public static string getLightKey(int color,int labelId, int address)
        {
            return string.Format("{0}-{1}-{2}", color, labelId, address);
        }

        public static Dictionary<int,string> convertEnumToDic(Type enumType){

            Dictionary<int, string> dic = new Dictionary<int, string>();
            foreach (int myCode in Enum.GetValues(enumType))
            {
                string strName = Enum.GetName(enumType, myCode);//获取名称
                string strVaule = myCode.ToString();//获取值
                dic[myCode] = strName;
               
            }

            return dic;
    }
        public static int getColor(int color)
        {
            switch (color)
            {
                case 1:
                    return 1;

                case 2:
                    return 2;

                case 3:
                    return 7;

                case 4:
                    return 6;
                case 5:
                    return 3;
                case 6:
                    return 4;
                case 7:
                    return 5;
            }

            return color;

        }



    }
}