/// <summary> /// 增加支持人 /// </summary> /// <param name="wfSupportGroupMembers">支持人对象实体</param> public static bool Add(WfSupportGroupMembersEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WF_SupportGroupMembers ("); strSql.Append(" SupportGroupID, GroupMemberID, GroupMemberName, IsDefault)"); strSql.Append(" values ( "); strSql.Append("@SupportGroupID, @GroupMemberID, @GroupMemberName, @IsDefault)"); SqlParameter[] parameters = { new SqlParameter("@SupportGroupID", SqlDbType.UniqueIdentifier), new SqlParameter("@GroupMemberID", SqlDbType.VarChar), new SqlParameter("@GroupMemberName", SqlDbType.NVarChar), new SqlParameter("@IsDefault", SqlDbType.Bit) }; int i = 0; parameters[i++].Value = entity.SupportGroupID; parameters[i++].Value = entity.GroupMemberID; parameters[i++].Value = entity.GroupMemberName; parameters[i++].Value = entity.IsDefault; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 获取实体信息 /// </summary> /// <param name="row">数据行</param> /// <returns></returns> private static WfSupportGroupMembersEntity GetEntity(DataRow row) { WfSupportGroupMembersEntity entity = new WfSupportGroupMembersEntity(); entity.SupportGroupID = Guid.Parse(row["SupportGroupID"].ToString()); entity.GroupMemberID = row["GroupMemberID"].ToString(); entity.GroupMemberName = row["GroupMemberName"].ToString(); entity.IsDefault = Convert.ToBoolean(row["IsDefault"]); return entity; }
/// <summary> /// 更新支持人 /// </summary> /// <param name="wF_SupportGroupMember">支持人</param> /// <returns>bool</returns> public static bool UpdateWfSupportGroupMembers(WfSupportGroupMembersEntity entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WF_SupportGroupMembers set "); strSql.Append("SupportGroupID = @SupportGroupID, "); strSql.Append("GroupMemberID = @GroupMemberID, "); strSql.Append("GroupMemberName = @GroupMemberName, "); strSql.Append("IsDefault = @IsDefault"); strSql.Append(" where "); strSql.Append(" SupportGroupID = @SupportGroupID "); strSql.Append(" and "); strSql.Append(" GroupMemberID = @GroupMemberID "); SqlParameter[] parameters = { new SqlParameter("@SupportGroupID", SqlDbType.UniqueIdentifier), new SqlParameter("@GroupMemberID", SqlDbType.VarChar), new SqlParameter("@GroupMemberName", SqlDbType.NVarChar), new SqlParameter("@IsDefault", SqlDbType.Bit) }; int i = 0; parameters[i++].Value = entity.SupportGroupID; parameters[i++].Value = entity.GroupMemberID; parameters[i++].Value = entity.GroupMemberName; parameters[i++].Value = entity.IsDefault; return DataHelper.ExecuteNoneQuery(strSql.ToString(), parameters) > 0; }
/// <summary> /// 保存支持组成员信息 /// </summary> /// <param name="supportGroupID"></param> /// <param name="groupMemberID"></param> /// <param name="groupMemberName"></param> /// <param name="isDefault"></param> /// <returns></returns> public static bool SaveSupportGroupMemberInfo(Guid supportGroupID, string groupMemberID, string groupMemberName, bool isDefault) { var isExist = WfSupportGroupMembersBusiness.IsExist(supportGroupID, groupMemberID); if (isExist) { throw new Exception("同一支持组内人不能重复!"); } else { var entity = new WfSupportGroupMembersEntity(supportGroupID, groupMemberID, groupMemberName, isDefault); return WfSupportGroupMembersBusiness.Add(entity); } }