/// <summary> /// 更新一条数据(所有字段) /// </summary> public int Update(DBHelper myHelperMySQL, Fm.Entity.orderlist model, string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("update orderlist set "); strSql.Append(" OrderId = @OrderId , "); strSql.Append(" ProductId = @ProductId , "); strSql.Append(" ProductName = @ProductName , "); strSql.Append(" Num = @Num , "); strSql.Append(" ProductPrice = @ProductPrice , "); strSql.Append(" ProductImage = @ProductImage "); MySqlParameter[] parameters = { new MySqlParameter("@OrderId", model.OrderId), new MySqlParameter("@ProductId", model.ProductId), new MySqlParameter("@ProductName", model.ProductName), new MySqlParameter("@Num", model.Num), new MySqlParameter("@ProductPrice", model.ProductPrice), new MySqlParameter("@ProductImage", model.ProductImage) }; if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } int rows = myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters); return(rows); }
public void ADD(Fm.Entity.orderlist model) { DBHelper myHelperMySQL = new DBHelper(); myHelperMySQL.connectionStr = MySQLConfig.ConnStringCenter; dal.Add(myHelperMySQL, model); }
/// <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.orderlist> GetList(DBHelper myHelperMySQL, int Top, string strWhere, string filedOrder, MySqlParameter[] parameters) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" a.OrderId, a.ProductId, a.ProductName, a.Num, a.ProductPrice, a.ProductImage "); strSql.Append(" FROM orderlist 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.orderlist> myList = new List <Fm.Entity.orderlist>(); using (MySqlDataReader dr = myHelperMySQL.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { Fm.Entity.orderlist model = new Fm.Entity.orderlist(); model.OrderId = dr["OrderId"].ToString(); model.ProductId = dr["ProductId"].ToString(); model.ProductName = dr["ProductName"].ToString(); if (dr["Num"].ToString() != "") { model.Num = int.Parse(dr["Num"].ToString()); } if (dr["ProductPrice"].ToString() != "") { model.ProductPrice = decimal.Parse(dr["ProductPrice"].ToString()); } model.ProductImage = dr["ProductImage"].ToString(); myList.Add(model); } dr.Close(); } return(myList); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DBHelper myHelperMySQL, Fm.Entity.orderlist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into orderlist("); strSql.Append("OrderId,ProductId,ProductName,Num,ProductPrice,ProductImage"); strSql.Append(") values ("); strSql.Append("@OrderId,@ProductId,@ProductName,@Num,@ProductPrice,@ProductImage"); strSql.Append(") "); MySqlParameter[] parameters = { new MySqlParameter("@OrderId", model.OrderId), new MySqlParameter("@ProductId", model.ProductId), new MySqlParameter("@ProductName", model.ProductName), new MySqlParameter("@Num", model.Num), new MySqlParameter("@ProductPrice", model.ProductPrice), new MySqlParameter("@ProductImage", model.ProductImage) }; myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters); }