Silverlight分页(VS2010)

最新推荐文章于 2013-10-31 15:58:00 发布

永远爱好写程序

最新推荐文章于 2013-10-31 15:58:00 发布

阅读量1k

点赞数

分类专栏： Silverlight 文章标签： silverlight 2010 exception string class null

本文链接：https://blog.csdn.net/limlimlim/article/details/7754061

版权

Silverlight 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

主要服务端代码
    public class wcfMain : IwcfMain
    {
        private const string mDBServer = "192.128.58.245";

        //获取总页数
        public int GetPageCount(int nPageSize)
        {
            DB.mStrDBServer = mDBServer;
            int nCount = DB.GetCount("Select Count(*) from Index_Second");
            if (nCount % nPageSize == 0)
            {
                return nCount / nPageSize;
            }
            else
            {
                return nCount / nPageSize + 1;
            }
        }
        //获取指定页数的数据
        public List<Index_SecondData> GetDatas(int nPageIndex, int nPageSize)
        {
            int nStartIndex = (nPageIndex-1)*nPageSize;     //开始数据
            int nEndIndex = nPageIndex*nPageSize;            //结束数据
            //ROW_Number()是SQL2005才有的内置函数，主要用来获取行号, OVER(Order by BatchID) 用来字段排序
            string strSQL = "Select * from " +
                            "(Select *,ROW_NUMBER() OVER(ORDER BY BatchID) AS RowNum FROM Index_Second) t" +
                            " Where t.RowNum>=" + nStartIndex.ToString() + " And t.RowNum<=" + nEndIndex.ToString();
            List<Index_SecondData> lstReturn = new List<Index_SecondData>();
            try
            {
                DB.mStrDBServer = mDBServer;
                DataTable dtGet = DB.GetDataTableBySQL(strSQL);
                Index_SecondData oData;
                for (int i = 0; i < dtGet.Rows.Count; i++)
                {
                    oData = new Index_SecondData();
                    oData.BatchID = dtGet.Rows[i]["BatchID"].ToString();
                    oData.BatchNo = dtGet.Rows[i]["BatchNo"].ToString();
                    oData.ImageNumber = dtGet.Rows[i]["ImageNumber"].ToString();
                    oData.F001 = dtGet.Rows[i]["F001"].ToString();
                    oData.F002 = dtGet.Rows[i]["F002"].ToString();
                    oData.F003 = dtGet.Rows[i]["F003"].ToString();
                    oData.F004 = dtGet.Rows[i]["F004"].ToString();
                    oData.F005 = dtGet.Rows[i]["F005"].ToString();
                    oData.F006 = dtGet.Rows[i]["F006"].ToString();
                    lstReturn.Add(oData);
                }
                return lstReturn;
            }
            catch (Exception ex)
            {
                MyLog.WriteErrLog("wcfMain-GetDatas", ex.Message.ToString());
                return null;
            }