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

namespace DBUtility
{
    public class Xt_BaseBillFun
    {

        public static bool Changelock;
        public static bool EditStatus;
        public static Int32 NoCol;

        //ÉèÖÃÁбíSQL¹ýÂËÌõ¼þ
        public static void Sub_SQLWhere(ref string sWhere)
        {
            //
        }

        //Åжϻá¼ÆÆÚ¼ä
        public static bool Fun_AllowYearPeriod(DateTime dtpHDate, ref int sYear, ref int sPeriod, ref string s)
        {
            //»ñÈ¡±¾ÆÚ»á¼ÆÆÚ¼ä
            int CurYear = 0;
            int CurPeriod = 0;
            if (DBUtility.ClsPub.Sub_GetCurPeriod(ref  CurYear, ref  CurPeriod) == false)
            {
                s = "»ñÈ¡»á¼ÆÆÚ¼äʧ°Ü!";
                return false;
            }
            if (ClsPub.Sub_GetPeriodByDate(ClsPub.isDate(dtpHDate, 0), ref sYear, ref sPeriod))
            {
                if (!(sYear * 100 + sPeriod >= CurYear * 100 + CurPeriod))
                {
                    s = "ÄúÑ¡ÔñµÄÈÕÆڵĻá¼ÆÆÚ¼äÒѽáÕË£¡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
                    return false;
                }
            }
            else
            {
                s = "ÄúÑ¡ÔñµÄÈÕÆÚ²»ÊôÓÚºÏÀíµÄ»á¼ÆÆڼ䣡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
                return false;
            }
            return true;
        }

        //ÅжϹ¤×Ê-»á¼ÆÆÚ¼ä
        public static bool Fun_AllowYearPeriod_Pay(DateTime dtpHDate, ref int sYear, ref int sPeriod, ref string s)
        {
            //»ñÈ¡±¾ÆÚ»á¼ÆÆÚ¼ä
            int CurYear = 0;
            int CurPeriod = 0;
            if (DBUtility.ClsPub.Sub_GetCurPeriod_Pay(ref  CurYear, ref  CurPeriod) == false)
            {
                s = "»ñÈ¡»á¼ÆÆÚ¼äʧ°Ü!";
                return false;
            }
            if (ClsPub.Sub_GetPeriodByDate_Pay(ClsPub.isDate(dtpHDate, 0), ref sYear, ref sPeriod))
            {
                if (!(sYear * 100 + sPeriod >= CurYear * 100 + CurPeriod))
                {
                    s = "ÄúÑ¡ÔñµÄÈÕÆڵĻá¼ÆÆÚ¼äÒѽáÕË£¡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
                    return false;
                }
            }
            else
            {
                s = "ÄúÑ¡ÔñµÄÈÕÆÚ²»ÊôÓÚºÏÀíµÄ»á¼ÆÆڼ䣡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
                return false;
            }
            return true;
        }

        ////Åжϻá¼ÆÆÚ¼ä
        //public static bool Fun_AllowYearPeriod(DateTime dtpHDate, ref int sYear,ref int sPeriod,ref string s)
        //{
        //    if (ClsPub.Sub_GetPeriodByDate(ClsPub.isDate(dtpHDate, 0), ref sYear, ref sPeriod))
        //    {
        //        if (!(sYear * 100 + sPeriod >= ClsPub.CurYear * 100 + ClsPub.CurPeriod))
        //        {
        //            s= "ÄúÑ¡ÔñµÄÈÕÆڵĻá¼ÆÆÚ¼äÒѽáÕË£¡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
        //            return false;
        //        }
        //    }
        //    else
        //    {
        //        s= "ÄúÑ¡ÔñµÄÈÕÆÚ²»ÊôÓÚºÏÀíµÄ»á¼ÆÆڼ䣡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
        //        return false;
        //    }
        //    return true;
        //}

        //ÅжÏK3»á¼ÆÆÚ¼ä
        public static bool Fun_AllowYearPeriodK3(DateTime dtpHDate, ref int sYear, ref int sPeriod, ref string s)
        {
            if (ClsPub.Sub_GetPeriodByDateK3(ClsPub.isDate(dtpHDate, 0), ref sYear, ref sPeriod))
            {
                if (!(sYear * 100 + sPeriod >= ClsPub.CurYear * 100 + ClsPub.CurPeriod))
                {
                    s = "ÄúÑ¡ÔñµÄÈÕÆڵĻá¼ÆÆÚ¼äÒѽáÕË£¡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
                    return false;
                }
            }
            else
            {
                s = "ÄúÑ¡ÔñµÄÈÕÆÚ²»ÊôÓÚºÏÀíµÄ»á¼ÆÆڼ䣡ÇëÓë¹ÜÀíÔ±ÁªÏµ";
                return false;
            }
            return true;
        }

        //¹Ø±ÕÇ°ÅжÏ
        public static bool Fun_AllowCloseBill(object oBill, ref string s)
        {
            return true;
        }

        //·´¹Ø±ÕÇ°ÅжÏ
        public static bool Fun_AllowCancelBill(object oBill, ref string s)
        {
            return true;
        }

        //×÷·ÏÇ°ÅжÏ
        public static bool Fun_AllowCancelltionBill(object oBill, ref string s)
        {
            return true;
        }

        //»Ö¸´×÷·ÏÇ°ÅжÏ
        public static bool Fun_AllowAbandonCancelltionBill(object oBill, ref string s)
        {
            return true;
        }


        //·´ÉóºËÇ°ÅжÏ
        public static bool Fun_AllowAbandonCheckBill(object oBill, ref string s)
        {
            return true;
        }

        //ÉóºËÇ°ÅжÏ
        public static bool Fun_AllowCheckBill(object oBill, ref string s)
        {
            return true;
        }
         

        //ɾ³ýÇ°ÅжÏ
        public static bool Fun_AllowDeleteBill(object oBill, ref string s)
        {
            return true;
        }

        //±à¼­Ç°ÅжÏ
        public static bool Fun_AllowEditBill(object oBill,ref string s)
        {
            return true;
        }



        //·´ÉóºËÇ°ÅжÏ
        public static bool Fun_AllowAbandonCheckBill(string HChecker, ref string s)
        {
            if (HChecker != ClsPub.CurUserName)
            {
                return false;
            }
            else
            {
                return true;
            }
        }


        

        //ɾ³ýÇ°ÅжÏ
        public static bool Fun_AllowDeleteBill(string HMaker, ref string s)
        {
            if (HMaker != ClsPub.CurUserName)
            {
                return false;
            }
            else
            {
                return true;
            }
        }




