private DataTable GetLocalData(MyArgs syncData)
{
if (syncData == null)
{
return(null);
}
string sql = string.Format("select * from (select BINARY_CHECKSUM(*) as CheckSum,ROW_NUMBER() over(order by {0} asc) as RowNum,* from {1}) as tblT where {0}>=@minKey and {0}<=@maxKey;", syncData.Key, syncData.TblName);
Dictionary <string, object> pms = new Dictionary <string, object>();
pms.Add("@maxKey", syncData.MaxKey);
pms.Add("@minKey", syncData.MinKey);
DataTable dt = new DataTable();
try { dt = LocalServer.QueryTable(sql, pms); }
catch (Exception)
{
dt = null;
}
return(dt);
}