/// <summary>
/// 用唯一值实现Equals
/// </summary>
public override bool Equals(object obj)
{
if (this == obj)
{
return(true);
}
if ((obj == null) || (obj.GetType() != GetType()))
{
return(false);
}
WfFile castObj = (WfFile)obj;
return((castObj != null) &&
(filecode == castObj.FileCode));
}
/// <summary>
/// 获取全部文档
/// </summary>
/// <returns></returns>
public IList<WfFile> GetWfFIle()
{
IList<WfFile> datalist = new List<WfFile>();
string strSql = "select * from wf_file order by FileCode";
IDataReader dr = OracleHelper.ExecuteReader(strSql);
while (dr.Read())
{
WfFile fileEntity = new WfFile();
fileEntity.FileCode = dr["FileCode"].ToString();
fileEntity.FileName = dr["FileName"].ToString();
fileEntity.FileType = dr["FileType"].ToString();
datalist.Add(fileEntity);
}
dr.Close();
return datalist;
}
/// <summary>
/// 获取环节对应的文档权限
/// </summary>
/// <param name="wffile"></param>
/// <returns></returns>
public IList<WfFile> GetWfFIle(WfFile wffile)
{
IList<WfFile> datalist = new List<WfFile>();
string strWhere = string.Empty;
if (string.IsNullOrEmpty(wffile.FileCode))
{
return datalist;
}
strWhere += "FileCode In (" + wffile.FileCode + ") And ";
string strSql = "select * from wf_file where {0} 1 = 1 order by OrderNo,FileCode";
strSql = string.Format(strSql, strWhere);
IDataReader dr = OracleHelper.ExecuteReader(strSql);
while (dr.Read())
{
WfFile fileEntity = new WfFile();
fileEntity.FileCode = dr["FileCode"].ToString();
fileEntity.FileName = dr["FileName"].ToString();
fileEntity.FileType = dr["FileType"].ToString();
datalist.Add(fileEntity);
}
dr.Close();
return datalist;
}
