/// <summary> /// 获取科常用排班类别 /// </summary> /// <param name="deptID"></param> private void getDeptType(string deptID) { if (this.fpSpread2_Sheet1.RowCount > 0) { this.fpSpread2_Sheet1.Rows.Remove(0, this.fpSpread2_Sheet1.RowCount); } if (tabMgr == null) { tabMgr = new Neusoft.HISFC.BizProcess.Integrate.Registration.Tabulation(); } ArrayList types = tabMgr.Query(deptID); if (types != null) { foreach (Neusoft.HISFC.Models.Registration.WorkType obj in types) { this.fpSpread2_Sheet1.Rows.Add(this.fpSpread2_Sheet1.RowCount, 1); int row = this.fpSpread2_Sheet1.RowCount - 1; add(row, obj); } } }
/// <summary> /// 生成排班类别列表 /// </summary> private void initType() { if (this.fpSpread1_Sheet1.RowCount > 0) { this.fpSpread1_Sheet1.Rows.Remove(0, this.fpSpread1_Sheet1.RowCount); } if (tabMgr == null) { tabMgr = new Neusoft.HISFC.BizProcess.Integrate.Registration.Tabulation(); } al = tabMgr.Query(Neusoft.HISFC.BizLogic.Operation.QueryState.All); ds.Tables["items"].Rows.Clear(); if (al != null) { foreach (Neusoft.HISFC.Models.Registration.WorkType obj in al) { fpSpread1_Sheet1.Rows.Add(this.fpSpread1_Sheet1.RowCount, 1); int row = this.fpSpread1_Sheet1.RowCount - 1; addfp1(row, obj); ds.Tables["items"].Rows.Add(new object[] { obj.ID, obj.Name, obj.SpellCode }); } } }
/// <summary> /// 删除一行 /// </summary> /// <param name="row"></param> private void del(int row) { if (row < 0 || this.fpSpread2_Sheet1.RowCount == 0) { return; } if (this.fpSpread2_Sheet1.Tag == null || this.fpSpread2_Sheet1.Tag.ToString() == "") { return; } if (MessageBox.Show("是否删除该排班类型?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } //删除 Neusoft.HISFC.Models.Registration.WorkType obj = this.fpSpread2_Sheet1.Rows[row].Tag as Neusoft.HISFC.Models.Registration.WorkType; Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(this.deptManager.Connection); //t.BeginTransaction(); if (tabMgr == null) { tabMgr = new Neusoft.HISFC.BizProcess.Integrate.Registration.Tabulation(); } tabMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); try { if (tabMgr.Delete(this.fpSpread2_Sheet1.Tag.ToString(), obj.ID) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(tabMgr.Err, "提示"); return; } Neusoft.FrameWork.Management.PublicTrans.Commit(); } catch (Exception e) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(e.Message, "提示"); return; } this.fpSpread2_Sheet1.Rows.Remove(row, 1); MessageBox.Show("删除成功!", "提示"); }
protected override int OnSave(object sender, object neuObject) { if (this.fpSpread2_Sheet1.Tag == null || this.fpSpread2_Sheet1.Tag.ToString() == "") { MessageBox.Show("请先选择一个科室!", "提示"); return(-1); } Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(); //t.BeginTransaction(); try { if (this.tabMgr == null) { this.tabMgr = new Neusoft.HISFC.BizProcess.Integrate.Registration.Tabulation(); } tabMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); for (int i = 0; i < this.fpSpread2_Sheet1.RowCount; i++) { Neusoft.HISFC.Models.Registration.WorkType obj = (Neusoft.HISFC.Models.Registration.WorkType) this.fpSpread2_Sheet1.Rows[i].Tag; //先删除 if (tabMgr.Delete(this.fpSpread2_Sheet1.Tag.ToString(), obj.ID) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(tabMgr.Err, "提示"); return(-1); } if (tabMgr.Insert(this.fpSpread2_Sheet1.Tag.ToString(), obj) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(tabMgr.Err, "提示"); return(-1); } } Neusoft.FrameWork.Management.PublicTrans.Commit(); } catch (Exception e) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(e.Message, "提示"); return(-1); } MessageBox.Show("保存成功!", "提示"); return(base.OnSave(sender, neuObject)); }