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