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