private bool purchaseOrderDetailsIsFull(ArrayList list) { bool isRet = true; for (int rowIndex = 0; rowIndex < list.Count; rowIndex++) { PurchaseOrderDetailsTable record = new PurchaseOrderDetailsTable(); record = (PurchaseOrderDetailsTable)list[rowIndex]; //string price = Convert.ToString(record.price); //string value = Convert.ToString(record.value); if (record.price == 0) { MessageBoxExtend.messageWarning("第[" + record.rowNumber + "]信息中物料单价不能为空"); isRet = false; break; } if (record.value == 0) { MessageBoxExtend.messageWarning("第[" + record.rowNumber + "]信息中物料数量不能为空"); isRet = false; break; } } return(isRet); }
public IHttpActionResult PutPurchaseOrderDetailsTable(int id, PurchaseOrderDetailsTable purchaseOrderDetailsTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != purchaseOrderDetailsTable.PurchaseOrderDetailsId) { return(BadRequest()); } db.Entry(purchaseOrderDetailsTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!PurchaseOrderDetailsTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void writeBillDetailsInfoFromBillNumber(string billNumber) { // DataGridView 赋值 SortedDictionary <int, PurchaseOrderDetailsTable> purchaseOrderDetails = PurchaseOrderDetails.getInctance().getPurchaseInfoFromBillNumber(billNumber); foreach (KeyValuePair <int, PurchaseOrderDetailsTable> index in purchaseOrderDetails) { PurchaseOrderDetailsTable record = new PurchaseOrderDetailsTable(); record = index.Value; int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Brand].Value = record.brand; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = record.materielUnitPurchase; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = record.transportationCost; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.otherCost; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney; } }
private ArrayList getPurchaseOrderDetailsValue() { ArrayList list = new ArrayList(); for (int rowIndex = 0; rowIndex < DateGridVeiwListDataListRowCount; rowIndex++) { if (this.dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value.ToString().Length == 0) { break; } else { PurchaseOrderDetailsTable record = new PurchaseOrderDetailsTable(); record.rowNumber = dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.RowNum].Value.ToString(); record.materielID = Convert.ToInt32(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value.ToString()); record.price = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value.ToString()); record.value = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value.ToString()); record.transportationCost = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value.ToString()); record.otherCost = Convert.ToDouble(dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value.ToString()); record.billNumber = this.labelBillNumber.Text; list.Add(record); } } return(list); }
public IHttpActionResult GetPurchaseOrderDetailsTable(int id) { PurchaseOrderDetailsTable purchaseOrderDetailsTable = db.PurchaseOrderDetailsTables.Find(id); if (purchaseOrderDetailsTable == null) { return(NotFound()); } return(Ok(purchaseOrderDetailsTable)); }
public IHttpActionResult PostPurchaseOrderDetailsTable(PurchaseOrderDetailsTable purchaseOrderDetailsTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.PurchaseOrderDetailsTables.Add(purchaseOrderDetailsTable); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = purchaseOrderDetailsTable.PurchaseOrderDetailsId }, purchaseOrderDetailsTable)); }
public IHttpActionResult DeletePurchaseOrderDetailsTable(int id) { PurchaseOrderDetailsTable purchaseOrderDetailsTable = db.PurchaseOrderDetailsTables.Find(id); if (purchaseOrderDetailsTable == null) { return(NotFound()); } db.PurchaseOrderDetailsTables.Remove(purchaseOrderDetailsTable); db.SaveChanges(); return(Ok(purchaseOrderDetailsTable)); }
public IHttpActionResult PostPurchaseDetailsTable(PurchaseOrderDetailsTable purchaseOrderDetail) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.PurchaseOrderDetailsTables.Add(purchaseOrderDetail); db.SaveChanges(); return(Ok()); } catch (Exception ex) { return(BadRequest()); } }
private void readBillInfoToUI() { // 单据表头表尾信息 m_purchaseOrder = PurchaseOrder.getInctance().getPurchaseInfoFromBillNumber(m_billNumber); m_supplierPkey = m_purchaseOrder.supplierId; this.labelPurchaseName.Visible = true; this.labelTradingDate.Visible = true; this.labelBillNumber.Visible = true; this.labelPurchaseType.Visible = true; this.labelDeliveryDate.Visible = true; this.labelPaymentDate.Visible = true; this.labelSummary.Visible = true; this.labelBusinessPeople.Visible = true; this.labelMakeBillStaff.Visible = true; this.labelReviewBillStaff.Visible = true; this.labelReviewDate.Visible = true; this.labelPurchaseName.Text = m_purchaseOrder.supplierName; this.labelTradingDate.Text = m_purchaseOrder.tradingDate; this.labelBillNumber.Text = m_purchaseOrder.billNumber; this.labelPurchaseType.Text = m_purchaseOrder.purchaseType; this.labelDeliveryDate.Text = m_purchaseOrder.deliveryDate; this.labelPaymentDate.Text = m_purchaseOrder.paymentDate; this.labelSummary.Text = m_purchaseOrder.exchangesUnit; m_staffPkey = m_purchaseOrder.businessPeopleId; this.labelBusinessPeople.Text = m_purchaseOrder.businessPeopleName; this.labelMakeBillStaff.Text = m_purchaseOrder.makeOrderStaffName; // DataGridView 赋值 SortedDictionary <int, PurchaseOrderDetailsTable> purchaseOrderDetails = PurchaseOrderDetails.getInctance().getPurchaseInfoFromBillNumber(m_billNumber); foreach (KeyValuePair <int, PurchaseOrderDetailsTable> index in purchaseOrderDetails) { PurchaseOrderDetailsTable record = new PurchaseOrderDetailsTable(); record = index.Value; int rowIndex = Convert.ToInt32(record.rowNumber.ToString()) - 1; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielNumber].Value = record.materielID; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.MatetielName].Value = record.materielName; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Model].Value = record.materielModel; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Unit].Value = record.materielUnitPurchase; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Price].Value = record.price; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Value].Value = record.value; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.Turnover].Value = record.sumMoney; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.TransportationCost].Value = record.transportationCost; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.OtherCost].Value = record.otherCost; dataGridViewDataList.Rows[rowIndex].Cells[(int)DataGridColumnName.SumTurnover].Value = record.totalMoney; } // 如果单据已审核,则禁用页面所有控件 if (m_purchaseOrder.isReview == "1") { this.labelReviewBillStaff.Text = m_purchaseOrder.orderrReviewName; this.labelReviewDate.Text = m_purchaseOrder.reviewDate; this.panelIsReview.Visible = true; this.save.Enabled = false; this.toolStripButtonReview.Enabled = false; this.dataGridViewDataList.ReadOnly = true; this.dataGridViewDataCount.ReadOnly = true; this.panelPurchaseName.Visible = false; this.panelTradingDate.Visible = false; this.panelPurchaseType.Visible = false; this.panelDeliveryDate.Visible = false; this.panelPaymentDate.Visible = false; this.panelSummary.Visible = false; this.textBoxPurchaseName.Visible = false; this.dateTimePickerTradingDate.Visible = false; this.comboBoxPurchaseType.Visible = false; this.dateTimePickerDeliveryDate.Visible = false; this.dateTimePickerPaymentDate.Visible = false; this.textBoxSummary.Visible = false; this.panelBusinessPeople.Visible = false; } else { this.labelReviewBillStaff.Visible = false; this.labelReviewDate.Visible = false; } }
public IHttpActionResult PostPurchase([FromBody] MvcPurchaseViewModel PurchaseViewModel) { using (DBEntities entities = new DBEntities()) { using (DbContextTransaction transaction = entities.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { try { PurchaseOrderTable _PTable = new PurchaseOrderTable(); _PTable.CompanyId = PurchaseViewModel.CompanyId; _PTable.UserId = PurchaseViewModel.UserId; _PTable.PurchaseID = PurchaseViewModel.PurchaseId.ToString(); _PTable.VenderId = PurchaseViewModel.VenderId; _PTable.PurchaseRefNumber = PurchaseViewModel.PurchaseRefNumber; _PTable.PurchaseDate = Convert.ToDateTime(PurchaseViewModel.PurchaseDate); _PTable.PurchaseDueDate = PurchaseViewModel.PurchaseDueDate; _PTable.PurchaseSubTotal = PurchaseViewModel.PurchaseSubTotal; _PTable.PurchaseDiscountAmount = PurchaseViewModel.PurchaseDiscountAmount; _PTable.PurchaseTotoalAmount = PurchaseViewModel.PurchaseTotoalAmount; _PTable.PurchaseVenderNote = PurchaseViewModel.PurchaseVenderNote; _PTable.Vat6 = PurchaseViewModel.Vat6; _PTable.Vat21 = PurchaseViewModel.Vat21; _PTable.Status = "open"; _PTable.Type = StatusEnum.Goods.ToString(); _PTable = entities.PurchaseOrderTables.Add(_PTable); entities.SaveChanges(); if (PurchaseViewModel.PurchaseOrderList != null) { foreach (PurchaseOrderDetailsTable item in PurchaseViewModel.PurchaseOrderList) { PurchaseOrderDetailsTable purchadeDetail = new PurchaseOrderDetailsTable(); purchadeDetail.PurchaseOrderDetailsId = item.PurchaseOrderDetailsId; purchadeDetail.PurchaseItemId = item.PurchaseItemId; purchadeDetail.PurchaseDescription = item.PurchaseDescription; purchadeDetail.PurchaseQuantity = item.PurchaseQuantity; purchadeDetail.PurchaseItemRate = item.PurchaseItemRate; purchadeDetail.PurchaseTotal = item.PurchaseTotal; purchadeDetail.Type = item.Type; purchadeDetail.RowSubTotal = item.RowSubTotal; purchadeDetail.PurchaseVatPercentage = item.PurchaseVatPercentage; purchadeDetail.PurchaseId = _PTable.PurchaseOrderID; purchadeDetail.ServiceDate = item.ServiceDate; entities.PurchaseOrderDetailsTables.Add(purchadeDetail); entities.SaveChanges(); } } AccountTransictionTable Account = new AccountTransictionTable(); Account.TransictionDate = DateTime.Now; Account.TransictionNumber = base64Guid; Account.TransictionType = "Purchase"; Account.CreationTime = DateTime.Now.TimeOfDay; Account.AddedBy = 1; Account.FK_CompanyId = PurchaseViewModel.CompanyId; Account.FKPaymentTerm = 1; Account.TransictionRefrenceId = _PTable.PurchaseOrderID.ToString(); //Accounts payable Transaction int Accountpayble = AccountIdByName("Accounts payable", (int)PurchaseViewModel.CompanyId); if (Accountpayble != 0) { Account.Dr = 0.00; Account.Cr = PurchaseViewModel.PurchaseTotoalAmount; Account.FK_AccountID = Accountpayble; entities.AccountTransictionTables.Add(Account); entities.SaveChanges(); } // Cost Of Goods Transaction int CostOfGood = AccountIdByName("Cost Of Goods", (int)PurchaseViewModel.CompanyId); if (CostOfGood != 0) { Account.Cr = 0.00; Account.Dr = PurchaseViewModel.PurchaseSubTotal; Account.FK_AccountID = CostOfGood; entities.AccountTransictionTables.Add(Account); entities.SaveChanges(); } // Input VAT Trnsaction int VatAccountId = AccountIdByName("Input VAT", (int)PurchaseViewModel.CompanyId); if (VatAccountId != 0) { Account.Cr = 0.00; Account.Dr = PurchaseViewModel.Vat21 + PurchaseViewModel.Vat6; Account.FK_AccountID = VatAccountId; entities.AccountTransictionTables.Add(Account); int Id = entities.SaveChanges(); } MvcPurchaseModel pModel = new MvcPurchaseModel(); pModel.PurchaseOrderID = _PTable.PurchaseOrderID; transaction.Commit(); return(Ok(pModel)); } catch (Exception) { transaction.Rollback(); return(BadRequest()); } } } }
public IHttpActionResult PutPurchaseTable(int id, MvcPurchaseViewModel PViewModel) { string Ref = PViewModel.PurchaseOrderID.ToString(); //accountTransictionTable.CreationTime = null; PurchaseOrderTable PTable = new PurchaseOrderTable(); using (DBEntities _dbcotext = new DBEntities()) { using (DbContextTransaction transaction = _dbcotext.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)) { try { PTable.PurchaseID = PViewModel.PurchaseId.ToString(); PTable.PurchaseOrderID = Convert.ToInt32(PViewModel.PurchaseOrderID); PTable.PurchaseRefNumber = PViewModel.PurchaseRefNumber; PTable.CompanyId = PViewModel.CompanyId; PTable.VenderId = PViewModel.VenderId; PTable.UserId = PViewModel.UserId; PTable.PurchaseDate = PViewModel.PurchaseDate; PTable.PurchaseDueDate = PViewModel.PurchaseDueDate; PTable.PurchaseSubTotal = PViewModel.PurchaseSubTotal; PTable.PurchaseDiscountAmount = PViewModel.PurchaseDiscountAmount; PTable.PurchaseTotoalAmount = PViewModel.PurchaseTotoalAmount; PTable.PurchaseVenderNote = PViewModel.PurchaseVenderNote; PTable.Vat6 = PViewModel.Vat6; PTable.Vat21 = PViewModel.Vat21; PTable.Status = "open"; PTable.Type = StatusEnum.Goods.ToString(); _dbcotext.Entry(PTable).State = EntityState.Modified; _dbcotext.SaveChanges(); if (PViewModel.PurchaseOrderList != null) { foreach (PurchaseOrderDetailsTable item in PViewModel.PurchaseOrderList) { PurchaseOrderDetailsTable DTable = new PurchaseOrderDetailsTable(); DTable.PurchaseOrderDetailsId = item.PurchaseOrderDetailsId; DTable.PurchaseItemId = item.PurchaseItemId; DTable.PurchaseDescription = item.PurchaseDescription; DTable.PurchaseQuantity = item.PurchaseQuantity; DTable.PurchaseItemRate = item.PurchaseItemRate; DTable.Type = item.Type; DTable.RowSubTotal = item.RowSubTotal; DTable.PurchaseDescription = item.PurchaseDescription; PTable.VenderId = PViewModel.VenderId; DTable.ServiceDate = item.ServiceDate; PTable.CompanyId = PViewModel.CompanyId; DTable.PurchaseTotal = item.PurchaseTotal; DTable.PurchaseVatPercentage = item.PurchaseVatPercentage; DTable.PurchaseId = PViewModel.PurchaseOrderID; if (DTable.PurchaseOrderDetailsId == 0) { _dbcotext.PurchaseOrderDetailsTables.Add(DTable); _dbcotext.SaveChanges(); } else { _dbcotext.Entry(DTable).State = EntityState.Modified; _dbcotext.SaveChanges(); } } AccountTransictionTable Account = new AccountTransictionTable(); Account.TransictionDate = DateTime.Now; Account.TransictionNumber = base64Guid; Account.TransictionType = "Purchase"; Account.CreationTime = DateTime.Now.TimeOfDay; Account.AddedBy = PViewModel.UserId; Account.FK_CompanyId = PViewModel.CompanyId; Account.FKPaymentTerm = 1; Account.TransictionRefrenceId = PTable.PurchaseOrderID.ToString(); //Accounts payable Transaction List <AccountTransictionTable> List = new List <AccountTransictionTable>(); List = _dbcotext.AccountTransictionTables.Where(t => t.TransictionRefrenceId == Ref.ToString()).ToList(); _dbcotext.AccountTransictionTables.RemoveRange(_dbcotext.AccountTransictionTables.Where(F => F.TransictionRefrenceId == Ref.ToString())); _dbcotext.SaveChanges(); int Accountpayble = AccountIdByName("Accounts payable", (int)PViewModel.CompanyId); if (Accountpayble != 0) { Account.Dr = 0.00; Account.Cr = PViewModel.PurchaseTotoalAmount; Account.FK_AccountID = Accountpayble; _dbcotext.AccountTransictionTables.Add(Account); _dbcotext.SaveChanges(); } // Cost Of Goods Transaction int CostOfGood = AccountIdByName("Cost Of Goods", (int)PViewModel.CompanyId); if (CostOfGood != 0) { Account.Cr = 0.00; Account.Dr = PViewModel.PurchaseSubTotal; Account.FK_AccountID = CostOfGood; _dbcotext.AccountTransictionTables.Add(Account); _dbcotext.SaveChanges(); } // Input VAT Trnsaction int VatAccountId = AccountIdByName("Input VAT", (int)PViewModel.CompanyId); if (VatAccountId != 0) { Account.Cr = 0.00; Account.Dr = PViewModel.Vat21 + PViewModel.Vat6; Account.FK_AccountID = VatAccountId; _dbcotext.AccountTransictionTables.Add(Account); int Id = _dbcotext.SaveChanges(); } transaction.Commit(); return(Ok()); } } catch (Exception) { transaction.Rollback(); return(BadRequest()); } return(BadRequest()); } } /////db.Entry(PurchaseTable).State = EntityState.Modified; //db.SaveChanges(); // return Ok(PurchaseTable); }