private void gridView2_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e) { var handler = gridView2.FocusedRowHandle; if (handler < 0) { return; } var entityId = gridView2.GetRowCellValue(handler, "ID"); if (entityId == null) { return; } int goodsOutID = int.Parse(entityId.ToString()); var entity = this.goodsOutHistory.FirstOrDefault(g => g.ID == goodsOutID); if (entity == null || entity == selectedHistoryGoodsOutEntity) { return; } else { selectedHistoryGoodsOutEntity = entity; LoadHistoryDetailGrid(); } }
private void gvGoodsOutList_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e) { var handler = gvGoodsOutList.FocusedRowHandle; if (handler < 0) { return; } var entityId = gvGoodsOutList.GetRowCellValue(handler, "ID"); if (entityId == null) { return; } int goodsOutID = int.Parse(entityId.ToString()); var entity = this.pendingGoodsOutList.FirstOrDefault(g => g.ID == goodsOutID); if (entity == null || entity == selectedGoodsOutEntity) { return; } else { selectedGoodsOutEntity = entity; simpleButton1.Enabled = selectedGoodsOutEntity.Status == 1; simpleButton2.Enabled = selectedGoodsOutEntity.Status == 1; LoadDetailGrid(); } }
public static int MaintainGoodsOutStatus(GoodsOutEntity entity, int status, Guid?receiverUserID) { var res = utity.ExecuteNonQuerySp("usp_MaintainGoodsOutStatus", new object[] { entity.ID, status, receiverUserID }); return(res); }
public static int InsertGoodsOut(GoodsOutEntity entity, DbTransaction trans) { var res = utity.ExecuteNonQuerySp(trans, "usp_InsertGoodsOut", new object[] { entity.ID, entity.StoreID, entity.ReceiverStoreID, entity.GoodsOutCode, entity.GoodsOutDate, entity.GoodsOutQuantity, entity.GoodsOutHumanID, entity.GoodsOutHumanName, entity.GoodsOutType, entity.GoodsOutTypeName, entity.Remrks }); return(res); }
private void GoodsOut() { var msg = string.Empty; bool result = false; if (!(gvGoodsOutList.RowCount > 0)) { ShowMessage("没有可出库商品,请先添加到到出库列表!"); return; } if (cboGoosOutType.EditValue == null) { ShowMessage("请选择出库类型!"); cboGoosOutType.Focus(); return; } if (cboReciveStore.EditValue == null) { ShowMessage("请选择接收门店!"); cboReciveStore.Focus(); return; } using (DbTransaction trans = utity.Transation) { var listGoodsEntity = gvGoodsOutList.DataSource as List <GoodsOutDetailEntity>; try { int success = 0; var goodsOutCode = PosBLL.instance.GetBatchNumber("OT"); listGoodsEntity.ForEach(item => { var mapGoodsOutDetail = item; mapGoodsOutDetail.ID = Guid.NewGuid(); mapGoodsOutDetail.GoodsOutCode = goodsOutCode; var receiver = (cboReciveStore.EditValue as BindUtil.ComboBoxItem); mapGoodsOutDetail.ReceiverStoreId = receiver.Value.ToInt32(); success += StockBLL.Instance.InsertGoodsOutDetail(mapGoodsOutDetail, trans); if (success <= 0) { throw new Exception(string.Format("商品({0})调拨失败,请确认接收方是否已授权并入库后重试", item.Name)); } }); if (success > 0) { var outType = (cboGoosOutType.EditValue as BindUtil.ComboBoxItem); var receiver = (cboReciveStore.EditValue as BindUtil.ComboBoxItem); var goodsOutEntiy = new GoodsOutEntity() { GoodsOutCode = goodsOutCode, GoodsOutDate = DateTime.Now, GoodsOutHumanID = UserInfo.Instance.ID, GoodsOutHumanName = UserInfo.Instance.RealName, GoodsOutQuantity = listGoodsEntity.Sum(item => item.OutQuantityStock), StoreID = (int)UserInfo.Instance.StoreID, ReceiverStoreID = receiver.Value.ToInt32(), GoodsOutType = outType.Value.ToInt32(), GoodsOutTypeName = outType.Text.Trim(), Remrks = txtRemark.EditValue.ToString() }; result = StockBLL.Instance.InsertGoodsOut(goodsOutEntiy, trans) > 0; } if (result) { trans.Commit(); msg = $"商品出库成功!共出库{listGoodsEntity.Count()}类商品,{listGoodsEntity.Sum(item => item.OutQuantityStock)}件"; ShowMessage(msg); //listGoods.Clear(); //ReloadGrid(); AfterCreated?.Invoke(); this.Close(); } else { trans.Rollback(); msg = "商品出库失败"; ShowMessage("商品出库失败"); } } catch (Exception e) { trans.Rollback(); msg = $"商品出库失败。失败原因:{e.Message}"; ShowMessage(msg); } WriteLog(new PartialLog { Description = msg, ModuleName = "商品出库", Result = result ? ResultType.success.ToString() : ResultType.error.ToString(), Type = LogType.CS.ToString() }); } }
public int MaintainGoodsOutStatus(GoodsOutEntity entity, int status, Guid?receiverUserId = null) { return(StockDAL.MaintainGoodsOutStatus(entity, status, receiverUserId)); }
public int InsertGoodsOut(GoodsOutEntity entity, DbTransaction trans) { return(StockDAL.InsertGoodsOut(entity, trans)); }