private void grid_CellValueChanged(object sender, GridCellValueChangedEventArgs e) { GridCell cell = e.GridCell; var row = (GridRow)e.GridPanel.Rows[cell.RowIndex]; //根据选择的零件号,获取库存批次,单价 if (cell.GridColumn == gcPartCode) { var stockDetail = StockDetailController.GetListByPartCode(_db, cell.Value.ToString()).OrderBy(p => p.Batch).FirstOrDefault(); row.Cells[gcBatch].Value = stockDetail.Batch; row.Cells[gcFromLocCode].Value = stockDetail.LocCode; } }
private void grid_CellValueChanged(object sender, GridCellValueChangedEventArgs e) { GridCell cell = e.GridCell; var row = (GridRow)e.GridPanel.Rows[cell.RowIndex]; //相同批次的物料,看库存中是否有单价 if (cell.GridColumn == gcPartCode || cell.GridColumn == gcBatch) { if (row[gcPartCode].Value != null) { var partcode = row[gcPartCode].Value.ToString(); if (row[gcBatch].Value != null) { var batch = row[gcBatch].Value.ToString(); var stockDetail = StockDetailController.GetListByPartCode(_db, partcode) .Where(p => p.Batch == batch) .OrderBy(p => p.Batch) .FirstOrDefault(); if (stockDetail != null) { row.Cells[gcUnitPrice].Value = stockDetail.UnitPrice; } } } if (row[gcProduceDate].Value == null) { row[gcProduceDate].Value = DateTime.Now; } } //根据出库数量,自动计算金额 if (cell.GridColumn == gcUnitPrice || cell.GridColumn == gcQty) { if (Convert.ToString(row.Cells[gcUnitPrice].Value) != "" && Convert.ToString(row.Cells[gcQty].Value) != "") { row.Cells[gcAmount].Value = (decimal)row.Cells[gcUnitPrice].Value * (decimal)row.Cells[gcQty].Value; } } }