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="ContentNum">目录号</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByContentNum(int DeptID, string ContentNum)
{
strSql = new StringBuilder();
strSql.Append("SELECT COUNT(*) FROM 案卷目录 INNER JOIN 一级类目 ON 案卷目录.一级类目ID = 一级类目.类目ID");
strSql.Append(" WHERE (一级类目.全宗ID = @DeptID) and 案卷目录.目录号 = @ContentNum");
SqlParameter[] parameters =
{
new SqlParameter("@DeptID", SqlDbType.Int, 4),
new SqlParameter("@ContentNum", SqlDbType.NVarChar, 20)
};
parameters[0].Value = DeptID;
parameters[1].Value = ContentNum;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证项目编号
/// </summary>
public static bool ExistsByProject(string 项目编号, int DeptID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 城建项目");
strSql.Append(" inner join 城建档案分类号 on 城建档案分类号.ID = 城建项目.分类号ID");
strSql.Append(" where 项目编号=@项目编号 and 城建档案分类号.全宗ID = @全宗ID");
SqlParameter[] parameters =
{
new SqlParameter("@项目编号", SqlDbType.NVarChar, 20),
new SqlParameter("@全宗ID", SqlDbType.Int, 4)
};
parameters[0].Value = 项目编号;
parameters[1].Value = DeptID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
