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