/// <summary>
/// 得到一个对象实体
/// </summary>
public WechatBuilder.Model.wx_ucard_users GetStoreUserInfo(string oepnid, int sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,sid,openid,cardNo,pwd,degreeId,sex,birthday,wxName,realName,age,qq,regTime,regIp,telphone,mobile,email,addr,endDate,ttScore,qdScore,consumeScore,consumeMoney from wx_ucard_users ");
strSql.Append(" where sid=@sid and openid=@openid");
SqlParameter[] parameters = {
new SqlParameter("@sid", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100)
};
parameters[0].Value = sid;
parameters[1].Value = oepnid;
WechatBuilder.Model.wx_ucard_users model = new WechatBuilder.Model.wx_ucard_users();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WechatBuilder.Model.wx_ucard_users DataRowToModel(DataRow row)
{
WechatBuilder.Model.wx_ucard_users model=new WechatBuilder.Model.wx_ucard_users();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["wid"]!=null && row["wid"].ToString()!="")
{
model.wid=int.Parse(row["wid"].ToString());
}
if(row["sid"]!=null && row["sid"].ToString()!="")
{
model.sid=int.Parse(row["sid"].ToString());
}
if(row["openid"]!=null)
{
model.openid=row["openid"].ToString();
}
if(row["cardNo"]!=null)
{
model.cardNo=row["cardNo"].ToString();
}
if(row["pwd"]!=null)
{
model.pwd=row["pwd"].ToString();
}
if(row["degreeId"]!=null && row["degreeId"].ToString()!="")
{
model.degreeId=int.Parse(row["degreeId"].ToString());
}
if(row["sex"]!=null && row["sex"].ToString()!="")
{
model.sex=int.Parse(row["sex"].ToString());
}
if(row["birthday"]!=null && row["birthday"].ToString()!="")
{
model.birthday=DateTime.Parse(row["birthday"].ToString());
}
if(row["wxName"]!=null)
{
model.wxName=row["wxName"].ToString();
}
if(row["realName"]!=null)
{
model.realName=row["realName"].ToString();
}
if(row["age"]!=null && row["age"].ToString()!="")
{
model.age=int.Parse(row["age"].ToString());
}
if(row["qq"]!=null)
{
model.qq=row["qq"].ToString();
}
if(row["regTime"]!=null && row["regTime"].ToString()!="")
{
model.regTime=DateTime.Parse(row["regTime"].ToString());
}
if(row["regIp"]!=null)
{
model.regIp=row["regIp"].ToString();
}
if(row["telphone"]!=null)
{
model.telphone=row["telphone"].ToString();
}
if(row["mobile"]!=null)
{
model.mobile=row["mobile"].ToString();
}
if(row["email"]!=null)
{
model.email=row["email"].ToString();
}
if(row["addr"]!=null)
{
model.addr=row["addr"].ToString();
}
if(row["endDate"]!=null && row["endDate"].ToString()!="")
{
model.endDate=DateTime.Parse(row["endDate"].ToString());
}
if(row["ttScore"]!=null && row["ttScore"].ToString()!="")
{
model.ttScore=int.Parse(row["ttScore"].ToString());
}
if(row["qdScore"]!=null && row["qdScore"].ToString()!="")
{
model.qdScore=int.Parse(row["qdScore"].ToString());
}
if(row["consumeScore"]!=null && row["consumeScore"].ToString()!="")
{
model.consumeScore=int.Parse(row["consumeScore"].ToString());
}
if(row["consumeMoney"]!=null && row["consumeMoney"].ToString()!="")
{
model.consumeMoney=decimal.Parse(row["consumeMoney"].ToString());
}
}
return model;
}
