/// <summary> /// 添加流程锁 /// </summary> /// <param name="entity"></param> /// <param name="userID"></param> /// <param name="formID"></param> /// <returns></returns> public static bool AddLockInfo(WFMessagesEntity entity, Guid userID, Guid formID) { var result = false; try { var wfLockInfoEntity = new WfFormLockInfoEntity(); wfLockInfoEntity.Guid = Guid.NewGuid(); wfLockInfoEntity.CreatePerson = userID; wfLockInfoEntity.CreateTime = DateTime.Now; wfLockInfoEntity.FormID = formID; wfLockInfoEntity.InstanceID = entity.WfInstanceId; wfLockInfoEntity.IsDelete = false; wfLockInfoEntity.IsLocked = 1; wfLockInfoEntity.UpdatePerson = wfLockInfoEntity.CreatePerson; wfLockInfoEntity.UpdateTime = wfLockInfoEntity.CreateTime; wfLockInfoEntity.WfStateID = entity.CurrentWfStateId; wfLockInfoEntity.WfStateName = entity.CurrentWfStateName; result = WfFormLockInfoDal.Add(wfLockInfoEntity); } catch (Exception ex) { LogWritter.WriteSystemExceptionLog(ex); } return result; }
/// <summary> /// 增加流程锁基本信息 /// </summary> /// <param name="wfFormLockInfo">流程锁基本信息对象实体</param> public static bool Add(WfFormLockInfoEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WF_FormLockInfo ("); strSql.Append(" Guid, FormID, InstanceID, IsLocked, WfStateID, WfStateName, CreatePerson, CreateTime, UpdatePerson, UpdateTime, IsDelete)"); strSql.Append(" values ( "); strSql.Append("@Guid, @FormID, @InstanceID, @IsLocked, @WfStateID, @WfStateName, @CreatePerson, @CreateTime, @UpdatePerson, @UpdateTime, @IsDelete)"); SqlParameter[] parameters = { new SqlParameter("@Guid", SqlDbType.UniqueIdentifier), new SqlParameter("@FormID", SqlDbType.UniqueIdentifier), new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier), new SqlParameter("@IsLocked", SqlDbType.Int), new SqlParameter("@WfStateID", SqlDbType.UniqueIdentifier), new SqlParameter("@WfStateName", SqlDbType.NVarChar), new SqlParameter("@CreatePerson", SqlDbType.UniqueIdentifier), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdatePerson", SqlDbType.UniqueIdentifier), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.Bit) }; int i = 0; parameters[i++].Value = entity.Guid; parameters[i++].Value = entity.FormID; parameters[i++].Value = entity.InstanceID; parameters[i++].Value = entity.IsLocked; parameters[i++].Value = entity.WfStateID; parameters[i++].Value = entity.WfStateName; parameters[i++].Value = entity.CreatePerson; if (entity.CreateTime == DateTime.MinValue) entity.CreateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.CreateTime; parameters[i++].Value = entity.UpdatePerson; if (entity.UpdateTime == DateTime.MinValue) entity.UpdateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.UpdateTime; parameters[i++].Value = entity.IsDelete; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 更新流程锁基本信息 /// </summary> /// <param name="wF_FormLockInfo">流程锁基本信息</param> /// <returns>bool</returns> public static bool Update(WfFormLockInfoEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WF_FormLockInfo set "); strSql.Append("Guid = @Guid, "); strSql.Append("FormID = @FormID, "); strSql.Append("InstanceID = @InstanceID, "); strSql.Append("IsLocked = @IsLocked, "); strSql.Append("WfStateID = @WfStateID, "); strSql.Append("WfStateName = @WfStateName, "); strSql.Append("CreatePerson = @CreatePerson, "); strSql.Append("CreateTime = @CreateTime, "); strSql.Append("UpdatePerson = @UpdatePerson, "); strSql.Append("UpdateTime = @UpdateTime, "); strSql.Append("IsDelete = @IsDelete"); strSql.Append(" where "); strSql.Append(" Guid = @Guid "); SqlParameter[] parameters = { new SqlParameter("@Guid", SqlDbType.UniqueIdentifier), new SqlParameter("@FormID", SqlDbType.UniqueIdentifier), new SqlParameter("@InstanceID", SqlDbType.UniqueIdentifier), new SqlParameter("@IsLocked", SqlDbType.Int), new SqlParameter("@WfStateID", SqlDbType.UniqueIdentifier), new SqlParameter("@WfStateName", SqlDbType.NVarChar), new SqlParameter("@CreatePerson", SqlDbType.UniqueIdentifier), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdatePerson", SqlDbType.UniqueIdentifier), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.Bit) }; int i = 0; parameters[i++].Value = entity.Guid; parameters[i++].Value = entity.FormID; parameters[i++].Value = entity.InstanceID; parameters[i++].Value = entity.IsLocked; parameters[i++].Value = entity.WfStateID; parameters[i++].Value = entity.WfStateName; parameters[i++].Value = entity.CreatePerson; if (entity.CreateTime == DateTime.MinValue) entity.CreateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.CreateTime; parameters[i++].Value = entity.UpdatePerson; if (entity.UpdateTime == DateTime.MinValue) entity.UpdateTime = (DateTime)SqlDateTime.MinValue; parameters[i++].Value = entity.UpdateTime; parameters[i++].Value = entity.IsDelete; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 获取实体信息 /// </summary> /// <param name="row">数据行</param> /// <returns></returns> public static WfFormLockInfoEntity GetEntity(DataRow row) { WfFormLockInfoEntity entity = new WfFormLockInfoEntity(); if (row["Guid"] != DBNull.Value) entity.Guid = Guid.Parse(row["Guid"].ToString()); if (row["FormID"] != DBNull.Value) entity.FormID = Guid.Parse(row["FormID"].ToString()); if (row["InstanceID"] != DBNull.Value) entity.InstanceID = Guid.Parse(row["InstanceID"].ToString()); if (row["IsLocked"] != DBNull.Value) entity.IsLocked = Convert.ToInt32(row["IsLocked"]); if (row["WfStateID"] != DBNull.Value) entity.WfStateID = Guid.Parse(row["WfStateID"].ToString()); entity.WfStateName = row["WfStateName"].ToString(); if (row["CreatePerson"] != DBNull.Value) entity.CreatePerson = Guid.Parse(row["CreatePerson"].ToString()); if (row["CreateTime"] != DBNull.Value) entity.CreateTime = Convert.ToDateTime(row["CreateTime"]); if (row["UpdatePerson"] != DBNull.Value) entity.UpdatePerson = Guid.Parse(row["UpdatePerson"].ToString()); if (row["UpdateTime"] != DBNull.Value) entity.UpdateTime = Convert.ToDateTime(row["UpdateTime"]); if (row["IsDelete"] != DBNull.Value) entity.IsDelete = Convert.ToBoolean(row["IsDelete"]); return entity; }