public static DataTable Convert(string strFileds, List txt,string strFileName, string strMC_NO, ref Grenarate_XML xml )
{
DataTable dt = new DataTable();
string[] colArr = strFileds.Split(new string[] { "," }, StringSplitOptions.None);
foreach (string ColumnName in colArr)
{
dt.Columns.Add(ColumnName, typeof(string));
}
string strNextLine = "";
int Record = -1;
int csvCount =0;
string str="";
for (int i = 0; i < txt.Count; i++)
{
strNextLine = txt[i].ToString().Replace(" ", ";");
string[] sArr = strNextLine.Split(new string[] { ";" }, StringSplitOptions.None);
DataRow dr = dt.NewRow();
for (int j = 0; j < dt.Columns.Count; j++) // 只取 配置长度
{
if (j == 0)
{
dr[j] = System.DateTime.Now.ToString();
}
if (j == 1)
{
dr[j] = strMC_NO;
}
else
{
int n = 0;
if (j > 1)
{
n = j - 2;
}
dr[j] = sArr[n].ToString();
}
}
//str = dr[5].ToString() + "," + dr[6].ToString() + "," + dr[10].ToString(); //DATETIMELS_Date,DATETIMELS_Time,PANELS
str = dr[6].ToString() + "," + dr[7].ToString() + "," + dr[11].ToString(); //DATETIMELS_Date,DATETIMELS_Time,PANELS
if (xml.last_Line.ToString() != "")
{
if (Record >= 0)
{
Record++;
dt.Rows.Add(dr);
}
else
{
if (xml.last_Line == str)
{
Record = 0;
}
}
}
else
{
Record++;
dt.Rows.Add(dr);
}
if (Record == 1)
{
xml.first_Line = str; //更新取第一条记录
}
csvCount ++;
}
if (str != string.Empty)
{
xml.last_Line = str; //更新最后一条记录
}
xml.record = "CSV_Record: " + csvCount.ToString() + "," + "Pass_Record: " + Record.ToString();
return dt;
}