private bool ExistByID(int Value, ArchivesLevel aLevel)
{
GetTableName(DataBase.archivesType, aLevel, out TableName, out FieldName);
if (TableName != string.Empty && FieldName != string.Empty)
{
sql = string.Format("select count(*) from {0} where {1} = {2}", TableName, FieldName, Value);
return(DataSql.Exists(sql));
}
else
{
return(false);
}
}
/// <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;
}
}
}
