/// <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();
}
}
}
