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));
}
