/// <summary> /// 增加流程定义 /// </summary> /// <param name="wFModifyStatesDefine">流程定义对象实体</param> public static bool Add(WFModifyStatesDefineEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WF_ModifyStatesDefine ("); strSql.Append(" StateId, StateName, BusinessType, ShowOrder, DealPersonLevel, DealDeptLevel, DealPerson, CreateTime, CreatePerson, StateType)"); strSql.Append(" values ( "); strSql.Append("@StateId, @StateName, @BusinessType, @ShowOrder, @DealPersonLevel, @DealDeptLevel, @DealPerson, @CreateTime, @CreatePerson, @StateType)"); SqlParameter[] parameters = { new SqlParameter("@StateId", SqlDbType.UniqueIdentifier), new SqlParameter("@StateName", SqlDbType.NVarChar), new SqlParameter("@BusinessType", SqlDbType.Int), new SqlParameter("@ShowOrder", SqlDbType.Int), new SqlParameter("@DealPersonLevel", SqlDbType.Int), new SqlParameter("@DealDeptLevel", SqlDbType.Int), new SqlParameter("@DealPerson", SqlDbType.NVarChar), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreatePerson", SqlDbType.UniqueIdentifier), new SqlParameter("@StateType", SqlDbType.Int), }; int i = 0; parameters[i++].Value = entity.StateId; parameters[i++].Value = entity.StateName; parameters[i++].Value = entity.BusinessType; parameters[i++].Value = entity.ShowOrder; parameters[i++].Value = entity.DealPersonLevel; parameters[i++].Value = entity.DealDeptLevel; parameters[i++].Value = entity.DealPerson; if (entity.CreateTime == DateTime.MinValue) entity.CreateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.CreateTime; parameters[i++].Value = entity.CreatePerson; parameters[i++].Value = entity.StateType; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
public static void AddWfDefinition(string StateName, int BusinessType, int StateType) { try { using (TransactionScope scope = new TransactionScope()) { var entity = new WFModifyStatesDefineEntity(); entity.StateId = Guid.NewGuid(); entity.StateName = StateName; entity.BusinessType = BusinessType; entity.StateType = StateType; entity.ShowOrder = 0; Add(entity); var sql = string.Format(" delete from WF_ModifyStatesDealWayDefine where StateId='{0}' ", entity.StateId); DataHelper.ExecuteNoneQuery(sql); sql = string.Format("Insert into WF_ModifyStatesDealWayDefine values('{0}',NEWID(),'{1}')", entity.StateId, entity.StateName + "通过"); DataHelper.ExecuteNoneQuery(sql); sql = string.Format("Insert into WF_ModifyStatesDealWayDefine values('{0}',NEWID(),'{1}')", entity.StateId, entity.StateName + "不通过"); DataHelper.ExecuteNoneQuery(sql); scope.Complete(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新流程定义 /// </summary> /// <param name="wF_ModifyStatesDefine">流程定义</param> /// <returns>bool</returns> public static bool Update(WFModifyStatesDefineEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WF_ModifyStatesDefine set "); strSql.Append("StateId = @StateId, "); strSql.Append("StateName = @StateName, "); strSql.Append("BusinessType = @BusinessType, "); strSql.Append("ShowOrder = @ShowOrder, "); strSql.Append("DealPersonLevel = @DealPersonLevel, "); strSql.Append("DealDeptLevel = @DealDeptLevel, "); strSql.Append("DealPerson = @DealPerson, "); strSql.Append("CreateTime = @CreateTime, "); strSql.Append("CreatePerson = @CreatePerson, "); strSql.Append("StateType = @StateType "); strSql.Append(" where "); strSql.Append(" StateId = @StateId "); SqlParameter[] parameters = { new SqlParameter("@StateId", SqlDbType.UniqueIdentifier), new SqlParameter("@StateName", SqlDbType.NVarChar), new SqlParameter("@BusinessType", SqlDbType.Int), new SqlParameter("@ShowOrder", SqlDbType.Int), new SqlParameter("@DealPersonLevel", SqlDbType.Int), new SqlParameter("@DealDeptLevel", SqlDbType.Int), new SqlParameter("@DealPerson", SqlDbType.NVarChar), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreatePerson", SqlDbType.UniqueIdentifier), new SqlParameter("@StateType", SqlDbType.Int), }; int i = 0; parameters[i++].Value = entity.StateId; parameters[i++].Value = entity.StateName; parameters[i++].Value = entity.BusinessType; parameters[i++].Value = entity.ShowOrder; parameters[i++].Value = entity.DealPersonLevel; parameters[i++].Value = entity.DealDeptLevel; parameters[i++].Value = entity.DealPerson; if (entity.CreateTime == DateTime.MinValue) entity.CreateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.CreateTime; parameters[i++].Value = entity.CreatePerson; parameters[i++].Value = entity.StateType; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 获取实体信息 /// </summary> /// <param name="row">数据行</param> /// <returns></returns> public static WFModifyStatesDefineEntity GetEntity(DataRow row) { WFModifyStatesDefineEntity entity = new WFModifyStatesDefineEntity(); entity.StateId = Guid.Parse(row["StateId"].ToString()); entity.StateName = row["StateName"].ToString(); entity.BusinessType = Convert.ToInt32(row["BusinessType"]); entity.ShowOrder = Convert.ToInt32(row["ShowOrder"]); if (row["DealPersonLevel"] != DBNull.Value) { entity.DealPersonLevel = Convert.ToInt32(row["DealPersonLevel"]); } if (row["DealDeptLevel"] != DBNull.Value) { entity.DealDeptLevel = Convert.ToInt32(row["DealDeptLevel"]); } entity.DealPerson = row["DealPerson"].ToString(); if (row["CreateTime"] != DBNull.Value) entity.CreateTime = Convert.ToDateTime(row["CreateTime"]); entity.CreatePerson = Guid.Parse(row["CreatePerson"].ToString()); entity.StateType = Convert.ToInt32(row["StateType"]); return entity; }