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