/// <summary> /// 修改 /// </summary> /// <param name="p_BE">要修改的实体</param> /// <param name="sqlTrans">事务类</param> public void RUpdate(int p_ID, int p_DID, BaseEntity[] p_BE, IDBTransAccess sqlTrans) { try { string sql = "DELETE Sale_SaleOrderItem WHERE MainID=" + SysString.ToDBString(p_ID); sql += " AND DID=" + SysString.ToDBString(p_DID); sqlTrans.ExecuteNonQuery(sql); decimal SH = 0; for (int i = 0; i < p_BE.Length; i++) { SaleOrderItemRule rule = new SaleOrderItemRule(); SaleOrderItem entity = (SaleOrderItem)p_BE[i]; entity.MainID = p_ID; entity.Seq = i + 1; rule.RAdd(entity, sqlTrans); SH = entity.SH; } sql = "UPDATE Sale_SaleOrderDts SET YarnCalcFlag=1"; sql += " WHERE ID=" + SysString.ToDBString(p_DID); sqlTrans.ExecuteNonQuery(sql); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
public void SaleOrderTest() { using (var Session = NhibernateLayer.OpenSession()) { using (var Transaction = Session.BeginTransaction()) { SaleOrderItemUnitTest SOrderItem = new SaleOrderItemUnitTest(); var SaleOrderItemID = SOrderItem.GetSaleOrderItem(); SaleOrderItem SaleOrderitem = Session.Get <SaleOrderItem>(SaleOrderItemID); SaleOrder SaleOrder1 = new SaleOrder { Title = "Ali", CreationDate = DateTime.Now }; SaleOrder1.SaleorderItems.Add(SaleOrderitem); Session.Save(SaleOrder1); Transaction.Commit(); var res = Session.Get <SaleOrder>(SaleOrder1.Id); Assert.AreEqual(res.Id, SaleOrder1.Id); } } }
/// <summary> /// 新增行 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertItem(SaleOrderItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SaleOrderItem("); strSql.Append("SaleOrderItemID,SaleOrderID,MaterialID,PlanQty,PlanCost,PrimaryUnitID,Remark,ActualQty)"); strSql.Append(" values ("); strSql.Append("@SaleOrderItemID,@SaleOrderID,@MaterialID,@PlanQty,@PlanCost,@PrimaryUnitID,@Remark,@ActualQty)"); SqlParameter[] parameters = { new SqlParameter("@SaleOrderItemID", SqlDbType.VarChar, 36), new SqlParameter("@SaleOrderID", SqlDbType.VarChar, 36), new SqlParameter("@MaterialID", SqlDbType.VarChar, 36), new SqlParameter("@PlanQty", SqlDbType.Decimal, 13), new SqlParameter("@ActualQty", SqlDbType.Decimal, 13), new SqlParameter("@PlanCost", SqlDbType.Decimal, 13), new SqlParameter("@PrimaryUnitID", SqlDbType.VarChar, 36), new SqlParameter("@Remark", SqlDbType.VarChar, 1024) }; parameters[0].Value = model.SaleOrderItemID; parameters[1].Value = model.SaleOrderID; parameters[2].Value = model.MaterialID; parameters[3].Value = model.PlanQty; parameters[4].Value = model.ActualQty; parameters[5].Value = model.PlanCost; parameters[6].Value = model.PrimaryUnitID; parameters[7].Value = model.Remark; return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters)); }
private void BtnUpdateSaleOrderItemQty_Click(object sender, EventArgs e) { SaleOrderItem.updateQty(selectedSaleOrderItemsRowId(), in_SaleOrderItemQty.ValueDecimal); in_SaleOrderItemQty.Value = 0; pnlUpdateSaleOrderItemQty.Visible = false; populateGridSaleOrderItems(); }
public Guid SaleOrderItemId() { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var IDItem = ItemId(); Item item = session.Get <Item>(IDItem); var IDRack = RackId(); Rack rack = session.Get <Rack>(IDRack); var saleOrderItem = new SaleOrderItem { NetPrice = "12", Quantity = "43", TotalPrice = "67", UnitPrice = "67", Rack = rack, Item = item }; session.Save(saleOrderItem); transaction.Commit(); saleOrderItem = session.Get <SaleOrderItem>(saleOrderItem.Id); return(saleOrderItem.Id); } } }
/// <summary> /// 删除 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Delete(BaseEntity p_Entity) { try { SaleOrderItem MasterEntity = (SaleOrderItem)p_Entity; if (MasterEntity.ID == 0) { return(0); } //删除主表数据 string Sql = ""; Sql = "DELETE FROM Sale_SaleOrderItem WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(Sql); } else { AffectedRows = sqlTrans.ExecuteNonQuery(Sql); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E); } }
private void ChangePriceTotal(SaleOrderItem item) { var Order = dbSaleOrder.Get(item.SaleOrder.Id); Order.PriceTotal = Order.SaleOrderItem .Where(s => s.Status == true) .Sum(t => t.PriceSalebyUnit * t.Unit); dbSaleOrder.Update(item.SaleOrder.Id, Order, item.UpdatedId); }
public void UpdateSingle(Guid id, SaleOrderItem item, Guid UpdatedId) { var inventory = dbStock.ExistsProduct(item.Product_Id, item.SaleOrder.Id, item.Unit); Check.IsEquals(inventory, false, "No exite inventario disponible para este producto"); item.State = ObjectState.Modified; item.UpdatedId = UpdatedId; db.Save(item); ChangePriceTotal(item); }
public int UpdateSaleOrderItem(SaleOrderItem objSaleOrderItem) { using (IDbConnection connection = OpenConnection(dataConnection)) { string sql = @"UPDATE SaleOrderItem SET SlNo = @SlNo ,WorkDescriptionId = @WorkDescriptionId ,Remarks = @Remarks,PartNo = @PartNo,Quantity = @Quantity,UnitId = @UnitId,Rate = @Rate,Discount = @Discount OUTPUT INSERTED.SaleOrderItemId WHERE SaleOrderItemId = @SaleOrderItemId"; var id = connection.Execute(sql, objSaleOrderItem); return(id); } }
private void populatePageData() { if (_formMode == FormMode.Browse) { gridSaleOrderItems.DataSource = SaleOrderItem.get(null, null, _Customers_Id, true); } else { populateGridSaleOrders(); } }
public void SaleOrderItemTest() { using (var Session = NhibernateLayer.OpenSession()) { using (var Transaction = Session.BeginTransaction()) { var SaleID = GetSaleOrderItem(); SaleOrderItem SaleOrderItem1 = Session.Get <SaleOrderItem>(SaleID); Assert.AreEqual(SaleID, SaleOrderItem1.Id); } } }
/// <summary> /// 检验字段值是否已存在 /// </summary> /// <param name="p_TableName">表名</param> /// <param name="p_FieldName">字段名</param> /// <param name="p_FieldValue">字段值</param> /// <param name="p_KeyField">主键(只考虑主键为ID的情况)</param> /// <param name="p_KeyValue">主键值</param> /// <param name="p_sqlTrans"></param> /// <returns></returns> private bool CheckFieldValueIsExist(BaseEntity p_BE, string p_FieldName, string p_FieldValue, IDBTransAccess p_sqlTrans) { SaleOrderItem entity = (SaleOrderItem)p_BE; bool ret = false; string sql = string.Format(" SELECT {0} FROM {1} WHERE 1=1 AND {0}={2} AND {3}<>{4}", p_FieldName, SaleOrderItem.TableName, SysString.ToDBString(p_FieldValue), "ID", entity.ID); DataTable dt = p_sqlTrans.Fill(sql); if (dt.Rows.Count != 0) { ret = true; } return(ret); }
private void populateGridSaleOrderItems() { clearGridInventoryItems(); if (gridSaleOrders.SelectedRows.Count == 0) { gridSaleOrderItems.DataSource = null; } else { gridSaleOrderItems.DataSource = SaleOrderItem.get(selectedSaleOrdersRowID(), null, _Customers_Id, false); lblSaleOrderInfo.Text = string.Format("Customer PO #{0} Order Date: {1: dd/MMM/yy} Target: {2: dd/MMM/yy}", Util.getSelectedRowValue(gridSaleOrders, col_gridSaleOrders_CustomerPONo), Util.getSelectedRowValue(gridSaleOrders, col_gridSaleOrders_Timestamp), Util.getSelectedRowValue(gridSaleOrders, col_gridSaleOrders_TargetDate)); } }
/// <summary> /// 删除 /// </summary> /// <param name="p_BE">要删除的实体</param> /// <param name="sqlTrans">事务类</param> public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); SaleOrderItem entity = (SaleOrderItem)p_BE; SaleOrderItemCtl control = new SaleOrderItemCtl(sqlTrans); control.Delete(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); SaleOrderItem entity = (SaleOrderItem)p_BE; SaleOrderItemCtl control = new SaleOrderItemCtl(sqlTrans); entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Sale_SaleOrderItem, sqlTrans); control.AddNew(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
public void SaveSaleOrder() { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var rackid = GetRackId(); Rack rack2 = session.Get <Rack>(rackid); var itemid = GetItemId(); Item item2 = session.Get <Item>(itemid); SaleOrder so1 = new SaleOrder { Code = 1, CreationDate = DateTime.Now, Title = "furush" }; SaleOrderItem soi1 = new SaleOrderItem { Item = item2, Rack = rack2, NetPrice = 50, Quantity = 25, TotalPrice = 150, UnitPrice = 30 }; so1.SaleOrderItems.Add(soi1); session.Save(so1); transaction.Commit(); Assert.IsNotNull(session.Get <SaleOrderItem>(soi1.Id)); } } }
public int InsertSaleOrderItem(SaleOrderItem objSaleOrderItem, IDbConnection connection, IDbTransaction trn) { try { string sql = @"insert into SaleOrderItem(SaleOrderId,SlNo,WorkDescriptionId,VehicleModelId,Remarks,PartNo,Quantity,UnitId,Rate,Discount,Amount) Values (@SaleOrderId,@SlNo,@WorkDescriptionId,@VehicleModelId,@Remarks,@PartNo,1,@UnitId,@Rate,@Discount,@Amount); SELECT CAST(SCOPE_IDENTITY() as int)"; var id = 0; //for (int i = 0; i < objSaleOrderItem.Quantity; i++) //{ id = connection.Query <int>(sql, objSaleOrderItem, trn).Single(); //} return(id); } catch (Exception) { throw; } }
public Guid GetSaleOrderItem() { using (var Session = NhibernateLayer.OpenSession()) { using (var Transaction = Session.BeginTransaction()) { ItemUnitTest itemTest = new ItemUnitTest(); RackUnitTest rackTest = new RackUnitTest(); var ItemId = itemTest.GetItem(); var RackId = rackTest.GetRack(); Item Item = Session.Get <Item>(ItemId); Rack Rack = Session.Get <Rack>(RackId); SaleOrderItem SaleOrderItem1 = new SaleOrderItem() { Name = "khodkar", QTY = 10, NetPrice = 800, TotalPrice = 10 * 800, UnitPrice = 800, Item1 = Item, Rack1 = Rack }; Session.Save(SaleOrderItem1); Transaction.Commit(); var Res = Session.Get <Market.Entities.ShouldMap.SaleOrderItem>(SaleOrderItem1.Id); return(Res.Id); } } }
public void SaleOrder() { using (ISession session = NhibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var ItemId = GetItemId(); Item item = session.Get <Item>(ItemId); var RackId = GetRackId(); Rack rack = session.Get <Rack>(RackId); SaleOrder saleOrder = new SaleOrder { CreationDate = DateTime.Now, Title = "Forush" }; SaleOrderItem saleOrderItem = new SaleOrderItem { Item = item, Rack = rack, NetPrice = 50, Quantity = 90, TotalPrice = 36, UnitPrice = 60 }; saleOrder.SaleOrderItems.Add(saleOrderItem); session.Save(saleOrder); transaction.Commit(); Assert.IsNotNull(session.Get <SaleOrderItem>(saleOrderItem.Id)); } } }
public void Insert(SaleOrderItem item, Guid UpdatedId) { var inventory = dbStock.ExistsProduct(item.Product_Id, item.SaleOrder.Id, item.Unit); Check.IsEquals(inventory, false, "No existe inventario disponible para este producto"); var Query = dbProduct.GetProductByTaxeWhere(item.Product_Id).ToList(); List <TaxeOrder> taxe = new List <TaxeOrder>(); if (Query != null) { taxe = Query .Select(t => new TaxeOrder { Id = Guid.NewGuid(), Code = t.Code, Name = t.Name, Parent = t.Parent, SaleOrderItem = item, ServiceType = t.ServiceType, State = ObjectState.Added, Status = true, Type = t.Type, UpdatedId = UpdatedId, Creation = DateTime.UtcNow, Value = t.Value, PriceTax = CalculateTax(item.Unit, item.PriceSalebyUnit, t.Value, t.Type) }) .ToList(); } item.TaxeOrder = taxe; item.UpdatedId = UpdatedId; item.State = ObjectState.Added; var id = db.Save(item); ChangePriceTotal(item); }
public void TestSaleOrder() { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var IDSaleOrderItem = SaleOrderItemId(); SaleOrderItem saleorderitem = session.Get <SaleOrderItem>(IDSaleOrderItem); var saleOrder = new SaleOrder { Code = "30", CreationDate = DateTime.Now, Title = "450" }; saleOrder.saleOrderItems.Add(saleorderitem); session.Save(saleOrder); transaction.Commit(); var result4 = session.Get <SaleOrder>(saleOrder.Id); Assert.IsNotNull(result4); } } }
/// <summary> /// 新增 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int AddNew(BaseEntity p_Entity) { try { SaleOrderItem MasterEntity = (SaleOrderItem)p_Entity; if (MasterEntity.ID == 0) { return(0); } //新增主表数据 StringBuilder MasterField = new StringBuilder(); StringBuilder MasterValue = new StringBuilder(); MasterField.Append("INSERT INTO Sale_SaleOrderItem("); MasterValue.Append(" VALUES("); MasterField.Append("ID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ","); MasterField.Append("MainID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ","); MasterField.Append("Seq" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ","); MasterField.Append("ItemCode" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ItemCode) + ","); MasterField.Append("ItemName" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ItemName) + ","); MasterField.Append("ItemStd" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ItemStd) + ","); MasterField.Append("Qty" + ","); if (MasterEntity.Qty != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.Qty) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("Unit" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Unit) + ","); MasterField.Append("Remark" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ","); MasterField.Append("VendorID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ","); MasterField.Append("ColorNum" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ColorNum) + ","); MasterField.Append("ColorName" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ColorName) + ","); MasterField.Append("SO" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SO) + ","); MasterField.Append("RQty" + ","); if (MasterEntity.RQty != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.RQty) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("ItemModel" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ItemModel) + ","); MasterField.Append("DID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.DID) + ","); MasterField.Append("SH" + ","); if (MasterEntity.SH != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.SH) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("SQty" + ","); if (MasterEntity.SQty != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.SQty) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("Per" + ","); if (MasterEntity.Per != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.Per) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("SH2" + ","); if (MasterEntity.SH2 != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.SH2) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("BuyType" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.BuyType) + ","); MasterField.Append("SH3" + ","); if (MasterEntity.SH3 != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.SH3) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("BL" + ")"); if (MasterEntity.BL != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.BL) + ")"); } else { MasterValue.Append("null)"); } //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString()); } else { AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString()); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E); } }
/// <summary> /// 新增行 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertItem(SaleOrderItem model) { return(iSaleOrderItemDAL.InsertItem(model)); }
public void changeStatus_Click(object sender, EventArgs args) { SaleOrderItem.updateStatus(selectedSaleOrderItemsRowId(), Tools.parseEnum <SaleOrderItemStatus>(sender.ToString())); populateGridSaleOrderItems(); }
/// <summary> /// 检查将要操作的数据是否符合业务规则 /// </summary> /// <param name="p_BE"></param> private void CheckCorrect(BaseEntity p_BE) { SaleOrderItem entity = (SaleOrderItem)p_BE; }
public void CreateAndUpdatePurchaseOrder(SaleOrderContract saleOrderContract) { var saleOrder = SaleOrderRepository.Get(saleOrderContract.Id); if (saleOrder != null) { // Update Order saleOrder.Title = saleOrderContract.Title; for (int i = 0; i < saleOrderContract.SaleOrderItemContracts.Count; i++) { var temp = saleOrderContract.SaleOrderItemContracts[i]; if (saleOrder.SaleOrderItems.Any(x => x.Id == temp.Id)) { // Update OrdetItem .. var InDatabaseOrderItem = saleOrder.SaleOrderItems.FirstOrDefault(x => x.Id == temp.Id); InDatabaseOrderItem.NetPrice = temp.NetPrice; InDatabaseOrderItem.Quantity = temp.Quantity; InDatabaseOrderItem.UnitPrice = temp.UnitPrice; InDatabaseOrderItem.TotalPrice = temp.TotalPrice; InDatabaseOrderItem.Item = IitemRepository.Get(temp.ItemId); InDatabaseOrderItem.Rack = IRackRepository.Get(temp.RackId); } else { // Create OrderItem var InDatabaseOrderItem = new SaleOrderItem(); InDatabaseOrderItem.NetPrice = temp.NetPrice; InDatabaseOrderItem.Quantity = temp.Quantity; InDatabaseOrderItem.UnitPrice = temp.UnitPrice; InDatabaseOrderItem.TotalPrice = temp.TotalPrice; InDatabaseOrderItem.Item = IitemRepository.Get(temp.ItemId); InDatabaseOrderItem.Rack = IRackRepository.Get(temp.RackId); saleOrder.SaleOrderItems.Add(InDatabaseOrderItem); } } //Delete extra orderItems in order(DB) for (int i = 0; i < saleOrder.SaleOrderItems.Count; i++) { var temp = saleOrder.SaleOrderItems[i]; if (!saleOrderContract.SaleOrderItemContracts.Any(x => x.Id == temp.Id)) { saleOrder.SaleOrderItems.Remove(temp); } } SaleOrderRepository.Update(saleOrder); } else { // Create Order saleOrder = new SaleOrder(); saleOrder.Code = saleOrderContract.Code; saleOrder.CreationDate = saleOrderContract.CreationDate; saleOrder.Title = saleOrderContract.Title; for (int i = 0; i < saleOrderContract.SaleOrderItemContracts.Count; i++) { var temp = saleOrderContract.SaleOrderItemContracts[i]; var InDatabaseOrderItem = new SaleOrderItem(); InDatabaseOrderItem.NetPrice = temp.NetPrice; InDatabaseOrderItem.Quantity = temp.Quantity; InDatabaseOrderItem.UnitPrice = temp.UnitPrice; InDatabaseOrderItem.TotalPrice = temp.TotalPrice; InDatabaseOrderItem.Item = IitemRepository.Get(temp.ItemId); InDatabaseOrderItem.Rack = IRackRepository.Get(temp.RackId); saleOrder.SaleOrderItems.Add(InDatabaseOrderItem); } SaleOrderRepository.Insert(saleOrder); } }
public void CreateAndUpdateSaleOrder(SaleOrderContract saleOrderContract) { var saleorder = ISaleOrderRepository.Get(saleOrderContract.Id); if (saleorder != null) { saleorder.Code = saleOrderContract.Code; //saleorder.CreationDate = saleOrderContract.CreationDate; lazem nist moghe sakht object bevojode amede mesl Id saleorder.Title = saleOrderContract.Title; for (int i = 0; i < saleOrderContract.SaleOrderItemContracts.Count; i++) { var Temp = saleOrderContract.SaleOrderItemContracts[i]; if (saleorder.saleOrderItems.Any(s => s.Id == Temp.Id)) { var Insaleorderitem = saleorder.saleOrderItems.FirstOrDefault(s => s.Id == Temp.Id); Insaleorderitem.NetPrice = Temp.NetPrice; Insaleorderitem.Quantity = Temp.Quantity; Insaleorderitem.TotalPrice = Temp.TotalPrice; Insaleorderitem.UnitPrice = Temp.UnitPrice; Insaleorderitem.Rack = IRackRepository.Get(Temp.RackId); Insaleorderitem.Item = IItemRepository.Get(Temp.ItemId); } else { Insaleorderitem = new SaleOrderItem(); Insaleorderitem.NetPrice = Temp.NetPrice; Insaleorderitem.Quantity = Temp.Quantity; Insaleorderitem.TotalPrice = Temp.TotalPrice; Insaleorderitem.UnitPrice = Temp.UnitPrice; Insaleorderitem.Rack = IRackRepository.Get(Temp.RackId); Insaleorderitem.Item = IItemRepository.Get(Temp.ItemId); saleorder.saleOrderItems.Add(Insaleorderitem); } } //var DeleteOrderItem = saleorder.saleOrderItems.Where(x => // !saleOrderContract.SaleOrderItemContracts.Any(y => y.Id == x.Id)); for (int i = 0; i < saleorder.saleOrderItems.Count; i++) { var Temp = saleorder.saleOrderItems.ToArray()[i]; if (!saleOrderContract.SaleOrderItemContracts.Any(s => s.Id == Temp.Id)) { saleorder.saleOrderItems.Remove(Temp); //var temp = ISaleOrderRepository.Get(Temp.Id); //ISaleOrderRepository.Delete(temp); } } ISaleOrderRepository.Update(saleorder); } else { saleorder = new SaleOrder(); saleorder.Code = saleOrderContract.Code; saleorder.CreationDate = saleOrderContract.CreationDate; saleorder.Title = saleOrderContract.Title; for (int i = 0; i < saleOrderContract.SaleOrderItemContracts.Count; i++) { var Temp = saleOrderContract.SaleOrderItemContracts[i]; Insaleorderitem = new SaleOrderItem(); Insaleorderitem.NetPrice = Temp.NetPrice; Insaleorderitem.Quantity = Temp.Quantity; Insaleorderitem.TotalPrice = Temp.TotalPrice; Insaleorderitem.UnitPrice = Temp.UnitPrice; Insaleorderitem.Rack = IRackRepository.Get(Temp.RackId); Insaleorderitem.Item = IItemRepository.Get(Temp.ItemId); saleorder.saleOrderItems.Add(Insaleorderitem); } ISaleOrderRepository.Insert(saleorder); } }
//esmet ke doros nist public void CreateAndDelete(SaleOrderContract saleOrderContract) { var SaleOrder = ISaleOrderRepository.Get(saleOrderContract.Id); if (SaleOrder != null) { SaleOrder.CreationDate = DateTime.Now; SaleOrder.Title = saleOrderContract.Title; SaleOrder.Code = saleOrderContract.Code; for (int i = 0; i < saleOrderContract.SaleorderItems.Count; i++) { var temp = saleOrderContract.SaleorderItems[i]; if (SaleOrder.SaleorderItems.Any(p => p.Id == temp.Id)) { var Sorderitem = SaleOrder.SaleorderItems.FirstOrDefault(p => p.Id == temp.Id); Sorderitem.QTY = temp.QTY; Sorderitem.Name = temp.Name; Sorderitem.NetPrice = temp.NetPrice; Sorderitem.TotalPrice = temp.TotalPrice; Sorderitem.UnitPrice = temp.UnitPrice; Sorderitem.Item1 = iitemRepository.Get(temp.ItemId); Sorderitem.Rack1 = iRackRepository.Get(temp.RackId); } else { var res = new SaleOrderItem(); res.QTY = temp.QTY; res.Name = temp.Name; res.NetPrice = temp.NetPrice; res.TotalPrice = temp.TotalPrice; res.UnitPrice = temp.UnitPrice; res.Item1 = iitemRepository.Get(temp.ItemId); res.Rack1 = iRackRepository.Get(temp.RackId); SaleOrder.SaleorderItems.Add(res); } } foreach (var item in SaleOrder.SaleorderItems) { if (SaleOrder.SaleorderItems.Any(s => s.Id != item.Id)) { SaleOrder.SaleorderItems.Remove(item); } } ISaleOrderRepository.Update(SaleOrder); } else { SaleOrder.CreationDate = saleOrderContract.CreationDate; SaleOrder.Title = saleOrderContract.Title; SaleOrder.Code = saleOrderContract.Code; for (int i = 0; i < saleOrderContract.SaleorderItems.Count; i++) { var temp = saleOrderContract.SaleorderItems[i]; if (SaleOrder.SaleorderItems.Any(p => p.Id == temp.Id)) { var sorderitem = SaleOrder.SaleorderItems.FirstOrDefault(p => p.Id == temp.Id); sorderitem.QTY = temp.QTY; sorderitem.Name = temp.Name; sorderitem.NetPrice = temp.NetPrice; sorderitem.TotalPrice = temp.TotalPrice; sorderitem.UnitPrice = temp.UnitPrice; sorderitem.Item1 = iitemRepository.Get(temp.ItemId); sorderitem.Rack1 = iRackRepository.Get(temp.RackId); } } ISaleOrderRepository.Insert(SaleOrder); } }
public void SaveCreateOrUpdate(SaleOrderContract saleOrderContract) { var saleOrderDb = ISaleOrderrepository.Get(saleOrderContract.Id); if (saleOrderDb != null) { for (int i = 0; i < saleOrderContract.SaleOrderItemscontract.Count; i++) { var temp = saleOrderContract.SaleOrderItemscontract[i]; if (saleOrderDb.SaleOrderItem.Any(x => x.Id == temp.Id)) { var indatabaseorderitem = saleOrderDb.SaleOrderItem.FirstOrDefault(x => x.Id == temp.Id); indatabaseorderitem.Item = ItemRepository.Get(temp.ItemId); indatabaseorderitem.Rack = IRackRepository.Get(temp.RackId); indatabaseorderitem.NetPrice = temp.NetPrice; indatabaseorderitem.Quantity = temp.Quantity; indatabaseorderitem.TotalPrice = temp.TotalPrice; indatabaseorderitem.UnitPrice = temp.UnitPrice; } else { SaleOrderItem saleOrderItem = new SaleOrderItem(); saleOrderItem.Item = ItemRepository.Get(temp.ItemId); saleOrderItem.Rack = IRackRepository.Get(temp.RackId); saleOrderItem.Quantity = temp.Quantity; saleOrderItem.NetPrice = temp.NetPrice; saleOrderItem.TotalPrice = temp.TotalPrice; saleOrderItem.UnitPrice = temp.UnitPrice; saleOrderDb.SaleOrderItem.Add(saleOrderItem); } } for (int i = 0; i < saleOrderDb.SaleOrderItem.Count; i++) { var temp = saleOrderDb.SaleOrderItem[i]; if (saleOrderContract.SaleOrderItemscontract.All(x => x.Id != temp.Id)) { saleOrderDb.SaleOrderItem.Remove(temp); } } ISaleOrderrepository.Update(saleOrderDb); } else { saleOrderDb = new SaleOrder(); saleOrderDb.Code = saleOrderContract.Code; saleOrderDb.CreationDate = saleOrderContract.CreationDate; saleOrderDb.Title = saleOrderContract.Title; SaleOrderItem saleOrderItem = new SaleOrderItem(); for (int i = 0; i < saleOrderContract.SaleOrderItemscontract.Count; i++) { var temp = saleOrderContract.SaleOrderItemscontract[i]; saleOrderItem.Item = ItemRepository.Get(temp.ItemId); saleOrderItem.Rack = IRackRepository.Get(temp.RackId); saleOrderItem.Quantity = temp.Quantity; saleOrderItem.NetPrice = temp.NetPrice; saleOrderItem.TotalPrice = temp.TotalPrice; saleOrderItem.UnitPrice = temp.UnitPrice; saleOrderDb.SaleOrderItem.Add(saleOrderItem); } ISaleOrderrepository.Insert(saleOrderDb); } }
/// <summary> /// 修改 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Update(BaseEntity p_Entity) { try { SaleOrderItem MasterEntity = (SaleOrderItem)p_Entity; if (MasterEntity.ID == 0) { return(0); } //更新主表数据 StringBuilder UpdateBuilder = new StringBuilder(); UpdateBuilder.Append("UPDATE Sale_SaleOrderItem SET "); UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ","); UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ","); UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ","); UpdateBuilder.Append(" ItemCode=" + SysString.ToDBString(MasterEntity.ItemCode) + ","); UpdateBuilder.Append(" ItemName=" + SysString.ToDBString(MasterEntity.ItemName) + ","); UpdateBuilder.Append(" ItemStd=" + SysString.ToDBString(MasterEntity.ItemStd) + ","); if (MasterEntity.Qty != 0) { UpdateBuilder.Append(" Qty=" + SysString.ToDBString(MasterEntity.Qty) + ","); } else { UpdateBuilder.Append(" Qty=null,"); } UpdateBuilder.Append(" Unit=" + SysString.ToDBString(MasterEntity.Unit) + ","); UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ","); UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ","); UpdateBuilder.Append(" ColorNum=" + SysString.ToDBString(MasterEntity.ColorNum) + ","); UpdateBuilder.Append(" ColorName=" + SysString.ToDBString(MasterEntity.ColorName) + ","); UpdateBuilder.Append(" SO=" + SysString.ToDBString(MasterEntity.SO) + ","); if (MasterEntity.RQty != 0) { UpdateBuilder.Append(" RQty=" + SysString.ToDBString(MasterEntity.RQty) + ","); } else { UpdateBuilder.Append(" RQty=null,"); } UpdateBuilder.Append(" ItemModel=" + SysString.ToDBString(MasterEntity.ItemModel) + ","); UpdateBuilder.Append(" DID=" + SysString.ToDBString(MasterEntity.DID) + ","); if (MasterEntity.SH != 0) { UpdateBuilder.Append(" SH=" + SysString.ToDBString(MasterEntity.SH) + ","); } else { UpdateBuilder.Append(" SH=null,"); } if (MasterEntity.SQty != 0) { UpdateBuilder.Append(" SQty=" + SysString.ToDBString(MasterEntity.SQty) + ","); } else { UpdateBuilder.Append(" SQty=null,"); } if (MasterEntity.Per != 0) { UpdateBuilder.Append(" Per=" + SysString.ToDBString(MasterEntity.Per) + ","); } else { UpdateBuilder.Append(" Per=null,"); } if (MasterEntity.SH2 != 0) { UpdateBuilder.Append(" SH2=" + SysString.ToDBString(MasterEntity.SH2) + ","); } else { UpdateBuilder.Append(" SH2=null,"); } UpdateBuilder.Append(" BuyType=" + SysString.ToDBString(MasterEntity.BuyType) + ","); if (MasterEntity.SH3 != 0) { UpdateBuilder.Append(" SH3=" + SysString.ToDBString(MasterEntity.SH3) + ","); } else { UpdateBuilder.Append(" SH3=null,"); } if (MasterEntity.BL != 0) { UpdateBuilder.Append(" BL=" + SysString.ToDBString(MasterEntity.BL)); } else { UpdateBuilder.Append(" BL=null"); } UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID)); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString()); } else { AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString()); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E); } }