/// <summary>
///
/// </summary>
/// <param name="memberId"></param>
/// <param name="roleIds"></param>
/// <returns>成更新的条数</returns>
public int UpdateMemberRole(int memberId, List <int> roleIds)
{
int result = 0;
string sql = string.Format(" delete from MemberRole where MemberId={0} ", memberId);
if (m_dbo.ExecuteNonQuery(sql))
{
foreach (int roleId in roleIds)
{
MemberRole mr = new MemberRole();
mr.MemberId = memberId;
mr.RoleId = roleId;
if (mr.Save() > 0)
{
result += 1;
}
}
}
return(result);
}
/// <summary>
/// 发送申请单邮件（可审核）
/// </summary>
/// <param name="applyId"></param>
/// <param name="dt">该申请单是被谁审核的 管理员的表 </param>
/// <returns></returns>
public bool SendEmail(int applyId, int isPass)
{
if (applyId > 0)//申请单添加成功，审核消息发送给对应的管理员
{
//1、找到要发邮件的对应的人
//通过ApplyId找到（新申请单生成）申请人，（审核过一级的）审核了一次的审核人
VIPApply apply = new VIPApply(applyId);
if (apply.Status == "待审核")
{
int memberId = apply.OperatorId > 0 ? apply.OperatorId : apply.MemberId;
VIPApplyOption option = new VIPApplyOption();
Member member = new Member();
DataSet ds = member.GetDeptComIdByMemberId(memberId);
option.ComId = Convert.ToInt32(ds.Tables[0].Rows[0]["ComId"]);
option.MemberId = memberId;
option.RoleId = 2;//成本中心管理员
option.Code = Convert.ToString(ds.Tables[0].Rows[0]["Code"]);
VIPApplyManager vam = new VIPApplyManager();
DataSet dsAdmin = vam.GetAdmin(option);
List <int> memberIds = new List <int>();
if (dsAdmin.Tables[0].Rows.Count > 0)
{
int SendmemberId = Convert.ToInt32(dsAdmin.Tables[0].Rows[0]["MemberId"]);//上一级成本中心
memberIds.Add(SendmemberId);
}
//越级是 admin+sys_admin 逐级是admin
if (isPass == 1)//越级
{
MemberRole role = new MemberRole();
DataSet dsMemberIds = role.GetSysAdmin(option.ComId);//找到系统管理
if (dsMemberIds.Tables[0].Rows.Count > 0)
{
memberIds.Add(Convert.ToInt32(dsMemberIds.Tables[0].Rows[0]["MemberId"]));
}
}
if (memberIds.Count > 0)
{
Memberinfocfg configure = new Memberinfocfg();
DataSet dsEmail = configure.GetIsPassAudit(memberIds);
if (dsEmail.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsEmail.Tables[0].Rows.Count; i++)
{
if (dsEmail.Tables[0].Rows[i]["Type"].ToString() == "实时发送" && Convert.ToInt32(dsEmail.Tables[0].Rows[i]["Value"]) == 1)
{
string emailss = dsEmail.Tables[0].Rows[i]["Email"].ToString();
if (emailss != "")
{
int mId = Convert.ToInt32(dsEmail.Tables[0].Rows[i]["MemberId"]);
mailToArray = new string[] { emailss };
mailSubject = "订单审核：您有新订单需要审核 来自 领先办公(Stationery Order: You have one new order need to approve _ from Leading Future)";
mailBody = EmailBodyStr(applyId, mId);
isbodyHtml = true;
Send();
}
}
}
}
}
}
return(true);
}
return(false);
}
