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; }