/// <summary>
/// 用唯一值实现Equals
/// </summary>
public override bool Equals(object obj)
{
if (this == obj)
{
return(true);
}
if ((obj == null) || (obj.GetType() != GetType()))
{
return(false);
}
Item_File castObj = (Item_File)obj;
return((castObj != null) &&
(this.FileName == castObj.FileName));
}
/// <summary>
/// 获取项目文件(按多个环节)
/// </summary>
/// <param name="itemCode"></param>
/// <param name="node"></param>
/// <returns></returns>
public List<Item_File> GetItemFileByNode(string itemCode, string node)
{
string strSql = " select a.*, decode(a.filecode, 0, '其它文件', b.filename) FileType"
+ " from item_file a left join wf_file b on a.filecode = b.filecode"
+ " Where a.ItemCode = '{0}' and a.NodeId in ({1}) order by a.nodeid,a.filecode";
strSql = string.Format(strSql, itemCode, node);
IDataReader dr = OracleHelper.ExecuteReader(strSql);
List<Item_File> fileList = new List<Item_File>();
while (dr.Read())
{
Item_File file = new Item_File();
file.ItemCode = dr["ItemCode"].ToString();
file.FileCode = dr["FileCode"].ToString();
file.FileCodeName = dr["FileType"].ToString();
file.FileName = dr["FileName"].ToString();
file.Stage = (ItemStage)EnumHelper.StringValueToEnum(typeof(ItemStage), dr["Stage"].ToString());
file.NodeId = (WorkFlowNode)EnumHelper.StringValueToEnum(typeof(WorkFlowNode), dr["NodeId"].ToString());
file.UserId = dr["UserId"].ToString();
file.UserName = dr["UserName"].ToString();
file.CreateDate = TypeConvert.Convert<DateTime?>(dr["CreateDate"]);
fileList.Add(file);
}
dr.Close();
return fileList;
}
public List<Item_File> GetItemFileAfterExclude(string itemCode, WorkFlowNode wfNode, List<FileCode> excludeFileCodes)
{
string strSql = " select a.*, decode(a.filecode, 0, '其它文件', b.filename) FileType"
+ " from item_file a left join wf_file b on a.filecode = b.filecode"
+ " Where a.ItemCode = '{0}' and a.NodeId = '{1}' and a.filecode not in ({2})";
string[] fileCodes = (from record in excludeFileCodes select "'" + ((int)record).ToString() + "'").Distinct().ToArray();
strSql = string.Format(strSql, itemCode, (int)wfNode, string.Join(",", fileCodes));
IDataReader dr = OracleHelper.ExecuteReader(strSql);
List<Item_File> fileList = new List<Item_File>();
while (dr.Read())
{
Item_File file = new Item_File();
file.ItemCode = dr["ItemCode"].ToString();
file.FileCode = dr["FileCode"].ToString();
file.FileCodeName = dr["FileType"].ToString();
file.FileName = dr["FileName"].ToString();
file.Stage = (ItemStage)EnumHelper.StringValueToEnum(typeof(ItemStage), dr["Stage"].ToString());
file.NodeId = (WorkFlowNode)EnumHelper.StringValueToEnum(typeof(WorkFlowNode), dr["NodeId"].ToString());
file.UserId = dr["UserId"].ToString();
file.UserName = dr["UserName"].ToString();
file.CreateDate = TypeConvert.Convert<DateTime?>(dr["CreateDate"]);
fileList.Add(file);
}
dr.Close();
return fileList;
}
/// <summary>
/// 获取项目文件
/// </summary>
/// <param name="itemCode"></param>
/// <returns></returns>
public List<Item_File> GetItemFile(string itemCode, WorkFlowNode wfNode, string fileCode, string xh)
{
List<object> parameters = new List<object>();
string strSql = " select a.*, decode(a.filecode, 0, '其它文件', b.filename) FileType"
+ " from item_file a left join wf_file b on a.filecode = b.filecode"
+ " Where a.ItemCode = '{0}' and a.NodeId = '{1}' and a.filecode = '{2}'";
parameters.Add(itemCode);
parameters.Add((int)wfNode);
parameters.Add(fileCode);
if (!string.IsNullOrEmpty(xh))
{
strSql += " and a.xh='{3}'";
parameters.Add(xh);
}
strSql = string.Format(strSql, parameters.ToArray());
IDataReader dr = OracleHelper.ExecuteReader(strSql);
List<Item_File> fileList = new List<Item_File>();
while (dr.Read())
{
Item_File file = new Item_File();
file.ItemCode = dr["ItemCode"].ToString();
file.FileCode = dr["FileCode"].ToString();
file.FileCodeName = dr["FileType"].ToString();
file.FileName = dr["FileName"].ToString();
file.Stage = (ItemStage)EnumHelper.StringValueToEnum(typeof(ItemStage), dr["Stage"].ToString());
file.NodeId = (WorkFlowNode)EnumHelper.StringValueToEnum(typeof(WorkFlowNode), dr["NodeId"].ToString());
file.UserId = dr["UserId"].ToString();
file.UserName = dr["UserName"].ToString();
file.CreateDate = TypeConvert.Convert<DateTime?>(dr["CreateDate"]);
fileList.Add(file);
}
dr.Close();
return fileList;
}