主要服务端代码
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;
}
}
}