/// <summary> 记录用户录入的总登记号 </summary>
/// <param name="userID">用户ID</param>
/// <param name="zdjh">总登记号</param>
public void setZDJHInfo(int userID, int zdjh)
{
StringBuilder strSql = new StringBuilder();
if (DataSql.Exists("select count(*) from 城建总登记号记录 where UserID = " + userID))
{
strSql.Append("update 城建总登记号记录 set ZDJH = @zdjh where UserID = @userID");
SqlParameter[] parameter =
{
new SqlParameter("@zdjh", SqlDbType.Int),
new SqlParameter("@userID", SqlDbType.Int)
};
parameter[0].Value = zdjh;
parameter[1].Value = userID;
DataSql.ExecuteSql(strSql.ToString(), parameter);
}
else
{
strSql.Append("insert into 城建总登记号记录(UserID,ZDJH) values (@userID,@zdjh)");
SqlParameter[] parameter =
{
new SqlParameter("@userID", SqlDbType.Int),
new SqlParameter("@zdjh", SqlDbType.Int)
};
parameter[0].Value = userID;
parameter[1].Value = zdjh;
DataSql.ExecuteSql(strSql.ToString(), parameter);
}
}
/// <summary> 记录用户录入的案卷号 </summary>
/// <param name="userID">用户ID</param>
/// <param name="projectID">项目ID</param>
/// <param name="fileNumber">案卷号</param>
public void setFileInfo(int userID, int projectID, int fileNumber)
{
StringBuilder strSql = new StringBuilder();
int flhID = getFlhID(projectID);
if (DataSql.Exists("select count(*) from 城建案卷号记录 where UserID = " + userID + " and FLHID = " + flhID))
{
strSql.Append("update 城建案卷号记录 set FileNumber = @fileNumber where UserID = @userID and FLHID = @flhID");
SqlParameter[] parameter =
{
new SqlParameter("@fileNumber", SqlDbType.Int),
new SqlParameter("@userID", SqlDbType.Int),
new SqlParameter("@flhID", SqlDbType.Int)
};
parameter[0].Value = fileNumber;
parameter[1].Value = userID;
parameter[2].Value = flhID;
DataSql.ExecuteSql(strSql.ToString(), parameter);
}
else
{
strSql.Append("insert into 城建案卷号记录(UserID,FLHID,FileNumber) values (@userID,@flhID,@fileNumber)");
SqlParameter[] parameter =
{
new SqlParameter("@userID", SqlDbType.Int),
new SqlParameter("@flhID", SqlDbType.Int),
new SqlParameter("@fileNumber", SqlDbType.Int)
};
parameter[0].Value = userID;
parameter[1].Value = flhID;
parameter[2].Value = fileNumber;
DataSql.ExecuteSql(strSql.ToString(), parameter);
}
}
/// <summary> 是否存在相同的总登记号 </summary>
/// <param name="zdjh">总登记号</param>
/// <returns>bool</returns>
public bool ExistsByZDJH(int zdjh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 城建案卷");
strSql.Append(" where 总登记号=@zdjh ");
SqlParameter[] parameters = { new SqlParameter("@zdjh", SqlDbType.Int, 4) };
parameters[0].Value = zdjh;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证归档文件的文件ID是否存在
/// </summary>
/// <param name="DocID">文件ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByGdDocID(int DocID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from GD_文件 where 文件ID = @DocID");
SqlParameter[] parameters =
{
new SqlParameter("@DocID", SqlDbType.Int, 4)
};
parameters[0].Value = DocID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证原件ID是否存在
/// </summary>
/// <param name="YjID">原件ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByYjID(int YjID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 城建档案原件 where 原件ID = @YjID");
SqlParameter[] parameters =
{
new SqlParameter("@YjID", SqlDbType.Int, 4)
};
parameters[0].Value = YjID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 案卷信息验证
/// </summary>
/// <param name="ClassID"></param>
/// <returns>true 存在 false 不存在</returns>
public bool FileExsitByID(int fileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 城建案卷 where 案卷ID = @案卷ID");
SqlParameter[] parameters =
{
new SqlParameter("@案卷ID", SqlDbType.Int, 4)
};
parameters[0].Value = fileID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
//private SqlConnection conn = new SqlConnection(DataSql.ConStr);
//private string sql;
//private DataSet ds;
/// <summary>
/// 验证全宗ID是否存在
/// </summary>
/// <param name="FileID">全宗ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByDeptID(int DeptID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 全宗 where 全宗ID = @DeptID");
SqlParameter[] parameter =
{
new SqlParameter("@DeptID", SqlDbType.Int, 4)
};
parameter[0].Value = DeptID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 验证一级类目ID是否存在
/// </summary>
/// <param name="FileID">全宗ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByTopClassID(int TopClassID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 一级类目 where 类目ID = @TopClassID");
SqlParameter[] parameter =
{
new SqlParameter("@TopClassID", SqlDbType.Int, 4)
};
parameter[0].Value = TopClassID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 验证案卷ID是否存在
/// </summary>
/// <param name="FileID">案卷ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByFileID(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from ZP_册 where 册ID = @FileID");
SqlParameter[] parameter =
{
new SqlParameter("@FileID", SqlDbType.Int, 4)
};
parameter[0].Value = FileID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 全宗信息验证
/// </summary>
/// <param name="ClassID"></param>
/// <returns>true 存在 false 不存在</returns>
public bool DeptExsitByID(int deptID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 全宗 where 全宗ID = @全宗ID");
SqlParameter[] parameters =
{
new SqlParameter("@全宗ID", SqlDbType.Int, 4)
};
parameters[0].Value = deptID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证目录ID是否存在
/// </summary>
/// <param name="FileID">目录ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByContentID(int ContentID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 案卷目录 where 目录ID = @ContentID");
SqlParameter[] parameter =
{
new SqlParameter("@ContentID", SqlDbType.Int, 4)
};
parameter[0].Value = ContentID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 文件信息验证
/// </summary>
/// <param name="ClassID"></param>
/// <returns>true 存在 false 不存在</returns>
public bool DocExsitByID(int docID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from view城建文件旧 where 文件ID = @文件ID");
SqlParameter[] parameters =
{
new SqlParameter("@文件ID", SqlDbType.Int, 4)
};
parameters[0].Value = docID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 获取案卷借阅状态
/// </summary>
/// <param name="DocID"></param>
/// <returns></returns>
public bool getFileState(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 借阅");
strSql.Append(" where 案卷ID = @案卷ID and 状态 = 1");
SqlParameter[] parameter =
{
new SqlParameter("@案卷ID", SqlDbType.Int, 4)
};
parameter[0].Value = FileID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 验证工程名称
/// </summary>
/// <param name="TypeNumID">工程名称</param>
/// <returns></returns>
public bool ExistsByGCMC(string 工程名称)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 城建项目");
strSql.Append(" where 工程名称=@工程名称");
SqlParameter[] parameters =
{
new SqlParameter("@工程名称", SqlDbType.NVarChar, 20)
};
parameters[0].Value = 工程名称;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 获取归档文件是否已经销毁
/// </summary>
/// <param name="DocID"></param>
/// <returns></returns>
public bool getGdDocState(int DocID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 销毁");
strSql.Append(" where 文件ID = @文件ID and 状态 = 1");
SqlParameter[] parameter =
{
new SqlParameter("@文件ID", SqlDbType.Int, 4)
};
parameter[0].Value = DocID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 分类号验证
/// </summary>
/// <param name="ContentNum">目录号</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExisByTypeNum(int TopClassID, string TypeNum)
{
strSql = new StringBuilder();
strSql.Append("SELECT COUNT(*) FROM view城建分类号旧 where 分类号 = @TypeNUm and 一级类目ID = @TopClassID");
SqlParameter[] parameters =
{
new SqlParameter("@TopClassID", SqlDbType.Int, 4),
new SqlParameter("@TypeNUm", SqlDbType.NVarChar, 15)
};
parameters[0].Value = TopClassID;
parameters[1].Value = TypeNum;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证分类号ID是否存在
/// </summary>
/// <param name="FileID">目录ID</param>
/// <returns>true 存在 false 不存在</returns>
public bool ExistByTypeNumID(int TyptNumID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from view城建分类号旧 ");
strSql.Append("where ID = @TyptNumID");
SqlParameter[] parameters =
{
new SqlParameter("@TyptNumID", SqlDbType.Int, 4)
};
parameters[0].Value = TyptNumID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from 城建专业记载房屋建筑");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证项目ID
/// </summary>
public bool ExistsByProjectID(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 城建项目");
strSql.Append(" where 项目ID=@项目ID ");
SqlParameter[] parameters =
{
new SqlParameter("@项目ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
//private SqlConnection conn = new SqlConnection(DataSql.ConStr);
/// <summary>
/// 验证是否存在角色记录
/// </summary>
/// <param name="RoleID"></param>
/// <returns></returns>
public bool RoleExistByID(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 角色");
strSql.Append(" where 角色ID=@角色ID ");
SqlParameter[] parameters =
{
new SqlParameter("@角色ID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证全宗名称是否存在
/// </summary>
/// <param name="全宗ID"></param>
/// <returns></returns>
public bool DeptNameExist(string 全宗名称)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 全宗");
strSql.Append(" where 全宗名称 = @全宗名称 ");
SqlParameter[] parameters =
{
new SqlParameter("@全宗名称", SqlDbType.NVarChar, 50)
};
parameters[0].Value = 全宗名称;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证是否存在一级类目记录
/// </summary>
/// <param name="类目ID"></param>
/// <returns></returns>
public bool TopClassExistByID(int 类目ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 一级类目");
strSql.Append(" where 类目ID=@类目ID ");
SqlParameter[] parameters =
{
new SqlParameter("@类目ID", SqlDbType.Int, 4)
};
parameters[0].Value = 类目ID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证一级类目下是否包含案卷目录数据
/// </summary>
/// <param name="类目ID"></param>
/// <returns></returns>
public bool TopClassDeleteExist(int 一级类目ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 案卷目录");
strSql.Append(" where 一级类目ID=@一级类目 ");
SqlParameter[] parameters =
{
new SqlParameter("@一级类目", SqlDbType.Int, 4)
};
parameters[0].Value = 一级类目ID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证角色名是否存在
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public bool RoleNameExist(string RoleName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 角色");
strSql.Append(" where 角色名=@角色名 ");
SqlParameter[] parameters =
{
new SqlParameter("@角色名", SqlDbType.NVarChar, 30)
};
parameters[0].Value = RoleName;
return(DataSql.Exists(strSql.ToString(), parameters));
}
//private SqlConnection conn = new SqlConnection(DataSql.ConStr);
/// <summary>
/// 验证是否存在用户记录
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public bool UserExsitByID(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 用户");
strSql.Append(" where 用户ID=@用户ID ");
SqlParameter[] parameters =
{
new SqlParameter("@用户ID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 验证用户账号是否存在
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public bool LoginNameExist(string LoginName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 用户");
strSql.Append(" where 账号=@账号 ");
SqlParameter[] parameters =
{
new SqlParameter("@账号", SqlDbType.NVarChar, 30)
};
parameters[0].Value = LoginName;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 获取案卷是否已经提交鉴定
/// </summary>
/// <param name="DocID"></param>
/// <returns></returns>
public bool FileIsCheckIn(int TopClassID, int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 销毁");
strSql.Append(" where 一级类目ID = @一级类目ID and 案卷ID = @案卷ID and 状态 = 0");
SqlParameter[] parameter =
{
new SqlParameter("@一级类目ID", SqlDbType.Int, 4),
new SqlParameter("@案卷ID", SqlDbType.Int, 4)
};
parameter[0].Value = TopClassID;
parameter[1].Value = FileID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 验证项目编号
/// </summary>
/// <param name="TypeNumID">项目编号</param>
/// <returns></returns>
public bool ExistsByXMBH(int 分类号ID, string 项目编号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 城建项目");
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 = 分类号ID;
return(DataSql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 获取相册借阅状态
/// </summary>
/// <param name="DocID"></param>
/// <returns></returns>
public bool getCeState(int TopClassID, int BookID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from 借阅");
strSql.Append(" where 一级类目ID = @一级类目ID and 案卷ID = @案卷ID and 状态 = 1");
SqlParameter[] parameter =
{
new SqlParameter("@一级类目ID", SqlDbType.Int, 4),
new SqlParameter("@案卷ID", SqlDbType.Int, 4)
};
parameter[0].Value = TopClassID;
parameter[1].Value = BookID;
return(DataSql.Exists(strSql.ToString(), parameter));
}
/// <summary>
/// 用户登录验证
/// </summary>
/// <param name="LoginName"></param>
/// <param name="PassWord"></param>
/// <returns></returns>
public bool checkUserLogin(string LoginName, string PassWord)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(0) from 用户");
strSql.Append(" where 账号 = @账号 and 密码 =@密码");
SqlParameter[] parameters =
{
new SqlParameter("@账号", SqlDbType.NVarChar, 30),
new SqlParameter("@密码", SqlDbType.NVarChar, 30)
};
parameters[0].Value = LoginName;
parameters[1].Value = PassWord;
return(DataSql.Exists(strSql.ToString(), parameters));
}
