读取两个txt文件，并将数据合并显示到一个easyui-datagrid表格中

1、首先配置web.config

<add key="SUANLI_BASE" value="E:\算例"/> //本地E盘下创建一个文件夹

2、创建一个实体类，用作对象吧

public class T_ZAIHEYUCE{

private string _x1;

        public string X1

        {

            get { return _x1; }

            set { _x1 = value; }

        }

        private string _x2;

        public string X2

        {

            get { return _x2; }

            set { _x2 = value; }

        }

        private string _x3;

        public string X3

        {

            get { return _x3; }

            set { _x3 = value; }

        }

        private string _x4;

        public string X4

        {

            get { return _x4; }

            set { _x4 = value; }

        }

        private string _x5;

        public string X5

        {

            get { return _x5; }

            set { _x5 = value; }

        }

}

3、创建一般处理程序ashx，继承自AjaxHandleBase:

public class ZaiHeYuCe : AjaxHandleBase{

  public override void BeforeProcess(HttpContext context)

        {

            AddMap("getzhtxt", GetZhtxt);

        }

 private void GetZhtxt(HttpContext context){

    decimal? id = QueryDecimal(context, "id");

    Work.Logic.T_SUANLI bll = new Work.Logic.T_SUANLI();

   Work.Model.T_SUANLI model = bll.GetEntity(id);  //得到id为XX的算例

//此处先建立两个第二步所创建的实例类，方便后边用

 List<Work.Model.T_ZAIHEYUCE> zhlist = new List<Work.Model.T_ZAIHEYUCE>();

 List<Work.Model.T_ZAIHEYUCE> zhyclist = new List<Work.Model.T_ZAIHEYUCE>();

   //获取web配置里的地址

 string suanliBasePath = ConfigurationManager.AppSettings["SUANLI_BASE"];

//获取文件夹下根据年份和case_加上此算例ID所生成的地址

string slpath = Path.Combine(suanliBasePath, DateTime.Now.Year.ToString(), "case_" + model.L_ID);

//获取此算例下的Solver文件夹

string solverpath = Path.Combine(slpath, "Solver");

//判断前台往数据库里添加的文件是否存在，此处我有四个文件需同时上传

if (File.Exists(model.F_ZHTXT_KEY) && File.Exists(model.F_ZHTRA_KEY) && File.Exists(model.F_WLTXT_KEY) && File.Exists(model.F_WLTRA_KEY)){

//获取Solver文件下载荷预测文件里综合类和物理类文件下的data_lo.txt。

//注意：综合类包括F_ZHTXT_KEY和F_ZHTRA_KEY，物理类包括model.F_WLTXT_KEY和model.F_WLTRA_KEY且这两类文件的data_log.txt都是149行3列分别是节点、textloss、trainloss

 string zhpath = Path.Combine(solverpath, "载荷预测", "zonghe", "data_log.txt");

//读取综合文件下的data_log.txt

string[] zhstrs = System.IO.File.ReadAllLines(zhpath);

//同理物理文件

string wlpath = Path.Combine(solverpath, "载荷预测", "wuli", "data_log.txt");

 string[] wlstrs = System.IO.File.ReadAllLines(wlpath);

//上文提到两个data_log的行列相等，

if (zhstrs.Length == wlstrs.Length)

{

//遍历综合类的txt,并添加到zhlist集合中，文本是用\t分隔的，所以

                 for (int i = 1; i < zhstrs.Length; i++)

                        {

                            var strs = zhstrs[i];

                            var s = strs.Substring(0, strs.Length - 1).Split("\t".ToCharArray());

                            zhlist.Add(new Work.Model.T_ZAIHEYUCE

                            {

                                X1 = s[0],

                                X2 = s[1],

                                X3 = s[s.Length - 1]

                            });

                        }

//遍历物理下的txt若zhlist集合中的X1节点等于i则赋值

注意：此处没有赋值s[0],是因为它俩在表格里共用同一节点

                  for (int i = 1; i < wlstrs.Length; i++)

                        {

                            var strs = wlstrs[i];

                            var s = strs.Substring(0, strs.Length - 1).Split("\t".ToCharArray());

                            var x1 = zhlist.Where(a => a.X1 == i.ToString()).FirstOrDefault().X1;

                            var x2 = zhlist.Where(a => a.X1 == i.ToString() && a.X2 != null).FirstOrDefault().X2;

                            var x3 = zhlist.Where(a => a.X1 == i.ToString() && a.X3 != null).FirstOrDefault().X3;

                            zhyclist.Add(new Work.Model.T_ZAIHEYUCE

                            {

                                X1 = x1,

                                X2 = x2,

                                X3 = x3,

                                X4 = s[1],

                                X5 = s[2]

                            });

                        }

}

}

//返回此集合的json格式，共有149条数据

string json = JsonHelper.ToJson(zhyclist);

 context.Response.Write(json);

}

}

4、前台aspx:

<script type="text/javascript">

 var url = "/Pages/Youhua/Data/ZaiHeYuCe.ashx?req_fun=";

 $(function () {

 loadLine();

//随浏览器窗口调整

 $(window).resize(function () {

loadLine();

}）；

});

//或者在此处用colums写多行表头也可以

        function loadLine()

        {

            $('#tabList').datagrid({

                url:url + "getzhtxt&id="+<%=SLID%>,

                //columns: [

                //    [{ "title": " " },

                //     { "title": "数字孪生", "colspan": 2 },

                //     { "title": "物理", "colspan": 2 }],

                //    [

                //     { "field": "X1", "title": "节点" },

                //     { "field": "X2", "title": "test-loss" },

                //     { "field": "X3", "title": "train-loss" },

                //     { "field": "X4", "title": "test-loss" },

                //     { "field": "X5", "title": "train-loss" }

                //    ]

                //]

            });                    

        }

</script>

 <table id="tabList" toolbar="" singleselect="true" rownumbers="true" striped="true" remotesort="false" class="easyui-datagrid" fit="true">

                            <thead>

                                <tr>

                                    <th align="center"></th>

                                    <th align="center" colspan="2">数字孪生</th>

                                    <th align="center" colspan="2">物理</th>

                                </tr>

                                <tr>

                                    <th align="center" data-options="sortable:true,field:'X1'">节点</th>

                                    <th align="center" data-options="sortable:true,field:'X2'">test-loss</th>

                                    <th align="center" data-options="sortable:true,field:'X3'">train-loss</th>

                                    <th align="center" data-options="sortable:true,field:'X4'">test-loss</th>

                                    <th align="center" data-options="sortable:true,field:'X5'">train-loss</th>

                                </tr>

                            </thead>                 

                        </table>

5、部分图像