public UserAccount Register(RegisterInf registerInf)
{
UserAccount userAccount = new UserAccount();
userAccount.isLogin = false;
userAccount.haveMsg = false;
if (registerInf == null)
{
userAccount.errorMsg = "注册信息不完整,请查看！";
}
else
{
if (registerInf.txtUserName.Trim().Equals(""))
{
userAccount.errorMsg = "请输入登录名称！";
return userAccount;
}
string sql = "Select * From TbUser Where UserName='******'";
DataSet ds = DBA.DbAccess.GetDataSet(CommandType.Text, sql);
if (ds.Tables[0].Rows.Count > 0)
{
userAccount.errorMsg = "您录入的登录名已存在，请重新输入！";
return userAccount;
}
if (registerInf.txtRealName.Trim() == "")
{
userAccount.errorMsg = "请输入真实姓名！";
return userAccount;
}
if (registerInf.txtPWD.Trim() == "")
{
userAccount.errorMsg = "请输入密码";
return userAccount;
}
if (registerInf.txtPWD.Trim().Length > 50)
{
userAccount.errorMsg = "密码超长，请重新输入！";
return userAccount;
}
//if (txtPWD.Text.ToString().Trim() != txtQueRen.Text.ToString().Trim())
//{
// return "您两次输入的密码不一致,请重新输入！";
//}
if (registerInf.txtYouXiang.Trim() == "")
{
userAccount.errorMsg = "请输入您的邮箱地址！";
return userAccount;
}
TbUser user = new TbUser();
user.UserName = registerInf.txtUserName.Trim();
user.UserPWD = registerInf.txtPWD.Trim();
user.RealName = registerInf.txtRealName.Trim();
user.YongHuLeiXing = "个人";
user.LianXiDianHua = registerInf.txtDianHua.Trim();
user.ShouJi = registerInf.txtShouJi.Trim();
user.TongXinDiZhi = registerInf.txtDiZhi.Trim();
user.EMail = registerInf.txtYouXiang.Trim();
user.DepartMentID = 0;
user.SHFlag = 0;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
db.Log = Console.Out;
db.TbUser.InsertOnSubmit(user);
db.SubmitChanges();
}
string sqlShouCang = "insert into TLC_Albums (UserId,ParentId,Title,live,isdel,isparent) values('" + user.ID.ToString().Trim() + "',0,'收藏夹',0,0,0)";
DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlShouCang);
userAccount.isLogin = true;
userAccount.userId = user.ID.ToString().Trim();
userAccount.userName = user.RealName.ToString().Trim();
}
return userAccount;
}
public UserAccount LoginCheck(string userName, string passWord)
{
UserAccount userAccount = new UserAccount();
userAccount.isLogin = false;
userAccount.haveMsg = false;
userAccount.msgContent = "";
if (userName == null || userName.Trim().Equals(""))
{
userAccount.errorMsg = "请填写用户名！";
}
else if (passWord == null || passWord.Trim().Equals(""))
{
userAccount.errorMsg = "请填写密码！";
}
else
{
DataSet ds = new DataSet();
string sql = "select * from TbUser Where UserName='******'";
ds = DBA.DbAccess.GetDataSet(CommandType.Text, sql);
if (ds.Tables[0].Rows.Count <= 0)
{
userAccount.errorMsg = "您输入的用户名不存在，请重新输入！";
return userAccount;
}
string PWD = ds.Tables[0].Rows[0]["UserPWD"].ToString().Trim();
if (PWD.ToLower() != passWord.Trim().ToLower())
{
userAccount.errorMsg = "您输入的用户名或密码错误，请重新输入！";
return userAccount;
}
userAccount.isLogin = true;
userAccount.userId = ds.Tables[0].Rows[0]["ID"].ToString().Trim();
userAccount.userName = ds.Tables[0].Rows[0]["RealName"].ToString().Trim();
//添加专利预警信息更新提醒
string YJ_sql = "Select a.c_id From C_EARLY_WARNING a Where a.user_id = '" + userAccount.userId + "' and a.isupdate = 1";
DataSet YJ_ds = DBA.DbAccess.GetDataSet(CommandType.Text, YJ_sql);
if (YJ_ds.Tables[0].Rows.Count > 0)
{
userAccount.haveMsg = true;
userAccount.msgContent = "请注意，您关注的专利预警信息有更新！";
YJ_sql = "UPDATE C_EARLY_WARNING SET isupdate = 0 WHERE user_id = '" + userAccount.userId + "' and isupdate = 1";
DBA.DbAccess.ExecNoQuery(CommandType.Text, YJ_sql);
}
}
return userAccount;
}
