/// <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());
}
