public SinoSZToolFlowDesign.DOL.Flow_BaseDefine GetFlowPropertiesByName(string _flowName)
{
Flow_BaseDefine _ret = null;
string _sql = "select [ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID] FROM [FLOW_ENTITYTYPE] ";
_sql += " where [FLOWNAME] = @FLOWNAME ";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_sql, cn);
_cmd.Parameters.Add(new OleDbParameter("@FLOWNAME", _flowName));
OleDbDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
_ret = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString()
);
}
dr.Close();
cn.Close();
return(_ret);
}
catch (Exception e)
{
throw e;
//写系统错误日志
return(null);
}
}
}
public List <SinoSZToolFlowDesign.DOL.Flow_BaseDefine> GetFlows()
{
List <Flow_BaseDefine> _ret = new List <Flow_BaseDefine>();
string _sql = "select [ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID] FROM [FLOW_ENTITYTYPE]";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_sql, cn);
OleDbDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
Flow_BaseDefine _fd = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString()
);
_ret.Add(_fd);
}
dr.Close();
cn.Close();
return(_ret);
}
catch (Exception e)
{
//写系统错误日志
throw e;
return(null);
}
}
}
public bool SaveNewFlowProperties(Flow_BaseDefine flow_BaseDefine)
{
string _insertStr = "insert into FLOW_ENTITYTYPE";
_insertStr += " (ID,FLOWNAME,DESCRIPTION,ROOTDWID) values (@ID,@FLOWNAME,@DESCRIPTION,@ROOTDWID) ";
SqlParameter[] _param2 =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@FLOWNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar, 1000),
new SqlParameter("@ROOTDWID", SqlDbType.Decimal)
};
_param2[0].Value = flow_BaseDefine.ID;
_param2[1].Value = flow_BaseDefine.FlowName;
_param2[2].Value = flow_BaseDefine.Description;
_param2[3].Value = decimal.Parse(flow_BaseDefine.RootDWID);
try
{
SqlHelper.ExecuteNonQuery(connectString, CommandType.Text, _insertStr, _param2);
return(true);
}
catch
{
//写系统错误日志
return(false);
}
}
public Flow_BaseDefine GetFlowProperties(string _id)
{
Flow_BaseDefine _ret = null;
string _sql = "select ID,FLOWNAME,DESCRIPTION,ROOTDWID FROM FLOW_ENTITYTYPE";
_sql += " where ID = @ID ";
SqlParameter[] _param = { new SqlParameter("@ID", SqlDbType.NVarChar, 50) };
_param[0].Value = _id;
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(connectString, CommandType.Text, _sql, _param);
while (dr.Read())
{
_ret = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString()
);
}
dr.Close();
return(_ret);
}
catch (Exception e)
{
//写系统错误日志
return(null);
}
}
public bool SaveFlowProperties(Flow_BaseDefine flow_BaseDefine)
{
string _updateStr = "update FLOW_ENTITYTYPE";
_updateStr += " set DESCRIPTION=@DESCRIPTION,FLOWNAME=@FLOWNAME,ROOTDWID=@ROOTDWID ";
_updateStr += " where ID=@ID";
SqlParameter[] _param2 =
{
new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar, 1000),
new SqlParameter("@FLOWNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@ROOTDWID", SqlDbType.Decimal),
new SqlParameter("@ID", SqlDbType.NVarChar, 50)
};
_param2[0].Value = flow_BaseDefine.Description;
_param2[1].Value = flow_BaseDefine.FlowName;
_param2[2].Value = decimal.Parse(flow_BaseDefine.RootDWID);
_param2[3].Value = flow_BaseDefine.ID;
try
{
SqlHelper.ExecuteNonQuery(connectString, CommandType.Text, _updateStr, _param2);
return(true);
}
catch (Exception e)
{
//写系统错误日志
return(false);
}
}
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);
}
}
/// <summary>
/// 取所有的流程定义及属性
/// </summary>
/// <returns></returns>
public List <Flow_BaseDefine> GetFlows()
{
List <Flow_BaseDefine> _ret = new List <Flow_BaseDefine>();
string _sql = "select ID,FLOWNAME,DESCRIPTION,ROOTDWID FROM FLOW_ENTITYTYPE";
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(connectString, CommandType.Text, _sql);
while (dr.Read())
{
Flow_BaseDefine _fd = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString()
);
_ret.Add(_fd);
}
dr.Close();
return(_ret);
}
catch (Exception e)
{
//写系统错误日志
LogWriter.WriteSystemLog("GetFlows——" + e.Message, "ERROR");
return(null);
}
}
/// <summary>
/// 取指定名称的流程属性定义
/// </summary>
/// <param name="_flowName">流程名称</param>
/// <returns></returns>
static public Biz_FlowProperties GetFlowPropertiesByName(string _flowName)
{
if (FlowInterface == null)
{
return(null);
}
Flow_BaseDefine _flow = FlowInterface.GetFlowPropertiesByName(_flowName);
return(new Biz_FlowProperties(_flow));
}
/// <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_FlowProperties(Flow_BaseDefine _flow)
{
_flowDefine = _flow;
_isNew = false;
}
public Biz_FlowProperties(string _id)
{
_isNew = true;
_flowDefine = new Flow_BaseDefine(Guid.NewGuid().ToString(), "新流程", "", "0");
}
