private double GetLastLotNo() { if (!string.IsNullOrEmpty(baseAddEditMasterDetail.FormKeyCode) && ddlWarehouseDetails.SelectedIndex != 0) { PhyLot entity = new PhyLot() { warehouse_id = ddlWarehouseDetails.SelectedValue.ToLong(), material_id = baseAddEditMasterDetail.FormKeyCode.ToLong() }; return(ServiceProvider.PhyLotService.GetCurrentLotNo(entity) + 1); } return(1); }
private double GetLastLotNo() { if (ddlMaterial.SelectedIndex != 0 && ddlWarehouseDetails.SelectedIndex != 0) { PhyLot entity = new PhyLot() { warehouse_id = ddlWarehouseDetails.SelectedValue.ToLong(), material_id = ddlMaterial.SelectedValue.ToLong() }; return(ServiceProvider.PhyLotService.GetCurrentLotNo(entity) + 1); } return(1); }
private void btnLoadPortFolio_Click(object sender, EventArgs e) { object result = base.OpenPopup <InPortfolio>(); if (result != null) { DataSet dsPortfolioDetail = (DataSet)result; if (dsPortfolioDetail.Tables.Count > 0) { foreach (DataRow dr in dsPortfolioDetail.Tables[0].Rows) { DataRow newRow = this.dsTranDetail.Tables[0].NewRow(); if (!string.IsNullOrEmpty(base.FormKeyCode)) { newRow["tran_head_id"] = base.FormKeyCode.ToLong(); } newRow["material_code"] = dr["material_code"]; newRow["material_id"] = dr["material_id"]; newRow["warehouse_id_dest"] = dr["warehouse_id"]; newRow["Quantity"] = 0; newRow["Remark"] = ""; newRow["Material"] = dr["material_name"]; newRow["warehouse_id_dest"] = dr["warehouse_id"]; newRow["Warehouse"] = dr["warehouse_name"]; PhyLot entityPhyLot = new PhyLot() { warehouse_id = newRow["warehouse_id_dest"].ToLong(), material_id = newRow["material_id"].ToLong() }; newRow["Lot No."] = (ServiceProvider.PhyLotService.GetCurrentLotNo(entityPhyLot) + 1); newRow["UOM"] = dr["uom_name"]; this.dsTranDetail.Tables[0].Rows.Add(newRow); } baseGridDetail.LoadData(); } } }
private void SaveLots(TranDetail entityDetail, TranHead entityTranHead) { //get in_material Material entityMaterial = new Material() { material_id = entityDetail.material_id }; entityMaterial = ServiceProvider.MaterialService.FindByKeys(entityMaterial, false); //update into in_phy_lot PhyLot entityPhyLot = ServiceProvider.PhyLotService.GetPhyLot(entityDetail.material_id, entityDetail.warehouse_id_dest, entityDetail.lot_no.Value); entityPhyLot.bal_qty = (entityPhyLot.bal_qty - entityDetail.quantity.Value); ServiceProvider.PhyLotService.Update(entityPhyLot); //update into in_log_lot LogLot entityLogLot = ServiceProvider.LogLotService.GetLogLot(entityDetail.material_id, entityDetail.warehouse_id_dest); entityLogLot.bal_qty = (entityLogLot.bal_qty - entityDetail.quantity.Value); ServiceProvider.LogLotService.Update(entityLogLot); }
private void SaveLots(StockDetail entityDetail, StockHead entityStockHead) { //update into in_phy_lot PhyLot entityPhyLot = ServiceProvider.PhyLotService.GetPhyLot(entityDetail.material_id, entityStockHead.warehouse_id, entityDetail.lot_no, false); entityPhyLot.bal_qty = entityDetail.bal_qty; entityPhyLot.bf_qty = entityDetail.bf_qty; entityPhyLot.bf_date = entityDetail.bf_date; ServiceProvider.PhyLotService.Update(entityPhyLot); //update into in_log_lot LogLot entityLogLot = ServiceProvider.LogLotService.GetLogLot(entityDetail.material_id, entityStockHead.warehouse_id); entityLogLot.bal_qty = entityDetail.bal_qty; entityLogLot.bf_qty = entityDetail.bf_qty; entityLogLot.bf_date = entityDetail.bf_date; ServiceProvider.LogLotService.Update(entityLogLot); //Insert BFLogical bfLogical = new BFLogical(); bfLogical.period_id = entityStockHead.period_id; bfLogical.warehouse_id = entityStockHead.warehouse_id; bfLogical.material_id = entityDetail.material_id; bfLogical.bf_qty = entityDetail.bf_qty; bfLogical.bal_qty = entityDetail.bal_qty; ServiceProvider.BFLogicalService.Insert(bfLogical); BFPhysical bfPhysical = new BFPhysical(); bfPhysical.period_id = entityStockHead.period_id; bfPhysical.warehouse_id = entityStockHead.warehouse_id; bfPhysical.material_id = entityDetail.material_id; bfPhysical.bf_qty = entityDetail.bf_qty; bfPhysical.bal_qty = entityDetail.bal_qty; bfPhysical.lot_no = entityDetail.lot_no; ServiceProvider.BFPhysicalService.Insert(bfPhysical); }
private void ValidationDetail(TranDetail entity) { ValidationResults results = new ValidationResults(); if (baseGridDetail.FormMode == ObjectState.Add) { if (entity.material_id == 0) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IsRequired, "Material"), this, string.Empty, string.Empty, null); results.AddResult(result); } else { if (entity.warehouse_id_dest != 0) { DataRow[] drs = this.GetDataRowDetail(entity.material_id, entity.warehouse_id_dest); if (drs.Count() >= 1) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IsDuplicate, "Material"), this, string.Empty, string.Empty, null); results.AddResult(result); } } } if (entity.warehouse_id_dest == 0) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IsRequired, "Warehouse"), this, string.Empty, string.Empty, null); results.AddResult(result); } } if (string.IsNullOrEmpty(txtLotNo.Text)) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IsRequired, "Lot No."), this, string.Empty, string.Empty, null); results.AddResult(result); } else if (Converts.ParseDoubleNullable(txtLotNo.Text) == null) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IncorrectFormatOne, "Lot No."), this, string.Empty, string.Empty, null); results.AddResult(result); } else if (entity.lot_no == 0) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.CompareValueMore, "Lot No.", "0"), this, string.Empty, string.Empty, null); results.AddResult(result); } else { if (entity.material_id != 0 && entity.warehouse_id_dest != 0) { PhyLot entityPhyLot = ServiceProvider.PhyLotService.GetPhyLot(entity.material_id, entity.warehouse_id_dest, entity.lot_no.Value, false); if (entityPhyLot == null || entityPhyLot.phy_lot_id == 0) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.NotExistsField, "Lot No.", entity.lot_no.Value), this, string.Empty, string.Empty, null); results.AddResult(result); } else { if ((entityPhyLot.bal_qty - entity.quantity) < 0) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.CompareValueMore, "Quantity", "material in stock"), this, string.Empty, string.Empty, null); results.AddResult(result); } } } } if (string.IsNullOrEmpty(txtQuantity.Text)) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IsRequired, "Quantity"), this, string.Empty, string.Empty, null); results.AddResult(result); } else if (Converts.ParseDoubleNullable(txtQuantity.Text) == null) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.IncorrectFormatOne, "Quantity"), this, string.Empty, string.Empty, null); results.AddResult(result); } else if (entity.quantity == 0) { ValidationResult result = new ValidationResult(string.Format(ErrorMessage.CompareValueMore, "Quantity", "0"), this, string.Empty, string.Empty, null); results.AddResult(result); } if (results.Count > 0) { throw new ValidationException(results); } }