/// <summary>
/// 会员登录
/// </summary>
/// <param name="membername"></param>
/// <param name="password"></param>
public static String Login(String membername, String password)
{
IJsonResult msg = new IJsonResult {
Status = false, Text = "用户名或密码输入错误！"
};
ExecuteObject obj = new ExecuteObject();
obj.tableName = "T_Members";
obj.cmdtype = CmdType.SELECT;
obj.terms.Add("MemberName", membername);
obj.terms.Add("PassWord", EncryptHelper.MD5Upper32(password));
T_MembersEntity data = db.ExecuteObject <T_MembersEntity>(obj);
if (!String.IsNullOrEmpty(data.MemberName))
{
if (!data.Status)
{
msg.Text = "当前账号无法登录，请与管理员联系！";
T_LogsHelper.Append("会员:" + data.MemberName + "尝试登录会员中心,登录失败!", data.ID);
}
else
{
msg.Text = null;
msg.Status = true;
data.LastSignTime = DateTime.Now;
db.ExecuteCommand <T_MembersEntity>(data, CmdType.UPDATE);
T_LogsHelper.Append("会员:" + data.MemberName + "成功登录会员中心!", data.ID);
Member = data;
}
}
return(JsonConvert.SerializeObject(msg));
}
/// <summary>
/// 会员注册
/// </summary>
/// <param name="data"></param>
public static IJsonResult RegMember(T_MembersEntity data)
{
IJsonResult msg = new IJsonResult {
Status = false, Text = "", Css = "line1px_2"
};
if (String.IsNullOrEmpty(data.MemberName))
{
msg.Text = "登录名称不能为空!！";
}
else if (!MemberCenter.CheckUser(data.MemberName))
{
msg.Text = "会员名称已注册！";
}
else if (!String.IsNullOrEmpty(data.Email) && !MemberCenter.CheckEmail(data.Email))
{
msg.Text = "邮箱已注册！";
}
else if (!String.IsNullOrEmpty(data.QQ) && !MemberCenter.CheckQQ(data.QQ))
{
msg.Text = "QQ号已注册！";
}
else
{
data.JoinDate = DateTime.Now;
data.LastSignTime = DateTime.Now;
if (db.ExecuteCommand <T_MembersEntity>(data, CmdType.INSERT))
{
msg.Status = true;
msg.Css = "line1px_3";
msg.Text = "注册成功！";
}
}
return(msg);
}
/// <summary>
/// 初始化编辑数据
/// </summary>
protected void LoadData()
{
String strSql = "SELECT * FROM [T_Members] WHERE id=" + EditID;
T_MembersEntity data = db.ExecuteObject <T_MembersEntity>(strSql);
ViewState["data"] = data;
this.SetFormValue(data);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
T_MembersEntity data = (T_MembersEntity)ViewState["data"];
data = this.GetFormValue <T_MembersEntity>(data);
if (!IsEdit)
{
IJsonResult msg = MemberCenter.RegMember(data);
Alert(Label1, msg.Text, msg.Css);
if (msg.Status)
{
this.ClearFromValue();
}
}
else
{
if (db.ExecuteCommand <T_MembersEntity>(data, CmdType.UPDATE))
{
Alert(Label1, "保存成功！", "line1px_3");
}
}
}
