示例#1
0
        private void Save()
        {
            int OccupyQty = Convert.ToInt32(this.txtInventoryQty.Text) + Convert.ToInt32(this.txtOccupyQty.Text);

            if (OccupyQty > Convert.ToInt32(this.txtCanOccupyQty.Text))
            {
                MsgBox.Err("占用数量大于可占用的数量。");
                return;
            }
            int result = stockdal.UpdateOccupyQty(OccupyQty, StockRecord.StockID);

            if (result > 0)
            {
                OccupyRecordEntity OccupyRecord = new OccupyRecordEntity();
                OccupyRecord.StockID    = StockRecord.StockID;
                OccupyRecord.Creator    = GlobeSettings.LoginedUser.UserName;
                OccupyRecord.CreateDate = DateTime.Now;
                OccupyRecord.OccupyQty  = Convert.ToInt32(this.txtInventoryQty.Text);
                OccupyRecord.Remark     = txtRemark.Text;
                OccupyRecord.Status     = SysCodeConstant.OCCUPY_STATUS_OK;
                result = occupyrecorddal.OccupyRecordAdd(OccupyRecord);
                if (DataSourceChanged != null && result > 0)
                {
                    StockRecord.OccupyQty = OccupyQty;
                    DataSourceChanged(StockRecord, null);
                    this.Close();
                }
            }
            else
            {
                MsgBox.Err("占用失败。");
            }
        }
示例#2
0
        /// <summary>
        /// 添加占用记录
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public int OccupyRecordAdd(OccupyRecordEntity entity)
        {
            IMapper map = DatabaseInstance.Instance();
            int     ret = -1;

            ret = map.Execute("INSERT INTO OCCUPY_RECORD ( STOCK_ID ,CREATOR ,CREATEDATE ,OCCUPY_QTY ,STATUS ,REMARK ) " +
                              "VALUES (@STOCK_ID,@CREATOR,@CREATEDATE,@OCCUPY_QTY,@STATUS,@REMARK)",
                              new
            {
                STOCK_ID   = entity.StockID,
                CREATOR    = entity.Creator,
                CREATEDATE = entity.CreateDate,
                OCCUPY_QTY = entity.OccupyQty,
                STATUS     = entity.Status,
                REMARK     = entity.Remark
            });
            return(ret);
        }