/// <summary> /// 更新一条数据(所有字段) /// </summary> public int Update(DBHelper myHelperMySQL, Fm.Entity.wx_requestdata model, string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("update wx_requestdata set "); strSql.Append(" id = @id , "); strSql.Append(" DataKey = @DataKey , "); strSql.Append(" DataValue = @DataValue , "); strSql.Append(" expires_in = @expires_in , "); strSql.Append(" RefreshTime = @RefreshTime "); MySqlParameter[] parameters = { new MySqlParameter("@id", model.id), new MySqlParameter("@DataKey", model.DataKey), new MySqlParameter("@DataValue", model.DataValue), new MySqlParameter("@expires_in", model.expires_in), new MySqlParameter("@RefreshTime", model.RefreshTime) }; if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } int rows = myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters); return(rows); }
/// <summary> /// 得到一个对象实体(List类型),数据连接类用myHelperMySQL(非静态) /// 表:MessageBoard /// <param name="myHelperMySQL">myHelperMySQL实例(数据访问类).</param> /// <param name="Top">记录数.</param> /// <param name="filedSelect">自定义字段.</param> /// <param name="strWhere">条件.</param> /// <param name="filedOrder">排序字段.</param> /// <param name="parameters">参数(若条件中未使用参数可为null).</param> /// </summary> public List <Fm.Entity.wx_requestdata> GetList(DBHelper myHelperMySQL, int Top, string filedSelect, string strWhere, string filedOrder, MySqlParameter[] parameters) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); //自定义字段 strSql.Append(" " + filedSelect); strSql.Append(" FROM wx_requestdata 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_requestdata> myList = new List <Fm.Entity.wx_requestdata>(); using (MySqlDataReader dr = myHelperMySQL.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { Fm.Entity.wx_requestdata model = new Fm.Entity.wx_requestdata(); if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.id").Count() > 0) { if (dr["id"].ToString() != "") { model.id = int.Parse(dr["id"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.datakey").Count() > 0) { model.DataKey = dr["DataKey"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.datavalue").Count() > 0) { model.DataValue = dr["DataValue"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.expires_in").Count() > 0) { model.expires_in = dr["expires_in"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.refreshtime").Count() > 0) { model.RefreshTime = dr["RefreshTime"].ToString(); } myList.Add(model); } dr.Close(); } return(myList); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DBHelper myHelperMySQL, Fm.Entity.wx_requestdata model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into wx_requestdata("); strSql.Append("id,DataKey,DataValue,expires_in,RefreshTime"); strSql.Append(") values ("); strSql.Append("@id,@DataKey,@DataValue,@expires_in,@RefreshTime"); strSql.Append(") "); MySqlParameter[] parameters = { new MySqlParameter("@id", model.id), new MySqlParameter("@DataKey", model.DataKey), new MySqlParameter("@DataValue", model.DataValue), new MySqlParameter("@expires_in", model.expires_in), new MySqlParameter("@RefreshTime", model.RefreshTime) }; myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters); }