/// <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();
//}
}
public void DelProductColor(long productID)
{
using (CostarDataContext linq = new CostarDataContext())
{
linq.StoreProductColors.DeleteOnSubmit(linq.StoreProductColors.Where(c => c.ProductID == productID).Single());
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 CostarDataContext GetContext()
{
string connString = "";
connString = Settings.Default.costarConnectionString;
CostarDataContext cdc = new CostarDataContext(connString);
return(cdc);
}
/// <summary>
/// Get StoreProductInventory By ProductID
/// </summary>
/// <param name="productID"></param>
/// <returns></returns>
public StoreShippingOption GetShippingByID(long ShippingOptionID)
{
StoreShippingOption result = null;
using (CostarDataContext linq = new CostarDataContext())
{
result = linq.StoreShippingOptions.Where(p => p.ShippingOptionID == ShippingOptionID).SingleOrDefault();
}
return(result);
}
public StoreProduct GetProductByID(long productID)
{
StoreProduct result = null;
using (CostarDataContext dc = _conn.GetContext())
{
result = dc.StoreProducts.Where(p => p.ProductID == productID).FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get StoreProductInventory By ProductID
/// </summary>
/// <param name="productID"></param>
/// <returns></returns>
public List <StoreProductInventory> GetInventoryByProductID(long productID)
{
List <StoreProductInventory> result = new List <StoreProductInventory>();
using (CostarDataContext dc = new CostarDataContext())
{
result = dc.StoreProductInventories.Where(p => p.ProductID == productID).OrderBy(c => c.SortOrder).ToList();
}
return(result);
}
/// <summary>
/// Get StoreVariantType By VariantTypeID
/// </summary>
/// <returns></returns>
public StoreVariantType GetStoreVariantTypeByID(int VariantTypeID)
{
StoreVariantType results = null;
using (CostarDataContext linq = new CostarDataContext())
{
results = linq.StoreVariantTypes.Where(c => c.VariantTypeID == VariantTypeID).FirstOrDefault();
}
return(results);
}
public List <StoreAnime> GetAllStoreAnimes()
{
List <StoreAnime> results = new List <StoreAnime>();
using (CostarDataContext dc = new CostarDataContext())
{
results = dc.StoreAnimes.ToList();
}
return(results);
}
/// <summary>
/// Get StoreVariantTypeOption By VariantTypeID
/// </summary>
/// <returns></returns>
public List <StoreVariantTypeOption> GetStoreVariantTypeOptionByVariantTypeID(int VariantTypeID)
{
List <StoreVariantTypeOption> results = new List <StoreVariantTypeOption>();
using (CostarDataContext linq = new CostarDataContext())
{
results = linq.StoreVariantTypeOptions.Where(c => c.VariantTypeID == VariantTypeID).ToList();
}
return(results);
}
/// <summary>
/// Get All StoreVariantType
/// </summary>
/// <returns></returns>
public List <StoreVariantType> GetAllStoreVariantType()
{
List <StoreVariantType> results = new List <StoreVariantType>();
using (CostarDataContext linq = new CostarDataContext())
{
results = linq.StoreVariantTypes.ToList();
}
return(results);
}
public Account GetAccountByID(long accountID)
{
Account result = new Account();
using (CostarDataContext dc = new CostarDataContext())
{
result = dc.Accounts.Where(a => a.AccountID == accountID).FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get StoreProductInventory By InventoryID
/// </summary>
/// <param name="productID"></param>
/// <returns></returns>
public StoreProductInventory GetInventoryByInventoryID(long inventoryID)
{
StoreProductInventory result = null;
using (CostarDataContext linq = new CostarDataContext())
{
linq.ObjectTrackingEnabled = false;
result = linq.StoreProductInventories.Where(p => p.InventoryID == inventoryID).SingleOrDefault();
}
return(result);
}
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");
}
}
/// <summary>
/// SUM QtyAvail
/// </summary>
/// <param name="productID"></param>
/// <returns></returns>
public decimal QtyAvailByProduct(long productID)
{
decimal QtyAvail = 0;
using (CostarDataContext linq = new CostarDataContext())
{
int?b = linq.StoreProductInventories.Where(i => i.ProductID == productID).Sum(a => (int?)a.QtyAvail);
decimal.TryParse(b.ToString(), out QtyAvail);
}
return(QtyAvail);
}
public List <StoreColor> GetAllStoreColorsByProductID(long productID)
{
List <StoreColor> results = new List <StoreColor>();
using (CostarDataContext dc = new CostarDataContext())
{
results = (from c in dc.StoreColors
join pc in dc.StoreProductColors on c.ColorID equals pc.ColorID
where pc.ProductID == productID
select c).ToList();
}
return(results);
}
protected void _OnPageLoad(int animeId)
{
using (CostarDataContext linq = new CostarDataContext())
{
if (animeId == 0)
{
var q = linq.StoreProducts.Where(c => c.DeleteDate == null).Select(c => new
{
img = c.ImageFile != "" ? c.ImageFile :
c.ImageFile2 != "" ? c.ImageFile2 :
c.ImageFile3 != "" ? c.ImageFile3 :
c.ImageFile4 != "" ? c.ImageFile4 :
"/images/ico_error-24.png",
Name = c.Name,
RetailPrice = c.RetailPrice,
SalePrice = c.SalePrice,
VIPPrice = c.VIPPrice,
SellCount = c.ProductID,
WarHouseCount = linq.StoreProductInventories.Where(i => i.ProductID == c.ProductID).Sum(a => (int?)a.QtyAvail),
ProductID = c.ProductID,
IsActive = c.IsActive == true ? "/images/ico_success-24.png" : "/images/ico_error-24.png"
});
rpt_list.DataSource = q;
rpt_list.DataBind();
}
else
{
var q = linq.StoreProducts.Where(c => c.AnimeID == animeId && c.DeleteDate == null).Select(c => new
{
img = c.ImageFile != "" ? c.ImageFile :
c.ImageFile2 != "" ? c.ImageFile2 :
c.ImageFile3 != "" ? c.ImageFile3 :
c.ImageFile4 != "" ? c.ImageFile4 :
"/images/ico_error-24.png",
Name = c.Name,
RetailPrice = c.RetailPrice,
SalePrice = c.SalePrice,
VIPPrice = c.VIPPrice,
SellCount = c.ProductID,
WarHouseCount = linq.StoreProductInventories.Where(i => i.ProductID == c.ProductID).Sum(a => (int?)a.QtyAvail),
ProductID = c.ProductID,
IsActive = c.IsActive == true ? "/images/ico_success-24.png" : "/images/ico_error-24.png"
});
rpt_list.DataSource = q;
rpt_list.DataBind();
}
}
}
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();
}
}
protected void BindRepeater(int productId)
{
using (CostarDataContext linq = new CostarDataContext())
{
var q = linq.StoreProductInventories.Where(c => c.ProductID == productId).OrderBy(c => c.SortOrder).Select(c => new
{
ProductID = c.ProductID,
InventoryID = c.InventoryID,
QtySold = c.QtySold,
QtyAvail = c.QtyAvail,
SortOrder = c.SortOrder,
QtyOnHold = c.QtyOnHold
});
rpt_list.DataSource = q;
rpt_list.DataBind();
}
}
protected void _OnPageLoad()
{
this.div_show.Style.Value = "display: none;";
using (CostarDataContext linq = new CostarDataContext())
{
var q = linq.StoreShippingOptions.Select(c => new
{
Name = c.Name,
Price = c.PerOrderFlatRate > 0 ? c.PerOrderFlatRate + "(每单)" :
(c.PerItemFlatRate > 0 ? c.PerItemFlatRate + "(每件)" :
(c.PerKGRate > 0 ? c.PerKGRate + "(每斤)" : "")),
IsActive = c.IsActive == true ? "/images/ico_success-24.png" : "/images/ico_error-24.png",
ShippingOptionID = c.ShippingOptionID
});
rpt_list.DataSource = q;
rpt_list.DataBind();
}
}
