/// <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);
}
}
