public bool SaveFlowState(SinoSZToolFlowDesign.DOL.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";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_updateStr, cn);
_cmd.Parameters.Add(new OleDbParameter("@STATENAME", flow_StateDefine.Name));
_cmd.Parameters.Add(new OleDbParameter("@STATEDISPLAYNAME", flow_StateDefine.DisplayName));
_cmd.Parameters.Add(new OleDbParameter("@STATEDESCRIPT", flow_StateDefine.Description));
_cmd.Parameters.Add(new OleDbParameter("@STATETYPE", flow_StateDefine.Type));
_cmd.Parameters.Add(new OleDbParameter("@DISPLAYORDER", Convert.ToDouble(flow_StateDefine.Order)));
_cmd.Parameters.Add(new OleDbParameter("@ID", flow_StateDefine.ID));
_cmd.ExecuteNonQuery();
cn.Close();
return(true);
}
catch (Exception e)
{
throw e;
//写系统错误日志
return(false);
}
}
}
public Flow_LocationStateMapItem(string _id, Flow_StateDefine _state, Flow_Location _location, decimal _type, string _meta)
{
id = _id;
state = _state;
location = _location;
type = _type;
showMeta = _meta;
}
public Flow_StateActionDefine(string _actionID, string _actionName, string _actionTitle, Flow_StateDefine _beginState, Flow_StateDefine _endState,
string _actionType, int _userType, int _order, string _param)
{
actionID = _actionID;
actionName = _actionName;
actionTitle = _actionTitle;
beginState = _beginState;
endState = _endState;
actionType = _actionType;
userType = _userType;
displayOrder = _order;
param = _param;
}
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 bool SaveNewFlowState(SinoSZToolFlowDesign.DOL.Flow_BaseDefine flow_BaseDefine, SinoSZToolFlowDesign.DOL.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) ";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_insertStr, cn);
_cmd.Parameters.Add(new OleDbParameter("@ID", flow_StateDefine.ID));
_cmd.Parameters.Add(new OleDbParameter("@FLOWID", flow_BaseDefine.ID));
_cmd.Parameters.Add(new OleDbParameter("@STATENAME", flow_StateDefine.Name));
_cmd.Parameters.Add(new OleDbParameter("@STATEDISPLAYNAME", flow_StateDefine.DisplayName));
_cmd.Parameters.Add(new OleDbParameter("@STATEDESCRIPT", flow_StateDefine.Description));
_cmd.Parameters.Add(new OleDbParameter("@STATETYPE", flow_StateDefine.Type));
_cmd.Parameters.Add(new OleDbParameter("@DISPLAYORDER", Convert.ToDouble(flow_StateDefine.Order)));
_cmd.ExecuteNonQuery();
cn.Close();
return(true);
}
catch (Exception e)
{
throw e;
//写系统错误日志
return(false);
}
}
}