/// <summary>
/// 通过流程ID取得所有申请节点
/// </summary>
/// <param name="processId"></param>
/// <returns></returns>
public IList <RequestNodeInfo> GetRequestNodeByProcessID(string processId)
{
//Guid ProcessID = Guid.Empty;
//try
//{
// ProcessID = new Guid(processId);
//}
//catch
//{
// return null;
//}
DataSet ds = dal.GetRequestNodeByProcessID(processId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <RequestNodeInfo> rnList = new List <RequestNodeInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
RequestNodeInfo info = new RequestNodeInfo();
info.NodeID = new Guid(dr["NodeID"].ToString());
info.NodeName = dr["NodeName"].ToString();
info.ProcessID = dr["ProcessID"].ToString();
info.Expression = dr["Expression"].ToString();
info.CreatedBy = dr["CreatedBy"].ToString();
info.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
info.State = Convert.ToBoolean(dr["State"]);
rnList.Add(info);
}
return(rnList);
}
return(null);
}
/// <summary>
/// 通过NodeId获得流程入口节点信息
/// </summary>
/// <param name="nodeId"></param>
/// <returns></returns>
public RequestNodeInfo GetRequestNodeByNodeId(string nodeId)
{
Guid NodeID = Guid.Empty;
try
{
NodeID = new Guid(nodeId);
}
catch (Exception ex)
{
return(null);
}
DataSet ds = dal.GetRequestNodeByNodeId(NodeID);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
RequestNodeInfo info = new RequestNodeInfo();
info.NodeID = new Guid(dr["NodeID"].ToString());
info.NodeName = dr["NodeName"].ToString();
info.ProcessID = dr["ProcessID"].ToString();
info.Expression = dr["Expression"].ToString();
info.CreatedBy = dr["CreatedBy"].ToString();
info.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
info.State = Convert.ToBoolean(dr["State"]);
return(info);
}
return(null);
}
/// <summary>
/// 当为编辑状态(edit)时绑定数据
/// </summary>
private void BindData()
{
ProcessRuleBLL bll = new ProcessRuleBLL();
RequestNodeInfo info = bll.GetRequestNodeByNodeId(NodeID);
if (info != null)
{
txtNodeName.Text = info.NodeName;
txtExpression.Text = info.Expression;
hfProcessID.Value = info.ProcessID.ToString();
}
}
/// <summary>
/// 创建页面对象
/// </summary>
/// <returns></returns>
private RequestNodeInfo CreateObject()
{
RequestNodeInfo info = new RequestNodeInfo();
info.NodeName = txtNodeName.Text;
info.ProcessID = ProcessID;
info.Expression = txtExpression.Text;
if (!string.IsNullOrEmpty(NodeID) && NodeID != "undefined")
{
info.NodeID = new Guid(NodeID);
}
return(info);
}
/// <summary>
/// 更新节点
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool UpdateRequestNode(RequestNodeInfo info)
{
try
{
string sql = "SProc_Admin_UpdateRequestNode";
SqlParameter[] parms =
{
new SqlParameter("@NodeID", info.NodeID),
new SqlParameter("@NodeName", info.NodeName),
new SqlParameter("@Expression", info.Expression)
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, sql, parms);
return(true);
}
catch (Exception ex)
{
//DBManager.RecoreErrorProfile(ex, "ProcessRuleDAL.UpdateRequestNode", HttpContext.Current.User.Identity.Name);
return(false);
}
}
/// <summary>
/// 取得指定的审批节点
/// </summary>
/// <param name="nodeIds"></param>
/// <returns></returns>
public IList <RequestNodeInfo> GetRequestNodesByNodeIds(string nodeIds)
{
DataSet ds = dal.GetRequestNodesByNodeIds(nodeIds);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <RequestNodeInfo> rnList = new List <RequestNodeInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
RequestNodeInfo info = new RequestNodeInfo();
info.NodeID = new Guid(dr["NodeID"].ToString());
info.NodeName = dr["NodeName"].ToString();
info.ProcessID = dr["ProcessID"].ToString();
info.Expression = dr["Expression"].ToString();
info.CreatedBy = dr["CreatedBy"].ToString();
info.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
info.State = Convert.ToBoolean(dr["State"]);
rnList.Add(info);
}
return(rnList);
}
return(null);
}
/// <summary>
/// 更新节点
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool UpdateRequestNode(RequestNodeInfo info)
{
return(dal.UpdateRequestNode(info));
}
/// <summary>
/// 插入申请节点
/// </summary>
/// <param name="rn"></param>
/// <returns></returns>
public bool InsertRequestNode(RequestNodeInfo rn)
{
return(dal.InsertRequestNode(rn));
}
