/// <summary> /// 文字列をクラス情報に変換する /// </summary> public static ItemMaster ConvertStrToMaster(string[] i_data) { int i = 0; ItemMaster master = new ItemMaster(); master.item_id = int.Parse(i_data[i]); master.name = i_data[MasterDataControllerClass.IncNum(ref i)]; master.category = int.Parse(i_data[MasterDataControllerClass.IncNum(ref i)]); master.cook = int.Parse(i_data[MasterDataControllerClass.IncNum(ref i)]) == 0 ? false : true; master.icon = i_data[MasterDataControllerClass.IncNum(ref i)]; master.deleted = int.Parse(i_data[MasterDataControllerClass.IncNum(ref i)]); return master; }
public void TestNonTrivial() { { Expression<Func<ItemMaster, bool>> exp = a => a.id > 5 && a.id < 10; var res = new ReplaceWithReference<ItemMaster, Item>(exp, "master", "item").NewExpression; Assert.AreEqual("item => ((item.master.id > 5) AndAlso (item.master.id < 10))", res.ToString()); } { Expression<Func<ItemMaster, bool>> exp = a => int.Equals(0, a.id + a.id * Math.Abs(a.id - 2 * a.id)); var res = new ReplaceWithReference<ItemMaster, Item>(exp, "master", "b").NewExpression; Assert.AreEqual("b => Equals(Convert(0), Convert((b.master.id + (b.master.id * Abs((b.master.id - (2 * b.master.id)))))))", res.ToString()); // lets try to execute it ItemMaster master = new ItemMaster() { id = 5 }; Item item = new Item() { master = master }; var func = res.Compile(); Assert.AreEqual(false, func(item)); } // parameter same name as member with double nested reference { Expression<Func<ItemMaster, bool>> exp = parent => parent.parent.id != Guid.Empty && parent.id > 0; var res = new ReplaceWithReference<ItemMaster, Item>(exp, "master", "master").NewExpression; Assert.AreEqual("master => ((master.master.parent.id != Guid.Empty) AndAlso (master.master.id > 0))", res.ToString()); } }
public ItemMaster GetBooksMasterDetails(String bookID) { ItemMaster obj = null; return(obj); }
private void instanceItemMasterHasBeenClosed(object sender, FormClosedEventArgs e) { _instanceItemMaster = null; }
internal static void Postfix(ItemStack __instance, ItemMaster itemMaster, int howMany = 1) { /*__instance.master = itemMaster; * __instance.Quantity = howMany; * __instance._initialLives = __instance._lives; * __instance.name = string.Format("ItemStack({0}{1})", itemMaster.name, (itemMaster.plusLevel <= 0) ? string.Empty : string.Format(" +{0}", itemMaster.plusLevel)); * __instance.itemImage.sprite = ItemDatabase.GetSpriteByItemName(__instance.master.worldSpriteName); * if (__instance._pixelatorFlashMaterial == null) * { * __instance._pixelatorFlashMaterial = __instance.itemImage.material; * } * * // use custom item if it exists *//*EquipmentItemMaster equipmentItemMaster = ItemRegister.GetEquip(itemMaster.name); * if (equipmentItemMaster is null)*//* * var equipmentItemMaster = __instance.master as EquipmentItemMaster; * * if (equipmentItemMaster != null) * { * __instance._equipment = __instance.gameObject.GetOrAddComponent<Equipment>(); * __instance._equipment.Init(equipmentItemMaster); * Equipment equipment = __instance._equipment; * equipment.onEquipmentEnchanted = (Action)Delegate.Remove(equipment.onEquipmentEnchanted, new Action(__instance.SetIdleMaterial)); * Equipment equipment2 = __instance._equipment; * equipment2.onEquipmentEnchanted = (Action)Delegate.Combine(equipment2.onEquipmentEnchanted, new Action(__instance.SetIdleMaterial)); * } * AmuletEquipmentMaster amuletEquipmentMaster = __instance.master as AmuletEquipmentMaster; * if (amuletEquipmentMaster != null) * { * __instance._amulet = __instance.gameObject.GetOrAddComponent<Amulet>(); * __instance._amulet.Init(amuletEquipmentMaster); * } * AbilityItemMaster abilityItemMaster = __instance.master as AbilityItemMaster; * if (abilityItemMaster != null) * { * __instance._ability = __instance.gameObject.GetOrAddComponent<Ability>(); * __instance._ability.Init(abilityItemMaster); * } * WeaponEquipmentMaster weaponEquipmentMaster = __instance.master as WeaponEquipmentMaster; * if (weaponEquipmentMaster != null) * { * TrickWeaponMaster trickWeaponMaster = weaponEquipmentMaster as TrickWeaponMaster; * if (trickWeaponMaster != null) * { * __instance._trickWeapon = __instance.gameObject.AddComponent<TrickWeapon>(); * __instance._trickWeapon.Init(trickWeaponMaster); * } * else * { * __instance._weapon = __instance.gameObject.AddComponent<Weapon>(); * __instance._weapon.Init(weaponEquipmentMaster); * BowWeaponMaster bowWeaponMaster = weaponEquipmentMaster as BowWeaponMaster; * if (bowWeaponMaster != null) * { * __instance._bow = __instance.gameObject.GetOrAddComponent<Bow>(); * __instance._bow.Init(bowWeaponMaster); * } * GlovesWeaponMaster glovesWeaponMaster = weaponEquipmentMaster as GlovesWeaponMaster; * BigSwordWeaponMaster bigSwordWeaponMaster = weaponEquipmentMaster as BigSwordWeaponMaster; * SpearWeaponMaster spearWeaponMaster = weaponEquipmentMaster as SpearWeaponMaster; * if (glovesWeaponMaster != null) * { * __instance.gameObject.AddComponent<SecondaryAttackWeapon>().Init(glovesWeaponMaster); * } * if (bigSwordWeaponMaster != null) * { * __instance.gameObject.AddComponent<SecondaryAttackWeapon>().Init(bigSwordWeaponMaster); * } * if (spearWeaponMaster != null) * { * __instance.gameObject.AddComponent<SecondaryAttackWeapon>().Init(spearWeaponMaster); * } * ShortSwordWeaponMaster shortSwordWeaponMaster = weaponEquipmentMaster as ShortSwordWeaponMaster; * if (shortSwordWeaponMaster != null) * { * __instance.gameObject.AddComponent<ShortSword>().Init(shortSwordWeaponMaster); * } * } * } * DecorativeItemMaster decorativeItemMaster = __instance.master as DecorativeItemMaster; * if (decorativeItemMaster != null) * { * __instance._decorative = __instance.gameObject.GetOrAddComponent<DecorativeItem>(); * __instance._decorative.Init(decorativeItemMaster); * } * FamiliarItemMaster familiarItemMaster = __instance.master as FamiliarItemMaster; * if (familiarItemMaster != null) * { * __instance._familiar = __instance.gameObject.GetOrAddComponent<FamiliarItem>(); * __instance._familiar.Init(familiarItemMaster); * } * AutoConsumableItemMaster autoConsumableItemMaster = __instance.master as AutoConsumableItemMaster; * if (autoConsumableItemMaster != null) * { * __instance._autoConsumable = __instance.gameObject.GetOrAddComponent<AutoConsumable>(); * } * * *//*ConsumableItemMaster consumableItemMaster = ItemRegister.GetConsumable(itemMaster.name); * if (consumableItemMaster is null)*//* * var consumableItemMaster = __instance.master as ConsumableItemMaster; * * * if (consumableItemMaster != null) * { * __instance._consumable = __instance.gameObject.GetOrAddComponent<Consumable>(); * __instance._consumable.Init(consumableItemMaster); * } * __instance.SetIdleMaterial(); * if (__instance.master.isDestroyedOnRunEnded) * { * __instance.GenerateEffect(ItemEffectManager.Instance.trickEffectPrefab.gameObject); * }*/ // Check if this item has a custom type. If so add the custom type var hasCustomItem = ItemRegister.Instance.CustomItemTypes.TryGetValue(itemMaster.name, out var type); if (hasCustomItem) { __instance.gameObject.AddComponent(type); } }
public int GetItemCount(ItemMaster master) { return(Items[master]); }
private void SetItem(ItemMaster obj) { txtItemId.Text = obj.ItemID; txtItemName.Text = obj.ItemName; txtRemarks.Text = obj.Remarks; }
private void CreateSOLines(Organization org, SOInfo soInfo, SaleOrderDTO dtoSO, Customer customer) { CustomerSite cs = CustomerSite.Finder.Find("Customer ='" + customer.ID + "'"); CustomerSiteMISCInfo customerSite = new CustomerSiteMISCInfo(); customerSite.CustomerSite = cs; customerSite.Code = cs.Code; customerSite.Name = cs.Name; foreach (var itemLine in soInfo.Lines) { UFIDA.U9.ISV.SM.SOLineDTO soLine = new UFIDA.U9.ISV.SM.SOLineDTO(); //料品 soLine.ItemInfo = new UFIDA.U9.CBO.SCM.Item.ItemInfo(); ItemMaster beItemMaster = ItemMaster.Finder.Find("Code = @code and Org = @orgID", new OqlParam[2] { new OqlParam(itemLine.ItemMasterCode), new OqlParam(org.ID) }); if (beItemMaster == null) { throw new Exception(string.Format("物料编码{0}在U9中不存在", itemLine.ItemMasterCode)); } soLine.ItemInfo.ItemID = beItemMaster; //soLine.BomOwner = new UFIDA.U9.CBO.Pub.Controller.CommonArchiveDataDTO(); //soLine.BomOwner.ID = org.ID; //soLine.BomOwner.Code = org.Code; //soLine.BomOwner.Name = org.Name; //数量 soLine.ChoiceResult = 0; soLine.OrderByQtyTU = itemLine.Qty; //扩展字段 soLine.DescFlexField = new UFIDA.U9.Base.FlexField.DescFlexField.DescFlexSegments(); //收款条件 if (customer.RecervalTerm != null) { soLine.RecTerm = new CommonArchiveDataDTO(); soLine.RecTerm.Code = customer.RecervalTerm.Code; } //立账位置 if (customer.CustomerSites != null) { if (customer.CustomerSites.Count > 0) { soLine.BillToSite = customerSite; soLine.BillToSite.Code = customerSite.Code; soLine.BillToSite.CustomerSiteKey = customerSite.CustomerSiteKey; } } //定价方式 soLine.CooperatePriceStyle = -1; //免费品类型 soLine.FreeType = FreeTypeEnum.GetFromValue(-1); //免费品原因 soLine.FreeReason = DonationReasonEnum.GetFromValue(-1); //台阶划分依据 soLine.StepBy = -1; //预收环节 soLine.PreRecObject = -1; //原币-额币 soLine.TCToCCExchRateType = ExchangeRateTypesEnum.GetFromValue(0); //来源单据类别 soLine.SrcDocType = SOSourceTypeEnum.GetFromValue(0); //成套收发货标志 soLine.ShipTogetherFlag = KITShipModeEnum.GetFromValue(-1); //数量类型 soLine.QuantityType = UsageQuantityTypeEnum.GetFromValue(-1); //资源成本计费基础 soLine.ChargeBasis = ChargeBasisEnum.GetFromValue(-1); //价格来源 soLine.PriceSource = PriceSourceEnum.GetFromValue(1); //是否消耗信用额度 soLine.IsEngrossCreditLimit = true; //添加销售订单上的计划行 soLine.SOShiplines = new List <SOShipLineDTO>(); SOShipLineDTO soship = new SOShipLineDTO(); soship.ItemInfo = new UFIDA.U9.CBO.SCM.Item.ItemInfo(); soship.ItemInfo.ItemID = beItemMaster; soship.ItemInfo.ItemCode = beItemMaster.Code; soship.ItemInfo.ItemName = beItemMaster.Name; soship.RequireDate = DateTime.Parse(itemLine.DeliveryDate); soship.DescFlexField = new UFIDA.U9.Base.FlexField.DescFlexField.DescFlexSegments(); //区域位置 soship.ShipToSite = new CustomerSiteMISCInfo(); soship.ShipToSite.CustomerSite = customerSite.CustomerSite; soship.ShipToSite.Code = customerSite.Code; soship.ShipToSite.Name = customerSite.Name; //单价 soLine.OrderPriceTC = itemLine.TCPrice; soLine.SOShiplines.Add(soship); dtoSO.SOLines.Add(soLine); } }
public int InsertItem(ItemMaster itemMaster) { return(itemRepository.InsertItem(itemMaster)); }
public void OpenDialog(ItemMaster master) { Dialog.Open(master, selectModel); }
public void SetDescription(ItemMaster master) { DescriptionPanel.SetDescription(master); }
public HttpResponseMessage GetOrdDataOnVrno(string VrNo) { try { GBCDbConn GbcCon = new GBCDbConn(); string GBCDBname = GbcCon.Database.Connection.Database + ".dbo."; Global objGBL = new Global(); OB ordObj = gbc_con.Db_ob.SingleOrDefault(p => p.VRNO == VrNo); Order obj_ord = new Order(); if (ordObj != null) { obj_ord.NameP = ordObj.NameP; obj_ord.TotalAmt = ordObj.ORAMT.ToString(); obj_ord.vrdate = Convert.ToDateTime(ordObj.VRDATE).ToString("dd/MM/yyyy"); obj_ord.vrno = ordObj.VRNO; obj_ord.imgName = ordObj.PresImg; List <ItemMaster> li_Oi = new List <ItemMaster>(); List <OI> OI = gbc_con.Db_OI.Where(p => p.VRNO == VrNo).ToList(); foreach (var oi_item in OI) { try { ItemMaster obj_oi = new ItemMaster(); try { IM IMObj = gbc_con.Db_itm.SingleOrDefault(p => p.ICODE == oi_item.ICODE); if (IMObj != null) { obj_oi.INAME = IMObj.INAME; obj_oi.packing = IMObj.packing; obj_oi.WRate = (oi_item.ORDRATE * IMObj.PURSIZE).ToString(); DataRow dr = objGBL.getDataRow(false, "SELECT GNAME FROM " + GBCDBname + "GM WHERE isnull( GCODE,'')='" + (IMObj.GCODE == null ? "" : IMObj.GCODE) + "' "); if (dr != null) { obj_oi.GNAme = dr["GNAME"].ToString(); } } } catch { obj_oi.INAME = oi_item.ICODE; } obj_oi.Qty = oi_item.ORDERQTY.ToString(); obj_oi.free = oi_item.FREEQTY.ToString(); obj_oi.WQty = oi_item.ORDERWQTY.ToString(); obj_oi.Wfree = oi_item.FREEWQTY.ToString(); obj_oi.Rate = oi_item.ORDRATE.ToString(); obj_oi.ICODE = oi_item.ICODE; obj_oi.Mrp = oi_item.ORDMRP.ToString(); li_Oi.Add(obj_oi); } catch { } } obj_ord.items = li_Oi; } return(Request.CreateResponse(HttpStatusCode.OK, obj_ord)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.NotFound, "Error Occurred While Getting Data. " + ex.Message)); } }
public CustomList <ItemMaster> GetAllItemMasterByItemCode(String itemCode) { return(ItemMaster.GetAllItemMasterByItemCode(itemCode)); }
public CustomList <ItemMaster> FindAllItemMaster() { return(ItemMaster.FindAllItemMaster()); }
public CustomList <ItemMaster> FindAllItemMasterGroupWise() { return(ItemMaster.FindAllItemMasterGroupWise()); }
protected void mbar_ItemCommand(object sender, Magic.Web.UI.MagicItemEventArgs args) { if (args.CommandName == "save") { using (ISession session = new Session()) { try { string itemCode = this.txtItemCode.Text.Trim(); string itemStatus = this.ddlItemStatus.SelectedValue; string itemName = this.txtItemName.Text.Trim(); string itemDesc = this.txtItemSpec.Text.Trim(); if (this.IsNew) { //新增 ItemMaster master = new ItemMaster(); master.ItemCode = itemCode; //判断输入的itemCode是否重复 if (session.CreateEntityQuery<ItemMaster>().Where(Exp.Eq("ItemCode", itemCode)).Count() > 0) { WebUtil.ShowMsg(this, string.Format("辅料编号{0}已经存在", master.ItemCode), "错误"); return; } master.ItemType = ItemType.AssistantItem; master.ItemName = itemName; master.ItemDesc = itemDesc; session.BeginTransaction(); master.Create(session); ItemSpec spec = new ItemSpec(); spec.ItemID = master.ItemID; spec.ItemCode = itemCode; spec.Status = Cast.Enum<ItemSpecStatus>(itemStatus); spec.ColorCode = " "; spec.BarCode = itemCode; spec.OperateTime = DateTime.Now; spec.Operator = 0;// Magic.Security.SecuritySession.CurrentUser.UserId; spec.PubDate = DateTime.Now; spec.AvgMoveCost = 0; spec.EnableCost = true; spec.EnableOS = false; spec.Create(session); session.Commit(); } else { session.BeginTransaction(); ItemSpec spec = ItemSpec.Retrieve(session, this.SKUID); spec.Status = Cast.Enum<ItemSpecStatus>(itemStatus); spec.Update(session, "Status"); int itemID = spec.ItemID; ItemMaster master = ItemMaster.Retrieve(session, itemID); master.ItemName = itemName; master.ItemDesc = itemDesc; master.Update(session, "ItemName", "ItemDesc"); session.Commit(); } } catch (System.Exception e) { session.Rollback(); throw e; } } this.Response.Redirect(WebUtil.Param("return")); } }
public CustomList <ItemMaster> FindAllItemMasterBySubGroup(String itemSubGroupID) { return(ItemMaster.FindAllItemMasterBySubGroup(itemSubGroupID)); }
public int UpdateItem(ItemMaster itemMaster) { return(itemRepository.UpdateItem(itemMaster)); }
private void btnSave_Click(object sender, EventArgs e) { try { if (String.IsNullOrWhiteSpace(tbxItemName.Text)) { errorProviderItem.SetError(tbxItemName, Constants.Messages.RequiredField); tbxItemName.SelectAll(); tbxItemName.Focus(); return; } Choice choice; Status status; ItemMaster item = new ItemMaster(); item.ItemCode = tbxItemCode.Text; item.ItemName = tbxItemName.Text; item.CompanyID = (int)tbxCompany.Tag; item.ConversionRate = ExtensionMethods.SafeConversionDecimal(tbxConvRate.Text); item.ShortName = tbxShortName.Text; item.Packing = tbxPacking.Text; item.PurchaseRate = ExtensionMethods.SafeConversionDecimal(tbxPurchaseRate.Text); item.MRP = ExtensionMethods.SafeConversionDecimal(tbxMRP.Text) ?? default(decimal); item.SaleRate = ExtensionMethods.SafeConversionDecimal(tbxSaleRate.Text); item.SpecialRate = ExtensionMethods.SafeConversionDecimal(tbxSpecialRate.Text); item.WholeSaleRate = ExtensionMethods.SafeConversionDecimal(tbxWholeSaleRate.Text); item.SaleExcise = ExtensionMethods.SafeConversionDecimal(tbxSaleExcise.Text); item.SurchargeOnSale = ExtensionMethods.SafeConversionDecimal(tbxSCOnSale.Text); item.TaxOnSale = (cbxSaleType.SelectedItem as AccountLedgerMaster).SalePurchaseTaxValue; item.Scheme1 = ExtensionMethods.SafeConversionDecimal(tbxScheme1.Text); item.Scheme2 = ExtensionMethods.SafeConversionDecimal(tbxScheme2.Text); item.PurchaseExcise = ExtensionMethods.SafeConversionDecimal(tbxPurchaseExcise.Text); item.UPC = tbxUPC.Text; Enum.TryParse <Choice>(cbxHalfScheme.SelectedValue.ToString(), out choice); item.IsHalfScheme = choice == Choice.Yes; Enum.TryParse <Choice>(cbxQtrScheme.SelectedValue.ToString(), out choice); item.IsQTRScheme = choice == Choice.Yes; item.SpecialDiscount = ExtensionMethods.SafeConversionDecimal(tbxSpecialDiscount.Text); item.SpecialDiscountOnQty = ExtensionMethods.SafeConversionDecimal(tbxSpecialDiscountOnQty.Text); Enum.TryParse <Choice>(cbxFixedDiscount.SelectedValue.ToString(), out choice); item.IsFixedDiscount = choice == Choice.Yes; item.FixedDiscountRate = ExtensionMethods.SafeConversionDecimal(tbxFixedDiscountRate.Text); item.MaximumQty = ExtensionMethods.SafeConversionDecimal(tbxMaxQty.Text); item.MaximumDiscount = ExtensionMethods.SafeConversionDecimal(tbxMaxDiscount.Text); item.SurchargeOnPurchase = ExtensionMethods.SafeConversionDecimal(tbxSCOnPurchase.Text); item.TaxOnPurchase = (cbxPurchaseType.SelectedItem as AccountLedgerMaster).SalePurchaseTaxValue; item.DiscountRecieved = ExtensionMethods.SafeConversionDecimal(tbxDiscountRecieved.Text); item.SpecialDiscountRecieved = ExtensionMethods.SafeConversionDecimal(tbxSpecialDiscountRecieved.Text); item.QtyPerCase = ExtensionMethods.SafeConversionDecimal(tbxQtyPerCase.Text); item.Location = tbxLocation.Text; item.MinimumStock = ExtensionMethods.SafeConversionInt(tbxMinimumStock.Text); item.MaximumStock = ExtensionMethods.SafeConversionInt(tbxMaximumStock.Text); item.SaleTypeId = (cbxSaleType.SelectedItem as AccountLedgerMaster).AccountLedgerID; item.PurchaseTypeId = (cbxPurchaseType.SelectedItem as AccountLedgerMaster).AccountLedgerID; Enum.TryParse <Status>(cbxStatus.SelectedValue.ToString(), out status); item.Status = status == Status.Active; item.HSNCode = tbxHSNCode.Text; bool actionResult = false; // if form is in Edit mode then udate item , else add item if (_itemId == 0) { actionResult = applicationFacade.AddNewItem(item); } else { actionResult = applicationFacade.UpdateItem(item); } //Close this form if operation is successful if (actionResult) { this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ItemMaster Add(ItemMaster itemMaster) { return(_context.ItemMaster.Add(itemMaster).Entity); }
void Awake() { //currentInventory = FindObjectOfType<PopulateInventoryListFromItemsMaster> (); currentItem = FindObjectOfType <UseItemToPopulateFields> (); masterList = FindObjectOfType <ItemMaster> (); }
public void Update(ItemMaster itemMaster) { //_context.Entry(itemMaster).State = EntityState.Modified; _context.ItemMaster.Update(itemMaster); }
public void Remove(ItemMaster master) { Items.Remove(master); Calculate(); }
public void Delete(ItemMaster itemMaster) { // var itemMaster = await _context.ItemMaster.SingleOrDefaultAsync(x => x.Id == itemMasterId); _context.Remove(itemMaster); }
// // GET: /item/{Key} public ActionResult Unique(Guid?id = null, string key = null) { if (!id.HasValue && string.IsNullOrWhiteSpace(key)) { return(RedirectToAction("Index")); } var callerId = User.IdentifierSafe(); var master = new ItemMaster() { Display = itemCore.GetItem(id, key, callerId), }; if (null != master.Display) { master.Display.SetCategories(); var dic = new Dictionary <Guid, ItemShare>(); foreach (var s in from s in borrowCore.Shares(master.Display) where s.Status == BorrowStatus.Returned select s) { if (!dic.ContainsKey(s.RequesterUserIdentifier)) { dic.Add(s.RequesterUserIdentifier, s); } } master.Display.Shares = dic.Values; var relatedProductQuery = string.Empty; if (null != master.Display.Categories && 0 < master.Display.Categories.Count()) { relatedProductQuery = string.Join(" ", master.Display.Categories); relatedProductQuery.Replace('#', (char)0); } else if (!string.IsNullOrWhiteSpace(master.Display.Title)) { relatedProductQuery = master.Display.Title; } if (!string.IsNullOrWhiteSpace(relatedProductQuery)) { master.Results = from i in this.luceneCore.Search(relatedProductQuery, callerId, 6, Reference.Item) where i.Key != key select i; } if (null != master.Display.Categories && (from c in master.Display.Categories where c.ToLower() == "book" || c.ToLower() == "books" select c).Count() > 0) { master.Display.ExternalReviews = this.goodReadsCore.GetReviewToken(master.Display.Title); } return(View(master)); } else if (!string.IsNullOrWhiteSpace(key)) { return(Redirect(ItemCore.SearchUrl(key, "unknown_key"))); } else { return(RedirectToAction("Index")); } }
//public static bool Insert(string sql) //{ // var ret = false; // using (SqlCeConnection conn = new SqlCeConnection(SQLCONN)) // { // conn.Open(); // SqlCeCommand command = new SqlCeCommand(sql, conn); // ret = command.ExecuteNonQuery() > 0; // conn.Close(); // } // return ret; //} /// <summary> /// InsertItemMaster /// </summary> /// <param name="item"></param> /// <returns></returns> public static bool InsertItemMaster(ItemMaster item) { var sql = @"INSERT INTO ItemMaster(ItemId,ItemName,ItemSize,ItemType,StockCount,StockPrice,Price,Id,UpdateTime,Color) VALUES (@ItemId,@ItemName,@ItemSize,@ItemType,@StockCount,@StockPrice,@Price,@Id,@UpdateTime,@Color)"; var ret = false; using (SqlCeConnection conn = new SqlCeConnection(SQLCONN)) { SqlCeTransaction tx = null; try { conn.Open(); tx = conn.BeginTransaction(); SqlCeCommand command = conn.CreateCommand(); var parameters = new[] { new SqlCeParameter("ItemId", SqlDbType.NVarChar, 100) { Value = item.ItemId }, new SqlCeParameter("ItemName", SqlDbType.NVarChar, 250) { Value = item.ItemName }, new SqlCeParameter("ItemSize", SqlDbType.Int) { Value = item.ItemSize }, new SqlCeParameter("ItemType", SqlDbType.Int) { Value = item.ItemType }, new SqlCeParameter("StockCount", SqlDbType.Int) { Value = item.StockCount }, new SqlCeParameter("StockPrice", SqlDbType.Decimal) { Value = item.StockPrice }, new SqlCeParameter("Price", SqlDbType.Decimal) { Value = item.Price }, new SqlCeParameter("Id", SqlDbType.NVarChar, 50) { Value = item.Id }, new SqlCeParameter("UpdateTime", SqlDbType.DateTime) { Value = item.UpdateTime.ToString("yyyy-MM-dd HH:mm:ss") }, new SqlCeParameter("Color", SqlDbType.NVarChar, 50) { Value = item.Color ?? "" } }; command.Parameters.AddRange(parameters); command.CommandText = sql; ret = command.ExecuteNonQuery() > 0; tx.Commit(); } catch (Exception ex) { tx.Rollback(); } finally { conn.Close(); } } return(ret); }
public int Remove_ItemMaster(ItemMaster _user) { SqlParameter[] param = { new SqlParameter("@ItemId", _user.ItemId) }; return(_da.Execute("Delete_ItemMaster", param)); }
/// <summary> /// /// </summary> /// <param name="window"></param> public StockViewModel(Window window) { ItemTypeCollection = new ObservableCollection <ItemTypeModel>(ItemTypeModel.ItemTypeModelList); ItemType = ItemTypeCollection.FirstOrDefault(); InsertCommandVisibility = Visibility.Visible; UpdateCommandVisibility = Visibility.Collapsed; BindData(); CloseCommand = new DelegateCommand(() => { window.Close(); }); InsertCommand = new DelegateCommand(() => { var item = new ItemMaster() { Id = Guid.NewGuid().ToString(), ItemId = ItemId, ItemName = ItemName, ItemSize = int.Parse(ItemSize), ItemType = ItemType.Type, StockCount = Count, StockPrice = decimal.Parse(StockPrice), Price = decimal.Parse(Price), UpdateTime = DateTime.Now, Color = Color }; if (SqlServerCompactService.InsertItemMaster(item)) { InitialControlValue(); BindData(); } }, CanExcute); UpdateCommand = new DelegateCommand(() => { var item = new ItemMaster() { Id = Id, ItemId = ItemId, ItemName = ItemName, ItemSize = int.Parse(ItemSize), ItemType = ItemType.Type, StockCount = Count, StockPrice = decimal.Parse(StockPrice), Price = decimal.Parse(Price), UpdateTime = DateTime.Now, Color = Color }; if (SqlServerCompactService.UpdateItemMaster(item)) { InitialControlValue(); BindData(); InsertCommandVisibility = Visibility.Visible; UpdateCommandVisibility = Visibility.Collapsed; } }, CanExcute); ClearCommand = new DelegateCommand(() => { InitialControlValue(); }); PreviousCommand = new DelegateCommand(() => { PageIndex--; ItemMasterColletion = new ObservableCollection <ItemMaster>(SOURCE.Where(t => t.ItemId.IndexOf(SearchItemId, StringComparison.OrdinalIgnoreCase) >= 0).Skip(PageIndex * PAGESIZE).Take(PAGESIZE)); }, () => { return(PageIndex > 0 ? true : false); }); NextCommand = new DelegateCommand(() => { PageIndex++; ItemMasterColletion = new ObservableCollection <ItemMaster>(SOURCE.Where(t => t.ItemId.IndexOf(SearchItemId, StringComparison.OrdinalIgnoreCase) >= 0).Skip(PageIndex * PAGESIZE).Take(PAGESIZE)); }, () => { return((PageIndex + 1) * PAGESIZE < SOURCE.Where(t => t.ItemId.IndexOf(SearchItemId, StringComparison.OrdinalIgnoreCase) >= 0).Count() ? true : false); }); SearchCommand = new DelegateCommand(() => { var s = SOURCE.Where(t => t.ItemId.IndexOf(SearchItemId, StringComparison.OrdinalIgnoreCase) >= 0); PageIndex = 0; ItemMasterColletion = new ObservableCollection <ItemMaster>(s.Skip(PageIndex * PAGESIZE).Take(PAGESIZE)); }, () => { return(string.IsNullOrEmpty(SearchItemId) ? false : true); }); AllCommand = new DelegateCommand(() => { SearchItemId = ""; ItemMasterColletion = new ObservableCollection <ItemMaster>(SOURCE.Where(t => t.ItemId.IndexOf(SearchItemId, StringComparison.OrdinalIgnoreCase) >= 0).Skip(PageIndex * PAGESIZE).Take(PAGESIZE)); }, () => { return(string.IsNullOrEmpty(SearchItemId) ? false : true); }); SelectCommand = new DelegateCommand <ItemMaster>(s => { if (s != null) { InsertCommandVisibility = Visibility.Collapsed; UpdateCommandVisibility = Visibility.Visible; Id = s.Id; ItemId = s.ItemId; ItemName = s.ItemName; ItemSize = s.ItemSize.ToString(); ItemType = ItemTypeCollection.FirstOrDefault(t => t.Type == s.ItemType); StockPrice = s.StockPrice.ToString(); Price = s.Price.ToString(); Count = s.StockCount; Color = s.Color; IsRepeat = false; } }); DeleteCommand = new DelegateCommand <ItemMaster>(s => { if (s != null) { if (MessageBox.Show(window, "是否确认删除该货品?", "确认删除点“Yes”,否则点“No”", MessageBoxButton.YesNo, MessageBoxImage.Warning, MessageBoxResult.Yes) == MessageBoxResult.Yes) { SqlServerCompactService.DeleteItemMaster(s); BindData(); InitialControlValue(); } } }); }
public IHttpActionResult UpdateItemMaster(ItemMaster itemMaster, bool isFileChanged) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { ItemMaster objGM = new ItemMaster(); objGM = objEntity.ItemMasters.Find(itemMaster.ID); if (objGM != null) { //objGM = itemMaster; objGM.DrawingNo = itemMaster.DrawingNo; objGM.Version = itemMaster.Version; objGM.C_Index = itemMaster.C_Index; objGM.PartName = itemMaster.PartName; objGM.PartCode = itemMaster.PartCode; objGM.PartCategory = itemMaster.PartCategory; objGM.CustomerName = itemMaster.CustomerName; objGM.BallooningNumber = itemMaster.BallooningNumber; if (itemMaster.DrawingUpload != null) { objGM.DrawingUpload = itemMaster.DrawingUpload; } if (itemMaster.ControlPlanUpload != null) { objGM.ControlPlanUpload = itemMaster.ControlPlanUpload; } if (itemMaster.PPAPUpload != null) { objGM.PPAPUpload = itemMaster.PPAPUpload; } if (isFileChanged && itemMaster.DrawingUpload != null) { fileName = itemMaster.DrawingUpload.Replace("C:\\fakepath\\", ""); fileName = fileName.Replace(" ", "-"); fileName = fileName.Replace(Path.GetExtension(itemMaster.DrawingUpload), ""); fileName = fileName + DateTime.Now + Path.GetExtension(itemMaster.DrawingUpload); fileName = fileName.Replace(" ", "-"); fileName = fileName.Replace(":", "-"); objGM.DrawingUpload = fileName; } if (isFileChanged && itemMaster.ControlPlanUpload != null) { fileName1 = itemMaster.ControlPlanUpload.Replace("C:\\fakepath\\", ""); fileName1 = fileName1.Replace(" ", "-"); fileName1 = fileName1.Replace(Path.GetExtension(itemMaster.ControlPlanUpload), ""); fileName1 = fileName1 + DateTime.Now + Path.GetExtension(itemMaster.ControlPlanUpload); fileName1 = fileName1.Replace(" ", "-"); fileName1 = fileName1.Replace(":", "-"); objGM.ControlPlanUpload = fileName1; } if (isFileChanged && itemMaster.PPAPUpload != null) { fileName2 = itemMaster.PPAPUpload.Replace("C:\\fakepath\\", ""); fileName2 = fileName.Replace(" ", "-"); fileName2 = fileName.Replace(Path.GetExtension(itemMaster.PPAPUpload), ""); fileName2 = fileName + DateTime.Now + Path.GetExtension(itemMaster.PPAPUpload); fileName2 = fileName.Replace(" ", "-"); fileName2 = fileName.Replace(":", "-"); objGM.PPAPUpload = fileName2; } } else { return(NotFound()); } int i = this.objEntity.SaveChanges(); } catch (Exception ex) { throw ex; } return(Ok(itemMaster)); }
public ItemMaster GetBooksMasterDetails(String itemID) { ItemMaster item = null; return(item); }
public static ItemMaster Instance () { if ( itemMaster == null ) { itemMaster = new ItemMaster(); } return itemMaster; }
/// <summary> /// 初始化 宫分组数据. /// </summary> /// <param name="result"></param> protected abstract void InitBox(ItemMaster result);
/// <summary> /// 初始化 其它分组数据. /// </summary> /// <param name="result"></param> protected virtual void InitOther(ItemMaster result) { // 默认情况下,不做处理. // 该方法由子类 覆盖处理. }
public CustomList <ItemMaster> GetAllItemMaster() { return(ItemMaster.GetAllItemMaster()); }