/// <summary>
        /// ���£������룩
        /// </summary>
        /// <param name="����ϵͳ"></param>
        public static void UpDate����ϵͳ(Def_����ϵͳ ����ϵͳ)
        {
            string InsertSQL =
              "UPDATE [New����ϵͳ] " +
            "   SET " +
            "      [��ѹ��]     =            		    '" + ����ϵͳ.B��ѹ��.ToString().Replace("'", "''") + "'" +
            "      ,[��ѹ��λ��]     =        		        '" + ����ϵͳ.B��ѹ��λ��.ToString().Replace("'", "''") + "'" +
            "      ,[�������]     =          		      '" + ����ϵͳ.B�������.ToString().Replace("'", "''") + "'" +
            "      ,[�����]     =          		      '" + ����ϵͳ.B�����.ToString().Replace("'", "''") + "'" +
            "      ,[�����µ�����ֵ]     =    		            '" + ����ϵͳ.B�����µ�����ֵ.ToString().Replace("'", "''") + "'" +
            "      ,[���ص���]     =          		      '" + ����ϵͳ.B���ص���.ToString().Replace("'", "''") + "'" +
            "      ,[��ѹ��·����]     =      		          '" + ����ϵͳ.B��ѹ��·����.ToString().Replace("'", "''") + "'" +
            "      ,[���緽ʽ]     =          		      '" + ����ϵͳ.B���緽ʽ.ToString().Replace("'", "''") + "'" +
            "      ,[������λ��]     =        		        '" + ����ϵͳ.B������λ��.ToString().Replace("'", "''") + "'" +
            "      ,[�����������]     =      		          '" + ����ϵͳ.B�����������.ToString().Replace("'", "''") + "'" +
            "      ,[���ص�Դ��]     =        		        '" + ����ϵͳ.B���ص�Դ��.ToString().Replace("'", "''") + "'" +
            "      ,[����ģ����]     =        		        '" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "'" +
            "      ,[����ģ����]     =        		        '" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "'" +
            "      ,[�տ������]     =      		          '" + ����ϵͳ.B�տ������.ToString().Replace("'", "''") + "'" +
            "      ,[��ӿ����]     =          		      '" + ����ϵͳ.B��ӿ����.ToString().Replace("'", "''") + "'" +
            "      ,[��ӿ�ͺ�]     =          		      '" + ����ϵͳ.B��ӿ�ͺ�.ToString().Replace("'", "''") + "'" +
            "      ,[��ͷ��ͷλ��]     =      		          '" + ����ϵͳ.B��ͷ��ͷλ��.ToString().Replace("'", "''") + "'" +
            "      ,[ģ���ͺ�]     =          		      '" + ����ϵͳ.Bģ���ͺ�.ToString().Replace("'", "''") + "'" +
            "      ,[�ܷ񷢵�]     =          		      '" + ����ϵͳ.B�ܷ񷢵�.ToString().Replace("'", "''") + "'" +
            "      ,[�豸]     =              		  '" + ����ϵͳ.B�豸.ToString().Replace("'", "''") + "'" +
            "      ,[�豸����1]     =         		       '" + ����ϵͳ.B�豸����1.ToString().Replace("'", "''") + "'" +
            "      ,[�豸����2]     =         		       '" + ����ϵͳ.B�豸����2.ToString().Replace("'", "''") + "'" +
            "      ,[�豸����3]     =         		       '" + ����ϵͳ.B�豸����3.ToString().Replace("'", "''") + "'" +
            "      ,[�豸λ��1]     =         		       '" + ����ϵͳ.B�豸λ��1.ToString().Replace("'", "''") + "'" +
            "      ,[�豸λ��2]     =         		       '" + ����ϵͳ.B�豸λ��2.ToString().Replace("'", "''") + "'" +
            "      ,[�豸λ��3]     =         		       '" + ����ϵͳ.B�豸λ��3.ToString().Replace("'", "''") + "'" +
            "      ,[�豸�ͺ�1]     =         		       '" + ����ϵͳ.B�豸�ͺ�1.ToString().Replace("'", "''") + "'" +
            "      ,[�豸�ͺ�2]     =         		       '" + ����ϵͳ.B�豸�ͺ�2.ToString().Replace("'", "''") + "'" +
            "      ,[�豸�ͺ�3]     =         		       '" + ����ϵͳ.B�豸�ͺ�3.ToString().Replace("'", "''") + "'" +
            "      ,[ʹ�ÿտ���]     =        		        '" + ����ϵͳ.Bʹ�ÿտ���.ToString().Replace("'", "''") + "'" +
            "      ,[�Ƿ�������ӿ]     =      		          '" + ����ϵͳ.B�Ƿ�������ӿ.ToString().Replace("'", "''") + "'" +
            "      ,[�Ƿ�����ͷ��ͷ]     =    		            '" + ����ϵͳ.B�Ƿ�����ͷ��ͷ.ToString().Replace("'", "''") + "'" +
            "      ,[���пտ���]     =        		        '" + ����ϵͳ.B���пտ���.ToString().Replace("'", "''") + "'" +
            "      ,[����]     =            		    '" + ����ϵͳ.B����.ToString().Replace("'", "''") + "'" +
            "      ,[����ʹ�����]     =    		            '" + ����ϵͳ.B����ʹ�����.ToString().Replace("'", "''") + "'" +
            "      ,[һ���µ�����ֵ]     =                      '" + ����ϵͳ.Bһ���µ�����ֵ.ToString().Replace("'", "''") + "'" +

            " WHERE [basedateID] ='" + ����ϵͳ.BasedateID.ToString().Replace("'", "''") + "'";

            string UpDateSQL =
            "INSERT INTO [New����ϵͳ] " +
            "           ([basedateID] " +
            "           ,[��ѹ��] " +
            "           ,[��ѹ��λ��] " +
            "           ,[�������] " +
            "           ,[�����] " +
            "           ,[�����µ�����ֵ] " +
            "           ,[���ص���] " +
            "           ,[��ѹ��·����] " +
            "           ,[���緽ʽ] " +
            "           ,[�������] " +
            "           ,[�����������] " +
            "           ,[���ص�Դ��] " +
            "           ,[����ģ����] " +
            "           ,[����ģ����] " +
            "           ,[�տ������] " +
            "           ,[��ӿ����] " +
            "           ,[��ӿ�ͺ�] " +
            "           ,[��ͷ��ͷλ��] " +
            "           ,[ģ���ͺ�] " +
            "           ,[�ܷ񷢵�] " +
            "           ,[�豸] " +
            "           ,[�豸����1] " +
            "           ,[�豸����2] " +
            "           ,[�豸����3] " +
            "           ,[�豸λ��1] " +
            "           ,[�豸λ��2] " +
            "           ,[�豸λ��3] " +
            "           ,[�豸�ͺ�1] " +
            "           ,[�豸�ͺ�2] " +
            "           ,[�豸�ͺ�3] " +
            "           ,[ʹ�ÿտ���] " +
            "           ,[�Ƿ�������ӿ] " +
            "           ,[�Ƿ�����ͷ��ͷ] " +
            "           ,[���пտ���] " +
            "           ,[����] " +
            "           ,[����ʹ�����] " +
            "           ,[һ���µ�����ֵ]) " +
            "     VALUES " +
            " ('" + ����ϵͳ.BasedateID.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ѹ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ѹ��λ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�������.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�����µ�����ֵ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���ص���.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ѹ��·����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���緽ʽ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B������λ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�����������.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���ص�Դ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�տ������.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ӿ����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ӿ�ͺ�.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ͷ��ͷλ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.Bģ���ͺ�.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�ܷ񷢵�.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸����1.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸����2.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸����3.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸λ��1.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸λ��2.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸λ��3.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸�ͺ�1.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸�ͺ�2.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸�ͺ�3.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.Bʹ�ÿտ���.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�Ƿ�������ӿ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�Ƿ�����ͷ��ͷ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���пտ���.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����ʹ�����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.Bһ���µ�����ֵ.ToString().Replace("'", "''") + "') ";

            string strSQL = null;
            strSQL += InsertSQL;//= string.Format("Update S_RoleDetail set [Power]='{0}'  where [RoleID]='{1}' and ProgramID  ='{2}'", dt.Rows[i][1].ToString().Replace("'", "''"), dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"));
            strSQL = strSQL + " if @@RowCount=0 ";
            strSQL = strSQL + UpDateSQL;//string.Format("Insert into S_RoleDetail ([RoleID],[ProgramID],[Power]) values ('{0}','{1}','{2}')", dt.Rows[0][2].ToString().Replace("'", "''"), dt.Rows[i][0].ToString().Replace("'", "''"), dt.Rows[i][1].ToString().Replace("'", "''"));

            SQLExecute.ExecuteNonQuery(strSQL);
        }
        /// <summary>
        /// ���
        /// </summary>
        /// <param name="����ϵͳ"></param>
        public static void Insert����ϵͳ(Def_����ϵͳ ����ϵͳ)
        {
            string sql =
            "INSERT INTO [New����ϵͳ] " +
            "           ([basedateID] " +
            "           ,[��ѹ��] " +
            "           ,[��ѹ��λ��] " +
            "           ,[�������] " +
            "           ,[�����] " +
            "           ,[�����µ�����ֵ] " +
            "           ,[���ص���] " +
            "           ,[��ѹ��·����] " +
            "           ,[���緽ʽ] " +
            "           ,[�������] " +
            "           ,[�����������] " +
            "           ,[���ص�Դ��] " +
            "           ,[����ģ����] " +
            "           ,[����ģ����] " +
            "           ,[�տ������] " +
            "           ,[��ӿ����] " +
            "           ,[��ӿ�ͺ�] " +
            "           ,[��ͷ��ͷλ��] " +
            "           ,[ģ���ͺ�] " +
            "           ,[�ܷ񷢵�] " +
            "           ,[�豸] " +
            "           ,[�豸����1] " +
            "           ,[�豸����2] " +
            "           ,[�豸����3] " +
            "           ,[�豸λ��1] " +
            "           ,[�豸λ��2] " +
            "           ,[�豸λ��3] " +
            "           ,[�豸�ͺ�1] " +
            "           ,[�豸�ͺ�2] " +
            "           ,[�豸�ͺ�3] " +
            "           ,[ʹ�ÿտ���] " +
            "           ,[�Ƿ�������ӿ] " +
            "           ,[�Ƿ�����ͷ��ͷ] " +
            "           ,[���пտ���] " +
            "           ,[����] " +
            "           ,[����ʹ�����] " +
            "           ,[һ���µ�����ֵ]) " +
            "     VALUES " +
            " ('" + ����ϵͳ.BasedateID.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ѹ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ѹ��λ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�������.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�����µ�����ֵ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���ص���.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ѹ��·����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���緽ʽ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B������λ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�����������.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���ص�Դ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����ģ����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�տ������.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ӿ����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ӿ�ͺ�.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B��ͷ��ͷλ��.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.Bģ���ͺ�.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�ܷ񷢵�.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸����1.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸����2.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸����3.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸λ��1.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸λ��2.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸λ��3.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸�ͺ�1.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸�ͺ�2.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�豸�ͺ�3.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.Bʹ�ÿտ���.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�Ƿ�������ӿ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B�Ƿ�����ͷ��ͷ.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B���пտ���.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.B����ʹ�����.ToString().Replace("'", "''") + "' " +
            ",'" + ����ϵͳ.Bһ���µ�����ֵ.ToString().Replace("'", "''") + "') ";

            SQLExecute.ExecuteNonQuery(sql);
        }