/// <summary>
/// 获取各档案信息的表名和主键
/// </summary>
/// <param name="aType">档案类型</param>
/// <param name="aLevel">档案信息分类级别</param>
/// <param name="TableName">表名</param>
/// <param name="FieldName">主键</param>
private void GetTableName(ArchivesType aType, ArchivesLevel aLevel, out string TableName, out string FieldName)
{
TableName = string.Empty;
FieldName = string.Empty;
if (aType == null || aType == ArchivesType.None)
{
return;
}
switch (aLevel)
{
case ArchivesLevel.TopClass:
{
TableName = "一级类目";
FieldName = "类目ID";
break;
}
case ArchivesLevel.Class_GD:
{
TableName = "GD_类目";
FieldName = "类目ID";
break;
}
case ArchivesLevel.TypeNum_Cj:
{
TableName = "城建档案分类号";
FieldName = "ID";
break;
}
case ArchivesLevel.Project_Cj:
{
TableName = "城建项目";
FieldName = "项目ID";
break;
}
case ArchivesLevel.Content:
{
if (aType == ArchivesType.照片档案_2002)
{
TableName = "ZP_册";
FieldName = "册ID";
}
else
{
TableName = "案卷目录";
FieldName = "目录ID";
}
break;
}
case ArchivesLevel.File:
{
#region 获取案卷的表名和主键
if (aType == ArchivesType.城建档案旧)
{
TableName = "view城建案卷旧";
}
if (aType == ArchivesType.城建档案新)
{
TableName = "城建案卷";
}
if (aType == ArchivesType.公安业务档案)
{
TableName = "YW_案卷";
}
if (aType == ArchivesType.会计档案)
{
TableName = "KuaiJi_案卷";
}
//if (aType == ArchivesType.科技档案_1989)
//{
// //暂无此类型程序
//}
if (aType == ArchivesType.科技档案_2000)
{
TableName = "KeJi_案卷";
}
if (aType == ArchivesType.社保业务档案)
{
TableName = "SBYW_案卷";
}
if (aType == ArchivesType.声像档案)
{
TableName = "SX_案卷";
}
if (aType == ArchivesType.文书档案)
{
TableName = "WS_案卷";
}
if (aType == ArchivesType.照片档案_1989)
{
TableName = "WS_案卷";
}
if (aType == ArchivesType.编制档案)
{
TableName = "BZ_案卷";
}
if (aType == ArchivesType.沿革档案)
{
TableName = "YG_案卷";
}
FieldName = "案卷ID";
if (aType == ArchivesType.照片档案_2002)
{
TableName = "ZP_照片组";
FieldName = "组ID";
}
#endregion
break;
}
case ArchivesLevel.Doc:
{
#region 获取文件的表名和主键
if (aType == ArchivesType.归档文件)
{
TableName = "GD_文件";
}
if (aType == ArchivesType.城建档案旧)
{
TableName = "view城建文件旧";
}
if (aType == ArchivesType.城建档案新)
{
TableName = "城建文件";
}
if (aType == ArchivesType.公安业务档案)
{
TableName = "YW_文件";
}
if (aType == ArchivesType.科技档案_2000)
{
TableName = "KeJi_文件";
}
if (aType == ArchivesType.社保业务档案)
{
TableName = "SBYW_文件";
}
if (aType == ArchivesType.声像档案)
{
TableName = "SX_文件";
}
if (aType == ArchivesType.文书档案)
{
TableName = "WS_文件";
}
if (aType == ArchivesType.照片档案_1989)
{
TableName = "WS_文件";
}
if (aType == ArchivesType.编制档案)
{
TableName = "BZ_文件";
}
if (aType == ArchivesType.沿革档案)
{
TableName = "YG_文件";
}
FieldName = "文件ID";
if (aType == ArchivesType.照片档案_2002)
{
TableName = "ZP_照片";
FieldName = "照片ID";
}
#endregion
break;
}
case ArchivesLevel.Yj:
{
#region 获取原件的表名和主键
if (aType == ArchivesType.归档文件)
{
TableName = "GD_原件";
}
if (aType == ArchivesType.城建档案旧)
{
TableName = "城建档案原件";
}
if (aType == ArchivesType.城建档案新)
{
TableName = "城建档案原件";
}
if (aType == ArchivesType.公安业务档案)
{
TableName = "YW_原件";
}
if (aType == ArchivesType.科技档案_2000)
{
TableName = "KeJi_原件";
}
if (aType == ArchivesType.社保业务档案)
{
TableName = "SBYW_原件";
}
if (aType == ArchivesType.文书档案)
{
TableName = "WS_原件";
}
if (aType == ArchivesType.照片档案_1989)
{
TableName = "WS_原件";
}
if (aType == ArchivesType.编制档案)
{
TableName = "BZ_原件";
}
if (aType == ArchivesType.沿革档案)
{
TableName = "BZ_原件";
}
FieldName = "原件ID";
#endregion
break;
}
}
}
public static void ShowHelp(ArchivesType aType)
{
string pathname = System.Windows.Forms.Application.StartupPath + "\\Help\\";
switch (aType)
{
case ArchivesType.文书档案:
pathname += "文书档案.chm";
break;
case ArchivesType.公安业务档案:
pathname += "业务档案.chm";
break;
case ArchivesType.科技档案_2000:
pathname += "科技档案.chm";
break;
case ArchivesType.会计档案:
pathname += "会计档案.chm";
break;
case ArchivesType.声像档案:
pathname += "声像档案.chm";
break;
case ArchivesType.照片档案_2002:
pathname += "照片档案.chm";
break;
case ArchivesType.归档文件:
pathname += "归档文件.chm";
break;
case ArchivesType.城建档案新:
pathname += "城建档案.chm";
break;
case ArchivesType.城建档案旧:
pathname += "城建档案.chm";
break;
case ArchivesType.社保业务档案:
pathname += "社保业务档案.chm";
break;
case ArchivesType.编制档案:
pathname += "编制档案.chm";
break;
default:
pathname += "使用说明.chm";
break;
}
if (System.IO.File.Exists(pathname))
{
//UIPublicClass.PdfReader pdf = new PdfReader(pathname, false);
//pdf.IsHelpLook = true;
//pdf.Show();
System.Diagnostics.Process.Start(pathname);
}
}
public PdfMergerCommand(ArchivesType archivesType)
{
PdfMergerCommand.archivesType = archivesType;
}
