public wx_UserExtEntity Populate_wx_UserExtEntity_FromDr(IDataReader dr)
{
wx_UserExtEntity Obj = new wx_UserExtEntity();
Obj.UserId = ((dr["UserId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["UserId"]);
Obj.RealName = dr["RealName"].ToString();
Obj.Phone = dr["Phone"].ToString();
Obj.Weixin = dr["Weixin"].ToString();
Obj.Description = dr["Description"].ToString();
Obj.OpenId = dr["OpenId"].ToString();
Obj.ShopId = ((dr["ShopId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["ShopId"]);
Obj.RoleId = ((dr["RoleId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["RoleId"]);
Obj.Status = ((dr["Status"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["Status"]);
Obj.Address = dr["Address"].ToString();
Obj.Points = ((dr["Points"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["Points"]);
Obj.Wallet = ((dr["Wallet"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["Wallet"]);
Obj.AddTime = ((dr["AddTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["AddTime"]);
Obj.UpdateTime = ((dr["UpdateTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["UpdateTime"]);
Obj.ParentId = ((dr["ParentId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["ParentId"]);
Obj.ParentName = dr["ParentName"].ToString();
Obj.NickName = dr["NickName"].ToString();
Obj.HeadImgurl = dr["HeadImgurl"].ToString();
Obj.RoleName = dr["rolename"].ToString();
Obj.yeji = ((dr["yeji"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["yeji"]);
Obj.yongjin = ((dr["yongjin"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["yongjin"]);
Obj.tixian = ((dr["tixian"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["tixian"]);
Obj.yijidaili = ((dr["yijidaili"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["yijidaili"]);
Obj.erjidaili = ((dr["erjidaili"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["erjidaili"]);
return(Obj);
}
public wx_UserExtEntity GetExtModelByUserId(int userid)
{
wx_UserExtEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@UserId", SqlDbType.Int)
};
_param[0].Value = userid;
string sqlStr = "select * from v_UserExt with(nolock) where UserId=@UserId";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.WfxRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_wx_UserExtEntity_FromDr(dr);
}
}
return(_obj);
}
