private void btnOK_Click(object sender, EventArgs e) { var items = gcItem.GetDataSource<t_instockitem>(); if (items == null || items.Count < 1) { MsgBox.ShowMessage("", "没有商品信息,不能保存!"); return; } if (items.Any(K => string.IsNullOrEmpty(K.ItemNo))) { MsgBox.ShowMessage("", "商品信息不完整!"); return; } if (EditMode == Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { try { db.BeginTransaction(); db.Execute("delete t_instockitem where instockno=@0", InStockNo); InStock.Remark = txtRemark.Text; InStock.Num = items.Sum(k => k.Num); InStock.OuterNo = txtOuterNo.Text; db.Save(InStock); items.ForEach(k => { k.Id = 0; db.Save(k); }); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } else { InStock = new t_instock(); InStock.Remark = txtRemark.Text; InStock.Guid = GuidKey; InStock.InStockNo = InStockNo; InStock.OuterNo = txtOuterNo.Text; InStock.Creator = this.CurUser; InStock.AuditDate = InStock.CreateDate = TimeSync.Default.CurrentSyncTime; InStock.Num = items.Sum(k => k.Num); using (var db = new Database()) { try { db.BeginTransaction(); db.Save(InStock); items.ForEach(k => db.Save(k)); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } DialogResult = DialogResult.OK; Close(); }
private void btnOK_Click(object sender, EventArgs e) { var items = gcItem.GetDataSource <t_instockitem>(); if (items == null || items.Count < 1) { MsgBox.ShowMessage("", "没有商品信息,不能保存!"); return; } if (items.Any(K => string.IsNullOrEmpty(K.ItemNo))) { MsgBox.ShowMessage("", "商品信息不完整!"); return; } if (EditMode == Web.Core.Enums.EnViewEditMode.Edit) { using (var db = new Database()) { try { db.BeginTransaction(); db.Execute("delete t_instockitem where instockno=@0", InStockNo); InStock.Remark = txtRemark.Text; InStock.Num = items.Sum(k => k.Num); InStock.OuterNo = txtOuterNo.Text; db.Save(InStock); items.ForEach(k => { k.Id = 0; db.Save(k); }); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } else { InStock = new t_instock(); InStock.Remark = txtRemark.Text; InStock.Guid = GuidKey; InStock.InStockNo = InStockNo; InStock.OuterNo = txtOuterNo.Text; InStock.Creator = this.CurUser; InStock.AuditDate = InStock.CreateDate = TimeSync.Default.CurrentSyncTime; InStock.Num = items.Sum(k => k.Num); using (var db = new Database()) { try { db.BeginTransaction(); db.Save(InStock); items.ForEach(k => db.Save(k)); db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); throw; } } } DialogResult = DialogResult.OK; Close(); }