资源简介

Dexpress gridcontrol控件分页,大家一起学习,可能不是很好。用户控件封装的。

资源截图

代码片段和文件信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using IWCFCommunicate;

namespace DataAcess
{
    public  class DataServerCommuication
    {
        /// 
        /// 查询数据
        /// 

        /// sql语句
        /// 返回的表数据
        /// 
        /// 返回值,0成功-1失败
        private int GetData(string sql out DataTable dt out string errorMessage)
        {
            var r = 0;
            dt = null;
            try
            {
                var m_info = (ICommunicateService)RemotingOpen.GetRemote(typeof(ICommunicateService) “DataAcess“);
                var ds = new DataSet();
                errorMessage = string.Empty;
                r = m_info.GetData(1 sql out ds out errorMessage);
                dt = ds.Tables[0];
            }
            catch (Exception ex)
            {
                errorMessage = ex.Message;
                r = -1;
            }
            return r;
        }
        /// 
        /// 执行sql
        /// 

        /// sql语句
        /// 错误信息
        /// 0成功-1失败
        private int ExceSql(string sql out string errorMessage)
        {
            var m_info = (ICommunicateService)RemotingOpen.GetRemote(typeof(ICommunicateService) “DataAcess“);
            errorMessage = string.Empty;
            var r =   m_info.ExcuteSql(1 sql out errorMessage);

            return r;
        }
        public int Test(string strsqlout DataTable dt out string errorMessage)
        {
            //var strsql = “select * from test“;
            dt = new DataTable();

            var r = GetData(strsql out dt out errorMessage);
            return r;
        }
        public int  GetStoreData(out DataTable dt out string errorMessage)
        {
            var strsql =  Readxml.GetSql(“仓库管理“);
            dt = new DataTable();

            var r = GetData(strsql out dt out errorMessage);
            return r;
        }
      
        #region 重用
        /// 
        /// 用户查询
        /// 

        /// 
        /// 
        /// 
        public int GetUser(out DataTable dt out string errorMessage)
        {
            var strsql = Readxml.GetSql(“查询用户“);
            dt = new DataTable();

            var r = GetData(strsql out dt out errorMessage);
            return r;
        }
        public int GetRole(out DataTable dt out string errorMessage)
        {
            var strsql = Readxml.GetSql(“查询角色“);
            dt = new DataTable();

            var r = GetData(strsql out dt out errorMessage);
            return r;
        }
        public int GetRoleType(out DataTable dt out str

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\DataAcess\
     文件         144  2013-11-02 12:44  WindowsFormsApplication1\DataAcess\App.config
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\DataAcess\bin\
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\DataAcess\bin\Debug\
     文件        5120  2013-09-01 20:37  WindowsFormsApplication1\DataAcess\bin\Debug\DataAcess.dll
     文件       13824  2013-09-01 20:37  WindowsFormsApplication1\DataAcess\bin\Debug\DataAcess.pdb
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\DataAcess\bin\Release\
     文件       11264  2013-11-07 23:06  WindowsFormsApplication1\DataAcess\bin\Release\DataAcess.dll
     文件         144  2013-11-02 12:44  WindowsFormsApplication1\DataAcess\bin\Release\DataAcess.dll.config
     文件       24064  2013-11-07 23:06  WindowsFormsApplication1\DataAcess\bin\Release\DataAcess.pdb
     文件        9216  2013-11-02 12:50  WindowsFormsApplication1\DataAcess\bin\Release\IWCFCommunicate.dll
     文件       11776  2013-09-19 10:37  WindowsFormsApplication1\DataAcess\bin\Release\IWCFCommunicate.pdb
     文件        4096  2013-11-02 12:50  WindowsFormsApplication1\DataAcess\bin\Release\PublicStruct.dll
     文件        7680  2013-09-19 10:37  WindowsFormsApplication1\DataAcess\bin\Release\PublicStruct.pdb
     文件        3609  2013-11-07 00:39  WindowsFormsApplication1\DataAcess\bin\Release\Query.xml
     文件         131  2013-09-01 20:29  WindowsFormsApplication1\DataAcess\bin\Release\ServerConstring.xml
     文件        3264  2014-01-12 23:13  WindowsFormsApplication1\DataAcess\DataAcess.csproj
     文件       63091  2014-02-14 17:44  WindowsFormsApplication1\DataAcess\DataServer.cs
     文件        5468  2014-01-12 23:24  WindowsFormsApplication1\DataAcess\Deciphering.cs
     文件        6223  2014-01-17 23:58  WindowsFormsApplication1\DataAcess\Encrypt.cs
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\DataAcess\obj\
     目录           0  2014-02-14 22:57  WindowsFormsApplication1\DataAcess\obj\Debug\
     文件         597  2014-02-14 17:20  WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.csproj.FileListAbsolute.txt
     文件        9382  2014-02-14 00:33  WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.csprojResolveAssemblyReference.cache
     文件       32256  2014-02-14 17:45  WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.dll
     文件       81408  2014-02-14 17:45  WindowsFormsApplication1\DataAcess\obj\Debug\DataAcess.pdb
     文件        6607  2014-02-14 22:58  WindowsFormsApplication1\DataAcess\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
     文件           0  2013-09-01 18:31  WindowsFormsApplication1\DataAcess\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
     文件           0  2013-09-01 18:31  WindowsFormsApplication1\DataAcess\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
     文件           0  2013-09-01 18:31  WindowsFormsApplication1\DataAcess\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
............此处省略92个文件信息

评论

共有 条评论