protected void Page_Load(object sender, EventArgs e) { try { if (Session["UserID"] == null) { Cpic.Cprs2010.User.User userInfo = Cpic.Cprs2010.User.UserManager.getGuestUser(Session.SessionID); if (userInfo != null) { TbUser tbXmUser = new TbUser(); tbXmUser.ID = userInfo.ID; tbXmUser.RealName = userInfo.Use_Name; tbXmUser.YongHuLeiXing = "游客"; Session["UserID"] = tbXmUser.ID.ToString(); Session["RealName"] = tbXmUser.RealName; Session["UserInfo"] = tbXmUser; } else { //Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>" // + "<script>javascript:alert('服务器资源不足,请稍后再试');window.location.href = 'UserLogin.aspx';</script>"); } } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["UserID"] == null) { Cpic.Cprs2010.User.User userInfo = Cpic.Cprs2010.User.UserManager.getGuestUser(Session.SessionID); if (userInfo != null) { TbUser tbXmUser = new TbUser(); tbXmUser.ID = userInfo.ID; tbXmUser.RealName = userInfo.Use_Name + userInfo.ID.ToString(); tbXmUser.YongHuLeiXing = "游客"; Session["UserID"] = tbXmUser.ID.ToString(); Session["RealName"] = tbXmUser.RealName; Session["UserInfo"] = tbXmUser; Response.Redirect("SmartQuery.aspx"); } else { Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>" + "<script>javascript:alert('服务器资源不足,请稍后再试');window.location.href = 'UserLogin.aspx';</script>"); } }else { DataSet ds = new DataSet(); string userid = Request.QueryString["UserID"].ToString(); string sql = "select * from TbUser Where UserName='******'"; ds = DBA.DbAccess.GetDataSet(CommandType.Text, sql); if (ds.Tables[0].Rows.Count <= 0) { Response.Redirect("../frmLogin.aspx"); } Session["UserID"] = ds.Tables[0].Rows[0]["ID"].ToString().Trim(); Session["RealName"] = ds.Tables[0].Rows[0]["RealName"].ToString().Trim(); Session["UserInfo"] = ProXZQDLL.UserRight.getUserInfo(Session["UserID"].ToString().Trim()); string IP = HttpContext.Current.Request.UserHostAddress.ToString(); ;//HttpContext.Current.Request.ServerVariables["HTTP_HOST"]; ProXZQDLL.ClsLog.LogInsert(IP, Session["RealName"].ToString().Trim(), ds.Tables[0].Rows[0]["YongHuLeiXing"].ToString().Trim()); Response.Redirect("SmartQuery.aspx"); } }
protected void imgBtnYk_Click(object sender, ImageClickEventArgs e) { Cpic.Cprs2010.User.User userInfo = Cpic.Cprs2010.User.UserManager.getGuestUser(Session.SessionID); if (userInfo != null) { TbUser tbXmUser = new TbUser(); tbXmUser.ID = userInfo.ID; tbXmUser.RealName = userInfo.Use_Name + userInfo.ID.ToString(); tbXmUser.YongHuLeiXing = "游客"; Session["UserID"] = tbXmUser.ID.ToString(); Session["RealName"] = tbXmUser.RealName; Session["UserInfo"] = tbXmUser; Response.Redirect("My/SmartQuery.aspx"); } else { Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>" + "<script>javascript:alert('服务器资源不足,请稍后再试');window.location.href = 'UserLogin.aspx';</script>"); } }
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; }
private string UserInsert() { string sql = ""; DataSet ds = new DataSet(); bool RoleFlag = false; if (this.txtUserName.Text.ToString().Trim() == "") { return "请输入登录名称!"; } if (this.txtRealName.Text.ToString().Trim() == "") { return "请输入真实姓名!"; } if (txtPWD.Text.ToString().Trim().Length > 50) { return "密码超长,请重新输入!"; } if (this.txtPWD.Text.ToString().Trim() == "") { return "请输入密码"; } sql = "Select * From TbUser Where UserName='******' "; ds = DBA.DbAccess.GetDataSet(CommandType.Text, sql); if (ds.Tables[0].Rows.Count > 0) { return "您录入的登录名已存在,请重新输入!"; } string sqlInsert = ""; //插入数据库项目名称,并返回当前插入行的ID if (false && hfUserLeiXing.Value.ToString().Trim() == "企业") { } else { for (int i = 0; i < chkRole.Items.Count; i++) { if (chkRole.Items[i].Selected) { sqlInsert += "Insert Into UserRole(RoleID,UserID) Values('" + chkRole.Items[i].Value.ToString().Trim() + "','@@@'); "; RoleFlag = true; } } if (!RoleFlag) { return "请给用户分配至少一个角色"; } } TbUser user = new TbUser(); user.UserName = txtUserName.Text.ToString().Trim(); user.UserPWD = txtPWD.Text.ToString().Trim(); user.RealName = txtRealName.Text.ToString().Trim(); user.YongHuLeiXing = ddlYongHuLX.SelectedValue.ToString().Trim(); user.LianXiDianHua = txtDianHua.Text.ToString().Trim(); user.ShouJi = txtShouJi.Text.ToString().Trim(); user.TongXinDiZhi = txtDiZhi.Text.ToString().Trim(); user.EMail = txtYouXiang.Text.ToString().Trim(); user.DepartMentID = 0; user.SHFlag = 1; user.QiYeMingCheng = txtQiYeMingCheng.Text.ToString().Trim(); //插入数据库项目名称,并返回当前插入行的ID if (hfUserLeiXing.Value.ToString().Trim() == "企业") { user.DepartMentID = Convert.ToInt32(Session["UserID"].ToString().Trim()); user.YongHuLeiXing = "企业"; } string DepID = UserRight.getDepartMentID(Session["UserID"].ToString()); if (DepID != "0") { user.DepartMentID = int.Parse(DepID); } using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbUser.InsertOnSubmit(user); db.SubmitChanges(); } // 企业用户新建出的用户角色 if (false && hfUserLeiXing.Value.ToString().Trim() == "企业") { DataClasses1DataContext db = new DataClasses1DataContext(); var result = from item in db.UserRole where item.UserID.ToString().Trim() == Session["UserID"].ToString().Trim() select item; foreach (var item in result) { UserRole userrole = new UserRole(); userrole.RoleID = item.RoleID; userrole.UserID = user.ID; db.UserRole.InsertOnSubmit(userrole); db.SubmitChanges(); } } else//系统用户建出的用户的角色 { sqlInsert = sqlInsert.Replace("@@@", user.ID.ToString().Trim()); DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlInsert); } if (ddlYongHuLX.SelectedValue.ToString().Trim() == "企业") { string sqlZTK = "insert into ZtDbList(ztDbName,dbType,createUserId) values('企业在线数据库','1','" + user.ID + "')"; DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlZTK); } string sqlShouCang = "insert into TLC_Albums (UserId,ParentId,Title,live,isdel,isparent) values('" + user.ID + "',0,'收藏夹',0,0,0)"; DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlShouCang); return ""; }
partial void DeleteTbUser(TbUser instance);
partial void UpdateTbUser(TbUser instance);
partial void InsertTbUser(TbUser instance);
public string RegUserinfo(string userid, string psd,string username,string email) { DataSet ds = new DataSet(); TbUser user = new TbUser(); string usertype = userid.Substring(4, 1); user.UserName = userid.Trim(); user.UserPWD = psd.Trim(); user.RealName = username; user.YongHuLeiXing = usertype; user.EMail = email.Trim(); user.DepartMentID = 0; user.SHFlag = 0; DataTable dt = new DataTable(); string sql = "select * from tbuser where username='******'"; dt = DBA.SqlDbAccess.GetDataTable(CommandType.Text, sql, null); using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.Log = Console.Out; db.TbUser.InsertOnSubmit(user); db.SubmitChanges(); } if (dt.Rows.Count > 0) return "1"; string sqlShouCang = "insert into TLC_Albums (UserId,ParentId,Title,live,isdel,isparent) values('" + user.ID.ToString().Trim() + "',0,'收藏夹',0,0,0)"; string cusertype = ""; if (DBA.DbAccess.ExecNoQuery(CommandType.Text, sqlShouCang) < 0) { return "-1"; } switch (usertype) { case "0": cusertype = "个人"; break; case "1": cusertype = "企业"; break; case "2": cusertype = "事业单位"; break; case "3": cusertype = "政府机关"; break; case "4": cusertype = "社会团体"; break; case "5": cusertype = "其他类型单位"; break; case "9": cusertype = "简易账户"; break; } sqlShouCang = "select * from TbRole where rolename='" + cusertype + "'"; dt = DBA.SqlDbAccess.GetDataTable(CommandType.Text, sqlShouCang, null); if (dt.Rows.Count == 0) { return "-1"; } string roleid = dt.Rows[0]["ID"].ToString(); sqlShouCang = "insert into UserRole (roleid,userid) values ('" + roleid + "','" + user.ID.ToString() + "') "; if (DBA.SqlDbAccess.ExecNoQuery(CommandType.Text, sqlShouCang, null) < 0) { return "-1"; } return "1"; }