void btn_Update_Click(object sender, EventArgs e)
{
//首先检查Email是否有重复
if (sm.Email != this.txtEmail.Text)
{
//检查除了自己本身之外是否重复
if (MemberManage.ExistsEmailExceptUser(this.txtEmail.Text, sm.UserId))
{
this.ltMsg.Text = "Email重复!";
return;
}
sm.Email = this.txtEmail.Text;
}
sm.Company = this.txtCompany.Text;
sm.Fax = this.txtFax.Text;
sm.InterestProduct = this.txtInterestProduct.Text;
sm.IsReceiveNewProductEmail = this.cbResive.Checked;
sm.Phone = this.txtPhone.Text;
sm.RealName = this.txtRealName.Text;
sm.Update();
this.ltMsg.Text = "更新成功!";
}
public ActionResult Register(MemberDTO member)
{
if (CheckEmailHasBeUsed(member.Email))
{
ModelState.AddModelError(string.Empty, "You input email has registed by other people.");
}
if (member.Password.Length < 8)
{
ModelState.AddModelError(string.Empty, "Password must be longer than 8 chars.");
}
if (ModelState.IsValid)
{
try
{
//Encrypt Password
member.Password = Utils.Md5Hash(salt + member.Password);
member.ConfirmPassword = member.Password;
MemberManage.Create(member);
return(RedirectToAction("Login", "Member"));
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex);
}
}
return(View());
}
/// <summary>
/// 构造方法
/// </summary>
public MemberAppService(IRepository <Member, int> memberRepository,
MemberManage memberManage
)
{
_memberRepository = memberRepository;
_memberManage = memberManage;
}
public SiteMember(int userId)
{
DataRow dr = MemberManage.GetUserInfo(userId);
if (dr != null)
{
FillHelper.Fill(dr, this);
}
}
private bool IsValid(string email, string password)
{
bool IsValid = false;
Member m = MemberManage.Get(email);
if (m != null && Utils.Md5Hash(salt + password) == m.Password)
{
IsValid = true;
}
return(IsValid);
}
public int UpdateMember(MemberManage member)
{
string sql = "UPDATE [dbo].[T_MemberManage] SET [Remark]=@Remark,[QQ]=@QQ,[SortLevel]=@SortLevel WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Remark", member.Remark);
dbOperator.AddParameter("QQ", member.QQ.Join(","));
dbOperator.AddParameter("Id", member.Id);
dbOperator.AddParameter("SortLevel", member.SortLevel);
return(dbOperator.ExecuteNonQuery(sql));
}
}
/// <summary>
/// Upgrade member to premium, if they have consumed over than $1000.00
/// </summary>
/// <param name="member"></param>
private void CheckAndUpgradeMember(Member member)
{
if (member.Role == Role.Basic)
{
double?total = (from order in db.Orders
where order.Member.Id == member.Id
select order.TotalPrice).Sum();
if (total >= 1000.0)
{
MemberManage.UpgradePremium(member);
}
}
}
public int InsertMember(Guid divideGroup, MemberManage member)
{
string sql = "INSERT INTO [dbo].[T_MemberManage]([Id],[Remark],[QQ],[DivideGroupId],[SortLevel]) VALUES(@Id,@Remark,@QQ,@DivideGroup,@SortLevel)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Id", member.Id);
dbOperator.AddParameter("Remark", member.Remark);
dbOperator.AddParameter("QQ", member.QQ.Join(","));
dbOperator.AddParameter("DivideGroup", divideGroup);
dbOperator.AddParameter("SortLevel", member.SortLevel);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public SiteMember(string userName)
{
if (string.IsNullOrEmpty(userName) == true)
{
throw new ArgumentException("loginName is null or empty");
}
DataRow dr = MemberManage.GetUserInfo(userName);
if (dr != null)
{
FillHelper.Fill(dr, this);
}
}
/// <summary>
/// 插入或编辑
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static MemberInfo Create(MemberInfo model)
{
if (model.Id == 0)
{
int id = MemberManage.Insert(model);
model.Id = id;
}
else
{
MemberManage.Update(model);
}
return(model);
}/// <summary>
public int Update()
{
if (this.UserId == 0)
{
//Add
this.UserId = MemberManage.Add(this);
}
else
{
//Update
MemberManage.Update(this);
}
return(this.UserId);
}
void btnSave_Click(object sender, EventArgs e)
{
SiteMember sm = new SiteMember(userId);
sm.IsPass = cbIsPass.Checked;
sm.Update();
DataRow dr = MemberManage.GetUserInfo(userId);
if (cbIsPass.Checked)
{
Roles.AddUsersToRoles(new string[] { dr["UserName"].ToString() }, new string[] { "Admin" });
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string memberId = Request.QueryString["memberId"];
if (!string.IsNullOrWhiteSpace(memberId))
{
this.lblAddOrUpdate.Text = "修改";
MemberManage view = OnLineCustomerService.QueryMember(Guid.Parse(memberId));
this.txtMemberExplain.InnerText = view.Remark;
this.hfdQQ.Value = view.QQ.Join(",");
this.txtSortLevel.Text = view.SortLevel.ToString();
}
}
}
/// <summary>
/// 插入成员管理
/// </summary>
/// <param name="divideGroup">分组信息Id</param>
/// <param name="view">成员管理信息</param>
/// <param name="operatorAccount">操作员帐号</param>
public static void InsertMember(Guid divideGroup, MemberView view, PublishRoles role, string operatorAccount)
{
var model = new MemberManage(view.Id);
model.Remark = view.Remark;
model.QQ = view.QQ;
model.SortLevel = view.SortLevel;
var reposity = Factory.CreateOnLineCustomerRepository();
reposity.InsertMember(divideGroup, model);
// 记录日志
OperatorRole operatorRole = getOperatorRole(role);
string content = string.Format("分组Id:{0},成员说明:{1},成员QQ:{2}", divideGroup, view.Remark, view.QQ.Join(","));
saveAddLog("成员信息", content, operatorRole, view.Id.ToString(), operatorAccount);
}
/// <summary>
/// 更新成员管理信息
/// </summary>
/// <param name="member">成员管理Id</param>
/// <param name="view">成员管理Id</param>
/// <param name="operatorAccount"></param>
public static void UpdateMember(MemberView view, PublishRoles role, string operatorAccount)
{
var member = OnLineCustomerService.QueryMember(view.Id);
var model = new MemberManage(view.Id);
model.QQ = view.QQ;
model.Remark = view.Remark;
model.SortLevel = view.SortLevel;
var reposity = Factory.CreateOnLineCustomerRepository();
reposity.UpdateMember(model);
// 记录日志
OperatorRole operatorRole = getOperatorRole(role);
string originalContent = string.Format("成员说明:{0},成员QQ:{1}", member.Remark, member.QQ.Join(","));
string newContent = string.Format("成员说明:{0},成员QQ:{1}", view.Remark, view.QQ.Join(","));
saveUpdateLog("成员信息", originalContent, newContent, operatorRole, view.Id.ToString(), operatorAccount);
}
void btn_Login_Click(object sender, EventArgs e)
{
if (MemberManage.Validator(this.txtUserName.Text, this.txtPwd.Text))
{
//管理员不能在这登录
bool isInAdmin = Roles.IsUserInRole(this.txtUserName.Text, "Admin");
if (isInAdmin)
{
this.ltMsg.Text = "用户名或密码错误!";
return;
}
Login(this.txtUserName.Text, this.txtPwd.Text);
Response.Redirect("/");
}
else
{
this.ltMsg.Text = "用户名或密码错误!";
}
}
public MemberManage QueryMember(Guid member)
{
MemberManage view = null;
string sql = "SELECT [Remark],[QQ],[SortLevel] FROM [dbo].[T_MemberManage] WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Id", member);
using (var reader = dbOperator.ExecuteReader(sql)) {
while (reader.Read())
{
view = new MemberManage(member);
view.Remark = reader.GetString(0);
view.QQ = reader.GetString(1).Split(new char[] { ',' });
view.SortLevel = reader.GetInt32(2);
}
}
}
return(view);
}
void btnRegister_Click(object sender, EventArgs e)
{
if (MemberManage.Exists(this.txtUserName.Text, this.txtUserEmail.Text))
{
this.ltMsg.Text = "用户名或Email已存在";
return;
}
SiteMember sm = new SiteMember();
sm.Email = this.txtUserEmail.Text;
sm.UserName = this.txtUserName.Text;
sm.UserPwd = this.txtConfirmUserPwd.Text;
int i = sm.Update();
if (i > 0)
{
this.ltMsg.Text = "用户已经创建,请等待审核!";
}
}
public IEnumerable <MemberManage> QueryMembers(Guid divideGroup)
{
var result = new List <MemberManage>();
string sql = "SELECT [Id],[Remark],[QQ] FROM [dbo].[T_MemberManage] WHERE [DivideGroupId]=@DivideGroup ORDER BY SortLevel";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("DivideGroup", divideGroup);
using (var reader = dbOperator.ExecuteReader(sql)) {
while (reader.Read())
{
MemberManage member = new MemberManage(reader.GetGuid(0));
member.Remark = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
member.QQ = reader.GetString(2).Split(new char[] { ',' });
result.Add(member);
}
}
}
return(result);
}
void btnLogin_Click(object sender, EventArgs e)
{
if (MemberManage.Validator(this.txtUserName.Text, this.txtUserPwd.Text))
{
SiteMember sm = new SiteMember(this.txtUserName.Text);
if (!sm.IsPass)
{
this.ltMsg.Text = "您还没有通过审核或帐号已禁用";
}
else
{
Login(this.txtUserName.Text, this.txtUserPwd.Text);
Response.Redirect(string.Format("{0}pagesadmin/index.aspx", ResolveUrl("~")));
}
}
else
{
this.ltMsg.Text = "用户名或密码错误!";
}
}
void btn_Ok_Click(object sender, EventArgs e)
{
//-1，说明没有此用户名名
//0，说明有此用户名，但是Email错误
//1，说明正确
int i = MemberManage.FindPwd(this.txtUserName.Text, this.txtEmail.Text);
if (i == -1)
{
this.ltMsg.Text = "用户名不存在!";
return;
}
if (i == 0)
{
this.ltMsg.Text = "Email不正确!";
return;
}
SiteMember sm = new SiteMember(this.txtUserName.Text);
this.ltMsg.Text = string.Format("请牢记您的密码：{0}，并尽快更新!", sm.UserPwd);
}
/// <summary>
/// Email是否存在
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public static bool EmailExists(string email)
{
return(MemberManage.EmailExists(email, 0));
}
/// <summary>
/// Email是否存在
/// </summary>
/// <param name="email"></param>
/// <param name="userId"></param>
/// <returns></returns>
public static bool EmailExists(string email, int userId)
{
return(MemberManage.EmailExists(email, userId));
}
/// <summary>
/// 根据用户ID获取用户基本信息
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static MemberInfo Get(int userId)
{
return(MemberManage.Get(userId));
}
/// <summary>
/// 根据用户名获取用户基本信息
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static MemberInfo Get(string userName)
{
return(MemberManage.Get(userName));
}
/// <summary>
/// 更新用户基本信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Update(MemberInfo model)
{
return(MemberManage.Update(model));
}
/// <summary>
/// 添加公司信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertCompany(CompanyInfo model)
{
//取消密码MD5
//model.Password = Controleng.Common.Utils.MD5(model.Password);
return(MemberManage.InsertCompany(model));
}
/// <summary>
/// 下载用户基本信息
/// 2012-12-17
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public static DataTable DownloadBaseInfo(int[] ids, DateTime startDate, DateTime endDate)
{
return(MemberManage.DownloadBaseInfo(ids, startDate, endDate));
}
/// <summary>
/// 查询，右LIKE
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static List <string> AdminSearchList(string userName)
{
return(MemberManage.AdminSearchList(userName));
}
/// <summary>
/// 管理员列表
/// </summary>
/// <returns></returns>
public static List <string> AdminMemberList()
{
return(MemberManage.AdminMemberList());
}
