/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DBHelper myHelperMySQL, Fm.Entity.wx_userinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_userinfo(");
strSql.Append("openid,nickname,sex,province,city,country,headimgurl,privilege,unionid,CreateDate");
strSql.Append(") values (");
strSql.Append("@openid,@nickname,@sex,@province,@city,@country,@headimgurl,@privilege,@unionid,@CreateDate");
strSql.Append(") ");
MySqlParameter[] parameters =
{
new MySqlParameter("@openid", model.openid),
new MySqlParameter("@nickname", model.nickname),
new MySqlParameter("@sex", model.sex),
new MySqlParameter("@province", model.province),
new MySqlParameter("@city", model.city),
new MySqlParameter("@country", model.country),
new MySqlParameter("@headimgurl", model.headimgurl),
new MySqlParameter("@privilege", model.privilege),
new MySqlParameter("@unionid", model.unionid),
new MySqlParameter("@CreateDate", model.CreateDate)
};
myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体(List类型)，数据连接类用myHelperMySQL（非静态）,查询全部数据
/// 表：MessageBoard
/// <param name="myHelperMySQL">myHelperMySQL实例（数据访问类）.</param>
/// <param name="Top">记录数.</param>
/// <param name="strWhere">条件.</param>
/// <param name="filedOrder">排序字段.</param>
/// <param name="parameters">参数(若条件中未使用参数可为null).</param>
/// </summary>
public List <Fm.Entity.wx_userinfo> GetList(DBHelper myHelperMySQL, int Top, string strWhere, string filedOrder, MySqlParameter[] parameters)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" a.openid, a.nickname, a.sex, a.province, a.city, a.country, a.headimgurl, a.privilege, a.unionid, a.CreateDate ");
strSql.Append(" FROM wx_userinfo a ");
if (strWhere.Trim() != "")
{
strSql.Append(" WHERE " + strWhere);
}
if (filedOrder.Trim() != "")
{
strSql.Append(" ORDER BY " + filedOrder);
}
if (Top > 0)
{
strSql.Append(" limit " + Top.ToString());
}
List <Fm.Entity.wx_userinfo> myList = new List <Fm.Entity.wx_userinfo>();
using (MySqlDataReader dr = myHelperMySQL.ExecuteReader(strSql.ToString(), parameters))
{
while (dr.Read())
{
Fm.Entity.wx_userinfo model = new Fm.Entity.wx_userinfo();
model.openid = dr["openid"].ToString();
model.nickname = dr["nickname"].ToString();
if (dr["sex"].ToString() != "")
{
model.sex = int.Parse(dr["sex"].ToString());
}
model.province = dr["province"].ToString();
model.city = dr["city"].ToString();
model.country = dr["country"].ToString();
model.headimgurl = dr["headimgurl"].ToString();
model.privilege = dr["privilege"].ToString();
model.unionid = dr["unionid"].ToString();
model.CreateDate = dr["CreateDate"].ToString();
myList.Add(model);
}
dr.Close();
}
return(myList);
}
/// <summary>
/// 更新一条数据(所有字段)
/// </summary>
public int Update(DBHelper myHelperMySQL, Fm.Entity.wx_userinfo model, string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_userinfo set ");
strSql.Append(" openid = @openid , ");
strSql.Append(" nickname = @nickname , ");
strSql.Append(" sex = @sex , ");
strSql.Append(" province = @province , ");
strSql.Append(" city = @city , ");
strSql.Append(" country = @country , ");
strSql.Append(" headimgurl = @headimgurl , ");
strSql.Append(" privilege = @privilege , ");
strSql.Append(" unionid = @unionid , ");
strSql.Append(" CreateDate = @CreateDate ");
MySqlParameter[] parameters =
{
new MySqlParameter("@openid", model.openid),
new MySqlParameter("@nickname", model.nickname),
new MySqlParameter("@sex", model.sex),
new MySqlParameter("@province", model.province),
new MySqlParameter("@city", model.city),
new MySqlParameter("@country", model.country),
new MySqlParameter("@headimgurl", model.headimgurl),
new MySqlParameter("@privilege", model.privilege),
new MySqlParameter("@unionid", model.unionid),
new MySqlParameter("@CreateDate", model.CreateDate)
};
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
int rows = myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters);
return(rows);
}
