///// <summary> ///// 登录 ///// </summary> ///// <param name="name"></param> ///// <param name="pwd"></param> ///// <param name="customer"></param> ///// <returns></returns> //public static WGUserEn Login(string name, string pwd, string customer, string openid, string nickname) //{ // using (DBSession db = new DBSession()) // { // pwd = pwd.Trim2().ToSHA1(); // string sql = @"select su.id as GWYUSERID,su.name GWYUSERCODE,su.realname as GWYUSERNAME,csc.code as CUSTOMERCODE,csc.hscode,csc.iscompany,csc.iscustomer,csc.isreceiver // from sys_user su left join cusdoc.sys_customer csc on su.customerid=csc.id where su.name='{0}' and su.password='******' and csc.code='{2}' and su.enabled=1"; // sql = string.Format(sql, name.Trim2(), pwd, customer.Trim2().ToUpper()); // WGUserEn user = db.QuerySignleEntity<WGUserEn>(sql); // if (user != null) // { // user.WCOpenID = openid; // user.WCNickName = nickname; // } // return user; // } //} ///// <summary> ///// 登录 ///// </summary> ///// <param name="name"></param> ///// <param name="pwd"></param> ///// <param name="customer"></param> ///// <returns></returns> //public static WGUserEn LoginById(string id) //{ // using (DBSession db = new DBSession()) // { // string sql = @"select su.id as GWYUSERID,su.name as GWYUSERCODE,su.realname as GWYUSERNAME,csc.code as CUSTOMERCODE,csc.hscode,csc.iscompany,csc.iscustomer,csc.isreceiver // from sys_user su left join cusdoc.sys_customer csc on su.customerid=csc.id where su.id={0} and su.enabled=1"; // sql = string.Format(sql, id); // WGUserEn user = db.QuerySignleEntity<WGUserEn>(sql); // return user; // } //} ///// <summary> ///// 判断用户是否已经存在, ///// </summary> ///// <param name="usercode"></param> ///// <param name="openid"></param> ///// <param name="nickname"></param> ///// <returns></returns> //public static bool UserExsit(string usercode, string openid, string nickname) //{ // using (DBSession db = new DBSession()) // { // string sql = "select wcopenid,wcnickname,isunbind from wechat_user where gwyusercode='" + usercode + "' and wcopenid<>'" + openid + "' order by unbindtime desc "; // DataTable dt = db.QuerySignle(sql); // if (dt != null && dt.Rows.Count > 0) // { // //已经存在则向之前的用户推送消息 // string exsql = @"insert into wechat_loginexceptioninfo(id,loginopenid,loginnickname,usercode,oldopenid,oldnickname) // values(wechat_loginexceptioninfo_id.nextval,'{0}','{1}','{2}','{3}','{4}')"; // exsql = string.Format(exsql, openid, nickname, usercode, dt.Rows[0]["wcopenid"].ToString2(), dt.Rows[0]["wcnickname"].ToString2()); // db.ExecuteSignle(exsql); // if (dt.Rows[0]["isunbind"].ToString2() == "1") // { // return false;//已经解绑,可以登录 // } // else // { // return true;//未解绑,不可登录 // } // } // return false; // } //} ///// <summary> ///// 新增账号 ///// </summary> ///// <param name="user"></param> ///// <returns></returns> //public static bool SaveUser(WGUserEn user) //{ // using (DBSession db = new DBSession()) // { // //string sql = "delete from wechat_user where WCOpenID='" + user.WCOpenID + "'"; // //db.ExecuteSignle(sql); // string sql = @"insert into wechat_user(id,GWYUSERCODE,GWYUSERNAME,WCOpenID,WCNickName,iscompany,iscustomer,isreceiver,customercode,createdate,gwyuserid,hscode) // values(wechat_user_id.nextval,'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',sysdate,{8},'{9}')"; // sql = string.Format(sql, user.GwyUserCode, user.GwyUserName, user.WCOpenID, user.WCNickName, user.IsCompany, user.IsCustomer, user.IsReceiver, // user.CustomerCode, user.GwyUserID, user.HSCode); // return db.ExecuteSignle(sql) == 0 ? false : true; // } //} ///// <summary> ///// 注销账号 ///// </summary> ///// <param name="openid"></param> ///// <returns></returns> //public static bool DeleteUser(string openid) //{ // using (DBSession db = new DBSession()) // { // string sql = "update wechat_user set isunbind=1,unbindtime=sysdate where wcopenid='" + openid + "'"; // return db.ExecuteSignle(sql) == 0 ? false : true; // } //} /// <summary> /// 根据opneid查询关联账号 /// </summary> /// <param name="openid"></param> /// <returns></returns> public static WPGIUserEn getWeChatUser(string openid) { DataTable dt = DbHelperSQL.Query("select * from Users where openid='" + openid + "'").Tables[0]; WPGIUserEn wuser = new WPGIUserEn(); if (dt != null) { if (dt.Rows.Count == 1) { wuser.workcode = dt.Rows[0]["workcode"].ToString(); wuser.workname = dt.Rows[0]["workname"].ToString(); wuser.telphone = dt.Rows[0]["telphone"].ToString(); wuser.password = dt.Rows[0]["password"].ToString(); wuser.openid = dt.Rows[0]["openid"].ToString(); } } return(wuser); }
protected void Page_Load(object sender, EventArgs e) { WPGIUserEn user = (WPGIUserEn)HttpContext.Current.Session["user"]; //如果当前用户未登陆,先获取授权 if (user == null) { WUserEn userInfo = PageShowQuan.GetShouQuanMessage(); if (userInfo != null && !string.IsNullOrEmpty(userInfo.OpenID)) { //授权成功 LogHelper.Write("第9步:" + userInfo.OpenID); WPGIUserEn wuser = UserModel.getWeChatUser(userInfo.OpenID); if (wuser == null || string.IsNullOrEmpty(wuser.workcode)) {//账号未关联,跳转至登录界面 LogHelper.Write("第10步:" + userInfo.OpenID); System.Web.HttpContext.Current.Response.Redirect(@"../Login.aspx?openid=" + userInfo.OpenID + "&nickname=" + userInfo.NickName + "&transferurl=SiteDeclareList"); } else {//无此权限 HttpContext.Current.Session["user"] = wuser; System.Web.HttpContext.Current.Response.Redirect(@"../WarnPage.aspx"); } LogHelper.Write("第12步:" + wuser.openid); } else {//获取授权失败,也跳转至登录页面 System.Web.HttpContext.Current.Response.Redirect(@"../Login.aspx?openid=" + userInfo.OpenID + "&nickname=" + userInfo.NickName + "&transferurl=SiteDeclareList"); } } else//无此权限 { System.Web.HttpContext.Current.Response.Redirect(@"../WarnPage.aspx"); } }