//-----------------------------------------truy vấn chi tiết điện thoại -------------------------------- public List <product_detail_hienthi> danhSachDienThoaiTheoMa(int product_id) { List <product_detail_hienthi> product_Details = new List <product_detail_hienthi>(); string dsdttheoma = "select product.product_id,product.product_name,color.color_name,product_detail.quantity, product.image,product_detail.product_detail_id from product_detail inner join product on product_detail.product_id = product.product_id inner join color on product_detail.color_id = color.color_id where product_detail.product_id =@product_id"; con.Open(); SqlCommand sqlCommand = new SqlCommand(dsdttheoma, con); sqlCommand.Parameters.AddWithValue("product_id", product_id); SqlDataReader dr = sqlCommand.ExecuteReader(); while (dr.Read()) { product_detail_hienthi product_Detail_Hienthi = new product_detail_hienthi(); product_Detail_Hienthi.product_detail_id = (int)dr["product_detail_id"]; product_Detail_Hienthi.color_name = (string)dr["color_name"]; product_Detail_Hienthi.image = (string)dr["image"]; product_Detail_Hienthi.product_name = (string)dr["product_name"]; product_Detail_Hienthi.quantity = (int)dr["quantity"]; product_Detail_Hienthi.product_id = (int)dr["product_id"]; product_Details.Add(product_Detail_Hienthi); } con.Close(); return(product_Details); }
protected void edit_Click(object sender, EventArgs e) { product_detail_hienthi product_Detail_Hienthi = new product_detail_hienthi(); product_Detail_Hienthi.color_id = int.Parse(dsmau.SelectedValue); product_Detail_Hienthi.quantity = int.Parse(soluong.Value); product_Detail_Hienthi.product_detail_id = int.Parse(product_detail_id.Value); DataUtils.suaSoLuongVaMau(product_Detail_Hienthi); }
protected void edit_click(object sender, CommandEventArgs e1) { if (e1.CommandName == "edit") { int productDetailId = Convert.ToInt16(e1.CommandArgument); product_detail_hienthi product_detail_hienthi = dataUtils.layProductDetail(productDetailId); Session["product_detail_hienthi"] = product_detail_hienthi; Response.Redirect("editProductDetail.aspx"); } }
public void suaSoLuongVaMau(product_detail_hienthi product_Detail_Hienthi) { string sqlSua = "update product_detail set color_id=@color_id,quantity=@quantity where product_detail_id=@product_detail_id"; con.Open(); SqlCommand cmd = new SqlCommand(sqlSua, con); cmd.Parameters.AddWithValue("color_id", product_Detail_Hienthi.color_id); cmd.Parameters.AddWithValue("quantity", product_Detail_Hienthi.quantity); cmd.Parameters.AddWithValue("product_detail_id", product_Detail_Hienthi.product_detail_id); cmd.ExecuteNonQuery(); con.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { product_detail_hienthi product_Detail_Hienthi = (product_detail_hienthi)Session["product_detail_hienthi"]; product_name.Text = product_Detail_Hienthi.product_name; soluong.Value = product_Detail_Hienthi.quantity.ToString(); product_detail_id.Value = product_Detail_Hienthi.product_detail_id.ToString(); dsmau.DataSource = DataUtils.GetColors(); dsmau.DataValueField = "color_id"; dsmau.DataTextField = "color_name"; dsmau.DataBind(); dsmau.SelectedValue = product_Detail_Hienthi.color_id.ToString(); quayvetrangchitiet.PostBackUrl = "~/product-detail-ad.aspx?product_id=" + product_Detail_Hienthi.product_id; } }
public product_detail_hienthi layProductDetail(int productDetailId) { product_detail_hienthi product_detail_hienthi = new product_detail_hienthi(); string ds = "select product_detail.quantity,color.color_name,product.product_name,color.color_id,product_detail.product_detail_id,product_detail.product_id from product_detail inner join product on product_detail.product_id = product.product_id inner join color on product_detail.color_id = color.color_id where product_detail.product_detail_id = @product_detail_id"; con.Open(); SqlCommand cmd = new SqlCommand(ds, con); cmd.Parameters.AddWithValue("product_detail_id", productDetailId); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { product_detail_hienthi.product_detail_id = (int)dr["product_detail_id"]; product_detail_hienthi.product_name = (string)dr["product_name"]; product_detail_hienthi.color_name = (string)dr["color_name"]; product_detail_hienthi.quantity = (int)dr["quantity"]; product_detail_hienthi.color_id = (int)dr["color_id"]; product_detail_hienthi.product_id = (int)dr["product_id"]; } con.Close(); return(product_detail_hienthi); }