/// <summary> /// 根据opneid查询关联账号 /// </summary> /// <param name="openid"></param> /// <returns></returns> public static WGUserEn getWeChatUser(string openid) { using (DBSession db = new DBSession()) { string sql = "select * from wechat_user where wcopenid='" + openid + "' and rownum=1 and isunbind=0"; WGUserEn wuser = db.QuerySignleEntity <WGUserEn>(sql); return(wuser); } }
/// <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="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); } }