using System;
using System.Collections.Generic;
using System.Text;
using DBUtility;
using System.Data;
using Pub_Class;
using System.Windows.Forms;
using System.Drawing;

namespace SCM
{
    public class ClsPub1
    {
        //public static string WEBSURL = "http://124.70.129.242/WEBS-WMS/WebService1.asmx";             //雅琪诺
        //public static string WEBSURL = "http://192.168.1.29/WEBS-WMS/WebService1.asmx";               //圣龙    内网
        //public static string WEBSURL = "http://122.227.138.236/WEBS-WMS/WebService1.asmx";            //圣龙(不用)
        //public static string WEBSURL = "http://220.189.218.154:8092/WEBS-WMS/WebService1.asmx";   //四维尔    新中间层    外网
        //public static string WEBSURL = "http://192.168.0.178/WEBS-WMS/WebService1.asmx";          //四维尔    新中间层    内网
        //public static string WEBSURL = "http://122.227.199.62:5050/LMESWEBS/WebService1.asmx";        //韩电    外网JIT（不用）
        //public static string WEBSURL = "http://122.227.199.62:5050/WMSWEBS/WebService1.asmx";         //韩电    外网
        //public static string WEBSURL = "http://192.168.10.60/WMSWEBS/WebService1.asmx";               //韩电    内网宁波
        //public static string WEBSURL = "http://60.190.50.86:5050/WEBS_CE/WebService1.asmx";           //飞龙
        //public static string WEBSURL = "http://192.192.192.13/WMSWEBS/WebService1.asmx";              //卓力
        //public static string WEBSURL = "http://120.195.29.36:1230/WEBS-WMS/WebService1.asmx";         //江苏龙亨
        public static string WEBSURL = "http://60.191.27.141:8090/WEBS-WMS/WebService1.asmx";         //森楷
        //public static string WEBSURL = "http://192.168.63.195/WEBS-WMS/WebService1.asmx";
        //public static string WEBSURL = "http://192.168.2.18/WEBS-WMS/WebService1.asmx";              //公司台式机
        //public static string WEBSURL = "http://192.168.0.107/WEBS-WMS/WebService1.asmx";              //家

        //public static string WEBSURL = "http://47.96.97.237/WEBS-WMS/WebService1.asmx";              //公司服务器
        public static long HOrgID = 0;
        public static string HOrgNumber = "";
        public static long HPersonL = 2;   // 仓库人员为1，车间人员为2
        public static long HPersonWHID = 100225;   // 车间人员绑定的仓库ID
        public static string VersionNew = "";
        public static string VersionOld = "";
        public static SCM.WMSWeb.WebService1 PubWeb = new SCM.WMSWeb.WebService1();
        
