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; } } }