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