public List <Flow_StateDefine> GetFlowStatusByFlow(Flow_BaseDefine flow_BaseDefine)
{
List <Flow_StateDefine> _ret = new List <Flow_StateDefine>();
string _sql = "select ID,STATENAME,STATEDISPLAYNAME,STATEDESCRIPT,STATETYPE,DISPLAYORDER ";
_sql += " FROM FLOW_ENTITYSTATUS where FLOWID = @FLOWID";
SqlParameter[] _param = { new SqlParameter("@FLOWID", SqlDbType.NVarChar, 50) };
_param[0].Value = flow_BaseDefine.ID;
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(connectString, CommandType.Text, _sql, _param);
while (dr.Read())
{
Flow_StateDefine _fd = new Flow_StateDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "" : dr.GetString(3),
dr.IsDBNull(4) ? "" : dr.GetString(4),
dr.IsDBNull(5) ? 0 : Convert.ToInt32(dr.GetDecimal(5))
);
_ret.Add(_fd);
}
dr.Close();
return(_ret);
}
catch (Exception e)
{
//写系统错误日志
return(null);
}
}
public bool SaveFlowState(Flow_StateDefine flow_StateDefine)
{
string _updateStr = "update FLOW_ENTITYSTATUS";
_updateStr += " set STATENAME=@STATENAME,STATEDISPLAYNAME=@STATEDISPLAYNAME,STATEDESCRIPT=@STATEDESCRIPT,STATETYPE=@STATETYPE, ";
_updateStr += " DISPLAYORDER=@DISPLAYORDER where ID=@ID";
SqlParameter[] _param2 =
{
new SqlParameter("@STATENAME", SqlDbType.NVarChar, 50),
new SqlParameter("@STATEDISPLAYNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@STATEDESCRIPT", SqlDbType.NVarChar, 1000),
new SqlParameter("@STATETYPE", SqlDbType.NVarChar, 10),
new SqlParameter("@DISPLAYORDER", SqlDbType.Decimal),
new SqlParameter("@ID", SqlDbType.NVarChar, 50)
};
_param2[0].Value = flow_StateDefine.Name;
_param2[1].Value = flow_StateDefine.DisplayName;
_param2[2].Value = flow_StateDefine.Description;
_param2[3].Value = flow_StateDefine.Type;
_param2[4].Value = Convert.ToDecimal(flow_StateDefine.Order);
_param2[5].Value = flow_StateDefine.ID;
try
{
SqlHelper.ExecuteNonQuery(connectString, CommandType.Text, _updateStr, _param2);
return(true);
}
catch (Exception e)
{
//写系统错误日志
return(false);
}
}
public List <SinoSZToolFlowDesign.DOL.Flow_StateActionDefine> GetFlowStatusAction(SinoSZToolFlowDesign.DOL.Flow_StateDefine flow_StateDefine)
{
List <Flow_StateActionDefine> _ret = new List <Flow_StateActionDefine>();
string _sql = "select A.[ID],A.[ACTIONNAME],A.[ACTIONTITLE], ";
_sql += "B.[ID],B.[STATENAME],B.[STATEDISPLAYNAME],B.[STATEDESCRIPT],B.[STATETYPE],B.[DISPLAYORDER], ";
_sql += "A.[ACTIONTYPE],A.[USERTYPE],A.[DISPLAYORDER],A.[ACTIONPARAM] ";
_sql += " FROM [FLOW_STATETRANSITION] A,[FLOW_ENTITYSTATUS] B where A.[STATEID] = @STATEID ";
_sql += " and B.[ID] = A.[TARGETSTATEID] ";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_sql, cn);
_cmd.Parameters.Add(new OleDbParameter("@STATEID", flow_StateDefine.ID));
OleDbDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
Flow_StateDefine _endStateDefine = new Flow_StateDefine(dr.IsDBNull(3) ? "" : dr.GetString(3),
dr.IsDBNull(4) ? "" : dr.GetString(4),
dr.IsDBNull(5) ? "" : dr.GetString(5),
dr.IsDBNull(6) ? "" : dr.GetString(6),
dr.IsDBNull(7) ? "" : dr.GetString(7),
dr.IsDBNull(8) ? 0 : Convert.ToInt32(dr.GetDecimal(8))
);
Flow_StateActionDefine _sa = new Flow_StateActionDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
flow_StateDefine,
_endStateDefine,
dr.IsDBNull(9) ? "" : dr.GetString(9),
dr.IsDBNull(10) ? 0 : Convert.ToInt32(dr.GetDecimal(10)),
dr.IsDBNull(11) ? 0 : Convert.ToInt32(dr.GetDecimal(11)),
dr.IsDBNull(12) ? "" : dr.GetString(12)
);
_ret.Add(_sa);
}
dr.Close();
cn.Close();
return(_ret);
}
catch (Exception e)
{
throw e;
//写系统错误日志
return(null);
}
}
}
public List <Flow_StateActionDefine> GetFlowStatusAction(Flow_StateDefine flow_StateDefine)
{
List <Flow_StateActionDefine> _ret = new List <Flow_StateActionDefine>();
string _sql = "select A.ID,A.ACTIONNAME,A.ACTIONTITLE, ";
_sql += "B.ID,B.STATENAME,B.STATEDISPLAYNAME,B.STATEDESCRIPT,B.STATETYPE,B.DISPLAYORDER, ";
_sql += "A.ACTIONTYPE,A.USERTYPE,A.DISPLAYORDER,A.ACTIONPARAM ";
_sql += " FROM FLOW_STATETRANSITION A,FLOW_ENTITYSTATUS B where A.STATEID = @STATEID ";
_sql += " and B.ID = A.TARGETSTATEID ";
SqlParameter[] _param = { new SqlParameter("@STATEID", SqlDbType.NVarChar, 50) };
_param[0].Value = flow_StateDefine.ID;
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(connectString, CommandType.Text, _sql, _param);
while (dr.Read())
{
Flow_StateDefine _endStateDefine = new Flow_StateDefine(dr.IsDBNull(3) ? "" : dr.GetString(3),
dr.IsDBNull(4) ? "" : dr.GetString(4),
dr.IsDBNull(5) ? "" : dr.GetString(5),
dr.IsDBNull(6) ? "" : dr.GetString(6),
dr.IsDBNull(7) ? "" : dr.GetString(7),
dr.IsDBNull(8) ? 0 : Convert.ToInt32(dr.GetDecimal(8))
);
Flow_StateActionDefine _sa = new Flow_StateActionDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
flow_StateDefine,
_endStateDefine,
dr.IsDBNull(9) ? "" : dr.GetString(9),
dr.IsDBNull(10) ? 0 : Convert.ToInt32(dr.GetDecimal(10)),
dr.IsDBNull(11) ? 0 : Convert.ToInt32(dr.GetDecimal(11)),
dr.IsDBNull(12) ? "" : dr.GetString(12)
);
_ret.Add(_sa);
}
dr.Close();
return(_ret);
}
catch (Exception e)
{
//写系统错误日志
return(null);
}
}
internal Biz_FlowState GetStateDefine(Flow_StateDefine flow_StateDefine)
{
if (flow_StateDefine == null)
{
return(null);
}
foreach (Biz_FlowState _st in this.Status)
{
if (_st.StateID == flow_StateDefine.ID)
{
return(_st);
}
}
return(null);
}
public List <SinoSZToolFlowDesign.DOL.Flow_StateDefine> GetFlowStatusByFlow(SinoSZToolFlowDesign.DOL.Flow_BaseDefine flow_BaseDefine)
{
List <Flow_StateDefine> _ret = new List <Flow_StateDefine>();
string _sql = "select [ID],[STATENAME],[STATEDISPLAYNAME],[STATEDESCRIPT],[STATETYPE],[DISPLAYORDER] ";
_sql += " FROM [FLOW_ENTITYSTATUS] where [FLOWID] = @FLOWID";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_sql, cn);
_cmd.Parameters.Add(new OleDbParameter("@FLOWID", flow_BaseDefine.ID));
OleDbDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
Flow_StateDefine _fd = new Flow_StateDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "" : dr.GetString(3),
dr.IsDBNull(4) ? "" : dr.GetString(4),
dr.IsDBNull(5) ? 0 : Convert.ToInt32(dr.GetDecimal(5))
);
_ret.Add(_fd);
}
dr.Close();
cn.Close();
return(_ret);
}
catch (Exception e)
{
throw e;
//写系统错误日志
return(null);
}
}
}
/// <summary>
/// 保存新状态
/// </summary>
/// <param name="flow_BaseDefine"></param>
/// <param name="flow_StateDefine"></param>
/// <returns></returns>
public bool SaveNewFlowState(Flow_BaseDefine flow_BaseDefine, Flow_StateDefine flow_StateDefine)
{
string _insertStr = "insert into FLOW_ENTITYSTATUS";
_insertStr += " (ID,FLOWID,STATENAME,STATEDISPLAYNAME,STATEDESCRIPT,STATETYPE,DISPLAYORDER) ";
_insertStr += " values (@ID,@FLOWID,@STATENAME,@STATEDISPLAYNAME,@STATEDESCRIPT,@STATETYPE,@DISPLAYORDER) ";
SqlParameter[] _param2 =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@FLOWID", SqlDbType.NVarChar, 50),
new SqlParameter("@STATENAME", SqlDbType.NVarChar, 50),
new SqlParameter("@STATEDISPLAYNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@STATEDESCRIPT", SqlDbType.NVarChar, 1000),
new SqlParameter("@STATETYPE", SqlDbType.NVarChar, 10),
new SqlParameter("@DISPLAYORDER", SqlDbType.Decimal)
};
_param2[0].Value = flow_StateDefine.ID;
_param2[1].Value = flow_BaseDefine.ID;
_param2[2].Value = flow_StateDefine.Name;
_param2[3].Value = flow_StateDefine.DisplayName;
_param2[4].Value = flow_StateDefine.Description;
_param2[5].Value = flow_StateDefine.Type;
_param2[6].Value = Convert.ToDecimal(flow_StateDefine.Order);
try
{
SqlHelper.ExecuteNonQuery(connectString, CommandType.Text, _insertStr, _param2);
return(true);
}
catch
{
//写系统错误日志
return(false);
}
}
public Biz_FlowState(Biz_FlowProperties _flow, Flow_StateDefine _state)
{
_isNew = false;
this.flow = _flow;
this.stateDefine = (Flow_StateDefine)_state.Clone();
}
