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); } } }
public bool SaveNewFlowProperties(SinoSZToolFlowDesign.DOL.Flow_BaseDefine flow_BaseDefine) { string _insertStr = "insert into [FLOW_ENTITYTYPE]"; _insertStr += " ([ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID]) values (@ID,@FLOWNAME,@DESCRIPTION,@ROOTDWID) "; using (OleDbConnection cn = OpenConnection(connectString)) { try { OleDbCommand _cmd = new OleDbCommand(_insertStr, cn); _cmd.Parameters.Add(new OleDbParameter("@ID", flow_BaseDefine.ID)); _cmd.Parameters.Add(new OleDbParameter("@FLOWNAME", flow_BaseDefine.FlowName)); _cmd.Parameters.Add(new OleDbParameter("@DESCRIPTION", flow_BaseDefine.Description)); _cmd.Parameters.Add(new OleDbParameter("@ROOTDWID", Double.Parse(flow_BaseDefine.RootDWID))); _cmd.ExecuteNonQuery(); cn.Close(); return(true); } catch (Exception e) { //写系统错误日志 throw e; return(false); } } }
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); } } }