public MemberWithRedpacketEntity SelectMemberWithRedpacketByUserId(int userId)
{
string today = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
var sql = @"select registerid,password,username,mobile,realname,id_number,isrealname,userstate,userPhotoUrl,account_total_assets,available_balance,UsrCustId,frozen_sum,usertypes,invitedcode,lastlogintime,
ISNULL(VoucherCount,0) VoucherCount,ISNULL(RedpacketMoney,0) RedpacketMoney
from
(
select registerid,password,username,mobile,realname,id_number,isrealname,userstate,avatar as userPhotoUrl,account_total_assets,available_balance,UsrCustId,frozen_sum,usertypes,invitedcode,lastlogintime from hx_member_table
) c
left join
(
SELECT count(*) VoucherCount,[registerid] RID FROM hx_UserAct where UseState = 0 and AmtEndtime >= '" + today + "' and RewTypeID in (2,3) group by [registerid]) d on c.registerid = d.RID left join(SELECT sum(amt) RedpacketMoney,[registerid] RID FROM hx_UserAct where UseState = 0 and AmtEndtime >= '" + today + "' and RewTypeID = 2 group by [registerid]) e on c.registerid = e.RID WHERE registerid =@registerid";
SqlParameter[] parameters =
{
new SqlParameter("@registerid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = userId;
var ds = DbHelper.Query(sql, parameters);
if (DataSetIsNotNull(ds))
{
var ent = DataHelper.GetEntity <MemberWithRedpacketEntity>(ds.Tables[0]);
//var ent = InitMemberEntity(ds.Tables[0]);
ent.account_total_assets = CommonDal.GetAccountTotalAssets(ent.available_balance.Value, ent.frozen_sum.Value, userId);
ent.totalGains = GetTotalGains2(userId);//累计赚取总额
return(ent);
}
return(null);
}
public MemberEntity SelectMemberByUserId(int userId)
{
var sql = @"select registerid,password,username,mobile,realname,id_number,isrealname,userstate,avatar as userPhotoUrl,account_total_assets,available_balance,UsrCustId,frozen_sum,usertypes,invitedcode,lastlogintime from hx_member_table WHERE registerid =@registerid";
SqlParameter[] parameters =
{
new SqlParameter("@registerid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = userId;
var ds = DbHelper.Query(sql, parameters);
if (DataSetIsNotNull(ds))
{
var ent = InitMemberEntity(ds.Tables[0]);
CommonDal.FillMemberEntityAccountTotalAssets(ref ent, userId);
ent.totalGains = GetTotalGains(userId);//累计赚取总额
return(ent);
}
return(null);
}