        public static string CreateBillCode(string BillCode, ref string sReturn, bool Add)
        {
            SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
            oWeb.Url = ClsPub1.WEBSURL;
            Int64 BillCodeMode;
            string Profix;
            Int64 Glida;
            Int32 CodeLen;
            string sBillNo = "";
            char c = Convert.ToChar("0");
            string sKjYear = DateTime.Today.Year.ToString();
            string sPeriod = DateTime.Today.Month.ToString();
            string sDay = DateTime.Today.Day.ToString();
            //得到单据号表 信息
            //ClsOracleHelper oCn = new ClsOracleHelper();
            DataSet Ds = new DataSet();
            Ds = oWeb.getDataSetBySQL("Select * from Gy_BillNumber where BillCode='" + BillCode.Trim() + "'", "Gy_BillNumber", ref DBUtility.ClsPub.sExeReturnInfo);
            if (Ds.Tables[0].Rows.Count != 0)
            {
                BillCodeMode = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["BillCodeMode"].ToString());
                Profix = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["Profix"].ToString());
                Glida = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["Glida"].ToString());
                CodeLen = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["CodeLen"].ToString());
            }
            else
            {
                return "";
            }
            //
            string sStr;
            switch (BillCodeMode)
            {
                case 0:
                    switch (Glida)
                    {
                        case 0:
                            Ds = oWeb.getDataSetBySQL("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "'", "Gy_MaxNum", ref DBUtility.ClsPub.sExeReturnInfo);
                            if (Ds.Tables[0].Rows.Count != 0)
                            {
                                sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length);
                                sBillNo = Profix.Trim() + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim();
                            }
                            else //插入新记录
                            {
                                sStr = new string(c, CodeLen - 1);
                                oWeb.getRunProc("insert into Gy_MaxNum(BillCode,NowNumber) values('" + BillCode.Trim() + "',1)", ref DBUtility.ClsPub.sExeReturnInfo);
                                sBillNo = Profix.Trim() + sStr + 1;
                            }
                            if (Add == true)
                            {
                                oWeb.getRunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                            }
                            return sBillNo;

                        case 1:
                            return sBillNo;

                        case 2:      //当前年当前期间 生成单据号
                            Ds = oWeb.getDataSetBySQL("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear=" + sKjYear + " and Period=" + sPeriod + " and Day=" + sDay, "Gy_MaxNum", ref DBUtility.ClsPub.sExeReturnInfo);
                            if (Ds.Tables[0].Rows.Count != 0)
                            {
                                sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length);
                                sBillNo = Profix.Trim() + sKjYear + DBUtility.ClsPub.isStrNull(("0" + sPeriod)).Substring(DBUtility.ClsPub.isStrNull(("0" + sPeriod)).Length - 2, 2) + DBUtility.ClsPub.isStrNull(("0" + sDay)).Substring(DBUtility.ClsPub.isStrNull(("0" + sDay)).Length - 2, 2) + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim();
                            }
                            else //插入新记录
                            {
                                sStr = new string(c, CodeLen - 1);
                                oWeb.getRunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,Day,NowNumber)  values('" + BillCode.Trim() + "'," + sKjYear + "," + sPeriod + "," + sDay + ",1)", ref DBUtility.ClsPub.sExeReturnInfo);
                                sBillNo = Profix.Trim() + sKjYear + DBUtility.ClsPub.isStrNull(("0" + sPeriod)).Substring(DBUtility.ClsPub.isStrNull(("0" + sPeriod)).Length - 2, 2) + DBUtility.ClsPub.isStrNull(("0" + sDay)).Substring(DBUtility.ClsPub.isStrNull(("0" + sDay)).Length - 2, 2) + sStr + 1;
                            }
                            if (Add == true)
                            {
                                oWeb.getRunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear=" + sKjYear + " and Period=" + sPeriod + " and Day=" + sDay, ref DBUtility.ClsPub.sExeReturnInfo);
                            }
                            return sBillNo;
                        default:
                            return sBillNo;

                    }

                case 1:
                    return sBillNo;

                default:
                    return sBillNo;

            }
        }


        public static Int64 CreateBillID(string BillCode, ref string sReturn)
        {
            SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
            oWeb.Url = WEBSURL;
            string BillType = "";
            DataSet Ds;
            //ClsOracleHelper oCn = new ClsOracleHelper();
            Int64 lID;
            Ds = oWeb.getDataSetBySQL("select * from Gy_BillNumber with (nolock) where BillCode='" + BillCode.Trim() + "'", "Gy_BillNumber", ref DBUtility.ClsPub.sExeReturnInfo);
            if (Ds.Tables[0].Rows.Count != 0)
            {
                lID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["IDNow"].ToString());
                BillType = Ds.Tables[0].Rows[0]["BillType"].ToString().Trim();
            }
            else
            {
                lID = 0;
            }
            //同类型单据 自增1
            if (BillType.Trim() != "")
            {
                oWeb.getRunProc("update Gy_BillNumber set IDNow=IDNow+1 where BillType='" + BillType.Trim() + "'", ref DBUtility.ClsPub.sExeReturnInfo);
            }
            Ds = null;
            return lID;
        }

        //
        //检验 最新版本
        public static bool CheckUpdate()
        {

            SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
            oWeb.Url = ClsPub1.WEBSURL;
            DataSet oDs = new DataSet();
            //ClsSqlHelperMaster oCn = new ClsSqlHelperMaster();
            string LastNumber1 = "";
            string LastNumber2 = "";
            string BbNumber = "";      
            string sTableName = "";
            //得到更新表
            sTableName = ClsIni.ReadIni("UpDateCounts", "sTableName", Pub_Class.ClsPub.AppPath + @"\" + "UpDatePrj.ini");
            if (sTableName == "没有找到！" || sTableName == "")
            {
                sTableName = "HX_UPdateForWInce";
            }
            //得到最新版本
            try
            {
                oDs = oWeb.getDataSetBySQL("select top 1 * from master.." + sTableName + " order by FItemID", sTableName, ref DBUtility.ClsPub.sExeReturnInfo);
                if (oDs == null || oDs.Tables[0].Rows.Count == 0)
                {
                    return false;
                }
                else
                {
                    LastNumber1 = oDs.Tables[0].Rows[0]["FNumber"].ToString().Trim();
                    VersionNew = LastNumber1;
                }
                //得到本地版本
                LastNumber2 = ClsIni.ReadIni("UpDateCounts", "LastUpdateID", Pub_Class.ClsPub.AppPath + @"\" + "UpDatePrj.ini");
                VersionOld = LastNumber2;
                if (LastNumber2 == "没有找到！")
                {
                    return false;
                }
                if (LastNumber2.Trim().ToUpper() == LastNumber1.Trim().ToUpper())
                {
                    return false;
                }
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }

        }
        //

        // 读取列宽datagridview
        public static void GetGridView(DataGridView oGrd, string KeyItem, string AppPath)
        {

            int Cols;
            char c = Convert.ToChar(",");
            string sStr = ClsIni.ReadIni("GridSave", KeyItem, AppPath + @"\" + "grdWidth.wyini");
            if (sStr != "没有找到！")
            {
                string[] ColWidth = sStr.Split(c);
                if (oGrd.ColumnCount > ColWidth.Length)
                {
                    Cols = ColWidth.Length;
                }
                else
                {
                    Cols = oGrd.ColumnCount;
                }
                for (int i = 0; i < Cols; i++)
                {
                    if (DBUtility.ClsPub.isInt(ColWidth[i]) > 500)
                    {
                        oGrd.Columns[i].Width = DBUtility.ClsPub.isInt(ColWidth[i]);
                    }
                    else
                    {
                        oGrd.Columns[i].Width = DBUtility.ClsPub.isInt(ColWidth[i]);
                    }
                }
            }
        }
        // 读取隐藏列datagridview  并设置 对齐方式
        /// <summary>
        /// 读取隐藏列datagridview  并设置 对齐方式
        /// </summary>
        /// <param name="oGrd"></param>
        /// <param name="KeyItem"></param>
        /// <param name="AppPath"></param>
        public static void HideGridView(DataGridView oGrd, string KeyItem, string AppPath)
        {
            int Cols;
            char c = Convert.ToChar(",");
            char s = Convert.ToChar("|");
            string sStr = Fun_GetGridStrByModName(KeyItem);
            if (sStr != "没有找到！")
            {
                string[] Col = sStr.Split(c);
                for (int i = 0; i < Col.Length; i++)
                {
                    if (i >= oGrd.ColumnCount)
                    {
                        break;
                    }
                    string[] sCol = Col[i].Split(s);
                    if (sCol.Length > 1)
                    {
                        if (DBUtility.ClsPub.isStrNull(sCol[1]) == "1")
                        {
                            oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].Visible = false;                           //隐藏列
                        }
                        else
                        {
                            oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].Visible = true;                           //隐藏列
                        }
                        //h开头的隐藏
                        if (oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].HeaderText != "")
                        {
                            if (oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].HeaderText.Substring(0, 1).ToLower() == "h")
                            {
                                oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].Visible = false;
                            }
                        }
                        else
                        {
                            oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].Visible = false;
                        }
                    }
                    //
                    //if (sCol.Length > 2)
                    //{
                    //    if (DBUtility.ClsPub.isStrNull(sCol[2]) == "L")
                    //    {
                    //        oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;                           // 
                    //    }
                    //    else if (DBUtility.ClsPub.isStrNull(sCol[2]) == "R")
                    //    {
                    //        oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;    // 
                    //    }
                    //    else if (DBUtility.ClsPub.isStrNull(sCol[2]) == "M")
                    //    {
                    //        oGrd.Columns[DBUtility.ClsPub.isInt(sCol[0])].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;    // 
                    //    }
                    //    else
                    //    {
                    //        //;
                    //    }
                    //}
                }
            }
        }

        //根据模块名 返回 网格 信息
        public static string Fun_GetGridStrByModName(string KeyItem)
        {
            try
            {
                SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
                oWeb.Url = WEBSURL;
                //ClsOracleHelper oCn = new ClsOracleHelper();
                DataSet ds;
                ds = oWeb.getDataSetBySQL("select top 1 HGridString from Xt_grdAlignment where HUserName='" + DBUtility.ClsPub.CurUserName + "' and HModName='" + KeyItem + "'", "Xt_grdAlignment", ref DBUtility.ClsPub.sExeReturnInfo);
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    //oCn.CnDispose();
                    //oCn = null;
                    return "没有找到！";
                }
                else
                {
                    //oCn.CnDispose();
                    //oCn = null;
                    return DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HGridString"]);
                }
            }
            catch (Exception e)
            {
                //oCn.CnDispose();
                //oCn = null;
                return "没有找到！";
            }
        }

        //初始化网格
        public static void initGridFst(DataGridView grdMain, string Name)
        {
            grdMain.RowTemplate.Height = 18;                //行高设置
            grdMain.RowTemplate.MinimumHeight = 18;         //最小行高
            grdMain.ColumnHeadersHeight = 40;               //标题行高
            grdMain.RowHeadersVisible = false;              //固定列是否显示
            grdMain.ColumnHeadersVisible = true;            //固定行是否显示
            grdMain.RowCount = 1;                           //总行数
            for (int i = 0; i < grdMain.ColumnCount; i++)
            {
                grdMain.Columns[i].Width = 100;                                 //设置 列宽
                grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; //列 排序模式

            }
            //
            grdMain.RowsDefaultCellStyle.SelectionForeColor = Color.Black;          //行选中字体颜色
            //grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;  //内容布局（居中，靠右）
            grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//标题行布局（居中，靠右
            grdMain.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.True;//标题行自动换行
            grdMain.SelectionMode = DataGridViewSelectionMode.CellSelect;                     //选行模式
            grdMain.ReadOnly = false;                                               //是否只读
            grdMain.EditMode = DataGridViewEditMode.EditOnEnter;                    //编辑模式
            grdMain.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;  //标题行高 调整模式
            grdMain.EnableHeadersVisualStyles = false;                              //标题 显示样式
            grdMain.AllowUserToAddRows = false;             //是否允许自增--否
            grdMain.AllowUserToDeleteRows = false;          //是否允许删除--否 
            grdMain.AllowUserToResizeColumns = true;         //允许调整列宽--是
            grdMain.AllowUserToResizeRows = false;           //允许调整行高--否
            grdMain.AllowUserToOrderColumns = false;            //是否允许拖拽列
            grdMain.BackgroundColor = Color.White;              //网格背景色
            grdMain.GridColor = Color.LightGray;                //网格线颜色
            grdMain.DefaultCellStyle.SelectionBackColor = Color.AntiqueWhite;   //选中时背景颜色
            grdMain.ShowCellToolTips = false;                                   //鼠标停留 显示提示
            grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightSteelBlue;  //标题列 背景色
            ClsPub1.GetGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置列宽
            ClsPub1.HideGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置列宽
            grdMain.RowCount = 20;                          //总行数(更改行数时，会触发 编辑前事件)
        }


        //初始化网格2
        public static void initGridLast(string sAllowCol, string sTotalCol, ClsGridViewSum oSumGrid)
        {
            string[] sA;
            string[] sT;
            sA = sAllowCol.Split(Convert.ToChar(","));
            sT = sTotalCol.Split(Convert.ToChar(","));
            //
            oSumGrid.BuildAllowEditCols(sA);
            oSumGrid.BuildTotalCols(sT);
            oSumGrid.SetGridsum();
            oSumGrid.SetGridMain();
        }

        public static void initGridList(DataGridView grdMain, string Name)
        {
            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 40;
            grdMain.RowHeadersVisible = false;
            grdMain.ColumnHeadersVisible = true;
            //grdMain.RowCount = 1;
            //格式化
            //表格设置
            grdMain.RowsDefaultCellStyle.SelectionForeColor = Color.White;
            grdMain.RowsDefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionForeColor = Color.White;
            //grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;//网格内容 对齐方式
            grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;  //标题列 内容对齐方式
            grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            grdMain.ReadOnly = true;
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //允许用户调整列宽
            grdMain.EnableHeadersVisualStyles = false;     //网格标题 样式
            grdMain.AllowUserToAddRows = false;             //是否允许自增--否
            grdMain.AllowUserToDeleteRows = false;          //是否允许删除--否 
            grdMain.AllowUserToResizeColumns = true;         //允许调整列宽--是
            grdMain.AllowUserToResizeRows = false;           //允许调整行高--否
            grdMain.AllowUserToOrderColumns = true;         //允许 拖拽列
            grdMain.BackgroundColor = Color.White;          //网格背景色
            grdMain.GridColor = Color.Gainsboro;             //网格线颜色
            grdMain.ShowCellToolTips = true;
            grdMain.CellBorderStyle = DataGridViewCellBorderStyle.SingleVertical; //网格线样式：只有竖线
            grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightGray; //标题列 背景色
            grdMain.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;  //剪贴板模式：
            //grdMain.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
            //
            ClsPub1.GetGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置列宽
        }

        //显示列表
        /// <summary>
        /// 设置列宽，隐藏列(h开头、用户设置)，冻结列，对齐方式
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="Name"></param>
        /// <param name="s"></param>
        /// <param name="FrCol"></param>
        public static void DisplayGrid(DataGridView grdMain, string Name, string s, int FrCol) 
        {
            //加载列宽,隐藏列（H开头）
            for (int i = 0; i < grdMain.ColumnCount; i++)
            {
                grdMain.Columns[i].Width = 100;//默认列宽
                if (s == "否")
                {
                    grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;//是否允许 排序列
                }
                else
                {
                    grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.Automatic;
                }

                if (grdMain.Columns[i].HeaderText.Substring(0, 1).ToLower() == "h")//隐藏H开头的列
                {
                    grdMain.Columns[i].Visible = false;
                }
                else
                {
                    grdMain.Columns[i].Visible = true;
                }
            }
            for (int i = 0; i < grdMain.ColumnCount; i++)//设置冻结列
            {
                grdMain.Columns[i].Frozen = false;
            }
            if (FrCol < grdMain.ColumnCount)
            {
                grdMain.Columns[FrCol].Frozen = true;//设置冻结列
            }
            //设置字体大小 及标题行高，内容行高

            //
            ClsPub1.GetGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置列宽
            ClsPub1.HideGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//读取隐藏列datagridview  并设置 对齐方式
        }

        //得到服务器日期
        public static string GetServerDate(Int64 iType)
        {
            SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
            oWeb.Url = WEBSURL;
            //ClsSqlHelper oCn = new ClsSqlHelper();
            DataSet Ds = new DataSet();
            try
            {
                Ds = oWeb.getDataSetBySQL("Select GetDate() as CurDate", "xt_xtgnb", ref DBUtility.ClsPub.sExeReturnInfo);
                //Ds = oCn.RunProcReturn("Select GetDate() as CurDate", "xt_xtgnb");
                switch (iType)
                {
                    case 0:
                        return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("yyyy-MM-dd");
                    case 1:
                        return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("HH:mm:ss");
                    case -1:
                        return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("yyyy-MM-dd HH:mm:ss");
                    default:
                        return "1900-01-01";
                }
            }
            catch (Exception e)
            {
                return "1900-01-01";
            }
        }


    }
}