/// <summary> /// 加载配置文件 /// </summary> private void SetComboArray() { string excelPath = @"配置文件.xls"; if (!File.Exists(excelPath)) { TypeConverter.Array = new string[] { "" }; PersonConverter.Array = new string[] { "" }; OrgConverter.Array = new string[] { "" }; return; //throw new Exception("未找到配置文件"); } DataTable dt = ExcelHandler.ReadExcelToDataTable(excelPath); if ((from DataColumn column in dt.Columns where column.ColumnName.Equals("分类") select column).ToArray().Length != 1) { throw new Exception("配置文件不符合要求"); } if ((from DataColumn column in dt.Columns where column.ColumnName.Equals("人物") select column).ToArray().Length != 1) { throw new Exception("配置文件不符合要求"); } if ((from DataColumn column in dt.Columns where column.ColumnName.Equals("机构") select column).ToArray().Length != 1) { throw new Exception("配置文件不符合要求"); } List <string> typeList = new List <string>(); List <string> personList = new List <string>(); List <string> orgList = new List <string>(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i]["分类"].ToString())) { typeList.Add(dt.Rows[i]["分类"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i]["人物"].ToString())) { personList.Add(dt.Rows[i]["人物"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i]["机构"].ToString())) { orgList.Add(dt.Rows[i]["机构"].ToString()); } } TypeConverter.Array = typeList.ToArray(); PersonConverter.Array = personList.ToArray(); OrgConverter.Array = orgList.ToArray(); }
/// <summary> /// 下载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDownload_MouseUp(object sender, MouseEventArgs e) { if (_pathArray == null) { return; } FolderBrowserDialog gbd = new FolderBrowserDialog(); if (gbd.ShowDialog() == DialogResult.OK) { string path = gbd.SelectedPath + "\\记录表_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; SqliteHelper.SqliteHelper mysql = new SqliteHelper.SqliteHelper(); if (!mysql.DBConnect(_localDBname)) { MessageBox.Show("查询数据库失败"); } try { string content = string.Join("','", _pathArray); string sql = "select picture_name as 文件名称, picture_file as 路径, picture_title as 标题,picture_time as 时间,picture_author as 作者,picture_level as 评级,picture_info as 摘要,picture_key as 关键词,picture_person as 人物,picture_org as 机构,picture_type as 分类,picture_marker as 标引人,picture_marktime as 标引时间,picture_width as 图片宽,picture_height as 图片高,picture_hr as 水平分辨率,picture_vr as 垂直分辨率,picture_bit as 位深度,picture_gps as gps信息,picture_size as 图片大小,picture_format as 图片格式 from u_picture where picture_file in ('" + content + "')"; DataTable dt = mysql.DBReadTable(sql); if (dt == null) { throw new Exception("查询数据库失败"); } bool res = ExcelHandler.Write(path, dt); if (!res) { throw new Exception("导出表格失败"); } else { MessageBox.Show("导出成功"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { mysql.DBDisConnect(); } } }