private void DeleteSupplement(string sql)
{
ProductSupplementCollection oSupplementList = ProductSupplement.LoadCollection(sql);
foreach (ProductSupplement oSupplement in oSupplementList)
{
oSupplement.Delete();
}
}
private void ShowProductSupplement()
{
string sql = "ProductId = '" + _ProductId.ToString() + "'";
ProductSupplement oProdSupp = ProductSupplement.LoadWhere(sql);
if (oProdSupp != null)
{
txtMemo.Text = oProdSupp.ProductName_Memo;
txtPole.Text = oProdSupp.ProductName_Pole;
cboVendorCurrency.Text = oProdSupp.VendorCurrencyCode;
txtVendorPrice.Text = oProdSupp.VendorPrice.ToString("n2");
}
}
private void SaveProductSupplement(Guid productId)
{
string sql = "ProductId = '" + productId.ToString() + "'";
ProductSupplement oProdSupp = ProductSupplement.LoadWhere(sql);
if (oProdSupp != null)
{
if (chkUpdateVendorPrice.Checked)
{
oProdSupp.VendorCurrencyCode = cboVendorCurrency.Text;
}
if (chkUpdateVendorPrice.Checked)
{
oProdSupp.VendorPrice = Convert.ToDecimal((txtVendorPrice.Text == string.Empty) ? "0" : txtVendorPrice.Text);
}
if (chkUpdateProductMemo.Checked)
{
oProdSupp.ProductName_Memo = txtProductMemo.Text;
}
if (chkUpdateProductPole.Checked)
{
oProdSupp.ProductName_Pole = txtProductPole.Text;
}
//tabDiscountInfo
if (chkDiscountForFixPriceItem.Checked)
{
oProdSupp.VipDiscount_FixedItem = Convert.ToDecimal(txtDiscountForFixPriceItem.Text);
}
if (chkDiscountForDiscountItem.Checked)
{
oProdSupp.VipDiscount_DiscountItem = Convert.ToDecimal(txtDiscountForDiscountItem.Text);
}
if (chkDiscountForNoDiscountItem.Checked)
{
oProdSupp.VipDiscount_NoDiscountItem = Convert.ToDecimal(txtDiscountForNoDiscountItem.Text);
}
if (chkStaffDiscount.Checked)
{
oProdSupp.StaffDiscount = Convert.ToDecimal(txtStaffDiscount.Text);
}
oProdSupp.Save();
}
}
// Product Price
private void LoadProductSupplement()
{
string sql = "ProductId = '" + _ProductId.ToString() + "'";
ProductSupplement oProdSupp = ProductSupplement.LoadWhere(sql);
if (oProdSupp != null)
{
general.cboVendorCurrency.Text = oProdSupp.VendorCurrencyCode;
general.txtVendorPrice.Text = oProdSupp.VendorPrice.ToString("n2");
general.txtMemo.Text = oProdSupp.ProductName_Memo;
general.txtPole.Text = oProdSupp.ProductName_Pole;
//discount.txtDiscount1_FixPriceItem.Text = oProdSupp.VipDiscount_FixedItem.ToString("n2");
//discount.txtDiscount2_DiscountItem.Text = oProdSupp.VipDiscount_DiscountItem.ToString("n2");
//discount.txtDiscount3_NoDiscountItem.Text = oProdSupp.VipDiscount_NoDiscountItem.ToString("n2");
//discount.txtStaff.Text = oProdSupp.StaffDiscount.ToString("n2");
}
}
// Product Price
private void LoadProductSupplement()
{
string sql = "ProductId = '" + productId.ToString() + "'";
ProductSupplement oProdSupp = ProductSupplement.LoadWhere(sql);
if (oProdSupp != null)
{
cboVendorCurrency.Text = oProdSupp.VendorCurrencyCode;
txtVendorPrice.Text = oProdSupp.VendorPrice.ToString("n2");
txtProductMemo.Text = oProdSupp.ProductName_Memo;
txtProductPole.Text = oProdSupp.ProductName_Pole;
//tabDiscountInfo
txtDiscountForFixPriceItem.Text = oProdSupp.VipDiscount_FixedItem.ToString("00.00");
txtDiscountForDiscountItem.Text = oProdSupp.VipDiscount_DiscountItem.ToString("00.00");
txtDiscountForNoDiscountItem.Text = oProdSupp.VipDiscount_NoDiscountItem.ToString("00.00");
txtStaffDiscount.Text = oProdSupp.StaffDiscount.ToString("00.00");
}
}
private void SaveProductSupplement(Guid productId)
{
string sql = "ProductId = '" + productId.ToString() + "'";
ProductSupplement oProdSupp = ProductSupplement.LoadWhere(sql);
if (oProdSupp == null)
{
oProdSupp = new ProductSupplement();
oProdSupp.ProductId = productId;
}
oProdSupp.VendorCurrencyCode = general.cboVendorCurrency.Text;
oProdSupp.VendorPrice = Convert.ToDecimal((general.txtVendorPrice.Text == string.Empty) ? "0" : general.txtVendorPrice.Text);
oProdSupp.ProductName_Memo = general.txtMemo.Text;
oProdSupp.ProductName_Pole = general.txtPole.Text;
//oProdSupp.VipDiscount_FixedItem = Convert.ToDecimal((txtDiscount1_FixPriceItem.Text == string.Empty) ? "0" : txtDiscount1_FixPriceItem.Text);
//oProdSupp.VipDiscount_DiscountItem = Convert.ToDecimal((txtDiscount2_DiscountItem.Text == string.Empty) ? "0" : txtDiscount2_DiscountItem.Text);
//oProdSupp.VipDiscount_NoDiscountItem = Convert.ToDecimal((txtDiscount3_NoDiscountItem.Text == string.Empty) ? "0" : txtDiscount3_NoDiscountItem.Text);
//oProdSupp.StaffDiscount = Convert.ToDecimal((txtStaffDiscount.Text == string.Empty) ? "0" : txtStaffDiscount.Text);
oProdSupp.Save();
}
