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; }