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("占用失败。"); } }
/// <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); }