/// <summary> /// 获取指定prjName的核心数据 /// </summary> /// <param name="prjName"></param> /// <returns></returns> public List <DbBean> GetSpecificDbData(string prjName) { //读取所有的Markers表中的数据 SQLiteCommand readCmd = connection.CreateCommand(); readCmd.CommandText = "SELECT * FROM Markers WHERE prjName=" + "'" + prjName + "'"; SQLiteDataReader reader = readCmd.ExecuteReader(); //将数据填充到List中 List <DbBean> list = new List <DbBean>(); while (reader.Read()) { //填充数据 DbBean bean = new DbBean(); bean.PrjName = reader[DbCons.COLUMN_PRJNAME] + ""; bean.Longitude = reader[DbCons.COLUMN_LONGITUDE] + ""; bean.Latitude = reader[DbCons.COLUMN_LATITUDE] + ""; bean.DeviceType = reader[DbCons.COLUMN_DEVICE_TYPE] + ""; bean.KilometerMark = reader[DbCons.COLUMN_KILOMETER_MARK] + ""; bean.SideDirection = reader[DbCons.COLUMN_SIDE_DIRECTION] + ""; bean.DistanceToRail = reader[DbCons.COLUMN_DISTANCE_TO_RAIL] + ""; bean.PhotoPathName = reader[DbCons.COLUMN_PHOTO_PATH_NAME] + ""; bean.Comment = reader[DbCons.COLUMN_COMMENT] + ""; bean.TowerType = reader[DbCons.COLUMN_TOWER_TYPE] + ""; bean.TowerHeight = reader[DbCons.COLUMN_TOWER_HEIGHT] + ""; bean.AntennaDirection1 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_1] + ""; bean.AntennaDirection2 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_2] + ""; bean.AntennaDirection3 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_3] + ""; bean.AntennaDirection4 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_4] + ""; //添加数据 list.Add(bean); } return(list); }
/// <summary> /// word 插入表格功能(13行2列) /// </summary> /// <param name="m_Docx">根文档</param> /// <param name="device_type">设备类型</param> /// <param name="kilometer_mark">公里标</param> /// <param name="side_direction">下行侧向</param> /// <param name="longitude">经度</param> /// <param name="latitude">纬度</param> private static void word_inster_table(XWPFDocument m_Docx, DbBean bean, int i = 1) { XWPFTable table = m_Docx.CreateTable(12, 2); CT_Tbl ctbl = m_Docx.Document.body.GetTblArray()[i]; CT_TblPr ctblpr = ctbl.AddNewTblPr(); ctblpr.jc = new CT_Jc(); ctblpr.jc.val = ST_Jc.center; table.Width = 3500; table.GetRow(0).GetCell(0).SetText("设备类型"); table.GetRow(0).GetCell(1).SetText(bean.DeviceType); table.GetRow(1).GetCell(0).SetText("公里标"); table.GetRow(1).GetCell(1).SetText(bean.KilometerMark); table.GetRow(2).GetCell(0).SetText("下行侧向"); table.GetRow(2).GetCell(1).SetText(bean.SideDirection); table.GetRow(3).GetCell(0).SetText("距线路中心距离(m)"); table.GetRow(4).GetCell(0).SetText("经度"); table.GetRow(4).GetCell(1).SetText(bean.Longitude); table.GetRow(5).GetCell(0).SetText("纬度"); table.GetRow(5).GetCell(1).SetText(bean.Latitude); table.GetRow(6).GetCell(0).SetText("杆塔类型"); table.GetRow(6).GetCell(1).SetText(bean.TowerType); table.GetRow(7).GetCell(0).SetText("杆塔高度"); table.GetRow(7).GetCell(1).SetText(bean.TowerHeight); table.GetRow(8).GetCell(0).SetText("天线1方向角"); table.GetRow(8).GetCell(1).SetText(bean.AntennaDirection1); table.GetRow(9).GetCell(0).SetText("天线2方向角"); table.GetRow(9).GetCell(1).SetText(bean.AntennaDirection2); table.GetRow(10).GetCell(0).SetText("天线3方向角"); table.GetRow(10).GetCell(1).SetText(bean.AntennaDirection3); table.GetRow(11).GetCell(0).SetText("天线4方向角"); table.GetRow(11).GetCell(1).SetText(bean.AntennaDirection4); CT_TcPr m_Pr = table.GetRow(2).GetCell(1).GetCTTc().AddNewTcPr(); m_Pr.tcW = new CT_TblWidth(); m_Pr.tcW.w = "3500"; m_Pr.tcW.type = ST_TblWidth.dxa; //设置单元格宽度 XWPFTableRow m_Row = table.InsertNewTableRow(0); XWPFTableCell cell = m_Row.CreateCell(); CT_Tc cttc = cell.GetCTTc(); CT_TcPr ctPr = cttc.AddNewTcPr(); ctPr.gridSpan = new CT_DecimalNumber(); ctPr.gridSpan.val = "2"; cttc.GetPList()[0].AddNewR().AddNewT().Value = "SITE 【序号】"; word_insert_space(1, m_Docx, 100); word_insert_text(m_Docx, "宋体", 11, "SITE 【序号】勘站照片"); word_insert_text(m_Docx, "宋体", 11, "(3-10张照片)"); word_insert_space(1, m_Docx, 100); }
/// <summary> /// 获取数据库中---所有的---的核心数据 /// </summary> /// <returns></returns> public List<DbBean> GetDbData() { //读取所有的Markers表中的数据 SQLiteCommand readCmd = connection.CreateCommand(); readCmd.CommandText = "SELECT * FROM Markers"; SQLiteDataReader reader = readCmd.ExecuteReader(); //将数据填充到List中 List<DbBean> list = new List<DbBean>(); while (reader.Read()) { //填充数据 DbBean bean = new DbBean(); bean.PrjName = reader[DbCons.COLUMN_PRJNAME] + ""; bean.Longitude = reader[DbCons.COLUMN_LONGITUDE] + ""; bean.Latitude = reader[DbCons.COLUMN_LATITUDE] + ""; bean.DeviceType = reader[DbCons.COLUMN_DEVICE_TYPE] + ""; bean.KilometerMark = reader[DbCons.COLUMN_KILOMETER_MARK] + ""; bean.SideDirection = reader[DbCons.COLUMN_SIDE_DIRECTION] + ""; bean.DistanceToRail = reader[DbCons.COLUMN_DISTANCE_TO_RAIL] + ""; bean.PhotoPathName = reader[DbCons.COLUMN_PHOTO_PATH_NAME] + ""; bean.Comment = reader[DbCons.COLUMN_COMMENT] + ""; bean.TowerType = reader[DbCons.COLUMN_TOWER_TYPE] + ""; bean.TowerHeight = reader[DbCons.COLUMN_TOWER_HEIGHT] + ""; bean.AntennaDirection1 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_1] + ""; bean.AntennaDirection2 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_2] + ""; bean.AntennaDirection3 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_3] + ""; bean.AntennaDirection4 = reader[DbCons.COLUMN_ANTENNA_DIRECTION_4] + ""; //添加数据 list.Add(bean); } return list; }