protected void Grid_ArtifactDetail_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { try { session.BeginTransaction(); e.Cancel = true; string rowstatus = Utility.Constant.ROWSTATUS_ACTIVE.ToString(); LegalInvoiceArtifactDetail detail = session.FindObject <LegalInvoiceArtifactDetail>( CriteriaOperator.And( new BinaryOperator("LegalInvoiceArtifactId", LegalInvoiceArtifactId, BinaryOperatorType.Equal), new BinaryOperator("ItemId", e.NewValues["ItemId"].ToString(), BinaryOperatorType.Equal), new BinaryOperator("UnitId", e.NewValues["UnitId"].ToString(), BinaryOperatorType.Equal), new BinaryOperator("RowStatus", rowstatus, BinaryOperatorType.Equal) )); Item itemid = BO.get_ItemId(session, e.NewValues["ItemId"].ToString(), rowstatus); NAS.DAL.Nomenclature.Item.Unit unitid = BO.get_UnitId(session, e.NewValues["UnitId"].ToString(), rowstatus); //detail.ItemId = itemid; detail.Price = int.Parse(e.NewValues["Price"].ToString()); detail.Amount = int.Parse(e.NewValues["Amount"].ToString()); //detail.UnitId = unitid; detail.Total = int.Parse(e.NewValues["Total"].ToString()); session.FlushChanges(); session.CommitTransaction(); Grid_ArtifactDetail.CancelEdit(); } catch (Exception) { session.RollbackTransaction(); throw; } }
protected void Grid_ArtifactDetail_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { session.BeginTransaction(); e.Cancel = true; string rowstatus = Utility.Constant.ROWSTATUS_ACTIVE.ToString(); NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifact legalInvoiceArtifactId = BO.get_LegalInvoiceArtifactId(session, LegalInvoiceArtifactId, rowstatus); LegalInvoiceArtifactDetail detail = new LegalInvoiceArtifactDetail(session); Item itemid = BO.get_ItemId(session, itemId, rowstatus); NAS.DAL.Nomenclature.Item.Unit unitid = BO.get_UnitId(session, unitID, rowstatus); //detail.ItemId = itemid; detail.Price = int.Parse(e.NewValues["Price"].ToString()); detail.Amount = int.Parse(e.NewValues["Amount"].ToString()); //detail.UnitId = unitid; detail.Total = int.Parse(e.NewValues["Total"].ToString()); detail.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE; detail.LegalInvoiceArtifactId = legalInvoiceArtifactId; session.FlushChanges(); session.CommitTransaction(); Grid_ArtifactDetail.CancelEdit(); } catch (Exception) { session.RollbackTransaction(); throw; } }
public LegalInvoiceArtifactDetail get_LegalInvoiceArtifactDetailId(Session session, Guid Id, string RowStatus) { try { LegalInvoiceArtifactDetail detail = session.FindObject <LegalInvoiceArtifactDetail>( CriteriaOperator.And( new BinaryOperator("LegalInvoiceArtifactId", Id, BinaryOperatorType.Equal), new BinaryOperator("RowStatus", RowStatus, BinaryOperatorType.Equal) )); if (detail == null) { return(null); } return(detail); } catch (Exception) { throw; } }
protected void Grid_ArtifactDetail_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { session.BeginTransaction(); string rowstatus = Utility.Constant.ROWSTATUS_ACTIVE.ToString(); LegalInvoiceArtifactDetail detail = BO.get_LegalInvoiceArtifactDetailId(session, LegalInvoiceArtifactId, rowstatus); if (detail == null) { throw new Exception("LegalInvoiceArtifactDetail is not exist system"); } detail.RowStatus = Utility.Constant.ROWSTATUS_DELETED; session.FlushChanges(); session.CommitTransaction(); } catch (Exception) { session.RollbackTransaction(); throw; } }