        //±à¼­Ç°ÅжÏ
        public static bool Fun_AllowEditBill(string HMaker, ref string s)
        {
            //if (HMaker != ClsPub.CurUserName)
            //{
            //    return false;
            //}
            //else
            //{
                return true;
            //}
        }

        //Çå¿Õ½çÃæ
        public static void Sub_ClearBill2(SplitterPanel gbUp)
        {
            //Çå¿Õ½çÃæ¿Ø¼þ for ¿Ø¼þ   
            foreach (Control ct in gbUp.Controls)
            {
                switch (ct.GetType().Name)
                {
                    case "ListBox":
                        ((ListBox)ct).Items.Clear();
                        break;
                    case "CheckBox":
                        //((CheckBox)ct).Checked = false;
                        break;
                    case "RadioButton":

                        break;
                    case "ComboBox":
                        ((ComboBox)ct).SelectedIndex = 0;
                        break;
                    case "TextBox":
                        ((TextBox)ct).Text = "";
                        break;
                    case "DateTimePicker":
                        ((DateTimePicker)ct).Value = DateTime.Today;
                        break;
                    default:
                        break;
                }
            }
        }
        //Çå¿Õ½çÃæ
        public static void Sub_ClearBill1(TabPage gbUp)
        {
            //Çå¿Õ½çÃæ¿Ø¼þ for ¿Ø¼þ   
            foreach (Control ct in gbUp.Controls)
            {
                switch (ct.GetType().Name)
                {
                    case "ListBox":
                        ((ListBox)ct).Items.Clear();
                        break;
                    case "CheckBox":
                        //((CheckBox)ct).Checked = false;
                        break;
                    case "RadioButton":

                        break;
                    case "ComboBox":
                        ((ComboBox)ct).SelectedIndex = 0;
                        break;
                    case "TextBox":
                        ((TextBox)ct).Text = "";
                        break;
                    case "DateTimePicker":
                        ((DateTimePicker)ct).Value = ClsPub.isDate(ClsPub.GetServerDate(0));
                        break;
                    default:
                        break;
                }
            }
        }

        //Çå¿Õ½çÃæ
        public static void Sub_ClearBill(GroupBox gbUp)
        {
            //Çå¿Õ½çÃæ¿Ø¼þ for ¿Ø¼þ   
            foreach (Control ct in gbUp.Controls)
            {
                switch (ct.GetType().Name)
                {
                    case "ListBox":
                        ((ListBox)ct).Items.Clear();
                        break;
                    case "CheckBox":
                        ((CheckBox)ct).Checked = false;
                        break;
                    case "RadioButton":

                        break;
                    case "ComboBox":
                        ((ComboBox)ct).SelectedIndex = 0;
                        break;
                    case "TextBox":
                        ((TextBox)ct).Text = "";
                        break;
                    case "DateTimePicker":
                        ((DateTimePicker)ct).Value =ClsPub.isDate(ClsPub.GetServerDate(0)) ;
                        break;
                    default:
                        break;
                }
            }
        }
       

        //³õʼ»¯Íø¸ñ
        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;  //±êÌâÁÐ ±³¾°É«
            ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);//ÉèÖÃÁпí
            ClsPub.HideGridView(grdMain, Name, 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();
        }

        //³õʼ»¯Íø¸ñ3
        /// <summary>
        /// ³õʼ»¯Íø¸ñ3  Î޺ϼÆÍø¸ñ
        /// </summary>
        /// <param name="sAllowCol"></param>
        /// <param name="oMainGrid"></param>
        public static void initGridLast(string sAllowCol, ClsGridViewFun oMainGrid)
        {
            string[] sA; 
            sA = sAllowCol.Split(Convert.ToChar(",")); 
            //
            oMainGrid.BuildAllowEditCols(sA);  
        }

        //ÊÇ·ñ¿ÕÐÐ
        public static bool IsNullRow(int Row,int Col,DataGridView grdMain)
        {
            if (ClsPub.isLong(grdMain.Rows[Row].Cells[Col].Value) == 0)
            {
                return true;
            }
            return false;
        }
        //ÅжÏÊÇ·ñÔÊÐí±à¼­
        public static bool AllowEdit(bool grdStatus, ClsGridViewSum oSumGrid,int Col)
        {
            if (!grdStatus)     //ä¯ÀÀģʽϲ»Äܱ༭
            {
                return  true;
            }
            if (oSumGrid.FindAllowEditCol(Col) == false) //·Ç¿É±à¼­ÁÐ ²»Äܱ༭
            {
                return true;
            }
            return false;
        }

        //ÅжÏÊÇ·ñÔÊÐí±à¼­
        public static bool AllowEdit( ClsGridViewFun oMainGrid, int Col)
        {

            if (oMainGrid.FindAllowEditCol(Col) == false) //·Ç¿É±à¼­ÁÐ ²»Äܱ༭
            {
                return true;
            }
            return false;
        }


        //ÉèÖúϼÆÍø¸ñ
        public static void SetSumGrid(ClsGridViewSum oSumGrid)
        {
            oSumGrid.SetGridsum();  //ÉèÖúϼÆ
            oSumGrid.Total();       //ºÏ¼Æ
        }

        public static void AddRow(ClsGridViewSum oSumGrid)
        {
            oSumGrid.Sub_AddRow();
        }

        public static void AddRow(ClsGridViewFun oMainGrid)
        {
            oMainGrid.Sub_AddRow();
        }

        public static void DelRow(ClsGridViewSum oSumGrid)
        {
            oSumGrid.Sub_DelRow();
        }

        public static void DelRow(ClsGridViewFun oMainGrid)
        {
            oMainGrid.Sub_DelRow();
        }

        public static void SaveGrid(DataGridView grdMain,string Name)
        {
            ClsPub.SaveGridView(grdMain,Name,ClsPub.AppPath);
        }

        

