/// <summary> /// 增加一条数据 /// </summary> public void Add(DBHelper myHelperMySQL, Fm.Entity.product_info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into product_info("); strSql.Append("ProductId,ProductName,ProductPrice,MainImgUrl,StoreNum,SalesNum,TypeId,Specifications,ProductWeight,ProductDetail,MadeFactor,MadeHome,Operator,StateId,CreateDate,RefreshDate"); strSql.Append(") values ("); strSql.Append("@ProductId,@ProductName,@ProductPrice,@MainImgUrl,@StoreNum,@SalesNum,@TypeId,@Specifications,@ProductWeight,@ProductDetail,@MadeFactor,@MadeHome,@Operator,@StateId,@CreateDate,@RefreshDate"); strSql.Append(") "); MySqlParameter[] parameters = { new MySqlParameter("@ProductId", model.ProductId), new MySqlParameter("@ProductName", model.ProductName), new MySqlParameter("@ProductPrice", model.ProductPrice), new MySqlParameter("@MainImgUrl", model.MainImgUrl), new MySqlParameter("@StoreNum", model.StoreNum), new MySqlParameter("@SalesNum", model.SalesNum), new MySqlParameter("@TypeId", model.TypeId), new MySqlParameter("@Specifications", model.Specifications), new MySqlParameter("@ProductWeight", model.ProductWeight), new MySqlParameter("@ProductDetail", model.ProductDetail), new MySqlParameter("@MadeFactor", model.MadeFactor), new MySqlParameter("@MadeHome", model.MadeHome), new MySqlParameter("@Operator", model.Operator), new MySqlParameter("@StateId", model.StateId), new MySqlParameter("@CreateDate", model.CreateDate), new MySqlParameter("@RefreshDate", model.RefreshDate) }; myHelperMySQL.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据(所有字段) /// </summary> public int Update(DBHelper myHelperMySQL, Fm.Entity.product_info model, string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("update product_info set "); strSql.Append(" ProductId = @ProductId , "); strSql.Append(" ProductName = @ProductName , "); strSql.Append(" ProductPrice = @ProductPrice , "); strSql.Append(" MainImgUrl = @MainImgUrl , "); strSql.Append(" StoreNum = @StoreNum , "); strSql.Append(" SalesNum = @SalesNum , "); strSql.Append(" TypeId = @TypeId , "); strSql.Append(" Specifications = @Specifications , "); strSql.Append(" ProductWeight = @ProductWeight , "); strSql.Append(" ProductDetail = @ProductDetail , "); strSql.Append(" MadeFactor = @MadeFactor , "); strSql.Append(" MadeHome = @MadeHome , "); strSql.Append(" Operator = @Operator , "); strSql.Append(" StateId = @StateId , "); strSql.Append(" CreateDate = @CreateDate , "); strSql.Append(" RefreshDate = @RefreshDate "); MySqlParameter[] parameters = { new MySqlParameter("@ProductId", model.ProductId), new MySqlParameter("@ProductName", model.ProductName), new MySqlParameter("@ProductPrice", model.ProductPrice), new MySqlParameter("@MainImgUrl", model.MainImgUrl), new MySqlParameter("@StoreNum", model.StoreNum), new MySqlParameter("@SalesNum", model.SalesNum), new MySqlParameter("@TypeId", model.TypeId), new MySqlParameter("@Specifications", model.Specifications), new MySqlParameter("@ProductWeight", model.ProductWeight), new MySqlParameter("@ProductDetail", model.ProductDetail), new MySqlParameter("@MadeFactor", model.MadeFactor), new MySqlParameter("@MadeHome", model.MadeHome), new MySqlParameter("@Operator", model.Operator), new MySqlParameter("@StateId", model.StateId), new MySqlParameter("@CreateDate", model.CreateDate), new MySqlParameter("@RefreshDate", model.RefreshDate) }; 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.product_info> 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 product_info 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.product_info> myList = new List <Fm.Entity.product_info>(); using (MySqlDataReader dr = myHelperMySQL.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { Fm.Entity.product_info model = new Fm.Entity.product_info(); if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.productid").Count() > 0) { model.ProductId = dr["ProductId"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.productname").Count() > 0) { model.ProductName = dr["ProductName"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.productprice").Count() > 0) { if (dr["ProductPrice"].ToString() != "") { model.ProductPrice = decimal.Parse(dr["ProductPrice"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.mainimgurl").Count() > 0) { model.MainImgUrl = dr["MainImgUrl"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.storenum").Count() > 0) { if (dr["StoreNum"].ToString() != "") { model.StoreNum = int.Parse(dr["StoreNum"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.salesnum").Count() > 0) { if (dr["SalesNum"].ToString() != "") { model.SalesNum = int.Parse(dr["SalesNum"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.typeid").Count() > 0) { if (dr["TypeId"].ToString() != "") { model.TypeId = int.Parse(dr["TypeId"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.specifications").Count() > 0) { model.Specifications = dr["Specifications"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.productweight").Count() > 0) { if (dr["ProductWeight"].ToString() != "") { model.ProductWeight = decimal.Parse(dr["ProductWeight"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.productdetail").Count() > 0) { model.ProductDetail = dr["ProductDetail"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.madefactor").Count() > 0) { model.MadeFactor = dr["MadeFactor"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.madehome").Count() > 0) { model.MadeHome = dr["MadeHome"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.operator").Count() > 0) { model.Operator = dr["Operator"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.stateid").Count() > 0) { if (dr["StateId"].ToString() != "") { model.StateId = int.Parse(dr["StateId"].ToString()); } } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.createdate").Count() > 0) { model.CreateDate = dr["CreateDate"].ToString(); } if (filedSelect.ToLower().Split(',').Where(x => x.Trim() == "a.refreshdate").Count() > 0) { model.RefreshDate = dr["RefreshDate"].ToString(); } myList.Add(model); } dr.Close(); } return(myList); }
/// <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.product_info> GetList(DBHelper myHelperMySQL, int Top, string strWhere, string filedOrder, MySqlParameter[] parameters) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" a.ProductId, a.ProductName, a.ProductPrice, a.MainImgUrl, a.StoreNum, a.SalesNum, a.TypeId, a.Specifications, a.ProductWeight, a.ProductDetail, a.MadeFactor, a.MadeHome, a.Operator, a.StateId, a.CreateDate, a.RefreshDate "); strSql.Append(" FROM product_info 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.product_info> myList = new List <Fm.Entity.product_info>(); using (MySqlDataReader dr = myHelperMySQL.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { Fm.Entity.product_info model = new Fm.Entity.product_info(); model.ProductId = dr["ProductId"].ToString(); model.ProductName = dr["ProductName"].ToString(); if (dr["ProductPrice"].ToString() != "") { model.ProductPrice = decimal.Parse(dr["ProductPrice"].ToString()); } model.MainImgUrl = dr["MainImgUrl"].ToString(); if (dr["StoreNum"].ToString() != "") { model.StoreNum = int.Parse(dr["StoreNum"].ToString()); } if (dr["SalesNum"].ToString() != "") { model.SalesNum = int.Parse(dr["SalesNum"].ToString()); } if (dr["TypeId"].ToString() != "") { model.TypeId = int.Parse(dr["TypeId"].ToString()); } model.Specifications = dr["Specifications"].ToString(); if (dr["ProductWeight"].ToString() != "") { model.ProductWeight = decimal.Parse(dr["ProductWeight"].ToString()); } model.ProductDetail = dr["ProductDetail"].ToString(); model.MadeFactor = dr["MadeFactor"].ToString(); model.MadeHome = dr["MadeHome"].ToString(); model.Operator = dr["Operator"].ToString(); if (dr["StateId"].ToString() != "") { model.StateId = int.Parse(dr["StateId"].ToString()); } model.CreateDate = dr["CreateDate"].ToString(); model.RefreshDate = dr["RefreshDate"].ToString(); myList.Add(model); } dr.Close(); } return(myList); }