private int EditPwd_Trans(IDbHelp thelp, DbHelp.ITransM pMod)
{
EditPwd_TransM tmod = (EditPwd_TransM)pMod;
//查询是否生效
string sql = "select FK_User from User_FindPwdEmail where FPEmail=@FPEmail and FPKey=@FPKey and AddDate>(dateadd(dd,-3,getdate())) order by AddDate desc";
IDataParameter[] param =
{
DbHelp.Def.AddParam("@FPEmail", Email),
DbHelp.Def.AddParam("@FPKey", Key),
};
string str = thelp.First(sql, param, "0");
if (str == "0")
{
tmod.returnValue = "此链接已失效";
return(0);
}
//更新密码
sql = "update User_Info set UserPwd=@UserPwd where UserSN=@UserSN";
IDataParameter[] param2 =
{
DbHelp.Def.AddParam("@UserPwd", Fn.MD5(tmod.sPwd)),
DbHelp.Def.AddParam("@UserSN", str),
};
//删除用户的找回密码记录
if (thelp.Update(sql, param2) <= 0)
{
tmod.returnValue = "找不到此用户";
return(0);
}
sql = "delete User_FindPwdEmail where FK_User=@FK_User";
IDataParameter[] param3 =
{
DbHelp.Def.AddParam("@FK_User", str),
};
if (thelp.Update(sql, param3) <= 0)
{
tmod.returnValue = "设置失败";
return(0);
}
tmod.returnValue = "1";
return(1);
}
private int EditInfo_Trans(IDbHelp thelp, DbHelp.ITransM pMod)
{
EditInfo_TransM tmod = (EditInfo_TransM)pMod;
User_InfoM infoMod = tmod.infoMod;
User_TeamM teamMod = tmod.teamMod;
#region 保存个人信息
string sql_pre = "update User_Team set TeamName=@TeamName,RealName=@RealName,Area=@Area,Address=@Address,Tel=@Tel,FixTel=@FixTel,Detail=@Detail where FK_User="******"@TeamName", teamMod.TeamName),
DbHelp.Def.AddParam("@RealName", teamMod.RealName),
DbHelp.Def.AddParam("@Area", teamMod.Area),
DbHelp.Def.AddParam("@Address", teamMod.Address),
DbHelp.Def.AddParam("@Tel", teamMod.Tel),
DbHelp.Def.AddParam("@FixTel", teamMod.FixTel),
DbHelp.Def.AddParam("@Detail", teamMod.Detail),
};
if (thelp.Update(sql_pre, dp_pre) <= 0)
{
tmod.returnValue = "您的账号信息可能已损坏，请重新注册账号或通过客服帮助";//个人用户信息保存失败
return(0);
}
#endregion
#region 保存账户信息
string sql_info = "update User_Info set Email=@Email where UserSN=" + userID + " and OpenIdentity&8=8";
IDataParameter[] dp_info =
{
DbHelp.Def.AddParam("@Email", infoMod.Email),
};
if (thelp.Update(sql_info, dp_info) <= 0)
{
tmod.returnValue = "c";//账户信息保存失败
return(0);
}
#endregion
tmod.returnValue = "1";
return(1);
}
private int EditInfo_Trans(IDbHelp thelp, DbHelp.ITransM pMod)
{
EditInfo_TransM tmod = (EditInfo_TransM)pMod;
User_InfoM infoMod = tmod.infoMod;
User_PersonalM perMod = tmod.perMod;
SurveyM surMod = tmod.surMod;
#region 保存调查信息
string sql_sur = "if exists(select 1 from Survey where FK_User=@FK_User) "
+ "update Survey set BirDate=@BirDate,FamilyN=@FamilyN,Trades=@Trades,Income=@Income,Cuisine=@Cuisine,Vegetables=@Vegetables,Taste=@Taste,Factor=@Factor,Proposal=@Proposal where FK_User=@FK_User "
+ "else "
+ "insert into Survey(FK_User,BirDate,FamilyN,Trades,Income,Cuisine,Vegetables,Taste,Factor,Proposal) values(@FK_User,@BirDate,@FamilyN,@Trades,@Income,@Cuisine,@Vegetables,@Taste,@Factor,@Proposal)";
IDataParameter[] dp_sur =
{
DbHelp.Def.AddParam("@FK_User", surMod.FK_User),
DbHelp.Def.AddParam("@BirDate", surMod.BirDate),
DbHelp.Def.AddParam("@FamilyN", surMod.FamilyN),
DbHelp.Def.AddParam("@Trades", surMod.Trades),
DbHelp.Def.AddParam("@Income", surMod.Income),
DbHelp.Def.AddParam("@Cuisine", surMod.Cuisine),
DbHelp.Def.AddParam("@Vegetables", surMod.Vegetables),
DbHelp.Def.AddParam("@Taste", surMod.Taste),
DbHelp.Def.AddParam("@Factor", surMod.Factor),
DbHelp.Def.AddParam("@Proposal", surMod.Proposal),
};
if (thelp.Update(sql_sur, dp_sur) <= 0)
{
tmod.returnValue = "a";//调查信息保存失败
return(0);
}
#endregion
#region 保存个人信息
string sql_pre = "update User_Personal set RealName=@RealName,Sex=@Sex,Area=@Area,Address=@Address,Tel=@Tel,FixTel=@FixTel where FK_User="******"@RealName", perMod.RealName),
DbHelp.Def.AddParam("@Sex", perMod.Sex),
DbHelp.Def.AddParam("@Area", perMod.Area),
DbHelp.Def.AddParam("@Address", perMod.Address),
DbHelp.Def.AddParam("@Tel", perMod.Tel),
DbHelp.Def.AddParam("@FixTel", perMod.FixTel),
};
if (thelp.Update(sql_pre, dp_pre) <= 0)
{
tmod.returnValue = "您的账号信息可能已损坏，请重新注册账号或通过客服帮助";//个人用户信息保存失败
return(0);
}
#endregion
#region 保存账户信息
string sql_info = "update User_Info set Email=@Email where UserSN=" + userID;
IDataParameter[] dp_info =
{
DbHelp.Def.AddParam("@Email", infoMod.Email),
};
if (thelp.Update(sql_info, dp_info) <= 0)
{
tmod.returnValue = "c";//账户信息保存失败
return(0);
}
#endregion
tmod.returnValue = "1";
return(1);
}