/// <summary>
/// 分页查询方法
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static async Task <DataResultList <T> > ToPageListAsync <T>(this IQueryable <T> query, int pageIndex, int pageSize) where T : class
{
DataResultList <T> result = new DataResultList <T>()
{
PageIndex = pageIndex,
PageSize = pageSize
};
result.TotalCount = await query.CountAsync();
if (result.TotalCount > 0)
{
if (pageIndex == 1)
{
query = query.Take(result.PageSize);
}
else
{
query = query.Skip((result.PageIndex - 1) * result.PageSize).Take(result.PageSize);
}
result.DataList = await query.ToListAsync();
}
else
{
result.DataList = new List <T>();
}
return(result);
}
/// <summary>
/// 异步分页查询方法
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static async Task <DataResultList <T> > ToPageListAsync <T>(this IQueryable <T> query, int pageIndex, int pageSize) where T : class
{
DataResultList <T> result = new DataResultList <T>()
{
PageIndex = pageIndex,
PageSize = pageSize
};
result.TotalRecord = await query.CountAsync();
if (result.TotalRecord > 0)
{
if (!query.ToString().Contains("ORDER BY"))
{
query = query.OrderBy(e => 0);
}
if (pageIndex == 1)
{
query = query.Take(result.PageSize);
}
else
{
query = query.Skip((result.PageIndex - 1) * result.PageSize).Take(result.PageSize);
}
result.ResultList = await query.ToListAsync();
}
else
{
result.ResultList = new List <T>();
}
return(result);
}
/// <summary>
/// 分页查询方法
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public static DataResultList <T> ToPageList <T>(this IQueryable <T> query, int pageIndex, int pageSize) where T : class
{
DataResultList <T> result = new DataResultList <T>()
{
PageSize = pageSize,
PageIndex = pageIndex,
TotalCount = query.Count()
};
if (result.TotalCount > 0)
{
if (pageIndex == 1)
{
query = query.Take(result.PageSize);
}
else
{
query = query.Skip((result.PageIndex - 1) * result.PageSize).Take(result.PageSize);
}
result.DataList = query.ToList();
}
else
{
result.DataList = new List <T>();
}
return(result);
}
/// <summary>
/// 对源数据进行排版，来让其中的Id集体与指定的目标Id集合相对应。
/// </summary>
/// <param name="SourceResult">要进行排版的数据源</param>
/// <param name="DestinationIdList">要匹配到的目标Id集合</param>
/// <returns></returns>
/// <remarks></remarks>
private static DataResultArray SortResult(DataResultList SourceResult, List <long> DestinationIdList)
{
int NodeCount = DestinationIdList.Count;
object[,] NodeId = new object[NodeCount - 1 + 1, 1];
object[,] X = new object[NodeCount - 1 + 1, 1];
object[,] Y = new object[NodeCount - 1 + 1, 1];
object[,] Z = new object[NodeCount - 1 + 1, 1];
//---------------------- 开始进行数据排版 ------------------------------
int SourceIndex = 0;
int DestiIndex = 0;
//
DataResultList with_1 = SourceResult;
List <long> SourceNode = with_1.NodeId;
for (SourceIndex = 0; SourceIndex <= SourceNode.Count - 1; SourceIndex++)
{
DestiIndex = DestinationIdList.IndexOf(SourceNode[SourceIndex], DestiIndex);
if (DestiIndex < 0)
{
// 搜索原理：
// 这里有一个前提假设：在SourceNode与DestinationIdList中，节点的Id都是从小到大排列的。
// 所以，一旦SourceNode中的节点在DestinationIdList集体中找不到对应的匹配节点号，则SourceNode中后面的节点都不会找到匹配的节点号了。
break;
}
else
{
// 将数据放置在对应的位置上
NodeId[DestiIndex, 0] = with_1.NodeId[SourceIndex];
X[DestiIndex, 0] = with_1.X[SourceIndex];
Y[DestiIndex, 0] = with_1.Y[SourceIndex];
Z[DestiIndex, 0] = with_1.Z[SourceIndex];
}
}
//---------------------------------------------------------------------
DataResultArray Res = new DataResultArray();
Res.NodeId = NodeId;
Res.X = X;
Res.Y = Y;
Res.Z = Z;
return(Res);
}
/// <summary>
/// 读取数据,并返回在读取数据的过程中是否出错。
/// </summary>
/// <param name="Reader"></param>
/// <returns>如果数据提取成功，则返回True，否则返回False</returns>
/// <remarks>在读取数据时，每一个生成单元的函数中，都会返回最后跳出循环的那个字符串，如果某行字符串没有进行任何的数据提取，或者进行单元类型的判断，则继续读取下一行字符。</remarks>
private static List <DataResultList> ReadFile(StreamReader Reader)
{
string strLine = "";
DataResultList blockData = new DataResultList();
List <DataResultList> AllData = new List <DataResultList>();
//
strLine = Reader.ReadLine();
LineNum++;
while (strLine != null)
{
if (IsData(strLine))
{
blockData = GetData(Reader, strLine);
AllData.Add(blockData);
}
strLine = Reader.ReadLine();
LineNum++;
}
return(AllData);
}
/// <summary>
/// 提取一个数据块中的所有数据
/// </summary>
/// <param name="sr"></param>
/// <param name="strLine">这一行字符必须要是一个数据块中的第一行数据</param>
/// <returns></returns>
/// <remarks></remarks>
private static DataResultList GetData(StreamReader sr, string strLine)
{
List <long> nodeId = new List <long>();
List <double> x = new List <double>();
List <double> y = new List <double>();
List <double> z = new List <double>();
string[] strData = null;
strData = strLine.Split(new[] { '(', ',', ',', ')' });
do
{
nodeId.Add(long.Parse(strData[0]));
x.Add(double.Parse(strData[1]));
y.Add(double.Parse(strData[2]));
z.Add(double.Parse(strData[3]));
//
strLine = sr.ReadLine();
LineNum++;
if (strLine == null)
{
// 如果 strLine 的值为 Nothing，说明已经读到了文本文件的结尾了。
// Console.WriteLine("Nothing 所在的行号为： " & LineNum)
break;
}
strData = strLine.Split(new[] { '(', ',', ',', ')' });
} while (IsData(strLine));
// 此时的strLine为不满足数据格式的一行字符串
DataResultList result = new DataResultList();
result.NodeId = nodeId;
result.X = x;
result.Y = y;
result.Z = z;
result.strEscape = strLine;
return(result);
}
/// <summary>
/// 将一个dat文本中的所有数据写入对应的Worksheet中。
/// </summary>
/// <param name="AllData">一个dat文本中的所有数据。注意：在一个文本中，
/// 记录节点位置的坐标点的数量与记录节点位移的坐标点的数量并不一定是相同的。</param>
/// <param name="wkSheet">要进行写入的工作表</param>
/// <remarks></remarks>
private static void WriteDataToExcel(List <DataResultList> AllData, Worksheet wkSheet)
{
Application app = wkSheet.Application;
int BlockCount = AllData.Count;
uint RowsCount = 0; // 每一个数据块的数据行数
DataResultList results = new DataResultList();
// 先写入测点的位置信息
results = AllData[0];
RowsCount = (uint)results.NodeId.Count;
wkSheet.Range["A1:D1"].Value = new[] { "ID", "X", "Y", "Z" };
wkSheet.Range[wkSheet.Cells[cstRow_FirstData, 1], wkSheet.Cells[cstRow_FirstData + RowsCount - 1, 1]].Value
= app.WorksheetFunction.Transpose(results.NodeId.ToArray());
wkSheet.Range[wkSheet.Cells[cstRow_FirstData, 2], wkSheet.Cells[cstRow_FirstData + RowsCount - 1, 2]].Value
= app.WorksheetFunction.Transpose(results.X.ToArray());
wkSheet.Range[wkSheet.Cells[cstRow_FirstData, 3], wkSheet.Cells[cstRow_FirstData + RowsCount - 1, 3]].Value
= app.WorksheetFunction.Transpose(results.Y.ToArray());
wkSheet.Range[wkSheet.Cells[cstRow_FirstData, 4], wkSheet.Cells[cstRow_FirstData + RowsCount - 1, 4]].Value
= app.WorksheetFunction.Transpose(results.Z.ToArray());
//写入X数据
var startColumn = 5;
for (int BlockNum = 1; BlockNum <= BlockCount - 1; BlockNum++)
{
startColumn++;
results = AllData[BlockNum];
// 将
DataResultArray SortedRes = SortResult(results, AllData[0].NodeId);
RowsCount = (uint)SortedRes.Count;
wkSheet.Range[
wkSheet.Cells[cstRow_FirstData, startColumn],
wkSheet.Cells[cstRow_FirstData + RowsCount - 1, startColumn]].Value = SortedRes.X;
// app.WorksheetFunction.Transpose(results.X.ToArray)
wkSheet.Range[
wkSheet.Cells[cstRow_FirstData, startColumn + BlockCount],
wkSheet.Cells[cstRow_FirstData + RowsCount - 1, startColumn + BlockCount]].Value = SortedRes.Y;
// app.WorksheetFunction.Transpose(results.Y.ToArray)
wkSheet.Range[
wkSheet.Cells[cstRow_FirstData, startColumn + BlockCount * 2],
wkSheet.Cells[cstRow_FirstData + RowsCount - 1, startColumn + BlockCount * 2]].Value = SortedRes.Z;
// app.WorksheetFunction.Transpose(results.Z.ToArray)
}
try
{
wkSheet.Activate();
wkSheet.Range[wkSheet.Cells[1, 1], wkSheet.Cells[1, startColumn + BlockCount * 2]].Select();
if (wkSheet.AutoFilterMode)
{
app.Selection.AutoFilter();
app.Selection.AutoFilter();
}
else
{
app.Selection.AutoFilter();
}
}
catch (Exception)
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine(
"Warnning : Can not set the autofilter for the worksheet: {0}, but it will not affect the extraction of data.",
wkSheet.Name);
Console.ForegroundColor = ConsoleColor.Gray;
}
}
