/// <summary>
/// 获取归档文件类目中的科室ID
/// </summary>
/// <param name="ClassID">归档文件中类目的ID</param>
/// <returns></returns>
private static int GetKeShiID_GD(int ClassID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT SYS_科室.ID FROM GD_类目 INNER JOIN");
strSql.Append(" SYS_科室 ON GD_类目.科室代号 = SYS_科室.科室代号");
strSql.Append(" where GD_类目.类目ID = @类目ID and SYS_科室.全宗ID = @全宗ID");
SqlParameter[] parameters =
{
new SqlParameter("@类目ID", SqlDbType.Int, 4),
new SqlParameter("@全宗ID", SqlDbType.Int, 4)
};
parameters[0].Value = ClassID;
parameters[1].Value = _deptID;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(int TopClassID, string TypeNum, string ClassName, int level)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 城建档案分类号(");
strSql.Append("分类号,类目名称,类目级别,大纲类型,一级类目ID)");
strSql.Append(" values (");
strSql.Append("@分类号,@类目名称,@类目级别,@大纲类型,@一级类目ID)");
strSql.Append(";select @@IDENTITY");
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 = 0;
parameters[4].Value = TopClassID;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 插入文件数据
/// </summary>
/// <param name="FileID">案卷ID</param>
/// <param name="DocNum">件号</param>
/// <param name="DocTitle">题名</param>
/// <param name="DocTypeNum">分类号</param>
/// <param name="DocFWZ">发文字</param>
/// <param name="DocFWH">发文号</param>
/// <param name="DocZRZ">责任者</param>
/// <param name="DocTime">时间</param>
/// <param name="DocWB">文本</param>
/// <param name="DocMJ">密级</param>
/// <param name="DocPageNum">页数</param>
/// <param name="DocGG">规格</param>
/// <param name="DocZTC">主题词</param>
/// <param name="DocFJ">附件</param>
/// <param name="DocLJ">备注</param>
/// <returns>true 插入成功 false 插入失败</returns>
public int InsertDocRows(int ClassID, int DocNum, string DocTitle, int DocHH, string DocTypeNum,
string DocFWZ, string DocFWH, string DocZRZ, string DocTime, string DocWB, string DocMJ,
int DocPageNum, string DocGG, string DocGJH, string DocZTC, string DocBZ, int UserID)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into GD_文件(类目ID,件号,题名,盒号,分类号,发文字,发文号,责任者,时间,文本,密级,页数,规格,柜架号,主题词,备注,UserID,InTime) values ");
sql.Append(" (@ClassID, @DocNum, @DocTitle, @DocHH, @DocTypeNum, @DocFWZ, @DocFWH, @DocZRZ, @DocTime, @DocWB, @DocMJ, @DocPageNum, @DocGG, @DocGJH, @DocZTC, @DocBZ,@UserID,@InTime)");
sql.Append(";select @@IDENTITY");
SqlParameter[] parameter =
{
new SqlParameter("@ClassID", SqlDbType.Int, 4),
new SqlParameter("@DocNum", SqlDbType.Int, 4),
new SqlParameter("@DocTitle", SqlDbType.NVarChar, 200),
new SqlParameter("@DocHH", SqlDbType.Int, 4),
new SqlParameter("@DocTypeNum", SqlDbType.NVarChar, 20),
new SqlParameter("@DocFWZ", SqlDbType.NVarChar, 20),
new SqlParameter("@DocFWH", SqlDbType.NVarChar, 4),
new SqlParameter("@DocZRZ", SqlDbType.NVarChar, 50),
new SqlParameter("@DocTime", SqlDbType.NVarChar, 10),
new SqlParameter("@DocWB", SqlDbType.NVarChar, 4),
new SqlParameter("@DocMJ", SqlDbType.NVarChar, 4),
new SqlParameter("@DocPageNum", SqlDbType.Int, 4),
new SqlParameter("@DocGG", SqlDbType.NVarChar, 10),
new SqlParameter("@DocGJH", SqlDbType.NVarChar, 20),
new SqlParameter("@DocZTC", SqlDbType.NVarChar, 50),
new SqlParameter("@DocBZ", SqlDbType.NText),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@InTime", SqlDbType.DateTime, 8)
};
parameter[0].Value = ClassID;
parameter[1].Value = DocNum;
parameter[2].Value = DocTitle.Trim();
parameter[3].Value = DocHH;
parameter[4].Value = DocTypeNum.Trim();
parameter[5].Value = DocFWZ.Trim();
parameter[6].Value = DocFWH.Trim();
parameter[7].Value = DocZRZ.Trim();
parameter[8].Value = DocTime.Trim();
parameter[9].Value = DocWB.Trim();
parameter[10].Value = DocMJ.Trim();
parameter[11].Value = DocPageNum;
parameter[12].Value = DocGG.Trim();
parameter[13].Value = DocGJH.Trim();
parameter[14].Value = DocZTC.Trim();
parameter[15].Value = DocBZ.Trim();
parameter[16].Value = UserID;
parameter[17].Value = System.DateTime.Now;
object obj = DataSql.GetSingle(sql.ToString(), parameter);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int GetYjID(string Limit, string Year, string LeiMu, string DocNum, string IndexNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT y.原件ID FROM (GD_类目 AS l INNER JOIN");
strSql.Append(" GD_文件 AS d ON l.类目ID = d.类目ID) INNER JOIN");
strSql.Append(" GD_原件 AS y ON d.文件ID = y.文件ID");
strSql.Append(" where l.保管期限 = @Limit and l.年度 = @Year and l.类目 = @leimu ");
strSql.Append(" and d.件号 = @DocNum and y.序号 = @IndexNum");
SqlParameter[] parameter =
{
new SqlParameter("@Limit", SqlDbType.NVarChar, 10),
new SqlParameter("@Year", SqlDbType.NVarChar, 10),
new SqlParameter("@leimu", SqlDbType.NVarChar, 20),
new SqlParameter("@DocNum", SqlDbType.Int, 4),
new SqlParameter("@IndexNum", SqlDbType.Int, 4)
};
parameter[0].Value = Limit;
parameter[1].Value = Year;
parameter[2].Value = LeiMu;
parameter[3].Value = DocNum;
parameter[4].Value = IndexNum;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 获取归档文件的档号信息
/// </summary>
/// <param name="DocID"></param>
/// <returns></returns>
public string getGdDocDH(int DocID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ");
if (DataAccess.DataSql.ConnectType == DB.DBConnectType.SqlServer)
{
strSql.Append("全宗.全宗号 + N'/' + GD_类目.保管期限 + N'/' + GD_类目.年度 + N'/' + GD_类目.类目 + N'/' + CONVERT(nvarchar(20), GD_文件.件号) AS 档号 ");
}
else
{
strSql.Append("全宗.全宗号 + \"/\" + GD_类目.保管期限 + \"/\" + GD_类目.年度 + \"/\" + GD_类目.类目 + \"/\" + Cstr(GD_文件.件号) AS 档号 ");
}
strSql.Append(" FROM ((GD_文件 INNER JOIN ");
strSql.Append(" GD_类目 ON GD_文件.类目ID = GD_类目.类目ID) INNER JOIN ");
strSql.Append(" 一级类目 ON GD_类目.一级类目ID = 一级类目.类目ID) INNER JOIN ");
strSql.Append(" 全宗 ON 一级类目.全宗ID = 全宗.全宗ID ");
strSql.Append(" where GD_文件.文件ID = " + DocID);
object obj = DataSql.GetSingle(strSql.ToString());
string cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = string.Empty;
}
else
{
cmdresult = obj.ToString();
}
return(cmdresult);
}
/// <summary> 获取总登记号对应的档号 </summary>
/// <param name="zdjh">总登记号</param>
/// <returns>string</returns>
public string getDH(int topClassID, int zdjh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select view城建分类号新.分类号 +'-'+城建项目.项目编号+'-'+cast(城建案卷.案卷号 as varchar(10)) as 档号 ");
strSql.Append("from view城建分类号新 inner join ");
strSql.Append("城建项目 on view城建分类号新.ID = 城建项目.分类号ID inner join ");
strSql.Append("城建案卷 on 城建项目.项目ID = 城建案卷.项目ID ");
strSql.Append("where view城建分类号新.一级类目ID = @topClassID and 城建案卷.总登记号 = @zdjh ");
SqlParameter[] parameter =
{
new SqlParameter("@topClassID", SqlDbType.Int),
new SqlParameter("@zdjh", SqlDbType.Int)
};
parameter[0].Value = topClassID;
parameter[1].Value = zdjh;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (Object.Equals(obj, null) || Object.Equals(obj, System.DBNull.Value))
{
return(string.Empty);
}
else
{
return(Convert.ToString(obj));
}
}
/// <summary>
/// 获取案卷的档号信息
/// </summary>
/// <param name="FileID"></param>
/// <returns></returns>
public string getFileDH(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ");
strSql.Append(" 全宗.全宗号 + N'/' + 案卷目录.目录号 + N'/' + CONVERT(nvarchar(20), WS_案卷.案卷号) AS 档号 ");
strSql.Append(" FROM WS_案卷 INNER JOIN ");
strSql.Append(" 案卷目录 ON WS_案卷.目录ID = 案卷目录.目录ID INNER JOIN ");
strSql.Append(" 一级类目 ON 案卷目录.一级类目ID = 一级类目.类目ID INNER JOIN ");
strSql.Append(" 全宗 ON 一级类目.全宗ID = 全宗.全宗ID ");
strSql.Append(" where WS_案卷.案卷ID = " + FileID);
object obj = DataSql.GetSingle(strSql.ToString());
string cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = string.Empty;
}
else
{
cmdresult = obj.ToString();
}
return(cmdresult);
}
/// <summary>
/// 获取案卷的总登记号最大值
/// </summary>
/// <param name="ContentID">目录ID</param>
/// <returns>返回案卷号最大值</returns>
public int getMaxFileZGJH(int TypeNumID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(总登记号) as 案卷号 from view城建案卷旧");
SqlParameter[] parameter =
{
new SqlParameter("@TypeNumID", SqlDbType.Int, 4)
};
parameter[0].Value = TypeNumID;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
return(cmdresult);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(int 分类号ID,
string 项目编号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into view城建项目通用(");
strSql.Append("分类号ID,项目编号)");
strSql.Append(" values (");
strSql.Append("@分类号ID,@项目编号)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@分类号ID", SqlDbType.Int, 4),
new SqlParameter("@项目编号", SqlDbType.NVarChar, 20)
};
parameters[0].Value = 分类号ID;
parameters[1].Value = 项目编号;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 验证用户是否为系统管理员
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public bool AdminExist(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select IsAdmin from 用户");
strSql.Append(" where 用户ID=@用户ID ");
SqlParameter[] parameters =
{
new SqlParameter("@用户ID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
bool cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = false;
}
else
{
cmdresult = Convert.ToBoolean(obj);
}
return(cmdresult);
}
/// <summary> 获取新的总登记号 </summary>
/// <param name="userID">用户ID</param>
/// <param name="flhID">flhID</param>
/// <returns>int</returns>
public int getNewZDJH(int userID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ZDJH from 城建总登记号记录 where UserID=@userID ");
SqlParameter[] parameter =
{
new SqlParameter("@userID", SqlDbType.Int)
};
parameter[0].Value = userID;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return(getMaxZDJH() + 1);
}
else
{
if (ExistsByZDJH(Convert.ToInt32(obj) + 1))
{
return(getMaxZDJH() + 1);
}
else
{
return(Convert.ToInt32(obj) + 1);
}
}
}
/// <summary>
/// 获取张号最大值
/// </summary>
/// <param name="ContentID">目录ID</param>
/// <returns>返回案卷号最大值</returns>
public static int getDocNumMax(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(件号) as 件号 from SX_文件 where 案卷ID = @案卷ID");
SqlParameter[] parameter =
{
new SqlParameter("@案卷ID", SqlDbType.Int, 4)
};
parameter[0].Value = FileID;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
return(cmdresult);
}
public int GetYjID(string FileNum, string DocFlhNum, string DocLnxhNum, string IndexNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT PersonDocYJ.原件ID FROM BaseInfo INNER JOIN");
strSql.Append(" PersonDoc ON BaseInfo.daID = PersonDoc.daID INNER JOIN");
strSql.Append(" PersonDocYJ ON PersonDoc.wjID = PersonDocYJ.文件ID");
strSql.Append(" where BaseInfo.dahm = @FileNum and PersonDoc.flh = @DocFlhNum and PersonDoc.lnxh = @DocLnxhNum and PersonDocYJ.序号 = @IndexNum and PersonDocYJ.sfsc = 0");
SqlParameter[] parameter =
{
new SqlParameter("@FileNum", SqlDbType.Int, 4),
new SqlParameter("@DocFlhNum", SqlDbType.Int, 4),
new SqlParameter("@DocLnxhNum", SqlDbType.Int, 4),
new SqlParameter("@IndexNum", SqlDbType.Int, 4)
};
parameter[0].Value = FileNum;
parameter[1].Value = DocFlhNum;
parameter[2].Value = DocLnxhNum;
parameter[3].Value = IndexNum;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (obj != null)
{
return((int)obj);
}
else
{
return(0);
}
}
/// <summary>
/// 获取案卷的档号信息
/// </summary>
/// <param name="FileID"></param>
/// <returns></returns>
public string getFileDH(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ");
if (DataAccess.DataSql.ConnectType == DB.DBConnectType.SqlServer)
{
strSql.Append("全宗.全宗号 + N'/' + 一级类目.类目名称 + N'/' + ZP_册.册号 AS 档号");
}
else
{
strSql.Append("全宗.全宗号 + \"/\" + 一级类目.类目名称 + \"/\" + ZP_册.册号 AS 档号");
}
strSql.Append(" FROM (ZP_册 INNER JOIN ");
strSql.Append(" 一级类目 ON ZP_册.一级类目ID = 一级类目.类目ID) INNER JOIN ");
strSql.Append(" 全宗 ON 一级类目.全宗ID = 全宗.全宗ID ");
strSql.Append(" where ZP_册.册ID = " + FileID);
object obj = DataSql.GetSingle(strSql.ToString());
string cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = string.Empty;
}
else
{
cmdresult = obj.ToString();
}
return(cmdresult);
}
/// <summary>
/// 新增全宗
/// </summary>
/// <param name="DeptName"></param>
/// <param name="DeptNum"></param>
/// <param name="GSNum"></param>
/// <returns></returns>
public int CreateDept(string DeptName, string DeptNum, string GSNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 全宗(");
strSql.Append("全宗名称,全宗号,馆室代号)");
strSql.Append(" values (");
strSql.Append("@全宗名称,@全宗号,@馆室代号)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@全宗名称", SqlDbType.NVarChar, 30),
new SqlParameter("@全宗号", SqlDbType.NVarChar, 4),
new SqlParameter("@馆室代号", SqlDbType.NVarChar, 10)
};
parameters[0].Value = DeptName;
parameters[1].Value = DeptNum;
parameters[2].Value = GSNum;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="UserID"></param>
/// <param name="FieldName"></param>
/// <param name="FieldValue"></param>
/// <returns></returns>
public int CreateRole(string RoleName, string Description)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 角色(");
strSql.Append("角色名,描述)");
strSql.Append(" values (");
strSql.Append("@角色名,@描述)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@角色名", SqlDbType.NVarChar, 30),
new SqlParameter("@描述", SqlDbType.NVarChar, 50)
};
parameters[0].Value = RoleName;
parameters[1].Value = Description;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 获取项目编号最大值
/// </summary>
/// <param name="ContentID">分类号ID</param>
/// <returns>返回项目编号最大值</returns>
public int getMaxXMBH(int 分类号ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT MAX(项目编号) FROM 城建项目");
strSql.Append(" where 分类号ID=@分类号ID ");
SqlParameter[] parameters =
{
new SqlParameter("@分类号ID", SqlDbType.Int, 4)
};
parameters[0].Value = 分类号ID;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
return(cmdresult);
}
public int GetYjID(string ContentNum, string FileNum, string DocNum, string IndexNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT y.原件ID FROM 案卷目录 AS c INNER JOIN");
strSql.Append(" YW_案卷 AS f ON c.目录ID = f.目录ID INNER JOIN");
strSql.Append(" YW_文件 AS d ON f.案卷ID = d.案卷ID INNER JOIN");
strSql.Append(" YW_原件 AS y ON d.文件ID = y.文件ID");
strSql.Append(" where c.目录号 = @ContentNum and f.案卷号 = @FileNum");
strSql.Append(" and d.件号 = @DocNum and y.序号 = @IndexNum");
SqlParameter[] parameter =
{
new SqlParameter("@ContentNum", SqlDbType.NVarChar, 20),
new SqlParameter("@FileNum", SqlDbType.Int, 4),
new SqlParameter("@DocNum", SqlDbType.Int, 4),
new SqlParameter("@IndexNum", SqlDbType.Int, 4)
};
parameter[0].Value = ContentNum;
parameter[1].Value = FileNum;
parameter[2].Value = DocNum;
parameter[3].Value = IndexNum;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (obj != null)
{
return((int)obj);
}
else
{
return(0);
}
}
/// <summary>
/// 验证用户是否进行最后录入信息提醒
/// </summary>
/// <param name="UserID"></param>
/// <returns></returns>
public bool RemindExist(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select IsRemind from 用户");
strSql.Append(" where 用户ID=@用户ID ");
SqlParameter[] parameters =
{
new SqlParameter("@用户ID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
bool cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = true;//默认进行提醒
}
else
{
cmdresult = (bool)obj;
}
return(cmdresult);
}
/// <summary>
/// 获取案卷的档号信息
/// </summary>
/// <param name="FileID"></param>
/// <returns></returns>
public string getFileDH(int FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ");
if (DataAccess.DataSql.ConnectType == DB.DBConnectType.SqlServer)
{
strSql.Append("全宗.全宗号 + N'/' + 案卷目录.目录号 + N'/' + CONVERT(nvarchar(20), SX_案卷.案卷号) AS 档号");
}
else
{
strSql.Append("全宗.全宗号 + \"/\" + 案卷目录.目录号 + \"/\" + Cstr(SX_案卷.案卷号) AS 档号");
}
strSql.Append(" FROM ((SX_案卷 INNER JOIN ");
strSql.Append(" 案卷目录 ON SX_案卷.目录ID = 案卷目录.目录ID) INNER JOIN ");
strSql.Append(" 一级类目 ON 案卷目录.一级类目ID = 一级类目.类目ID) INNER JOIN ");
strSql.Append(" 全宗 ON 一级类目.全宗ID = 全宗.全宗ID ");
strSql.Append(" where SX_案卷.案卷ID = " + FileID);
object obj = DataSql.GetSingle(strSql.ToString());
string cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = string.Empty;
}
else
{
cmdresult = obj.ToString();
}
return(cmdresult);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="UserID"></param>
/// <param name="FieldName"></param>
/// <param name="FieldValue"></param>
/// <returns></returns>
public int CreateUser(string LoginName, string PassWord, string UserName, bool IsAdmin)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 用户(");
strSql.Append("账号,密码,用户名,IsAdmin)");
strSql.Append(" values (");
strSql.Append("@账号,@密码,@用户名,@IsAdmin)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@账号", SqlDbType.NVarChar, 30),
new SqlParameter("@密码", SqlDbType.NVarChar, 30),
new SqlParameter("@用户名", SqlDbType.NVarChar, 30),
new SqlParameter("@IsAdmin", SqlDbType.Bit, 1)
};
parameters[0].Value = LoginName;
parameters[1].Value = PassWord;
parameters[2].Value = UserName;
parameters[3].Value = IsAdmin;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary> 获取上一个项目的最大案卷号 </summary>
/// <param name="topClassID">一级类目ID</param>
/// <param name="typeName">分类号名称</param>
/// <param name="projectNum">项目编号</param>
/// <returns>int</returns>
public int getFileNumber(int topClassID, string typeName, string projectNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select max(案卷号) as 案卷号 from view城建分类号新 inner join ");
strSql.Append("城建项目 on view城建分类号新.ID = 城建项目.分类号ID inner join ");
strSql.Append("城建案卷 on 城建项目.项目ID = 城建案卷.项目ID ");
strSql.Append("where view城建分类号新.一级类目ID = @topClassID and ");
strSql.Append("view城建分类号新.分类号 = @typeName and 城建项目.项目编号 = @projectNum ");
SqlParameter[] parameter =
{
new SqlParameter("@topClassID", SqlDbType.Int),
new SqlParameter("@typeName", SqlDbType.NVarChar,15),
new SqlParameter("@projectNum", SqlDbType.NVarChar, 20)
};
parameter[0].Value = topClassID;
parameter[1].Value = typeName;
parameter[2].Value = projectNum;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (Object.Equals(obj, null) || Object.Equals(obj, System.DBNull.Value))
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 数据的添加
/// </summary>
/// <returns>true 添加成功 false 添加失败</returns>
public static int insertYj(int FileID, string 题名, string 责任者, string 密级, string 时间,
string 时长, Image Thumbnail, string ftpFtp目录, string ftpFtp保存名称, int UserID)
{
MemoryStream ms = null;
if (Thumbnail != null)
{
ms = new MemoryStream();
Thumbnail.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SX_文件(");
strSql.Append("案卷ID,件号,题名,责任者,时间,密级,时长,缩略图,Ftp目录,Ftp保存名称,UserID,InTime)");
strSql.Append(" values (");
strSql.Append("@案卷ID,@件号,@题名,@责任者,@时间,@密级,@时长,@缩略图,@Ftp目录,@Ftp保存名称,@UserID,@InTime)");
strSql.Append(";select @@IDENTITY");
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),
new SqlParameter("@缩略图", SqlDbType.Image),
new SqlParameter("@Ftp目录", SqlDbType.NVarChar, 100),
new SqlParameter("@Ftp保存名称", SqlDbType.NVarChar, 100),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@InTime", SqlDbType.DateTime, 10)
};
parameters[0].Value = FileID;
parameters[1].Value = getDocNumMax(FileID) + 1;
parameters[2].Value = 题名.Trim();
parameters[3].Value = 责任者.Trim();
parameters[4].Value = getDataTime(时间).Trim();
parameters[5].Value = 密级.Trim();
parameters[6].Value = 时长.Trim();
parameters[7].Value = (ms == null) ? null : (ms.ToArray());
parameters[8].Value = ftpFtp目录.Trim();
parameters[9].Value = ftpFtp保存名称.Trim();
parameters[10].Value = UserID;
parameters[11].Value = System.DateTime.Now;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 插入文件数据
/// </summary>
/// <param name="FileID">案卷ID</param>
/// <param name="DocNum">件号</param>
/// <param name="DocTitle">题名</param>
/// <param name="DocTypeNum">分类号</param>
/// <param name="DocFWZ">发文字</param>
/// <param name="DocFWH">发文号</param>
/// <param name="DocZRZ">责任者</param>
/// <param name="DocTime">时间</param>
/// <param name="DocWB">文本</param>
/// <param name="DocMJ">密级</param>
/// <param name="DocPageNum">页数</param>
/// <param name="DocGG">规格</param>
/// <param name="DocZTC">主题词</param>
/// <returns>true 插入成功 false 插入失败</returns>
public int InsertDoc(int FileID, int DocNum, string DocTitle, string DocTypeNum, string DocFWZ, string DocFWH, string DocZRZ,
string DocTime, string DocWB, string DocMJ, int DocPageNum, string DocGG, string DocZTC, string DocGLDW, int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BZ_文件(案卷ID,件号,题名,分类号,发文字,发文号,责任者,时间,文本,密级,页数,规格,主题词,关联单位,UserID,InTime) values ");
strSql.Append(" (@FileID, @DocNum, @DocTitle, @DocTypeNum, @DocFWZ, @DocFWH, @DocZRZ, @DocTime, @DocWB, @DocMJ, @DocPageNum, @DocGG, @DocZTC,@DocGLDW, @UserID,@InTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameter =
{
new SqlParameter("@FileID", SqlDbType.Int, 4),
new SqlParameter("@DocNum", SqlDbType.Int, 4),
new SqlParameter("@DocTitle", SqlDbType.NVarChar, 255),
new SqlParameter("@DocTypeNum", SqlDbType.NVarChar, 20),
new SqlParameter("@DocFWZ", SqlDbType.NVarChar, 20),
new SqlParameter("@DocFWH", SqlDbType.NVarChar, 4),
new SqlParameter("@DocZRZ", SqlDbType.NVarChar, 50),
new SqlParameter("@DocTime", SqlDbType.NVarChar, 10),
new SqlParameter("@DocWB", SqlDbType.NVarChar, 4),
new SqlParameter("@DocMJ", SqlDbType.NVarChar, 4),
new SqlParameter("@DocPageNum", SqlDbType.Int, 4),
new SqlParameter("@DocGG", SqlDbType.NVarChar, 10),
new SqlParameter("@DocZTC", SqlDbType.NVarChar, 50),
new SqlParameter("@DocGLDW", SqlDbType.NVarChar, 500),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@InTime", SqlDbType.DateTime, 8)
};
parameter[0].Value = FileID;
parameter[1].Value = DocNum;
parameter[2].Value = DocTitle.Trim();
parameter[3].Value = DocTypeNum.Trim();
parameter[4].Value = DocFWZ.Trim();
parameter[5].Value = DocFWH.Trim();
parameter[6].Value = DocZRZ.Trim();
parameter[7].Value = DocTime.Trim();
parameter[8].Value = DocWB.Trim();
parameter[9].Value = DocMJ.Trim();
parameter[10].Value = DocPageNum;
parameter[11].Value = DocGG.Trim();
parameter[12].Value = DocZTC.Trim();
parameter[13].Value = DocGLDW.Trim();
parameter[14].Value = UserID;
parameter[15].Value = System.DateTime.Now;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(int 项目ID,
string 单项工程名称,
string 施工单位,
string 建筑面积,
string 高度,
string 地下层数,
string 地上层数,
string 结构类型,
string 开工时间,
string 竣工时间)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 城建专业记载房屋建筑(");
strSql.Append("项目ID,单项工程名称,施工单位,建筑面积,高度,地下层数,地上层数,结构类型,开工时间,竣工时间)");
strSql.Append(" values (");
strSql.Append("@项目ID,@单项工程名称,@施工单位,@建筑面积,@高度,@地下层数,@地上层数,@结构类型,@开工时间,@竣工时间)");
strSql.Append(";select @@IDENTITY");
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)
};
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 = 竣工时间;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 数据的添加
/// </summary>
/// <returns>true 添加成功 false 添加失败</returns>
public static int insertYj(int 组ID, string 题名, string 时间, string 文字说明,
Image Thumbnail, string ftpFtp目录, string ftpFtp保存名称, int UserID)
{
MemoryStream ms = null;
if (Thumbnail != null)
{
ms = new MemoryStream();
Thumbnail.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ZP_照片(");
strSql.Append("组ID,张号,题名,时间,文字说明,缩略图,Ftp目录,Ftp保存名称,UserID,InTime)");
strSql.Append(" values (");
strSql.Append("@组ID,@张号,@题名,@时间,@文字说明,@缩略图,@Ftp目录,@Ftp保存名称,@UserID,@InTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@组ID", SqlDbType.Int, 4),
new SqlParameter("@张号", SqlDbType.Int, 4),
new SqlParameter("@题名", SqlDbType.NVarChar, 200),
new SqlParameter("@时间", SqlDbType.NVarChar, 10),
new SqlParameter("@文字说明", SqlDbType.NText),
new SqlParameter("@缩略图", SqlDbType.Image),
new SqlParameter("@Ftp目录", SqlDbType.NVarChar, 100),
new SqlParameter("@Ftp保存名称", SqlDbType.NVarChar, 100),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@InTime", SqlDbType.DateTime, 10)
};
parameters[0].Value = 组ID;
parameters[1].Value = getDocNumMax(组ID) + 1;
parameters[2].Value = 题名.Trim();
parameters[3].Value = getDataTime(时间).Trim();
parameters[4].Value = 文字说明.Trim();
parameters[5].Value = (ms == null) ? null : (ms.ToArray());
parameters[6].Value = ftpFtp目录.Trim();
parameters[7].Value = ftpFtp保存名称.Trim();
parameters[8].Value = UserID;
parameters[9].Value = System.DateTime.Now;
object obj = DataSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="ContentID">目录ID</param>
/// <param name="FileNum">案卷号</param>
/// <param name="FileTitle">题名</param>
/// <param name="FileTypeName">分类号</param>
/// <param name="FileClassName">类目名称</param>
/// <param name="FileTime">归档时间</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 InsertFile(int ContentID, int FileNum, string FileTitle, string FileTypeNum, string FileTypeName,
string FileInTime, string FileYear, string FileSecrit, string FileAuthor, string FileChecker, string FileGJH, string FileBZ, int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BZ_案卷(目录ID,案卷号,题名,分类号,类目名称,归档时间,年度,密级,立卷人,检查人,柜架号,备注,UserID,InTime) values");
strSql.Append(" (@ContentID, @FileNum, @FileTitle, @FileTypeNum, @FileTypeName, @FileInTime, @FileYear, @FileSecrit, @FileAuthor, @FileChecker, @FileGJH, @FileBZ,@UserID,@InTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameter =
{
new SqlParameter("@ContentID", SqlDbType.Int, 4),
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("@UserID", SqlDbType.Int, 4),
new SqlParameter("@InTime", SqlDbType.DateTime, 8)
};
parameter[0].Value = ContentID;
parameter[1].Value = FileNum;
parameter[2].Value = FileTitle.Trim();
parameter[3].Value = FileTypeNum.Trim();
parameter[4].Value = FileTypeName.Trim();
parameter[5].Value = FileInTime.Trim();
parameter[6].Value = FileYear.Trim();
parameter[7].Value = FileSecrit.Trim();
parameter[8].Value = FileAuthor.Trim();
parameter[9].Value = FileChecker.Trim();
parameter[10].Value = FileGJH.Trim();
parameter[11].Value = FileBZ.Trim();
parameter[12].Value = UserID;
parameter[13].Value = System.DateTime.Now;
object obj = DataSql.GetSingle(strSql.ToString(), parameter);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public int getMaxYjNum_CJ_New(int docID)
{
string strSql = string.Format("select max(序号) from 城建档案原件 where 城建项目大纲文件ID = {0}", docID);
object obj = DataSql.GetSingle(strSql);
if (Object.Equals(obj, null) || Object.Equals(obj, System.DBNull.Value) || Object.Equals(obj, ""))
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
///// <summary>
///// 获取一级类目列表
///// </summary>
///// <param name="dataAdapter"></param>
///// <returns></returns>
//public DataTable getTopClassList(ref SqlDataAdapter dataAdapter, int 全宗ID)
//{
// StringBuilder selectCommand = new StringBuilder();
// selectCommand.Append("select 类目ID,全宗ID,类目名称,顺序 from 一级类目");
// selectCommand.Append(" where 全宗ID = " + 全宗ID);
// selectCommand.Append(" order by 顺序");
// DataTable table = new DataTable();
// try
// {
// conn.Open();
// dataAdapter = new SqlDataAdapter(selectCommand.ToString(), conn);
// SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
// table.Locale = System.Globalization.CultureInfo.InvariantCulture;
// dataAdapter.Fill(table);
// conn.Close();
// }
// catch (SqlException ex)
// {
// MessageBox.Show(ex.Message);
// }
// return table;
//}
//获取一级类目顺序的最大值
public int getMaxNum(int 全宗ID)
{
string strsql = "select max(顺序)+1 from 一级类目 where 全宗ID = " + 全宗ID;
object obj = DataSql.GetSingle(strsql);
if (obj == null)
{
return(1);
}
else
{
return(int.Parse(obj.ToString()));
}
}
/// <summary>
/// 获取件号的最大值
/// </summary>
/// <param name="FileID">案卷ID</param>
/// <returns>件号的最大值</returns>
public string getDocMaxNum(int ClassID)
{
string strsql = "select max(件号)+1 as 件号 from GD_文件 where 类目ID = " + ClassID;
object obj = DataSql.GetSingle(strsql);
if (obj == null)
{
return("1");
}
else
{
return(obj.ToString());
}
}
