/// <summary> /// 保存数据 /// </summary> public int Save() { this.fpStorage.StopCellEditing(); //有效性判断 if (Valid()) { return(-1); } ; //定义数据库处理事务 Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); //t.BeginTransaction(); basesetManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); Neusoft.HISFC.Models.Material.MaterialStorage storage = null; foreach (DataRow row in this.dt.Rows) { storage = new Neusoft.HISFC.Models.Material.MaterialStorage(); storage.ID = row["仓库编码"].ToString(); //0编码 storage.Name = row["仓库名称"].ToString(); //1仓库名称 storage.SpellCode = row["拼音码"].ToString(); //2拼音码 storage.WBCode = row["五笔码"].ToString(); //3五笔码 storage.OutStartNO = Neusoft.FrameWork.Function.NConvert.ToInt32(row["出库单起始号"]); //4出库单起始号 storage.InStartNO = Neusoft.FrameWork.Function.NConvert.ToInt32(row["入库单起始号"]); //5入库单起始号 storage.PlanStartNO = Neusoft.FrameWork.Function.NConvert.ToInt32(row["申请单起始号"]); //6申请单起始号 storage.IsWithFix = Neusoft.FrameWork.Function.NConvert.ToBoolean(row["有无固定资产"].ToString()); //7有无固定资产 storage.IsStorage = Neusoft.FrameWork.Function.NConvert.ToBoolean(row["是否是仓库"].ToString()); //8是否是仓库 storage.IsStoreManage = Neusoft.FrameWork.Function.NConvert.ToBoolean(row["是否管理库存"].ToString()); //9是否管理库存 storage.IsBatchManage = Neusoft.FrameWork.Function.NConvert.ToBoolean(row["是否管理批次"].ToString()); //10是否管理批次 storage.MaxDays = Neusoft.FrameWork.Function.NConvert.ToInt32(row["库存上限天数"]); storage.MinDays = Neusoft.FrameWork.Function.NConvert.ToInt32(row["库存下限天数"]); storage.ReferenceDays = Neusoft.FrameWork.Function.NConvert.ToInt32(row["库存参考天数"]); storage.Oper.ID = row["操作员"].ToString(); storage.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(row["操作日期"].ToString()); //首先执行更新操作,如果没有成功则插入新数据 if (this.basesetManager.SetStorage(storage) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(this.basesetManager.Err); return(0); } } Neusoft.FrameWork.Management.PublicTrans.Commit(); //刷新数据 this.ShowData(); MessageBox.Show("保存成功!"); return(1); }
/// <summary> /// 删除记录 /// </summary> public void DeleteData() { string kindID = ""; //{9E7FB328-89B3-4f43-A417-2EC3ACFC7093} //如果选择的是fp里面的东西,则可以删除明细信息 if (this.neuSpread1_Sheet1.ActiveRow != null) { kindID = this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 1].Value.ToString(); } else { kindID = this.ucMaterialKindTree1.NodeTag; } int kindRowCount = this.basesetManager.GetKindRowCount(kindID); ArrayList alKind = this.basesetManager.GetMetKindByPreID(kindID); if (kindRowCount > 0) { MessageBox.Show("此科目下存在物品字典信息,请先删除字典信息再执行此操作!", "删除提示"); return; } if (kindRowCount < 0) { MessageBox.Show("获取该科目下项目字典总条数出错"); return; } if (alKind.Count > 0) { MessageBox.Show("该科目下存在下级科目信息,请先删除下级科目信息再执行此操作!", "删除提示"); return; } //{9E7FB328-89B3-4f43-A417-2EC3ACFC7093} //如果是新加的,则不提示,直接删除行 ArrayList al = this.basesetManager.GetMetKindByMetID(kindID); if (al == null) { MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("获取物资信息出错!")); return; } if (al.Count == 0 && this.neuSpread1_Sheet1.ActiveRow != null) { this.neuSpread1_Sheet1.Rows.Remove(this.neuSpread1_Sheet1.ActiveRowIndex, 1); } else { System.Windows.Forms.DialogResult dr; dr = MessageBox.Show("确定要删除科目“" + (this.neuSpread1_Sheet1.ActiveRow == null?this.ucMaterialKindTree1.NodeName:this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, 3].Text) + "”吗?", "提示!", System.Windows.Forms.MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dr == DialogResult.No) { return; } Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); //t.BeginTransaction(); basesetManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); if (this.basesetManager.DeleteMetKind(kindID) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(this.basesetManager.Err); return; } Neusoft.FrameWork.Management.PublicTrans.Commit(); //this.neuSpread1_Sheet1.Rows.Remove(this.neuSpread1_Sheet1.ActiveRowIndex, 1); this.ShowData(); MessageBox.Show("删除成功!"); this.ucMaterialKindTree1.InitTreeView(); } }