/// <summary>
/// 增加活动
/// </summary>
/// <param name="wfModifyStatesInstance">活动对象实体</param>
public static bool Add(WFModifyStatesInstanceEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WF_ModifyStatesInstance (");
strSql.Append(" StateId, StateName, BusinessType, FormId, ShowOrder, DealPersonLevel, DealDeptLevel, DealPerson, CreateTime, CreatePerson, IsDeleted, CompleteTime, DealDescription, AssignPerson, ID, StateType)");
strSql.Append(" values ( ");
strSql.Append("@StateId, @StateName, @BusinessType, @FormId, @ShowOrder, @DealPersonLevel, @DealDeptLevel, @DealPerson, @CreateTime, @CreatePerson, @IsDeleted, @CompleteTime, @DealDescription, @AssignPerson, @ID, @StateType)");
SqlParameter[] parameters = {
new SqlParameter("@StateId", SqlDbType.UniqueIdentifier),
new SqlParameter("@StateName", SqlDbType.NVarChar),
new SqlParameter("@BusinessType", SqlDbType.Int),
new SqlParameter("@FormId", SqlDbType.NVarChar),
new SqlParameter("@ShowOrder", SqlDbType.Int),
new SqlParameter("@DealPersonLevel", SqlDbType.Int),
new SqlParameter("@DealDeptLevel", SqlDbType.Int),
new SqlParameter("@DealPerson", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime2),
new SqlParameter("@CreatePerson", SqlDbType.UniqueIdentifier),
new SqlParameter("@IsDeleted", SqlDbType.Bit),
new SqlParameter("@CompleteTime", SqlDbType.DateTime2),
new SqlParameter("@DealDescription", SqlDbType.NVarChar),
new SqlParameter("@AssignPerson", SqlDbType.VarChar),
new SqlParameter("@ID", 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.FormId;
parameters[i++].Value = entity.ShowOrder;
parameters[i++].Value = entity.DealPersonLevel;
parameters[i++].Value = entity.DealDeptLevel;
parameters[i++].Value = entity.DealPerson;
parameters[i++].Value = entity.CreateTime;
parameters[i++].Value = entity.CreatePerson;
parameters[i++].Value = entity.IsDeleted;
parameters[i++].Value = entity.CompleteTime;
parameters[i++].Value = entity.DealDescription;
parameters[i++].Value = entity.AssignPerson;
parameters[i++].Value = entity.ID;
parameters[i++].Value = entity.StateType;
return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0;
}
/// <summary>
/// 更新活动
/// </summary>
/// <param name="wF_ModifyStatesInstance">活动</param>
/// <returns>bool</returns>
public static bool Update(WFModifyStatesInstanceEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WF_ModifyStatesInstance set ");
strSql.Append("StateId = @StateId, ");
strSql.Append("StateName = @StateName, ");
strSql.Append("BusinessType = @BusinessType, ");
strSql.Append("FormId = @FormId, ");
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("IsDeleted = @IsDeleted, ");
strSql.Append("CompleteTime = @CompleteTime, ");
strSql.Append("DealDescription = @DealDescription, ");
strSql.Append("AssignPerson = @AssignPerson, ");
strSql.Append("ID = @ID, ");
strSql.Append("StateType = @StateType");
strSql.Append(" where ");
strSql.Append(" ID = @ID ");
SqlParameter[] parameters = {
new SqlParameter("@StateId", SqlDbType.UniqueIdentifier),
new SqlParameter("@StateName", SqlDbType.NVarChar),
new SqlParameter("@BusinessType", SqlDbType.Int),
new SqlParameter("@FormId", SqlDbType.NVarChar),
new SqlParameter("@ShowOrder", SqlDbType.Int),
new SqlParameter("@DealPersonLevel", SqlDbType.Int),
new SqlParameter("@DealDeptLevel", SqlDbType.Int),
new SqlParameter("@DealPerson", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime2),
new SqlParameter("@CreatePerson", SqlDbType.UniqueIdentifier),
new SqlParameter("@IsDeleted", SqlDbType.Bit),
new SqlParameter("@CompleteTime", SqlDbType.DateTime2),
new SqlParameter("@DealDescription", SqlDbType.NVarChar),
new SqlParameter("@AssignPerson", SqlDbType.VarChar),
new SqlParameter("@ID", 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.FormId;
parameters[i++].Value = entity.ShowOrder;
parameters[i++].Value = entity.DealPersonLevel;
parameters[i++].Value = entity.DealDeptLevel;
parameters[i++].Value = entity.DealPerson;
parameters[i++].Value = entity.CreateTime;
parameters[i++].Value = entity.CreatePerson;
parameters[i++].Value = entity.IsDeleted;
parameters[i++].Value = entity.CompleteTime;
parameters[i++].Value = entity.DealDescription;
parameters[i++].Value = entity.AssignPerson;
parameters[i++].Value = entity.ID;
parameters[i++].Value = entity.StateType;
return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0;
}
/// <summary>
/// 插入工作流
/// </summary>
/// <returns></returns>
public static bool InsertStates(WFModifyStatesInstanceEntity insertentity, int preStateShowOrder, out string message)
{
message = "";
try
{
var result = AllowInsert(insertentity.FormId, insertentity.StateId);
if (!result)
{
message = "该环节已经存在，不允许重复插入！";
return false;
}
UpdateOrder(insertentity.FormId, preStateShowOrder);
Add(insertentity);
return true;
}
catch (Exception ex)
{
LogWritter.WriteSystemExceptionLog(ex);
message = "系统出现异常！";
return false;
}
}
/// <summary>
/// 获取实体信息
/// </summary>
/// <param name="row">数据行</param>
/// <returns></returns>
public static WFModifyStatesInstanceEntity GetEntity(DataRow row)
{
WFModifyStatesInstanceEntity entity = new WFModifyStatesInstanceEntity();
entity.StateId = Guid.Parse(row["StateId"].ToString());
entity.StateName = row["StateName"].ToString();
entity.BusinessType = Convert.ToInt32(row["BusinessType"]);
entity.FormId = row["FormId"].ToString();
entity.ShowOrder = Convert.ToInt32(row["ShowOrder"]);
entity.DealPersonLevel = Convert.ToInt32(row["DealPersonLevel"]);
entity.DealDeptLevel = Convert.ToInt32(row["DealDeptLevel"]);
entity.DealPerson = row["DealPerson"].ToString();
entity.CreatePerson = Guid.Parse(row["CreatePerson"].ToString());
entity.IsDeleted = Convert.ToBoolean(row["IsDeleted"]);
entity.DealDescription = row["DealDescription"].ToString();
entity.AssignPerson = row["AssignPerson"].ToString();
entity.ID = Guid.Parse(row["ID"].ToString());
entity.StateType = Convert.ToInt32(row["StateType"]);
return entity;
}