        public static void GetGrid(DataGridView grdMain,string Name)
        {
            ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);
        }

       
        

        public static void DefaultGridView(DataGridView grdMain,string Name)
        {
            ClsPub.DefaultGridView(grdMain);
            //²ÎÊý½âÊÍ  ¿ªÊ¼ÁÐ £¬½áÊøÁУ¬ÊÇ·ñÒÔ×î´óÁпíΪ׼£¬×îСÁпí
            ClsPub.SaveGridView(grdMain,  Name,ClsPub.AppPath);
        }

       

        public static Int32 Fun_GetCol(string sCol,DataGridView grdMain)
        {
            for (int c = 0; c < grdMain.ColumnCount; c++)
            {
                if (ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
                {
                    return c;
                }
            }
            return -1;
        }

        


        public static void GraphLine(DataGridView grdMain,int MainIDCol,int SubIDCol,string s,ref long n)
        {
            long HMainID = 0;
            bool b = false; 
            //Ñ­»·ËùÓÐÐÐ
            for (int i = 0; i < grdMain.RowCount; i++)
            {
                if (HMainID == 0)
                {
                    HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value);
                    n++;
                }
                else
                {
                    if (HMainID == ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value))
                    {
                        if (s == "·ñ")
                        {
                            //ÇøÓòÐÔÇå¿Õ
                            SetDataGrid(grdMain,i, MainIDCol + 1, i, SubIDCol - 1, "");

                        }
                    }
                    else
                    {
                        HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value);
                        b = !b;
                        n++;
                    }
                }
                if (b)
                {
                    grdMain.Rows[i].DefaultCellStyle.BackColor = Color.White;
                }
                else
                {
                    grdMain.Rows[i].DefaultCellStyle.BackColor = Color.Lavender;
                }
            }
        }



        public static void GraphLine_XB(DataGridView grdMain, int MainIDCol, int SubIDCol, string s, ref long n)
        {
            long HMainID = 0;
            bool b = false;
            //Ñ­»·ËùÓÐÐÐ
            for (int i = 0; i < grdMain.RowCount; i++)
            {
                if (HMainID == 0)
                {
                    HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value);
                    n++;
                }
                else
                {
                    if (HMainID == ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value))
                    {
                        if (s == "·ñ")
                        {
                            //ÇøÓòÐÔÇå¿Õ
                            SetDataGrid(grdMain, i, MainIDCol + 1, i, SubIDCol - 1, "");

                        }
                    }
                    else
                    {
                        HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value);
                        b = !b;
                        n++;
                    }
                }
                if (b)
                {
                    grdMain.Rows[i].DefaultCellStyle.BackColor = Color.Khaki;
                }
                else
                {
                    grdMain.Rows[i].DefaultCellStyle.BackColor = Color.Black;
                }
            }
        }


        //ÉèÖÃÍø¸ñ
        public static void SetDataGrid(DataGridView grdMain, int BRow, int BCol, int ERow, int ECol, string sText)
        {
            for (int i = BRow; i <= ERow; i++)
            {
                for (int j = BCol; j <= ECol; j++)
                {
                    grdMain.Rows[i].Cells[j].Value = DBNull.Value;
                }
            }

        }

        //ÉèÖÃÍø¸ñ
        public static void SetDataGrid_XB(DataGridView grdMain, int BRow, int BCol, int ERow, int ECol, string sText)
        {
            for (int i = BRow; i <= ERow; i++)
            {
                for (int j = BCol; j <= ECol; j++)
                {
                    grdMain.Rows[i].Cells[j].Value = DBNull.Value;
                }
            }

        }

        //»­Íø¸ñÏÂÏß
        /// <summary>
        /// »­Íø¸ñÏÂÏß
        /// </summary>
        /// <param name="grdMain"></param>
        public static void GraphicsGrid(DataGridView grdMain)
        {
            Graphics g = grdMain.CreateGraphics();
            Pen p = new Pen(Color.Black);
            p.Width = 1;
            int lWidth;
            if (grdMain.Rows.Count >= 100)//ÐÐÊý³¬¹ý100£¬¾ÍûÓбØÒª»­ÏßÁË
            {
                return;
            }
            if (grdMain.RowHeadersVisible)
                lWidth = grdMain.RowHeadersWidth;
            else
                lWidth = 0;
            //foreach (DataGridViewColumn col in grdMain.Columns)
            //{
            //    lWidth += col.Width;
            //}
            lWidth = 3000;
            int sWidth;
            if (grdMain.ColumnHeadersVisible)
                sWidth = grdMain.ColumnHeadersHeight;
            else
                sWidth = 0;
            foreach (DataGridViewRow col in grdMain.Rows)
            {
                sWidth += col.Height;
                if (col.Index == grdMain.RowCount - 1)
                {
                    g.DrawLine(p, new Point(0, sWidth), new Point(lWidth, sWidth));
                }
            }
        }


        //»­Íø¸ñºáÏß
        /// <summary>
        /// »­Íø¸ñºáÏß
        /// </summary>
        /// <param name="grdMain"></param>
        public static void GraphicsRowGrid(DataGridView grdMain, Int32 iBeginRow, Int32 iEndRow, Int32 MainIDCol)
        {
            Graphics g = grdMain.CreateGraphics();
            Pen p = new Pen(Color.Gainsboro);
            p.Width = 1;
            Int64 HMainID = 0;
            int lWidth;//³¤¶È
            lWidth = 3000;
            int sWidth; //¸ß¶È
            if (grdMain.ColumnHeadersVisible)//Èç¹ûÓбêÌâÁÐ ÔòÌí¼Ó±êÌâÁÐ Ðиß
                sWidth = grdMain.ColumnHeadersHeight;
            else
                sWidth = 0;
            //
            for (int i = iBeginRow; i < iEndRow; i++)
            {
                if (i + 1 <= grdMain.Rows.Count - 1)
                {
                    sWidth += grdMain.Rows[i].Height;
                }
                else
                {
                    return;
                }
                //¸Ä±ä±³¾°É«
                //grdMain.Rows[i].DefaultCellStyle.BackColor = Color.White;
                //
                if (HMainID == 0)
                {
                    HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value); 
                }
                if (HMainID == ClsPub.isLong(grdMain.Rows[i+1].Cells[MainIDCol].Value))
                {
                    //ÓëÏÂÒ»ÐÐÏàͬÔò²»»­Ïß
                }
                else
                {
                    //ÓëÏÂÒ»Ðв»Í¬Ôò»­Ïß
                    g.DrawLine(p, new Point(0, sWidth), new Point(lWidth, sWidth));
                    HMainID = ClsPub.isLong(grdMain.Rows[i+1].Cells[MainIDCol].Value);
                }
                
                
            }
        }

        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;
            //
            ClsPub.GetGridView(grdMain, Name,ClsPub.AppPath);//ÉèÖÃÁпí
        }


        public static void initGridMESList(DataGridView grdMain, string Name)
        {
            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 30;
            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.DefaultCellStyle.ForeColor = Color.Blue;
            //grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;//Íø¸ñÄÚÈÝ ¶ÔÆ뷽ʽ
            grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;  //±êÌâÁÐ ÄÚÈݶÔÆ뷽ʽ
            grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            grdMain.ReadOnly = true;
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //ÔÊÐíÓû§µ÷ÕûÁпí
            grdMain.EnableHeadersVisualStyles = true;     //Íø¸ñ±êÌâ Ñùʽ
            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;
            //
            ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);//ÉèÖÃÁпí
        }


        public static void initGridList(DataGridView grdMain, string Name, bool VisualStyles)
        {
            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 25;
            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 = VisualStyles;     //Íø¸ñ±êÌâ Ñùʽ
            grdMain.AllowUserToAddRows = false;             //ÊÇ·ñÔÊÐí×ÔÔö--·ñ
            grdMain.AllowUserToDeleteRows = false;          //ÊÇ·ñÔÊÐíɾ³ý--·ñ 
            grdMain.AllowUserToResizeColumns = true;         //ÔÊÐíµ÷ÕûÁпí--ÊÇ
            grdMain.AllowUserToResizeRows = false;           //ÔÊÐíµ÷ÕûÐиß--·ñ
            grdMain.AllowUserToOrderColumns = true;         //ÔÊÐí ÍÏקÁÐ
            grdMain.BackgroundColor = Color.White;
            grdMain.GridColor = Color.LightGray;             //Íø¸ñÏßÑÕÉ«
            grdMain.ShowCellToolTips = true;
            grdMain.CellBorderStyle = DataGridViewCellBorderStyle.RaisedVertical;
            grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightGray;
            //
            ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);//ÉèÖÃÁпí
        }

        public static void initGridRpt(DataGridView grdMain, string Name)
        {
            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 40;
            grdMain.RowHeadersVisible = false;
            grdMain.ColumnHeadersVisible = true;
            //¸ñʽ»¯
            //±í¸ñÉèÖÃ
            grdMain.RowsDefaultCellStyle.SelectionForeColor = Color.White;
            grdMain.RowsDefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionForeColor = Color.White;
            //grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            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.LightGray;             //Íø¸ñÏßÑÕÉ«
            grdMain.ShowCellToolTips = true;
            //grdMain.CellBorderStyle = DataGridViewCellBorderStyle.RaisedVertical;
            grdMain.AlternatingRowsDefaultCellStyle.BackColor = Color.Lavender;
            grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightGray;
            //
            if (grdMain.ColumnCount > 0 && grdMain.RowCount > 0)
            {
                ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);//ÉèÖÃÁпí
            }

        }

        public static void initGridRpt(DataGridView grdMain, string Name, bool VisualStyles)
        {
            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 40;
            grdMain.RowHeadersVisible = false;
            grdMain.ColumnHeadersVisible = true;
            //¸ñʽ»¯
            //±í¸ñÉèÖÃ
            grdMain.RowsDefaultCellStyle.SelectionForeColor = Color.White;
            grdMain.RowsDefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionForeColor = Color.White;
            //grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
            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.LightGray;             //Íø¸ñÏßÑÕÉ«
            grdMain.ShowCellToolTips = true;
            //grdMain.CellBorderStyle = DataGridViewCellBorderStyle.RaisedVertical;
            //grdMain.AlternatingRowsDefaultCellStyle.BackColor = Color.Lavender;
            grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightGray;
            //
            ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);//ÉèÖÃÁпí
        }

        //ÊͷŶ³½áÁÐ
        public static void CancelFrozenCol(DataGridView grdMain)
        {
            for (int i = 0; i < grdMain.ColumnCount; i++)
            {
                grdMain.Columns[i].Frozen = false;
            }
        }

        //ÉèÖà ±êÌâÁÐ ÐòºÅ
        /// <summary>
        /// ÉèÖà ±êÌâÁÐ ÐòºÅ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="b">ÊÇ·ñÓÐÐòºÅ</param>
        public static void SetColNo(DataGridView grdMain,bool b)
        {
            if (b)
            {
                grdMain.RowHeadersVisible = true;
                grdMain.RowHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
                grdMain.RowHeadersWidth = 50;
                grdMain.EnableHeadersVisualStyles = true;     //Íø¸ñ±êÌâ Ñùʽ
                for (int i = 0; i < grdMain.RowCount; i++)
                {
                    grdMain.Rows[i].HeaderCell.Value =Convert.ToString(i + 1);

                }
            }
            else
            {
                grdMain.RowHeadersVisible = false; 
            }
        }
        
        //ÏÔʾÁбí
        /// <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;//ÉèÖö³½áÁÐ
            }
            //ÉèÖÃ×ÖÌå´óС ¼°±êÌâÐиߣ¬ÄÚÈÝÐиß

            //
            ClsPub.GetGridView(grdMain, Name, ClsPub.AppPath);//ÉèÖÃÁпí
            ClsPub.HideGridView(grdMain, Name, ClsPub.AppPath);//¶ÁÈ¡Òþ²ØÁÐdatagridview  ²¢ÉèÖà ¶ÔÆ뷽ʽ
        }
       
              //ÏÔʾÁбí
        /// <summary>
        /// ÉèÖöÔÆ뷽ʽ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="Name"></param>
        public static void DisplayGridDuiQi(DataGridView grdMain, string Name)
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                DataSet DSet;
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    DSet = oCn.RunProcReturn("select * from Xt_grdField where HUserID='" + Pub_Class.ClsPub.CurUserName + "' and HBillName='" + Name + "' and HRow=" + i, "Xt_grdField");
                    if (DSet.Tables[0].Rows.Count != 0)
                    {
                        if (DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["hfiduiqi"]) == "×ó¶ÔÆë")
                        {
                            grdMain.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
                        }
                        else if (DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["hfiduiqi"]) == "ÓÒ¶ÔÆë")
                        {
                            grdMain.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                        }
                        else if (DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["hfiduiqi"]) == "¾ÓÖÐ")
                        {
                            grdMain.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
                        }
                        else
                        {
                            //
                        }
                    }
                }
            }
            catch (Exception e)
            {
                return;
            }
        }

        public static void SetCondition(frmBillQueryCondition_New frmCondition, string ViewName, string Name)
        {
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = Name;
        }

        //»ñÈ¡½ðµûµ¥¾ÝºÅ
        public static string get_MaxBillNo_K3(string HTranType, SQLHelper.ClsCNK3 oCnK3)
        {
            try
            {
                DataSet DS;
                DS = oCnK3.RunProcReturn("exec HX_GetICBillNo 1," + HTranType, "xt_xtgnb");
                if (DS == null || DS.Tables[0].Rows.Count == 0)
                {
                    return "";
                }
                else
                {
                    return DS.Tables[0].Rows[0][0].ToString();
                }
            }
            catch (Exception e)
            {
                return e.Message;
            }
        }

        //»ñÈ¡½ðµûµ¥¾ÝºÅ
        public static string get_MaxBillNo_K3(string HTranType, ref string sReturn)
        {
            SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3();
            try
            {
                DataSet DS;
                DS = oCnK3.RunProcReturn("exec HX_GetICBillNo 1," + HTranType, "xt_xtgnb");
                if (DS == null || DS.Tables[0].Rows.Count == 0)
                {
                    return "";
                }
                else
                {
                    return DS.Tables[0].Rows[0][0].ToString();
                }
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                return e.Message;
            }
        }

        //µÃµ½×î´óHINTERID K3
        public static Int64 CreateBillID_K3(string BillCode, ref string sReturn)
        {
            SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3();
            DataSet Ds1;
            long HInterID = 0;
            try
            {
                Ds1 = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNumOld  'ICStockBill',@InterID output select ltrim(@InterID)", "xt_xtgnb");
                if (Ds1.Tables[0].Rows.Count != 0)
                {
                    HInterID = DBUtility.ClsPub.isLong(Ds1.Tables[0].Rows[0][0]);
                    return HInterID;
                }
                else
                {
                    return 0;
                }
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                return 0;
            }
        }

        //ɾ³ýÐÐ
        public static void Sub_DelRowDH(DataGridView ogrdMain)
        {
            int Scqwghz; //Ô­Ñ¡ÖÐÐÐ
            int Scqwglz; //Ô­Ñ¡ÖÐÁÐ
            //ogrdMain.CurrentRow.DefaultCellStyle.BackColor = Color.Red;
            if (MessageBox.Show("È·¶¨ÒªÉ¾³ýµ±Ç°¼Ç¼£¿", "Ìáʾ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
            {

                //ogrdMain.CurrentRow.DefaultCellStyle.BackColor = Color.White;
                Changelock = true;
                Changelock = false;
                return;
            }
            int j = ogrdMain.SelectedRows.Count;
            //
            for (int i = 0; i < j; i++)
            {
                Scqwghz = ogrdMain.SelectedRows[j - i - 1].Index;
                Scqwglz = ogrdMain.SelectedCells[i].ColumnIndex;

                //Scqwghz = ogrdMain.CurrentRow.Index;
                //Scqwglz = ogrdMain.CurrentCell.ColumnIndex;
                DisplayCurRow(ogrdMain);
                Changelock = true;
                Changelock = false;
                ogrdMain.Rows.RemoveAt(Scqwghz);
                ogrdMain.Rows.Add();
                Changelock = true;
                Changelock = false;
                RefreshNoCol(ogrdMain);
                EditStatus = false;
            }
        }
        //¼ÆËãÓû§¿ÉÓÃÐÐ
        public static Int64 CountNullRows(DataGridView ogrdMain)
        {
            Int32 r;
            Int32 lngRows;
            lngRows = 0;
            for (r = 0; r < ogrdMain.RowCount; r++)
            {
                if (ClsPub.isStrNull(ogrdMain.Rows[r].Cells[0].Value) != "*")
                    lngRows = lngRows + 1;
            }
            return lngRows;
        }

        //ÏÔʾµ±Ç°ÐÐ
        public static void DisplayCurRow(DataGridView ogrdMain)
        {
            Int64 Toprowte;
            if (CountNullRows(ogrdMain) < 20)
                ogrdMain.Rows.Add();
            Toprowte = 0;
        }

        //Ë¢ÐÂÐкÅ
        public static void RefreshNoCol(DataGridView ogrdMain)
        {
            int i, m;
            i = 0;
            m = 0;
            for (i = 0; i < ogrdMain.RowCount; i++)
            {
                m = m + 1;
                ogrdMain.Rows[i].Cells[NoCol].Value = m.ToString().Trim();
            }
            ogrdMain.Columns[NoCol].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
        }

        //ÐÂÔö×ֶΠ·µ»Ø×Ö¶ÎÃû
        public static void Fun_AddField(string FieldName, string Type, string FieldHLength, SQLHelper.ClsCN oCn)
        {
            try
            {
                oCn.RunProc("exec h_p_Gy_DuSubsidyItemAddField  " + FieldName + "," + Type + "," + FieldHLength, ref DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            catch (Exception e)
            { 
                throw (e);
            }
        }

        public static void Sub_GetSelfInsertSQL(ref string sSQL,string sDataType,object oValue)
        {
            switch (sDataType)
            {
                case "×Ö·û":
                    sSQL = sSQL + ",'" + DBUtility.ClsPub.isStrNull(oValue) + "'";
                    break;
                case "ʵÊý":
                    sSQL = sSQL + "," + DBUtility.ClsPub.isDoule(oValue,4) + "";
                    break;
                case "½ð¶î":
                    sSQL = sSQL + "," + DBUtility.ClsPub.isDoule(oValue, 4) + "";
                    break;
                case "Âß¼­":
                    sSQL = sSQL + "," + DBUtility.ClsPub.BoolToString(oValue) + "";
                    break;
                case "ÈÕÆÚ":
                    sSQL = sSQL + ",'" + DBUtility.ClsPub.isDate(oValue).ToShortDateString() + "'";
                    break;
                case "ÕûÊý":
                    sSQL = sSQL + "," + DBUtility.ClsPub.isLong(oValue).ToString() + "";
                    break;
                default:
                    sSQL = sSQL + ",'" + DBUtility.ClsPub.isStrNull(oValue) + "'";
                    break;
            }

        }



        public static void initKanBan(string HName, DataGridView grdMain, ToolStrip Ts, ToolStripLabel lbl, SplitterPanel Sp, ref int FY, Timer timer2, Timer timer3)
        {
            string TitleCaption = ClsIni.ReadIni(HName, "Title-Caption", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleForeColor = ClsIni.ReadIni(HName, "Title-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleFontFamily = ClsIni.ReadIni(HName, "Title-FontFamily", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleFontSize = ClsIni.ReadIni(HName, "Title-FontSize", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleFontStyle = ClsIni.ReadIni(HName, "Title-FontStyle", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleBackColor = ClsIni.ReadIni(HName, "Title-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitlePageRows = ClsIni.ReadIni(HName, "Title-PageRows", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitlePageDownTimer = ClsIni.ReadIni(HName, "Title-PageDownTimer", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleDisplayTimer = ClsIni.ReadIni(HName, "Title-DisplayTimer", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            if (TitleCaption != "" && TitleCaption != "ûÓÐÕÒµ½£¡")
            {
                lbl.Text = TitleCaption;
            }
            if (TitlePageRows != "" && TitlePageRows != "ûÓÐÕÒµ½£¡")
            {
                FY = ClsPub.isInt(TitlePageRows);
            }
            if (TitlePageDownTimer != "" && TitlePageDownTimer != "ûÓÐÕÒµ½£¡")
            {
                timer2.Interval = ClsPub.isInt(TitlePageDownTimer) * 1000;
            }
            if (TitleDisplayTimer != "" && TitleDisplayTimer != "ûÓÐÕÒµ½£¡")
            {
                timer3.Interval = ClsPub.isInt(TitleDisplayTimer) * 1000;
            }
            if (TitleForeColor != "" && TitleForeColor != "ûÓÐÕÒµ½£¡")
            {
                for (int i = 0; i < Ts.Items.Count; i++)
                {
                    Ts.Items[i].ForeColor = System.Drawing.ColorTranslator.FromHtml(TitleForeColor);
                }
                if (Sp != null)
                {
                    foreach (Control ct in Sp.Controls)
                    {
                        switch (ct.GetType().Name)
                        {
                            //case "ListBox":
                            //    ((ListBox)ct).Items.Clear();
                            //    break;
                            //case "CheckBox":
                            //    ((CheckBox)ct).Checked = false;
                            //    break;
                            //case "RadioButton":

                            //    break;
                            //case "TextBox":
                            //    ((TextBox)ct).ForeColor = System.Drawing.ColorTranslator.FromHtml(TitleForeColor);
                            //    break;
                            //case "DateTimePicker":
                            //    ((DateTimePicker)ct).Value = DateTime.Today;
                            //    break;
                            case "Label":
                                ((Label)ct).ForeColor = System.Drawing.ColorTranslator.FromHtml(TitleForeColor);
                                break;
                            default:
                                break;
                        }
                    }
                }
            }

            if (TitleBackColor != "" && TitleBackColor != "ûÓÐÕÒµ½£¡")
            {
                Ts.BackColor = System.Drawing.ColorTranslator.FromHtml(TitleBackColor);
                if (Sp != null)
                {
                    Sp.BackColor = System.Drawing.ColorTranslator.FromHtml(TitleBackColor);
                }
            }
            if (TitleFontStyle != "" && TitleFontStyle != "ûÓÐÕÒµ½£¡")
            {
                if (TitleFontStyle.Contains("Bold"))
                {
                    lbl.Font = new Font(TitleFontFamily, DBUtility.ClsPub.isSingle(TitleFontSize), FontStyle.Bold);
                }
                else
                {
                    lbl.Font = new Font(TitleFontFamily, DBUtility.ClsPub.isSingle(TitleFontSize));
                }
            }


            string HeaderForeColor = ClsIni.ReadIni(HName, "Header-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderFontFamily = ClsIni.ReadIni(HName, "Header-FontFamily", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderFontSize = ClsIni.ReadIni(HName, "Header-FontSize", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderFontStyle = ClsIni.ReadIni(HName, "Header-FontStyle", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderBackColor = ClsIni.ReadIni(HName, "Header-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderAlignment = ClsIni.ReadIni(HName, "Header-Alignment", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderRowHeight = ClsIni.ReadIni(HName, "Header-RowHeight", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            if (HeaderRowHeight != "" && HeaderRowHeight != "ûÓÐÕÒµ½£¡")
            {
                grdMain.ColumnHeadersHeight = DBUtility.ClsPub.isInt(HeaderRowHeight);
            }
            if (HeaderForeColor != "" && HeaderForeColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.ColumnHeadersDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml(HeaderForeColor);
                grdMain.ColumnHeadersDefaultCellStyle.SelectionForeColor = System.Drawing.ColorTranslator.FromHtml(HeaderForeColor);
            }
            if (HeaderBackColor != "" && HeaderBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.ColumnHeadersDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml(HeaderBackColor);
                grdMain.ColumnHeadersDefaultCellStyle.SelectionBackColor = System.Drawing.ColorTranslator.FromHtml(HeaderBackColor);
            }
            if (HeaderFontStyle != "" && HeaderFontStyle != "ûÓÐÕÒµ½£¡")
            {
                if (HeaderFontStyle.Contains("Bold"))
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Font = new Font(HeaderFontFamily, DBUtility.ClsPub.isSingle(HeaderFontSize), FontStyle.Bold);
                }
                else
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Font = new Font(HeaderFontFamily, DBUtility.ClsPub.isSingle(HeaderFontSize));
                }
            }
            if (HeaderAlignment != "" && HeaderAlignment != "ûÓÐÕÒµ½£¡")
            {
                if (HeaderAlignment == "×ó¶ÔÆë")
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
                }
                if (HeaderAlignment == "ÓÒ¶ÔÆë")
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                }
                if (HeaderAlignment == "¾ÓÖÐ")
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
                }
            }

            string CellForeColor = ClsIni.ReadIni(HName, "Cell-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellForeColor2 = ClsIni.ReadIni(HName, "Cell-ForeColor2", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellFontFamily = ClsIni.ReadIni(HName, "Cell-FontFamily", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellFontSize = ClsIni.ReadIni(HName, "Cell-FontSize", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellFontStyle = ClsIni.ReadIni(HName, "Cell-FontStyle", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellBackColor = ClsIni.ReadIni(HName, "Cell-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellAlignment = ClsIni.ReadIni(HName, "Cell-Alignment", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellRowHeight = ClsIni.ReadIni(HName, "Cell-RowHeight", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellAlternatingBackColor = ClsIni.ReadIni(HName, "Cell-AlternatingBackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellDefaultBackColor = ClsIni.ReadIni(HName, "Cell-DefaultBackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            if (CellRowHeight != "" && CellRowHeight != "ûÓÐÕÒµ½£¡")
            {
                grdMain.RowTemplate.Height = DBUtility.ClsPub.isInt(CellRowHeight);
            }
            if (CellForeColor != "" && CellForeColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.RowsDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml(CellForeColor);
            }
            if (CellForeColor2 != "" && CellForeColor2 != "ûÓÐÕÒµ½£¡")
            {
                grdMain.AlternatingRowsDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml(CellForeColor2);
            }
            if (CellBackColor != "" && CellBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.BackgroundColor = System.Drawing.ColorTranslator.FromHtml(CellBackColor);
            }
            if (CellFontStyle != "" && CellFontStyle != "ûÓÐÕÒµ½£¡")
            {
                if (CellFontStyle.Contains("Bold"))
                {
                    grdMain.RowsDefaultCellStyle.Font = new Font(CellFontFamily, DBUtility.ClsPub.isSingle(CellFontSize), FontStyle.Bold);
                }
                else
                {
                    grdMain.RowsDefaultCellStyle.Font = new Font(CellFontFamily, DBUtility.ClsPub.isSingle(CellFontSize));
                }
            }
            if (CellAlignment != "" && CellAlignment != "ûÓÐÕÒµ½£¡")
            {
                if (CellAlignment == "×ó¶ÔÆë")
                {
                    grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
                }
                if (CellAlignment == "ÓÒ¶ÔÆë")
                {
                    grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                }
                if (CellAlignment == "¾ÓÖÐ")
                {
                    grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
                }
            }
            if (CellAlternatingBackColor != "" && CellAlternatingBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.AlternatingRowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml(CellAlternatingBackColor);
                grdMain.AlternatingRowsDefaultCellStyle.SelectionBackColor = System.Drawing.ColorTranslator.FromHtml(CellAlternatingBackColor);
            }
            if (CellDefaultBackColor != "" && CellDefaultBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.RowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml(CellDefaultBackColor);
                grdMain.RowsDefaultCellStyle.SelectionBackColor = System.Drawing.ColorTranslator.FromHtml(CellDefaultBackColor);
            }
            //ÁбêÌâ±ß¿òÑùʽ
            grdMain.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; ;
            //±êÌâÑùʽÊÇ·ñʹÓÃÓû§µ±Ç°Ö÷ÌâµÄÑùʽ
            grdMain.EnableHeadersVisualStyles = false;
            //Òþ²ØÐбêÌâ
            grdMain.RowHeadersVisible = false;
            //¸ù¾ÝÄÚÈÝ×Ô¶¯µ÷Õû±êÌâ¸ß¶È
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
        }


        //¿´°å×Ô¶¨ÒåÑÕÉ«£ºHName Ä£¿éÃû£¬grdMain Íø¸ñ£¬Ts ±êÌâ°´Å¥£¬lbl ¿´°å±êÌ⣬Sp ҳü£¬Sp2 Ò³½Å£¬FY ¹ö¶¯ÐÐÊý£¬timer2 ¹ö¶¯¼ä¸ô£¬timer3 ˢмä¸ô
        public static void initKanBan(string HName, DataGridView grdMain, ToolStrip Ts, ToolStripLabel lbl, SplitterPanel Sp, SplitterPanel Sp2, ref int FY, Timer timer2, Timer timer3)
        {
            string TitleCaption = ClsIni.ReadIni(HName, "Title-Caption", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleForeColor = ClsIni.ReadIni(HName, "Title-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleFontFamily = ClsIni.ReadIni(HName, "Title-FontFamily", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleFontSize = ClsIni.ReadIni(HName, "Title-FontSize", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleFontStyle = ClsIni.ReadIni(HName, "Title-FontStyle", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleBackColor = ClsIni.ReadIni(HName, "Title-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitlePageRows = ClsIni.ReadIni(HName, "Title-PageRows", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitlePageDownTimer = ClsIni.ReadIni(HName, "Title-PageDownTimer", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string TitleDisplayTimer = ClsIni.ReadIni(HName, "Title-DisplayTimer", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            if (TitleCaption != "" && TitleCaption != "ûÓÐÕÒµ½£¡")
            {
                lbl.Text = TitleCaption;
            }
            if (TitlePageRows != "" && TitlePageRows != "ûÓÐÕÒµ½£¡")
            {
                FY = ClsPub.isInt(TitlePageRows);
            }
            if (TitlePageDownTimer != "" && TitlePageDownTimer != "ûÓÐÕÒµ½£¡")
            {
                timer2.Interval = ClsPub.isInt(TitlePageDownTimer) * 1000;
            }
            if (TitleDisplayTimer != "" && TitleDisplayTimer != "ûÓÐÕÒµ½£¡")
            {
                timer3.Interval = ClsPub.isInt(TitleDisplayTimer) * 1000;
            }
            if (TitleForeColor != "" && TitleForeColor != "ûÓÐÕÒµ½£¡")
            {
                for (int i = 0; i < Ts.Items.Count; i++)
                {
                    Ts.Items[i].ForeColor = System.Drawing.ColorTranslator.FromHtml(TitleForeColor);
                }
            }

            if (TitleBackColor != "" && TitleBackColor != "ûÓÐÕÒµ½£¡")
            {
                Ts.BackColor = System.Drawing.ColorTranslator.FromHtml(TitleBackColor);
            }
            if (TitleFontStyle != "" && TitleFontStyle != "ûÓÐÕÒµ½£¡")
            {
                if (TitleFontStyle.Contains("Bold"))
                {
                    lbl.Font = new Font(TitleFontFamily, DBUtility.ClsPub.isSingle(TitleFontSize), FontStyle.Bold);
                }
                else
                {
                    lbl.Font = new Font(TitleFontFamily, DBUtility.ClsPub.isSingle(TitleFontSize));
                }
            }


            string HeaderForeColor = ClsIni.ReadIni(HName, "Header-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderFontFamily = ClsIni.ReadIni(HName, "Header-FontFamily", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderFontSize = ClsIni.ReadIni(HName, "Header-FontSize", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderFontStyle = ClsIni.ReadIni(HName, "Header-FontStyle", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderBackColor = ClsIni.ReadIni(HName, "Header-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderAlignment = ClsIni.ReadIni(HName, "Header-Alignment", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string HeaderRowHeight = ClsIni.ReadIni(HName, "Header-RowHeight", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            if (HeaderRowHeight != "" && HeaderRowHeight != "ûÓÐÕÒµ½£¡")
            {
                grdMain.ColumnHeadersHeight = DBUtility.ClsPub.isInt(HeaderRowHeight);
            }
            if (HeaderForeColor != "" && HeaderForeColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.ColumnHeadersDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml(HeaderForeColor);
                grdMain.ColumnHeadersDefaultCellStyle.SelectionForeColor = System.Drawing.ColorTranslator.FromHtml(HeaderForeColor);
            }
            if (HeaderBackColor != "" && HeaderBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.ColumnHeadersDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml(HeaderBackColor);
                grdMain.ColumnHeadersDefaultCellStyle.SelectionBackColor = System.Drawing.ColorTranslator.FromHtml(HeaderBackColor);
            }
            if (HeaderFontStyle != "" && HeaderFontStyle != "ûÓÐÕÒµ½£¡")
            {
                if (HeaderFontStyle.Contains("Bold"))
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Font = new Font(HeaderFontFamily, DBUtility.ClsPub.isSingle(HeaderFontSize), FontStyle.Bold);
                }
                else
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Font = new Font(HeaderFontFamily, DBUtility.ClsPub.isSingle(HeaderFontSize));
                }
            }
            if (HeaderAlignment != "" && HeaderAlignment != "ûÓÐÕÒµ½£¡")
            {
                if (HeaderAlignment == "×ó¶ÔÆë")
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
                }
                if (HeaderAlignment == "ÓÒ¶ÔÆë")
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                }
                if (HeaderAlignment == "¾ÓÖÐ")
                {
                    grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
                }
            }

            string CellForeColor = ClsIni.ReadIni(HName, "Cell-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellFontFamily = ClsIni.ReadIni(HName, "Cell-FontFamily", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellFontSize = ClsIni.ReadIni(HName, "Cell-FontSize", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellFontStyle = ClsIni.ReadIni(HName, "Cell-FontStyle", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellBackColor = ClsIni.ReadIni(HName, "Cell-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellAlignment = ClsIni.ReadIni(HName, "Cell-Alignment", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellRowHeight = ClsIni.ReadIni(HName, "Cell-RowHeight", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellAlternatingBackColor = ClsIni.ReadIni(HName, "Cell-AlternatingBackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string CellDefaultBackColor = ClsIni.ReadIni(HName, "Cell-DefaultBackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            if (CellRowHeight != "" && CellRowHeight != "ûÓÐÕÒµ½£¡")
            {
                grdMain.RowTemplate.Height = DBUtility.ClsPub.isInt(CellRowHeight);
            }
            if (CellForeColor != "" && CellForeColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.RowsDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml(CellForeColor);
            }
            if (CellBackColor != "" && CellBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.BackgroundColor = System.Drawing.ColorTranslator.FromHtml(CellBackColor);
            }
            if (CellFontStyle != "" && CellFontStyle != "ûÓÐÕÒµ½£¡")
            {
                if (CellFontStyle.Contains("Bold"))
                {
                    grdMain.RowsDefaultCellStyle.Font = new Font(CellFontFamily, DBUtility.ClsPub.isSingle(CellFontSize), FontStyle.Bold);
                }
                else
                {
                    grdMain.RowsDefaultCellStyle.Font = new Font(CellFontFamily, DBUtility.ClsPub.isSingle(CellFontSize));
                }
            }
            if (CellAlignment != "" && CellAlignment != "ûÓÐÕÒµ½£¡")
            {
                if (CellAlignment == "×ó¶ÔÆë")
                {
                    grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
                }
                if (CellAlignment == "ÓÒ¶ÔÆë")
                {
                    grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                }
                if (CellAlignment == "¾ÓÖÐ")
                {
                    grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
                }
            }
            if (CellAlternatingBackColor != "" && CellAlternatingBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.AlternatingRowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml(CellAlternatingBackColor);
                grdMain.AlternatingRowsDefaultCellStyle.SelectionBackColor = System.Drawing.ColorTranslator.FromHtml(CellAlternatingBackColor);
            }
            if (CellDefaultBackColor != "" && CellDefaultBackColor != "ûÓÐÕÒµ½£¡")
            {
                grdMain.RowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml(CellDefaultBackColor);
                grdMain.RowsDefaultCellStyle.SelectionBackColor = System.Drawing.ColorTranslator.FromHtml(CellDefaultBackColor);
            }
            //ҳü£¬Ò³½Å

            string YeMeiForeColor = ClsIni.ReadIni(HName, "YeMei-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string YeMeiBackColor = ClsIni.ReadIni(HName, "YeMei-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string FooterForeColor = ClsIni.ReadIni(HName, "Footer-ForeColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");
            string FooterBackColor = ClsIni.ReadIni(HName, "Footer-BackColor", DBUtility.ClsPub.AppPath + @"/KanbanInfo.ini");

            if (YeMeiForeColor != "" && YeMeiForeColor != "ûÓÐÕÒµ½£¡")
            {
                if (Sp != null)
                {
                    foreach (Control ct in Sp.Controls)
                    {
                        switch (ct.GetType().Name)
                        {
                            case "Label":
                                ((Label)ct).ForeColor = System.Drawing.ColorTranslator.FromHtml(YeMeiForeColor);
                                break;
                            default:
                                break;
                        }
                    }
                }
            }

            if (YeMeiBackColor != "" && YeMeiBackColor != "ûÓÐÕÒµ½£¡")
            {
                if (Sp != null)
                {
                    Sp.BackColor = System.Drawing.ColorTranslator.FromHtml(YeMeiBackColor);
                }
            }

            if (FooterForeColor != "" && FooterForeColor != "ûÓÐÕÒµ½£¡")
            {
                if (Sp2 != null)
                {
                    foreach (Control ct in Sp2.Controls)
                    {
                        switch (ct.GetType().Name)
                        {
                            case "Label":
                                ((Label)ct).ForeColor = System.Drawing.ColorTranslator.FromHtml(FooterForeColor);
                                break;
                            default:
                                break;
                        }
                    }
                }
            }

            if (FooterBackColor != "" && FooterBackColor != "ûÓÐÕÒµ½£¡")
            {
                if (Sp2 != null)
                {
                    Sp2.BackColor = System.Drawing.ColorTranslator.FromHtml(FooterBackColor);
                }
            }
            //ÁбêÌâ±ß¿òÑùʽ
            grdMain.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; ;
            //±êÌâÑùʽÊÇ·ñʹÓÃÓû§µ±Ç°Ö÷ÌâµÄÑùʽ
            grdMain.EnableHeadersVisualStyles = false;
            //Òþ²ØÐбêÌâ
            grdMain.RowHeadersVisible = false;
            //¸ù¾ÝÄÚÈÝ×Ô¶¯µ÷Õû±êÌâ¸ß¶È
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
        }

        //ÉèÖÃÍø¸ñÄÚÈÝ£¨×Ô¶¨ÒåÁУ©
        public static void Sub_SetSelfValueToGrid(DataGridView grdMain,int iRow,int iCol,string sType,object oValue)
        {
            switch (sType)
            {
                case "×Ö·û":
                    grdMain.Rows[iRow].Cells[iCol].Value=DBUtility.ClsPub.isStrNull(oValue);
                    break;
                case "ʵÊý":
                    grdMain.Rows[iRow].Cells[iCol].Value=DBUtility.ClsPub.isDoule(oValue);
                    break;
                case "½ð¶î":
                    grdMain.Rows[iRow].Cells[iCol].Value=DBUtility.ClsPub.isSingle(oValue);
                    break;
                case "Âß¼­":
                    grdMain.Rows[iRow].Cells[iCol].Value=DBUtility.ClsPub.isBool(oValue);
                    break;
                case "ÈÕÆÚ":
                    grdMain.Rows[iRow].Cells[iCol].Value=DBUtility.ClsPub.isDate(oValue);
                    break;
                case "ÕûÊý":
                    grdMain.Rows[iRow].Cells[iCol].Value=DBUtility.ClsPub.isLong(oValue);
                    break;
                default:
                    grdMain.Rows[iRow].Cells[iCol].Value = DBUtility.ClsPub.isStrNull(oValue);
                    break;
            }

        }


        
    }
}