/// <summary> /// 得到一个对象实体 /// </summary> public BuysingooShop.Model.order_goods DataRowToModel(DataRow row) { BuysingooShop.Model.order_goods model = new BuysingooShop.Model.order_goods(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["order_id"] != null && row["order_id"].ToString() != "") { model.order_id = int.Parse(row["order_id"].ToString()); } if (row["goods_id"] != null && row["goods_id"].ToString() != "") { model.goods_id = int.Parse(row["goods_id"].ToString()); } if (row["goods_title"] != null) { model.goods_title = row["goods_title"].ToString(); } if (row["goods_price"] != null && row["goods_price"].ToString() != "") { model.goods_price = decimal.Parse(row["goods_price"].ToString()); } if (row["real_price"] != null && row["real_price"].ToString() != "") { model.real_price = decimal.Parse(row["real_price"].ToString()); } if (row["quantity"] != null && row["quantity"].ToString() != "") { model.quantity = int.Parse(row["quantity"].ToString()); } if (row["point"] != null && row["point"].ToString() != "") { model.point = int.Parse(row["point"].ToString()); } if (row["goods_pic"] != null) { model.goods_pic = row["goods_pic"].ToString(); } if (row["strcode"] != null) { model.strcode = row["strcode"].ToString(); } if (row["type"] != null && row["type"].ToString() != "") { model.type = row["type"].ToString(); } if (row["total"] != null && row["total"].ToString() != "") { model.total = decimal.Parse(row["total"].ToString()); } if (row["weight"] != null && row["weight"].ToString() != "") { model.weight = decimal.Parse(row["weight"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BuysingooShop.Model.order_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "order_goods set "); strSql.Append("order_id=@order_id,"); strSql.Append("goods_id=@goods_id,"); strSql.Append("goods_title=@goods_title,"); strSql.Append("goods_price=@goods_price,"); strSql.Append("real_price=@real_price,"); strSql.Append("quantity=@quantity,"); strSql.Append("point=@point,"); strSql.Append("goods_pic=@goods_pic,"); strSql.Append("strcode=@strcode,"); strSql.Append("type=@type,"); strSql.Append("total=@total,"); strSql.Append("weight=@weight"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@order_id", SqlDbType.Int, 4), new SqlParameter("@goods_id", SqlDbType.Int, 4), new SqlParameter("@goods_title", SqlDbType.NVarChar, 100), new SqlParameter("@goods_price", SqlDbType.Decimal, 5), new SqlParameter("@real_price", SqlDbType.Decimal, 5), new SqlParameter("@quantity", SqlDbType.Int, 4), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@goods_pic", SqlDbType.NVarChar, 255), new SqlParameter("@strcode", SqlDbType.VarChar, 50), new SqlParameter("@type", SqlDbType.VarChar, 50), new SqlParameter("@total", SqlDbType.Decimal, 5), new SqlParameter("@weight", SqlDbType.Decimal, 5), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.order_id; parameters[1].Value = model.goods_id; parameters[2].Value = model.goods_title; parameters[3].Value = model.goods_price; parameters[4].Value = model.real_price; parameters[5].Value = model.quantity; parameters[6].Value = model.point; parameters[7].Value = model.goods_pic; parameters[8].Value = model.strcode; parameters[9].Value = model.type; parameters[10].Value = model.total; parameters[11].Value = model.weight; parameters[12].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BuysingooShop.Model.order_goods GetModel(string strwhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,order_id,goods_id,goods_title,goods_price,real_price,quantity,point,goods_pic,strcode,type,total,weight from " + databaseprefix + "order_goods "); strSql.Append(" where " + strwhere); BuysingooShop.Model.order_goods model = new BuysingooShop.Model.order_goods(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); return(ds.Tables[0].Rows.Count > 0 ? DataRowToModel(ds.Tables[0].Rows[0]) : null); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BuysingooShop.Model.order_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "order_goods("); strSql.Append("order_id,goods_id,goods_title,goods_price,real_price,quantity,point,goods_pic,strcode,type,total,weight)"); strSql.Append(" values ("); strSql.Append("@order_id,@goods_id,@goods_title,@goods_price,@real_price,@quantity,@point,@goods_pic,@strcode,@type,@total,@weight)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@order_id", SqlDbType.Int, 4), new SqlParameter("@goods_id", SqlDbType.Int, 4), new SqlParameter("@goods_title", SqlDbType.NVarChar, 100), new SqlParameter("@goods_price", SqlDbType.Decimal, 5), new SqlParameter("@real_price", SqlDbType.Decimal, 5), new SqlParameter("@quantity", SqlDbType.Int, 4), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@goods_pic", SqlDbType.NVarChar, 255), new SqlParameter("@strcode", SqlDbType.VarChar, 50), new SqlParameter("@type", SqlDbType.VarChar, 50), new SqlParameter("@total", SqlDbType.Decimal, 5), new SqlParameter("@weight", SqlDbType.Decimal, 5) }; parameters[0].Value = model.order_id; parameters[1].Value = model.goods_id; parameters[2].Value = model.goods_title; parameters[3].Value = model.goods_price; parameters[4].Value = model.real_price; parameters[5].Value = model.quantity; parameters[6].Value = model.point; parameters[7].Value = model.goods_pic; parameters[8].Value = model.strcode; parameters[9].Value = model.type; parameters[10].Value = model.total; parameters[11].Value = model.weight; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BuysingooShop.Model.order_goods GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,order_id,goods_id,goods_title,goods_price,real_price,quantity,point,goods_pic,strcode,type,total,weight from " + databaseprefix + "order_goods "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; BuysingooShop.Model.order_goods model = new BuysingooShop.Model.order_goods(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体(通过orderID) /// </summary> public BuysingooShop.Model.order_goods GetModelorderid(int orderid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,order_id,goods_id,goods_title,goods_price,real_price,quantity,point,goods_pic,strcode,type,total,weight from " + databaseprefix + "order_goods "); strSql.Append(" where order_id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = orderid; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { //商品名称 string _goods_title = ""; //商品类型 string _type = ""; //商品总额 string _totalstring = ""; //商品数量 string _quantitystring = ""; //商品单价 string _goods_pricestring = ""; //商品重量 string _weightstring = ""; BuysingooShop.Model.order_goods model = new BuysingooShop.Model.order_goods(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["id"] != null && ds.Tables[0].Rows[i]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[i]["id"].ToString()); } if (ds.Tables[0].Rows[i]["order_id"] != null && ds.Tables[0].Rows[i]["order_id"].ToString() != "") { model.order_id = int.Parse(ds.Tables[0].Rows[i]["order_id"].ToString()); } if (ds.Tables[0].Rows[i]["goods_id"] != null && ds.Tables[0].Rows[i]["goods_id"].ToString() != "") { model.goods_id = int.Parse(ds.Tables[0].Rows[i]["goods_id"].ToString()); } if (ds.Tables[0].Rows[i]["goods_title"] != null) { _goods_title += ds.Tables[0].Rows[i]["goods_title"].ToString() + ","; } if (ds.Tables[0].Rows[i]["goods_price"] != null && ds.Tables[0].Rows[i]["goods_price"].ToString() != "") { _goods_pricestring += ds.Tables[0].Rows[i]["goods_price"].ToString() + ","; } if (ds.Tables[0].Rows[i]["real_price"] != null && ds.Tables[0].Rows[i]["real_price"].ToString() != "") { model.real_price = decimal.Parse(ds.Tables[0].Rows[i]["real_price"].ToString()); } if (ds.Tables[0].Rows[i]["quantity"] != null && ds.Tables[0].Rows[i]["quantity"].ToString() != "") { _quantitystring += ds.Tables[0].Rows[i]["quantity"].ToString() + ","; } if (ds.Tables[0].Rows[i]["point"] != null && ds.Tables[0].Rows[i]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[i]["point"].ToString()); } if (ds.Tables[0].Rows[i]["goods_pic"] != null) { model.goods_pic = ds.Tables[0].Rows[i]["goods_pic"].ToString(); } if (ds.Tables[0].Rows[i]["strcode"] != null) { model.strcode = ds.Tables[0].Rows[i]["strcode"].ToString(); } if (ds.Tables[0].Rows[i]["type"] != null && ds.Tables[0].Rows[i]["type"].ToString() != "") { _type += ds.Tables[0].Rows[i]["type"].ToString() + ","; } if (ds.Tables[0].Rows[i]["total"] != null && ds.Tables[0].Rows[i]["total"].ToString() != "") { _totalstring += ds.Tables[0].Rows[i]["total"].ToString() + ","; } if (ds.Tables[0].Rows[i]["weight"] != null && ds.Tables[0].Rows[i]["weight"].ToString() != "") { _weightstring += ds.Tables[0].Rows[i]["weight"].ToString() + ","; } } model.totalstring = _totalstring.Substring(0, _totalstring.Length - 1); model.goods_title = _goods_title; model.type = _type; model.quantitystring = _quantitystring.Substring(0, _quantitystring.Length - 1); model.goods_pricestring = _goods_pricestring; model.weightstring = _weightstring; return(model); } else { return(null); } }