/// <summary>
/// Add or Edit StoreProductInventory
/// </summary>
/// <param name="product"></param>
public void SaveProductInventory(StoreProductInventory proInv)
{
using (CostarDataContext dc = _conn.GetContext())
{
if (proInv.InventoryID > 0)
{
dc.StoreProductInventories.Attach(proInv, true);
}
if (proInv.InventoryID == 0)
{
dc.StoreProductInventories.InsertOnSubmit(proInv);
}
dc.SubmitChanges();
}
//using (CostarDataContext linq = new CostarDataContext())
//{
// if (proInv.InventoryID > 0)
// {
// StoreProductInventory inv = linq.StoreProductInventories.Where(c => c.InventoryID == proInv.InventoryID).SingleOrDefault();
// Common.CommonClass.CopyObjectProperty(proInv, inv);
// }
// else
// {
// linq.StoreProductInventories.InsertOnSubmit(proInv);
// }
// linq.SubmitChanges();
//}
}
/// <summary>
/// Delete StoreProductInventory
/// </summary>
/// <param name="product"></param>
public void DelProductInventoryByProduct(long productID)
{
using (CostarDataContext linq = new CostarDataContext())
{
linq.StoreProductInventories.DeleteAllOnSubmit(linq.StoreProductInventories.Where(c => c.ProductID == productID));
linq.SubmitChanges();
}
}
public void DelProductColor(long productID)
{
using (CostarDataContext linq = new CostarDataContext())
{
linq.StoreProductColors.DeleteOnSubmit(linq.StoreProductColors.Where(c => c.ProductID == productID).Single());
linq.SubmitChanges();
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
using (CostarDataContext linq = new CostarDataContext())
{
int ShippingOptionID = MyCommon.ToInt(Request["ShippingOptionID"]);
StoreShippingOption shipping;
if (this.HiddenField1.Value == "add")
{
shipping = new StoreShippingOption();
}
else
{
shipping = linq.StoreShippingOptions.Where(c => c.ShippingOptionID == ShippingOptionID).SingleOrDefault();
}
shipping.Name = this.txt_Name.Text;
shipping.Instruction = this.txt_Description.Text;
shipping.IsActive = this.CheckBox_Active.Checked;
decimal price = 0;
decimal.TryParse(this.txt_Price.Text, out price);
switch (this.ddl_Per.SelectedValue)
{
case "0":
shipping.PerItemFlatRate = price;
shipping.PerKGRate = null;
shipping.PerOrderFlatRate = null;
break;
case "1":
shipping.PerItemFlatRate = null;
shipping.PerKGRate = null;
shipping.PerOrderFlatRate = price;
break;
case "2":
shipping.PerItemFlatRate = null;
shipping.PerKGRate = price;
shipping.PerOrderFlatRate = null;
break;
}
if (this.HiddenField1.Value == "add")
{
linq.StoreShippingOptions.InsertOnSubmit(shipping);
}
linq.SubmitChanges();
MyCommon.Alert("保存成功.", "StoreShippingManage.aspx");
}
}
public void SaveProduct(StoreProduct product)
{
using (CostarDataContext dc = _conn.GetContext())
{
if (product.ProductID > 0)
{
dc.StoreProducts.Attach(product, true);
}
if (product.ProductID == 0)
{
product.AddeDate = DateTime.Now;
dc.StoreProducts.InsertOnSubmit(product);
}
dc.SubmitChanges();
}
}