public DataSet bindgr(Model.orderdetail myorderdetail) { StringBuilder sql = new StringBuilder(); sql.Append("select * from orderdetail where _order_num=@ordernum"); SqlParameter [] par = { new SqlParameter("@ordernum", SqlDbType.VarChar, 50) }; par[0].Value = myorderdetail.ordernum; return(Common.DbHelperSQL.Query(sql.ToString(), par)); }
public int insertdetail(Model.orderdetail myorderdetail) { StringBuilder sql = new StringBuilder(); sql.Append("insert into orderdetail(_product_count,_order_num,_sum_price,_product_price,_product_weight,_sum_weight,_product_name,_product_id,_product_size,_product_color,_product_image,_product_cate) "); sql.Append("values(@count,@ordernum,@sumprice,@price,@weight,@sumweight,@title,@proid,@size,@color,@proimage,@cate)"); SqlParameter[] par = { new SqlParameter("@count", SqlDbType.Int, 4), new SqlParameter("@ordernum", SqlDbType.VarChar, 50), new SqlParameter("@sumprice", SqlDbType.Money, 8), new SqlParameter("@price", SqlDbType.Money, 8), new SqlParameter("@weight", SqlDbType.VarChar, 50), new SqlParameter("@sumweight", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 50), new SqlParameter("@proid", SqlDbType.Int, 4), new SqlParameter("@size", SqlDbType.VarChar, 50), new SqlParameter("@color", SqlDbType.VarChar, 50), new SqlParameter("@proimage", SqlDbType.VarChar, 50), new SqlParameter("@cate", SqlDbType.VarChar, 50) }; par[0].Value = myorderdetail.count; par[1].Value = myorderdetail.ordernum; par[2].Value = myorderdetail.sumprice; par[3].Value = myorderdetail.price; par[4].Value = myorderdetail.weight; par[5].Value = myorderdetail.sumweight; par[6].Value = myorderdetail.title; par[7].Value = myorderdetail.proid; par[8].Value = myorderdetail.size; par[9].Value = myorderdetail.color; par[10].Value = myorderdetail.proimage; par[11].Value = myorderdetail.cate; return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
public int insertdetail(Model.orderdetail myorderdetail) { DAL.DALshoplist2 dall = new DAL.DALshoplist2(); return(dall.insertdetail(myorderdetail)); }
public DataSet bindgr(Model.orderdetail myorderdetail) { DAL.DALorderupdate dall = new DAL.DALorderupdate(); return(dall.bindgr(myorderdetail)); }