数据格式如下:
导入方法方法
原格式数据存在dataList
string strLast = string.Empty; //最后型号
StringBuilder sbFlow = new StringBuilder(); //流量
StringBuilder sbLift = new StringBuilder();//扬程
StringBuilder sbPower = new StringBuilder();//功率
StringBuilder sbEffict = new StringBuilder();//效率
foreach (objData a in dataList)
{
///新型号
if (!string.IsNullOrWhiteSpace(a.ProductName))
{
//计算公式
if (sbFlow.Length > 0)
{
//objFormula item = GetFormula(sbFlow.ToString(), sbLift.ToString(), sbPower.ToString(), sbEffict.ToString(),
// strLast,i);
double[] flowArry = Array.ConvertAll<string, double>(sbFlow.ToString().Split(','), s => double.Parse(s));
double[] liftArry = Array.ConvertAll<string, double>(sbLift.ToString().Split(','), s => double.Parse(s));
double[] powerArry = Array.ConvertAll<string, double>(sbPower.ToString().Split(','), s => double.Parse(s));
double[] effictArry = Array.ConvertAll<string, double>(sbEffict.ToString().Split(','), s => double.Parse(s));
objFormula item = new objFormula();
item.Product = strLast;
double[] qhArry = Common.MultiLine(flowArry, liftArry, flowArry.Length, int.Parse(this.tboxNumber.Text));
item.QH = string.Join(",", qhArry);
double[] qpArry = Common.MultiLine(flowArry, powerArry, flowArry.Length, int.Parse(this.tboxNumber.Text));
item.QP = string.Join(",", qpArry);
double[] qnArry = Common.MultiLine(flowArry, effictArry, flowArry.Length, int.Parse(this.tboxNumber.Text));
item.QN = string.Join(",", qnArry);
retList.Add(item);
//清空
sbFlow.Clear();
sbLift.Clear();
sbPower.Clear();
sbEffict.Clear();
}
//新型号
strLast = a.ProductName;
sbFlow.Append(a.flow);
sbLift.Append(a.lift);
sbPower.Append(a.power);
sbEffict.Append(a.effict);
}
else
{
sbFlow.Append("," + a.flow);
sbLift.Append("," + a.lift);
sbPower.Append("," + a.power);
sbEffict.Append("," + a.effict);
}
}
三个stringbuild值居然一致????
