public CostarDataContext GetContext()
{
string connString = "";
connString = Settings.Default.costarConnectionString;
CostarDataContext cdc = new CostarDataContext(connString);
return cdc;
}
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 ProductInventoy By InventoryID
/// </summary>
/// <param name="InventoryID"></param>
public void DelProductInventoy(long InventoryID)
{
using (CostarDataContext linq = new CostarDataContext())
{
linq.StoreProductInventories.DeleteAllOnSubmit(linq.StoreProductInventories.Where(c => c.InventoryID == InventoryID));
linq.SubmitChanges();
}
}
/// <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;
}
/// <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 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;
}
public List<StoreColor> GetAllStoreColors()
{
List<StoreColor> results = new List<StoreColor>();
using (CostarDataContext dc = new CostarDataContext())
{
results = dc.StoreColors.ToList();
}
return results;
}
/// <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 List<StoreAnime> GetAllStoreAnimes()
{
List<StoreAnime> results = new List<StoreAnime>();
using (CostarDataContext dc = new CostarDataContext())
{
results = dc.StoreAnimes.ToList();
}
return results;
}
/// <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;
}
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();
}
}
}
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 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");
}
}
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();
}
}
/// <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;
}
