void Creat_Ri_by_Color()
{
try
{
if (!CheckValidate_F())
{
return;
}
c_j_ao = Convert.ToInt16(txtCount_J.Text);
c_from = Convert.ToInt16(txtFromAge.Text);
c_to = Convert.ToInt16(txtToAge.Text);
c_count = Convert.ToInt16(txtCount.Text);
decimal _count = 0;
foreach (Product_Detail_Info item in c_lst_Products_Detail)
{
_count += item.Total_Count / c_count;
}
if (_count == c_j_ao)
{
NoteBox.Show("Bạn đã nhập đủ số dây áo");
return;
}
frmCreate_Item _frmCreateItems = new frmCreate_Item();
_frmCreateItems.Owner = Window.GetWindow(this);
_frmCreateItems.c_count = c_j_ao - _count;
_frmCreateItems.ShowDialog();
if (_frmCreateItems.c_ok == 1)
{
Product_Detail_Info _Product_Detail_Info = new Product_Detail_Info();
_Product_Detail_Info.Name = " Ri " + (c_lst_Products_Detail.Count + 1).ToString();
_Product_Detail_Info.Color_Id = _frmCreateItems.c_ProductInfo.Color_Id;
_Product_Detail_Info.Total_Count = _frmCreateItems.c_ProductInfo.Count_Ri_by_Color * c_count;
_Product_Detail_Info.Ri_Count = _frmCreateItems.c_ProductInfo.Count_Ri_by_Color;
_Product_Detail_Info.Size = c_from.ToString() + " - " + c_to.ToString();
_Product_Detail_Info.Color_Name = _frmCreateItems.c_ProductInfo.Color_Name;
c_lst_Products_Detail.Add(_Product_Detail_Info);
dgrProduct_VietNam.ItemsSource = c_lst_Products_Detail;
dgrProduct_VietNam.Items.Refresh();
}
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
public bool Product_Detail_Insert(Product_Detail_Info p_Product_Detail_Info)
{
try
{
SqlParameter[] spParameter = new SqlParameter[6];
spParameter[0] = new SqlParameter("@Product_Id", SqlDbType.Int);
spParameter[0].Direction = ParameterDirection.Input;
spParameter[0].Value = p_Product_Detail_Info.Product_Id;
spParameter[1] = new SqlParameter("@Color_Id", SqlDbType.Int);
spParameter[1].Direction = ParameterDirection.Input;
spParameter[1].Value = p_Product_Detail_Info.Color_Id;
spParameter[2] = new SqlParameter("@Ri_Count", SqlDbType.Int);
spParameter[2].Direction = ParameterDirection.Input;
spParameter[2].Value = p_Product_Detail_Info.Ri_Count;
spParameter[3] = new SqlParameter("@Total_Count", SqlDbType.Int);
spParameter[3].Direction = ParameterDirection.Input;
spParameter[3].Value = p_Product_Detail_Info.Total_Count;
spParameter[4] = new SqlParameter("@Name", SqlDbType.NVarChar);
spParameter[4].Direction = ParameterDirection.Input;
spParameter[4].Value = p_Product_Detail_Info.Name;
spParameter[5] = new SqlParameter("@Size", SqlDbType.NVarChar);
spParameter[5].Direction = ParameterDirection.Input;
spParameter[5].Value = p_Product_Detail_Info.Size;
SqlHelper.ExecuteNonQuery(CommonData.ConnectionString, CommandType.StoredProcedure, "proc_Product_Detail_Insert", spParameter);
return(true);
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
return(false);
}
}
void Add_Product()
{
try
{
if (txtCount.Text == "")
{
NoteBox.Show("Nhập số lượng sản phẩm ", "", NoteBoxLevel.Error);
return;
}
if (c_Product_Info_Search == null)
{
return;
}
decimal _count = Convert.ToDecimal(txtCount.Text);
if (_count > c_Product_Info_Search.Total_Remain)
{
NoteBox.Show("Mua nhiều thế !!!!! Số lượng trong hàng không đủ, hiện tại chỉ còn " + c_Product_Info_Search.Total_Remain.ToString(), "", NoteBoxLevel.Error);
txtCount.Focus();
txtCount.SelectAll();
return;
}
decimal _color_id = 0;
if (cboColor.Text != "")
{
_color_id = Convert.ToDecimal(cboColor.SelectedValue);
c_Product_Info_Search.Color_Name = cboColor.Text;
c_Product_Info_Search.Color_Id = _color_id;
Product_Detail_Info _Product_Detail_Info = (Product_Detail_Info)cboColor.SelectedItem;
if (_count > _Product_Detail_Info.Remain_Count)
{
NoteBox.Show("Mua nhiều thế !!!!! Số lượng trong hàng không đủ, hiện tại chỉ còn " + _Product_Detail_Info.Remain_Count.ToString("###,###,0") + " sản phẩm", "", NoteBoxLevel.Error);
txtCount.Focus();
txtCount.SelectAll();
return;
}
}
string _key = c_Product_Info_Search.Product_Code.ToUpper() + "_" + _color_id.ToString();
if (!c_hs_Product.ContainsKey(_key))
{
c_Product_Info_Search.Count_Sale_By_Header = _count;
c_Product_Info_Search.Total_Price = c_Product_Info_Search.Count_Sale_By_Header * c_Product_Info_Search.BanBuon_Price;
c_list_Product_Buy.Add(c_Product_Info_Search);
c_hs_Product[_key] = c_Product_Info_Search;
}
else
{
Product_Info _Product_Info = (Product_Info)c_hs_Product[_key];
//_Product_Info.Count_Sale_By_Header = _Product_Info.Count_Sale_By_Header + _count;
_Product_Info.Count_Sale_By_Header = _count;
_Product_Info.Total_Price = c_Product_Info_Search.Count_Sale_By_Header * c_Product_Info_Search.BanBuon_Price;
}
txtProductCode.Focus();
txtProductCode.Text = "";
lblProduct_Name.Content = "";
lblRemain.Content = "";
lblSalePrice.Content = "";
dgrProduct.ItemsSource = c_list_Product_Buy;
dgrProduct.Items.Refresh();
}
catch (Exception ex)
{
CommonData.log.Error(ex.ToString());
}
}
