/// <summary> /// 添加归档文件销毁鉴定信息 /// </summary> /// <param name="DocID">文件ID</param> /// <param name="DH">档号</param> /// <returns></returns> public bool AddGdDocCheckInfo(int DocID, int DeptID, int TopClassID, string DH) { StringBuilder strSql = new StringBuilder(); strSql.Append("Insert into 销毁 "); strSql.Append(" (文件ID,档号,题名,保管期限,归档时间,状态,全宗ID,一级类目ID)"); strSql.Append(" select 文件ID,@档号 as 档号,题名,GD_类目.保管期限,时间,0,@全宗ID as 全宗ID,@一级类目ID as 一级类目ID"); strSql.Append(" from GD_文件 inner join "); strSql.Append(" GD_类目 on GD_类目.类目ID = GD_文件.类目ID"); strSql.Append(" where GD_文件.文件ID = @文件ID"); SqlParameter[] parameter = { new SqlParameter("@档号", SqlDbType.NVarChar, 50), new SqlParameter("@全宗ID", SqlDbType.Int, 4), new SqlParameter("@一级类目ID", SqlDbType.Int, 4), new SqlParameter("@文件ID", SqlDbType.Int, 4) }; parameter[0].Value = DH; parameter[1].Value = DeptID; parameter[2].Value = TopClassID; parameter[3].Value = DocID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameter); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改用户角色 /// </summary> /// <param name="UpdateInfo"></param> /// <returns></returns> public bool UpdateUserRole(string UpdateInfo) { string[] userrole = UpdateInfo.Split('|'); string sqlstr = ""; if (userrole[2] == "0")//如果为0就删除用户拥有的角色 { sqlstr = "Delete From 用户角色 Where 用户ID=" + userrole[0] + " And 角色ID=" + userrole[1]; } else { sqlstr = "Insert Into 用户角色 (用户ID,角色ID) Values (" + userrole[0] + "," + userrole[1] + ")"; } int rows = DataSql.ExecuteSql(sqlstr); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加案卷销毁鉴定信息 /// </summary> /// <param name="FileID">案卷ID</param> /// <param name="DH">档号</param> /// <returns></returns> public bool AddFileCheckInfo(int FileID, int DeptID, string DH) { StringBuilder strSql = new StringBuilder(); strSql.Append("Insert into 销毁 "); strSql.Append(" (案卷ID,档号,题名,保管期限,归档时间,状态,全宗ID)"); strSql.Append(" select 案卷ID,@档号 as 档号,题名,目录.保管期限,归档时间,0,@全宗ID as 全宗ID"); strSql.Append(" from WS_案卷 inner join "); strSql.Append(" 案卷目录 on WS_案卷.目录ID = 案卷目录.目录ID"); strSql.Append(" where WS_案卷.案卷ID = @案卷ID"); SqlParameter[] parameter = { new SqlParameter("@档号", SqlDbType.NVarChar, 50), new SqlParameter("@全宗ID", SqlDbType.Int, 4), new SqlParameter("@案卷ID", SqlDbType.Int, 4) }; parameter[0].Value = DH; parameter[1].Value = DeptID; parameter[2].Value = FileID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameter); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 续借档案 /// </summary> /// <param name="FileID">ID</param> /// <param name="FileNum">续借时间</param> /// <returns></returns> public bool RenewDa(int ID, DateTime ReturnTime, DateTime RenewTime) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 借阅 set "); strSql.Append(" 归还时间 = @归还时间,"); strSql.Append(" 续借时间 = @续借时间"); strSql.Append(" where ID = @ID"); SqlParameter[] parameter = { new SqlParameter("@归还时间", SqlDbType.DateTime, 8), new SqlParameter("@续借时间", SqlDbType.DateTime, 8), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameter[0].Value = ReturnTime; parameter[1].Value = RenewTime; parameter[2].Value = ID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameter); if (rows > 0) { return(true); } else { return(false); } }
public bool UpdateRole(int RoleID, string RoleName, string Description) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 角色 set "); strSql.Append("角色名=@角色名,"); strSql.Append("描述=@描述"); strSql.Append(" where 角色ID=@角色ID "); SqlParameter[] parameters = { new SqlParameter("@角色名", SqlDbType.NVarChar, 30), new SqlParameter("@描述", SqlDbType.NVarChar, 50), new SqlParameter("@角色ID", SqlDbType.Int, 4) }; parameters[0].Value = RoleName; parameters[1].Value = Description; parameters[2].Value = RoleID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool UpdateUser(int UserID, string LoginName, string PassWord, string UserName, bool IsAdmin) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 用户 set "); strSql.Append("账号=@账号,"); strSql.Append("密码=@密码,"); strSql.Append("用户名=@用户名,"); strSql.Append("IsAdmin=@IsAdmin"); strSql.Append(" where 用户ID=@用户ID "); SqlParameter[] parameters = { new SqlParameter("@账号", SqlDbType.NVarChar, 30), new SqlParameter("@密码", SqlDbType.NVarChar, 30), new SqlParameter("@用户名", SqlDbType.NVarChar, 30), new SqlParameter("@IsAdmin", SqlDbType.Bit, 1), new SqlParameter("@用户ID", SqlDbType.Int, 4) }; parameters[0].Value = LoginName; parameters[1].Value = PassWord; parameters[2].Value = UserName; parameters[3].Value = IsAdmin; parameters[4].Value = UserID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool UpdateDept(int DeptID, string DeptName, string DeptNum, string GSNum) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 全宗 set "); strSql.Append("全宗号=@全宗号,"); strSql.Append("全宗名称=@全宗名称,"); strSql.Append("馆室代号=@馆室代号"); strSql.Append(" where 全宗ID=@全宗ID "); SqlParameter[] parameters = { new SqlParameter("@全宗号", SqlDbType.NVarChar, 4), new SqlParameter("@全宗名称", SqlDbType.NVarChar, 50), new SqlParameter("@馆室代号", SqlDbType.NVarChar, 10), new SqlParameter("@全宗ID", SqlDbType.Int, 4) }; parameters[0].Value = DeptNum; parameters[1].Value = DeptName; parameters[2].Value = GSNum; parameters[3].Value = DeptID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新专业记载项 /// </summary> public void UpdateZYJZ(int 项目ID, string 用地分类, string 征拨分类, string 原土地分类, string 批准时间, string 用地面积) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建专业记载建设用地规划管理 set "); strSql.Append("用地分类=@用地分类,"); strSql.Append("征拨分类=@征拨分类,"); strSql.Append("原土地分类=@原土地分类,"); strSql.Append("批准时间=@批准时间,"); strSql.Append("用地面积=@用地面积"); strSql.Append(" where 项目ID=@项目ID "); SqlParameter[] parameters = { new SqlParameter("@用地分类", SqlDbType.NVarChar, 10), new SqlParameter("@征拨分类", SqlDbType.NVarChar, 10), new SqlParameter("@原土地分类", SqlDbType.NVarChar, 10), new SqlParameter("@批准时间", SqlDbType.NVarChar, 10), new SqlParameter("@用地面积", SqlDbType.NVarChar, 10), new SqlParameter("@项目ID", SqlDbType.Int, 4) }; parameters[0].Value = 用地分类; parameters[1].Value = 征拨分类; parameters[2].Value = 原土地分类; parameters[3].Value = 批准时间; parameters[4].Value = 用地面积; parameters[5].Value = 项目ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新项目表中的档案状况信息 /// </summary> public void UpdateDAZK(int 项目ID, string 文字_卷, string 图纸_张, string 光盘, string 计算机磁盘) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建项目 set "); strSql.Append("文字_卷=@文字_卷,"); strSql.Append("图纸_张=@图纸_张,"); strSql.Append("光盘=@光盘,"); strSql.Append("计算机磁盘=@计算机磁盘"); strSql.Append(" where 项目ID=@项目ID "); SqlParameter[] parameters = { new SqlParameter("@文字_卷", SqlDbType.NVarChar, 10), new SqlParameter("@图纸_张", SqlDbType.NVarChar, 10), new SqlParameter("@光盘", SqlDbType.NVarChar, 10), new SqlParameter("@计算机磁盘", SqlDbType.NVarChar, 10), new SqlParameter("@项目ID", SqlDbType.Int, 4) }; parameters[0].Value = 文字_卷; parameters[1].Value = 图纸_张; parameters[2].Value = 光盘; parameters[3].Value = 计算机磁盘; parameters[4].Value = 项目ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> 更换原件 </summary> /// <param name="DocID">文件ID</param> /// <param name="YjDescription">描述</param> /// <param name="YjExt">扩展名</param> /// <returns>true 添加成功 false 添加失败</returns> public void ChangeYj(int YjID, string YjDescription, string YjExt, string path, string fileName) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YW_原件 set "); strSql.Append("描述=@描述,"); strSql.Append("扩展名=@扩展名,"); strSql.Append("Ftp目录=@Ftp目录,"); strSql.Append("Ftp保存名称=@Ftp保存名称"); strSql.Append(" where 原件ID=@原件ID "); SqlParameter[] parameters = { new SqlParameter("@描述", SqlDbType.NText), new SqlParameter("@扩展名", SqlDbType.NVarChar, 10), new SqlParameter("@Ftp目录", SqlDbType.NVarChar, 100), new SqlParameter("@Ftp保存名称", SqlDbType.NVarChar, 100), new SqlParameter("@原件ID", SqlDbType.Int, 4) }; parameters[0].Value = YjDescription.Trim(); parameters[1].Value = YjExt.Trim(); parameters[2].Value = path.Trim(); parameters[3].Value = fileName.Trim(); parameters[4].Value = YjID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 添加案卷销毁鉴定信息 /// </summary> /// <param name="FileID">案卷ID</param> /// <param name="DH">档号</param> /// <returns></returns> public bool AddFileCheckInfo(int FileID, int DeptID, int TopClassID, string DH) { StringBuilder strSql = new StringBuilder(); strSql.Append("Insert into 销毁 "); strSql.Append(" (案卷ID,档号,题名,保管期限,归档时间,状态,全宗ID,一级类目ID)"); strSql.Append(" select 册ID,@档号 as 档号,说明,保管期限,立册时间,0,@全宗ID as 全宗ID,@一级类目ID as 一级类目ID"); strSql.Append(" from ZP_册 where ZP_册.册ID = @案卷ID"); SqlParameter[] parameter = { new SqlParameter("@档号", SqlDbType.NVarChar, 50), new SqlParameter("@全宗ID", SqlDbType.Int, 4), new SqlParameter("@一级类目ID", SqlDbType.Int, 4), new SqlParameter("@案卷ID", SqlDbType.Int, 4) }; parameter[0].Value = DH; parameter[1].Value = DeptID; parameter[2].Value = TopClassID; parameter[3].Value = FileID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameter); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改原件 /// </summary> /// <returns> true 成功 false 失败</returns> public static void UpdateYj(int 照片ID, string 号, string 题名, string 照片号, string 参见号, string 摄影者, string 时间, string 文字说明) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ZP_照片 set "); strSql.Append("张号=@张号,"); strSql.Append("题名=@题名,"); strSql.Append("照片号=@照片号,"); strSql.Append("参见号=@参见号,"); strSql.Append("摄影者=@摄影者,"); strSql.Append("时间=@时间,"); strSql.Append("文字说明=@文字说明"); strSql.Append(" where 照片ID=@照片ID "); SqlParameter[] parameters = { new SqlParameter("@照片ID", SqlDbType.Int, 4), new SqlParameter("@张号", SqlDbType.Int, 4), new SqlParameter("@题名", SqlDbType.NVarChar, 200), new SqlParameter("@照片号", SqlDbType.NVarChar, 50), new SqlParameter("@参见号", SqlDbType.NVarChar, 50), new SqlParameter("@摄影者", SqlDbType.NVarChar, 50), new SqlParameter("@时间", SqlDbType.NVarChar, 10), new SqlParameter("@文字说明", SqlDbType.NText) }; parameters[0].Value = 照片ID; parameters[1].Value = 号.Trim(); parameters[2].Value = 题名.Trim(); parameters[3].Value = 照片号.Trim(); parameters[4].Value = 参见号.Trim(); parameters[5].Value = 摄影者.Trim(); parameters[6].Value = getDataTime(时间).Trim(); parameters[7].Value = 文字说明.Trim(); DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(int ID, string TypeNum, string ClassName, int level, int ProjectType) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建档案分类号 set "); strSql.Append("分类号=@分类号,"); strSql.Append("类目名称=@类目名称,"); strSql.Append("类目级别=@类目级别,"); strSql.Append("项目类型=@项目类型"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@分类号", SqlDbType.NVarChar, 15), new SqlParameter("@类目名称", SqlDbType.NVarChar, 30), new SqlParameter("@类目级别", SqlDbType.Int, 4), new SqlParameter("@项目类型", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = TypeNum; parameters[1].Value = ClassName; parameters[2].Value = level; parameters[3].Value = ProjectType; parameters[4].Value = ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
public bool UpdateTopClass(int TopClassID, string TopClassName, int ArchiveType, int Order) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 一级类目 set "); strSql.Append("类目名称=@类目名称,"); strSql.Append("类型ID=@类型ID,"); strSql.Append("顺序=@顺序"); strSql.Append(" where 类目ID=@类目ID "); SqlParameter[] parameters = { new SqlParameter("@类目名称", SqlDbType.NVarChar, 20), new SqlParameter("@类型ID", SqlDbType.Int, 4), new SqlParameter("@顺序", SqlDbType.SmallInt, 2), new SqlParameter("@类目ID", SqlDbType.Int, 4) }; parameters[0].Value = TopClassName; parameters[1].Value = ArchiveType; parameters[2].Value = Order; parameters[3].Value = TopClassID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 打回鉴定 /// </summary> /// <param name="ID">鉴定信息ID</param> /// <returns></returns> public bool ReturnCheck(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 销毁 set "); strSql.Append("状态 = 0"); strSql.Append(" where ID = @ID"); SqlParameter[] parameter = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameter[0].Value = ID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameter); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(string 总登记号起, string 总登记号止, string 存放地址) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建案卷 set "); strSql.Append("存放地址=@存放地址"); strSql.Append(" where 总登记号 between @总登记号起 and @总登记号止 "); SqlParameter[] parameters = { new SqlParameter("@存放地址", SqlDbType.NVarChar, 10), new SqlParameter("@总登记号起", SqlDbType.Int, 4), new SqlParameter("@总登记号止", SqlDbType.Int, 4) }; parameters[0].Value = 存放地址; parameters[1].Value = 总登记号起; parameters[2].Value = 总登记号止; DataSql.ExecuteSql(strSql.ToString(), parameters); MessageBox.Show("更新成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtZDJHStart.Text = ""; txtZDJHEnd.Text = ""; maskCFDZ.Text = ""; } catch { MessageBox.Show("更新失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 更新项目表中的专业记载项 /// </summary> public void UpdateZYJZ(int 项目ID, string 起点, string 止点, string 总长度, string 开工时间, string 竣工时间, string 工程造价, string 工程结算) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建项目 set "); strSql.Append("起点=@起点,"); strSql.Append("止点=@止点,"); strSql.Append("总长度=@总长度,"); strSql.Append("开工时间=@开工时间,"); strSql.Append("竣工时间=@竣工时间,"); strSql.Append("工程造价=@工程造价,"); strSql.Append("工程结算=@工程结算"); strSql.Append(" where 项目ID=@项目ID "); SqlParameter[] parameters = { new SqlParameter("@起点", SqlDbType.NVarChar, 20), new SqlParameter("@止点", SqlDbType.NVarChar, 20), new SqlParameter("@总长度", SqlDbType.NVarChar, 10), new SqlParameter("@开工时间", SqlDbType.NVarChar, 10), new SqlParameter("@竣工时间", SqlDbType.NVarChar, 10), new SqlParameter("@工程造价", SqlDbType.NVarChar, 20), new SqlParameter("@工程结算", SqlDbType.NVarChar, 20), new SqlParameter("@项目ID", SqlDbType.Int, 4) }; parameters[0].Value = 起点; parameters[1].Value = 止点; parameters[2].Value = 总长度; parameters[3].Value = 开工时间; parameters[4].Value = 竣工时间; parameters[5].Value = 工程造价; parameters[6].Value = 工程结算; parameters[7].Value = 项目ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <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="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> /// <returns> true 成功 false 失败</returns> public static void UpdateYj(int 文件ID, int 件号, string 题名, string 责任者, string 密级, string 时间, string 时长) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SX_文件 set "); strSql.Append("件号=@件号,"); strSql.Append("题名=@题名,"); strSql.Append("责任者=@责任者,"); strSql.Append("时间=@时间,"); strSql.Append("密级=@密级,"); strSql.Append("时长=@时长"); strSql.Append(" where 文件ID=@文件ID "); SqlParameter[] parameters = { new SqlParameter("@文件ID", SqlDbType.Int, 4), new SqlParameter("@件号", SqlDbType.Int, 4), new SqlParameter("@题名", SqlDbType.NVarChar, 200), new SqlParameter("@责任者", SqlDbType.NVarChar, 50), new SqlParameter("@时间", SqlDbType.NVarChar, 10), new SqlParameter("@密级", SqlDbType.NVarChar, 4), new SqlParameter("@时长", SqlDbType.NVarChar, 20) }; parameters[0].Value = 文件ID; parameters[1].Value = 件号; parameters[2].Value = 题名.Trim(); parameters[3].Value = 责任者.Trim(); parameters[4].Value = getDataTime(时间).Trim(); parameters[5].Value = 密级.Trim(); parameters[6].Value = 时长.Trim(); DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新项目表中的专业记载项 /// </summary> public void UpdateZYJZ(int 项目ID, string 总用地面积, string 总建筑面积, string 幢数, string 工程造价, string 工程结算) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建项目 set "); strSql.Append("总用地面积=@总用地面积,"); strSql.Append("总建筑面积=@总建筑面积,"); strSql.Append("幢数=@幢数,"); strSql.Append("工程造价=@工程造价,"); strSql.Append("工程结算=@工程结算"); strSql.Append(" where 项目ID=@项目ID "); SqlParameter[] parameters = { new SqlParameter("@总用地面积", SqlDbType.NVarChar, 20), new SqlParameter("@总建筑面积", SqlDbType.NVarChar, 20), new SqlParameter("@幢数", SqlDbType.NVarChar, 10), new SqlParameter("@工程造价", SqlDbType.NVarChar, 20), new SqlParameter("@工程结算", SqlDbType.NVarChar, 20), new SqlParameter("@项目ID", SqlDbType.Int, 4) }; parameters[0].Value = 总用地面积; parameters[1].Value = 总建筑面积; parameters[2].Value = 幢数; parameters[3].Value = 工程造价; parameters[4].Value = 工程结算; parameters[5].Value = 项目ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> 删除文件关联的单位ID </summary> /// <param name="docID">文件ID</param> /// <returns>int</returns> public int delDocForUnitID(int docID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from UnitForDoc where docID = @DocID"); SqlParameter[] parameter = { new SqlParameter("@DocID", SqlDbType.Int) }; parameter[0].Value = docID; return(DataSql.ExecuteSql(strSql.ToString(), parameter)); }
/// <summary> /// 修改案卷 /// </summary> /// <param name="FileID">案卷ID</param> /// <param name="FileNum">案卷号</param> /// <param name="FileTitle">题名</param> /// <param name="FileTypeNum">分类号</param> /// <param name="FileTypeName">类目名称</param> /// <param name="FileInTime">归档时间</param> /// <param name="FileYear">年度</param> /// <param name="FileSecrit">密级</param> /// <param name="FileAuthor">立卷人</param> /// <param name="FileChecker">检查人</param> /// <param name="FileGJH">柜架号</param> /// <param name="FileBZ">备注</param> /// <returns></returns> public int UpdateFile(int FileID, int FileNum, string FileTitle, string FileTypeNum, string FileTypeName, string FileInTime, string FileYear, string FileSecrit, string FileAuthor, string FileChecker, string FileGJH, string FileBZ) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BZ_案卷 set "); strSql.Append(" 案卷号 = @FileNum"); strSql.Append(" ,题名 = @FileTitle"); strSql.Append(" ,分类号 = @FileTypeNum"); strSql.Append(" ,类目名称 = @FileTypeName"); strSql.Append(" ,归档时间 = @FileInTime"); strSql.Append(" ,年度 = @FileYear"); strSql.Append(" ,密级 = @FileSecrit"); strSql.Append(" ,立卷人 = @FileAuthor"); strSql.Append(" ,检查人 = @FileChecker"); strSql.Append(" ,柜架号 = @FileGJH"); strSql.Append(" ,备注 = @FileBZ"); strSql.Append(" where 案卷ID = @FileID"); SqlParameter[] parameter = { new SqlParameter("@FileNum", SqlDbType.Int, 4), new SqlParameter("@FileTitle", SqlDbType.NVarChar, 200), new SqlParameter("@FileTypeNum", SqlDbType.NVarChar, 10), new SqlParameter("@FileTypeName", SqlDbType.NVarChar, 20), new SqlParameter("@FileInTime", SqlDbType.NVarChar, 10), new SqlParameter("@FileYear", SqlDbType.NVarChar, 10), new SqlParameter("@FileSecrit", SqlDbType.NVarChar, 4), new SqlParameter("@FileAuthor", SqlDbType.NVarChar, 10), new SqlParameter("@FileChecker", SqlDbType.NVarChar, 10), new SqlParameter("@FileGJH", SqlDbType.NVarChar, 20), new SqlParameter("@FileBZ", SqlDbType.NText, 16), new SqlParameter("@FileID", SqlDbType.Int, 4) }; parameter[0].Value = FileNum; parameter[1].Value = FileTitle.Trim(); parameter[2].Value = FileTypeNum.Trim(); parameter[3].Value = FileTypeName.Trim(); parameter[4].Value = FileInTime.Trim(); parameter[5].Value = FileYear.Trim(); parameter[6].Value = FileSecrit.Trim(); parameter[7].Value = FileAuthor.Trim(); parameter[8].Value = FileChecker.Trim(); parameter[9].Value = FileGJH.Trim(); parameter[10].Value = FileBZ.Trim(); parameter[11].Value = FileID; object obj = DataSql.ExecuteSql(strSql.ToString(), parameter); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(int ID, int 项目ID, string 单项工程名称, string 施工单位, string 建筑面积, string 高度, string 地下层数, string 地上层数, string 结构类型, string 开工时间, string 竣工时间) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建专业记载房屋建筑 set "); strSql.Append("项目ID=@项目ID,"); strSql.Append("单项工程名称=@单项工程名称,"); strSql.Append("施工单位=@施工单位,"); strSql.Append("建筑面积=@建筑面积,"); strSql.Append("高度=@高度,"); strSql.Append("地下层数=@地下层数,"); strSql.Append("地上层数=@地上层数,"); strSql.Append("结构类型=@结构类型,"); strSql.Append("开工时间=@开工时间,"); strSql.Append("竣工时间=@竣工时间"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@项目ID", SqlDbType.Int, 4), new SqlParameter("@单项工程名称", SqlDbType.NVarChar, 80), new SqlParameter("@施工单位", SqlDbType.NVarChar, 80), new SqlParameter("@建筑面积", SqlDbType.NVarChar, 10), new SqlParameter("@高度", SqlDbType.NVarChar, 10), new SqlParameter("@地下层数", SqlDbType.NVarChar, 10), new SqlParameter("@地上层数", SqlDbType.NVarChar, 10), new SqlParameter("@结构类型", SqlDbType.NVarChar, 20), new SqlParameter("@开工时间", SqlDbType.NVarChar, 10), new SqlParameter("@竣工时间", SqlDbType.NVarChar, 10), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = 项目ID; parameters[1].Value = 单项工程名称; parameters[2].Value = 施工单位; parameters[3].Value = 建筑面积; parameters[4].Value = 高度; parameters[5].Value = 地下层数; parameters[6].Value = 地上层数; parameters[7].Value = 结构类型; parameters[8].Value = 开工时间; parameters[9].Value = 竣工时间; parameters[10].Value = ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除原件 /// </summary> /// <param name="YjID">原件ID</param> /// <returns>true 删除成功 false 删除失败</returns> public void DeleteYj(int YjID) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PersonDocYj set sfsc = 1 "); strSql.Append(" where 原件ID=@原件ID "); SqlParameter[] parameters = { new SqlParameter("@原件ID", SqlDbType.Int, 4) }; parameters[0].Value = YjID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除原件 /// </summary> /// <param name="YjID">原件ID</param> /// <returns>true 删除成功 false 删除失败</returns> public static void DeleteYj(int YjID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SX_文件 "); strSql.Append(" where 文件ID=@文件ID "); SqlParameter[] parameters = { new SqlParameter("@文件ID", SqlDbType.Int, 4) }; parameters[0].Value = YjID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除一条数据 /// </summary> public void Delete(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from 城建专业记载房屋建筑 "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 删除角色信息 /// </summary> /// <param name="RoleID"></param> /// <returns></returns> public void RolePermissionDelete(int RoleID, int TopClassID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from 角色权限 where 角色ID = @角色ID and 一级类目ID = @一级类目ID"); SqlParameter[] parameters = { new SqlParameter("@角色ID", SqlDbType.Int, 4), new SqlParameter("@一级类目ID", SqlDbType.Int, 4) }; parameters[0].Value = RoleID; parameters[1].Value = TopClassID; DataSql.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 添加案卷借阅信息 /// </summary> /// <param name="DocID">案卷ID</param> /// <param name="DH">档号</param> /// <param name="Title">题名</param> /// <param name="GJH">柜架号</param> /// <param name="Borrower">借阅人</param> /// <param name="BorrowTime">借阅时间</param> /// <param name="BorrowPurpose">借阅目的</param> /// <param name="Remark">备注</param> public bool AddFileBorrowInfo(int FileID, int TopClassID, string DH, string Title, string GJH, string Borrower, string JDR, DateTime BorrowTime, string BorrowPurpose, DateTime ReturnTime, string Remark, int DeptID) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into 借阅(案卷ID,一级类目ID,档号,题名,柜架号,借阅人,接待人,借阅时间,借阅目的,归还时间,状态,备注,全宗ID) values"); strSql.Append(" (@案卷ID,@一级类目ID,@档号,@题名,@柜架号,@借阅人,@接待人,@借阅时间,@借阅目的,@归还时间,@状态,@备注,@全宗ID)"); SqlParameter[] parameter = { new SqlParameter("@案卷ID", SqlDbType.Int, 4), new SqlParameter("@一级类目ID", SqlDbType.Int, 4), new SqlParameter("@档号", SqlDbType.NVarChar, 50), new SqlParameter("@题名", SqlDbType.NVarChar, 200), new SqlParameter("@柜架号", SqlDbType.NVarChar, 20), new SqlParameter("@借阅人", SqlDbType.NVarChar, 20), new SqlParameter("@接待人", SqlDbType.NVarChar, 20), new SqlParameter("@借阅时间", SqlDbType.DateTime, 8), new SqlParameter("@借阅目的", SqlDbType.NVarChar, 50), new SqlParameter("@归还时间", SqlDbType.DateTime, 8), new SqlParameter("@状态", SqlDbType.Int, 4), new SqlParameter("@备注", SqlDbType.NVarChar, 50), new SqlParameter("@全宗ID", SqlDbType.Int, 4) }; parameter[0].Value = FileID; parameter[1].Value = TopClassID; parameter[2].Value = DH; parameter[3].Value = Title; parameter[4].Value = GJH; parameter[5].Value = Borrower; parameter[6].Value = JDR; parameter[7].Value = BorrowTime; parameter[8].Value = BorrowPurpose; parameter[9].Value = ReturnTime; parameter[10].Value = 1; parameter[11].Value = Remark; parameter[12].Value = DeptID; int rows = DataSql.ExecuteSql(strSql.ToString(), parameter); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> 修改总登记号和案卷号 </summary> /// <param name="zdjh">总登记号</param> /// <param name="fileNumber">案卷号</param> /// <param name="fileID">案卷ID</param> public void updateFileInfo(int zdjh, int fileNumber, int fileID) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 城建案卷 set 总登记号=@zdjh,案卷号=@fileNumber where 案卷ID = @fileID"); SqlParameter[] parameter = { new SqlParameter("@zdjh", SqlDbType.Int), new SqlParameter("@fileNumber", SqlDbType.Int), new SqlParameter("@fileID", SqlDbType.Int) }; parameter[0].Value = zdjh; parameter[1].Value = fileNumber; parameter[2].Value = fileID; DataSql.ExecuteSql(strSql.ToString(), parameter); }