/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TOaArchivesDirectoryVo tOaArchivesDirectory, int iIndex, int iCount)
{
string strSQL = " select * from T_OA_ARCHIVES_DIRECTORY {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tOaArchivesDirectory));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取子级文档目录最大排序号
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <returns></returns>
public string getNum(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = "select MAX(NUM) from T_OA_ARCHIVES_DIRECTORY";
strSQL += BuildWhereStatement(tOaArchivesDirectory);
return(SqlHelper.ExecuteScalar(strSQL).ToString());
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaArchivesDirectory_UpdateSet">UpdateSet用户对象</param>
/// <param name="tOaArchivesDirectory_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaArchivesDirectoryVo tOaArchivesDirectory_UpdateSet, TOaArchivesDirectoryVo tOaArchivesDirectory_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tOaArchivesDirectory_UpdateSet, TOaArchivesDirectoryVo.T_OA_ARCHIVES_DIRECTORY_TABLE);
strSQL += this.BuildWhereStatement(tOaArchivesDirectory_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaArchivesDirectory">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = SqlHelper.BuildUpdateExpress(tOaArchivesDirectory, TOaArchivesDirectoryVo.T_OA_ARCHIVES_DIRECTORY_TABLE);
strSQL += string.Format(" where ID='{0}' ", tOaArchivesDirectory.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tOaArchivesDirectory"></param>
/// <returns></returns>
public string BuildWhereStatement(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tOaArchivesDirectory)
{
//主键
if (!String.IsNullOrEmpty(tOaArchivesDirectory.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tOaArchivesDirectory.ID.ToString()));
}
//目录名称
if (!String.IsNullOrEmpty(tOaArchivesDirectory.DIRECTORY_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DIRECTORY_NAME = '{0}'", tOaArchivesDirectory.DIRECTORY_NAME.ToString()));
}
//父目录ID，如果为根目录，则存储“0”
if (!String.IsNullOrEmpty(tOaArchivesDirectory.PARENT_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PARENT_ID = '{0}'", tOaArchivesDirectory.PARENT_ID.ToString()));
}
//使用状态(0为启用、1为停用)
if (!String.IsNullOrEmpty(tOaArchivesDirectory.IS_USE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_USE = '{0}'", tOaArchivesDirectory.IS_USE.ToString()));
}
//序号
if (!String.IsNullOrEmpty(tOaArchivesDirectory.NUM.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND NUM = '{0}'", tOaArchivesDirectory.NUM.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tOaArchivesDirectory.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tOaArchivesDirectory.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tOaArchivesDirectory.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tOaArchivesDirectory.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tOaArchivesDirectory.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tOaArchivesDirectory.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tOaArchivesDirectory.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tOaArchivesDirectory.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tOaArchivesDirectory.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tOaArchivesDirectory.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = "delete from T_OA_ARCHIVES_DIRECTORY ";
strSQL += this.BuildWhereStatement(tOaArchivesDirectory);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取档案文件目录
/// </summary>
/// <returns></returns>
protected string getFileInfo()
{
TOaArchivesDirectoryVo objArchiverDirectory = new TOaArchivesDirectoryVo();
objArchiverDirectory.IS_USE = "0";
DataTable dtDirectory = new TOaArchivesDirectoryLogic().SelectByTable(objArchiverDirectory);
return(LigerGridTreeDataToJson(dtDirectory, "PARENT_ID='0'", "ID", "PARENT_ID", "DIRECTORY_NAME"));
}
/// <summary>
/// 更新节点
/// </summary>
/// <returns></returns>
protected string editRoot()
{
TOaArchivesDirectoryVo objArchiverDirectory = new TOaArchivesDirectoryVo();
TOaArchivesDirectoryLogic objArchiverDirectoryLogic = new TOaArchivesDirectoryLogic();
objArchiverDirectory.ID = Request.QueryString["id"];
objArchiverDirectory.IS_USE = "0";
objArchiverDirectory.DIRECTORY_NAME = Request.QueryString["name"];
if (objArchiverDirectoryLogic.Edit(objArchiverDirectory))
{
WriteLog("编辑文件目录", "", LogInfo.UserInfo.USER_NAME + "编辑文件目录" + objArchiverDirectory.ID);
return("true");
}
return("false");
}
/// <summary>
/// 删除文档目录（级联删除其所有子目录）
/// </summary>
/// <returns></returns>
protected string delRoot()
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
TOaArchivesDirectoryVo objArchiverDirectory = new TOaArchivesDirectoryVo();
objArchiverDirectory.IS_USE = "0";
DataTable dtDirectory = new TOaArchivesDirectoryLogic().SelectByTable(objArchiverDirectory);
string strAllID = GetAllSonByParent(dtDirectory, "PARENT_ID='" + Request.QueryString["id"] + "'", "ID", "PARENT_ID", "DIRECTORY_NAME");
strAllID = strAllID.Length > 0 ? (Request.QueryString["id"] + "," + strAllID) : Request.QueryString["id"];
if (strAllID != "" && new TOaArchivesDirectoryLogic().DeleteTran(strAllID))
{
WriteLog("删除文档目录及其子目录", "", LogInfo.UserInfo.USER_NAME + "删除文档目录及其子目录");
return("true");
}
}
return("false");
}
/// <summary>
/// 添加文档目录
/// </summary>
/// <returns>返回Json</returns>
protected string addRoot()
{
TOaArchivesDirectoryVo objArchiverDirectory = new TOaArchivesDirectoryVo();
TOaArchivesDirectoryLogic objArchiverDirectoryLogic = new TOaArchivesDirectoryLogic();
objArchiverDirectory.PARENT_ID = Request.QueryString["parent_id"];
objArchiverDirectory.IS_USE = "0";
//生成子目录序号
try
{
objArchiverDirectory.NUM = (Int32.Parse(objArchiverDirectoryLogic.getNum(objArchiverDirectory)) + 1).ToString();
}
catch
{
objArchiverDirectory.NUM = "1";
}
objArchiverDirectory.DIRECTORY_NAME = "新建文件夹" + objArchiverDirectory.NUM;
objArchiverDirectory.ID = GetSerialNumber("t_oa_archives_directoty_id");
if (objArchiverDirectoryLogic.Create(objArchiverDirectory))
{
WriteLog("添加文件目录", "", LogInfo.UserInfo.USER_NAME + "添加文件目录" + objArchiverDirectory.ID);
}
return(ToJson(objArchiverDirectory));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tOaArchivesDirectory"></param>
/// <returns></returns>
public DataTable SelectByTable(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = "select * from T_OA_ARCHIVES_DIRECTORY " + this.BuildWhereStatement(tOaArchivesDirectory);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaArchivesDirectory_UpdateSet">UpdateSet用户对象</param>
/// <param name="tOaArchivesDirectory_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaArchivesDirectoryVo tOaArchivesDirectory_UpdateSet, TOaArchivesDirectoryVo tOaArchivesDirectory_UpdateWhere)
{
return(access.Edit(tOaArchivesDirectory_UpdateSet, tOaArchivesDirectory_UpdateWhere));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TOaArchivesDirectoryVo> SelectByObject(TOaArchivesDirectoryVo tOaArchivesDirectory, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_OA_ARCHIVES_DIRECTORY " + this.BuildWhereStatement(tOaArchivesDirectory));
return(SqlHelper.ExecuteObjectList(tOaArchivesDirectory, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.Delete(tOaArchivesDirectory));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TOaArchivesDirectoryVo tOaArchivesDirectory, int iIndex, int iCount)
{
return(access.SelectByTable(tOaArchivesDirectory, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tOaArchivesDirectory">对象条件</param>
/// <returns>对象</returns>
public TOaArchivesDirectoryVo Details(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = String.Format("select * from T_OA_ARCHIVES_DIRECTORY " + this.BuildWhereStatement(tOaArchivesDirectory));
return(SqlHelper.ExecuteObject(new TOaArchivesDirectoryVo(), strSQL));
}
public TOaArchivesDirectoryLogic(TOaArchivesDirectoryVo _tOaArchivesDirectory)
{
tOaArchivesDirectory = _tOaArchivesDirectory;
access = new TOaArchivesDirectoryAccess();
}
/// <summary>
/// 获取文档目录排序号
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <returns></returns>
public string getNum(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.getNum(tOaArchivesDirectory));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tOaArchivesDirectory">对象条件</param>
/// <returns>对象</returns>
public TOaArchivesDirectoryVo Details(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.Details(tOaArchivesDirectory));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.GetSelectResultCount(tOaArchivesDirectory));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.Create(tOaArchivesDirectory));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <returns>是否成功</returns>
public bool Create(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = SqlHelper.BuildInsertExpress(tOaArchivesDirectory, TOaArchivesDirectoryVo.T_OA_ARCHIVES_DIRECTORY_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tOaArchivesDirectory"></param>
/// <returns></returns>
public DataTable SelectByTable(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.SelectByTable(tOaArchivesDirectory));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaArchivesDirectory">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.Edit(tOaArchivesDirectory));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
string strSQL = "select Count(*) from T_OA_ARCHIVES_DIRECTORY " + this.BuildWhereStatement(tOaArchivesDirectory);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <returns></returns>
public TOaArchivesDirectoryVo SelectByObject(TOaArchivesDirectoryVo tOaArchivesDirectory)
{
return(access.SelectByObject(tOaArchivesDirectory));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tOaArchivesDirectory">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TOaArchivesDirectoryVo> SelectByObject(TOaArchivesDirectoryVo tOaArchivesDirectory, int iIndex, int iCount)
{
return(access.SelectByObject(tOaArchivesDirectory, iIndex, iCount));
}
