public string FP80306()
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U000 u000 = dbma1.U000s.Where(c => c.userSN == userSN).First();
//获取用户名
string userName = u000.name;
//获取短信费用
decimal shortMessageFee = Convert.ToDecimal(dbma1.A028s.First().shortMessageCost);
//获取手机号码
string phone = u000.phone;
//获取原邮箱
string email = dbma1.U002s.Where(c => c.userSN == userSN).First().email;
//获取通知设定
var u003 = (from c in dbma1.U003s
where c.userSN == userSN
select new
{
c.billGenerate_shortMessage,
c.billGenerate_email,
c.overdue_shortMessage,
c.overdue_email,
c.receiveReserve_shortMessage,
c.receiveReserve_email
}).First();
return(string.Format("{{\"userName\":\"{0}\",\"shortMessageFee\":\"{1}\",\"phone\":\"{2}\",\"email\":\"{3}\",\"messageConfig\":{4},\"userSN\":\"{5}\"}}", userName, shortMessageFee, phone, email, C101.FC10107(u003), userSN));
}
}
//1:绑定成功;0:操作失败 不返回结果:2:原手机的验证码错误;3:新手机的验证码错误
public int FP80308(string oldPhone, string oldIC, string newPhone, string newIC)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//新手机是否被注册
if (IfPhoneHasBeenReg(dbma1, newPhone) == true)
{
return(0);
}
//原手机验证码是否正确
if (IfIdentifyingCodeCorrect(dbma1, oldPhone, oldIC, "原手机验证") == false)
{
return(2);
}
//新手机验证码是否正确
if (IfIdentifyingCodeCorrect(dbma1, newPhone, newIC, "新手机验证") == false)
{
return(3);
}
//修改U000手机
U000 u000 = dbma1.U000s.Where(c => c.userSN == userSN).First();
u000.phone = newPhone;
//修改U002手机
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.phone = newPhone;
dbma1.SubmitChanges();
return(1);
}
}
//插入用户表
private string InsertIntoU00(DBMA1DataContext dbma1, string phoneNum, string pwd, string name)
{
string tableName = "U000";
int SNDigitLength = 5;
string prefix = "U";
string max33SN = Comm.C101.FC10102(tableName, SNDigitLength, prefix);
string pwdMD5 = Comm.C101.FC10103(pwd);
U000 u000 = new U000();
u000.userSN = max33SN;
u000.phone = phoneNum;
u000.pwd = pwdMD5;
u000.name = name;
u000.registerDate = DateTime.Now;
u000.lastLoginDate = DateTime.Now;
u000.lastLoginIp = HttpContext.Current.Request.UserHostAddress;
dbma1.U000s.InsertOnSubmit(u000);
return(max33SN);
}
//1:修改成功;0:操作失败 不返回结果:2:原密码不正确;
public int FP80309(string oldPwd, string newPwd)
{
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检验原密码是否正确
U000 u000 = dbma1.U000s.Where(c => c.userSN == userSN).First();
string oldPwdMd5 = u000.pwd;
if (C101.FC10104(oldPwd, oldPwdMd5) == false)
{
return(2);
}
//修改密码
string newPwdMd5 = C101.FC10103(newPwd);
u000.pwd = newPwdMd5;
u000.ifChangePwd = true;
dbma1.SubmitChanges();
return(1);
}
}