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