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