/// <summary> /// 将查询结果添加到列表显示 /// </summary> /// <param name="checkLogs">盘点日志集合</param> private void FillToFp(ArrayList checkLogs) { Hashtable hsTemp = new Hashtable(); for (int i = 0; i < checkLogs.Count; i++) { Neusoft.HISFC.Models.Pharmacy.Check checkObj = new Neusoft.HISFC.Models.Pharmacy.Check(); checkObj = checkLogs[i] as Neusoft.HISFC.Models.Pharmacy.Check; this.fpCheckLogs.RowCount = i + 1; this.fpCheckLogs.Cells[i, 0].Text = checkObj.CheckNO; this.fpCheckLogs.Cells[i, 1].Text = checkObj.FOper.Dept.ID;//已经转换成名称 this.fpCheckLogs.Cells[i, 2].Text = checkObj.Item.Name; this.fpCheckLogs.Cells[i, 3].Text = checkObj.BatchNO; this.fpCheckLogs.Cells[i, 4].Text = checkObj.Item.Specs; this.fpCheckLogs.Cells[i, 5].Text = checkObj.Item.PriceCollection.RetailPrice.ToString(); this.fpCheckLogs.Cells[i, 6].Text = checkObj.Item.PackUnit; this.fpCheckLogs.Cells[i, 7].Text = checkObj.Item.PackQty.ToString(); this.fpCheckLogs.Cells[i, 8].Text = checkObj.AdjustQty.ToString(); this.fpCheckLogs.Cells[i, 9].Text = checkObj.Item.MinUnit; this.fpCheckLogs.Cells[i, 10].Text = checkObj.PlaceNO; this.fpCheckLogs.Cells[i, 11].Text = checkObj.Operation.Oper.OperTime.ToString(); this.fpCheckLogs.Cells[i, 12].Text = checkObj.Operation.Oper.Name; if (!hsTemp.ContainsKey(checkObj.Operation.Oper.ID)) { hsTemp.Add(checkObj.Operation.Oper.ID, checkObj.Operation.Oper.Name); } } this.lbOperCount.Text = "操作员数:" + hsTemp.Count.ToString(); this.lbRecordCount.Text = "盘点记录数:" + this.fpCheckLogs.RowCount.ToString(); }
/// <summary> /// 数据插入 /// </summary> /// <param name="item">盘点附加实体</param> public int AddDataToTable(Neusoft.HISFC.Models.Pharmacy.Check check) { try { this.dt.Rows.Add(new object[] { false, // 加入盘点 check.Item.ID, // 药品编码 check.Item.NameCollection.UserCode, // 自定义码 check.Item.Name, // 药品名称 check.Item.Specs, // 规格 check.PlaceNO, // 库位号 check.BatchNO, // 批号 check.Item.NameCollection.SpellCode, // 拼音码 check.Item.NameCollection.WBCode, // 五笔码 check.Item.NameCollection.RegularSpell.SpellCode, // 通用名拼音码 check.Item.NameCollection.RegularSpell.WBCode // 通用名五笔码 } ); } catch (Exception ex) { MessageBox.Show(Language.Msg(ex.Message)); return(-1); } return(1); }
protected override void OnAfterLabelEdit(System.Windows.Forms.NodeLabelEditEventArgs e) { if (e.Label != null) { if (e.Label.Length > 0) { if (e.Label.IndexOfAny(new char[] { '@', '.', ',', '!' }) == -1) { e.Node.EndEdit(false); } else { e.CancelEdit = true; System.Windows.Forms.MessageBox.Show(Language.Msg("存在无效字符!请重新命名")); e.Node.BeginEdit(); } } else { e.CancelEdit = true; System.Windows.Forms.MessageBox.Show(Language.Msg("模板名称不能为空")); e.Node.BeginEdit(); } Neusoft.HISFC.Models.Pharmacy.Check check = e.Node.Tag as Neusoft.HISFC.Models.Pharmacy.Check; Neusoft.HISFC.BizLogic.Pharmacy.Item itemManager = new Neusoft.HISFC.BizLogic.Pharmacy.Item(); check.CheckName = e.Label; if (check.CheckNO != "") { if (itemManager.UpdateCheckListName(this.privDept.ID, check.CheckNO, e.Label) == -1) { System.Windows.Forms.MessageBox.Show(Language.Msg("更新盘点统计信息中盘点单名称出错")); return; } } } base.OnAfterLabelEdit(e); }
private void ucDrugList1_ChooseDataEvent(FarPoint.Win.Spread.SheetView sv, int activeRow) { if (activeRow < 0) { return; } Neusoft.HISFC.Models.Pharmacy.Item item = this.itemManager.GetItem(sv.Cells[activeRow, 0].Text); Neusoft.HISFC.Models.Pharmacy.Check check = new Neusoft.HISFC.Models.Pharmacy.Check(); check.Item = item; check.PlaceNO = sv.Cells[activeRow, 4].Text; //货位号 check.BatchNO = sv.Cells[activeRow, 3].Text; //批号 if (this.AddDataToTable(check) == 1) { this.SetFocus(true); } else { this.SetFocus(false); } }
/// <summary> /// 对于选中的药品返回ArrayList加入盘点单 /// </summary> /// <returns>成功选择返回1 否则返回-1</returns> public int SaveChoose() { for (int i = 0; i < this.dt.DefaultView.Count; i++) { this.dt.DefaultView[i].EndEdit(); } string filter = "加入盘点 = true"; this.dt.DefaultView.RowFilter = filter; if (MessageBox.Show(Language.Msg("确定要增加您选中的“" + this.neuSpread1_Sheet1.Rows.Count.ToString() + "”条药品吗?"), "确认加入盘点", MessageBoxButtons.YesNo) == DialogResult.No) { filter = "1=1"; this.dt.DefaultView.RowFilter = filter; return(-1); } Neusoft.HISFC.Models.Pharmacy.Check info; this.chooseData = new List <Neusoft.HISFC.Models.Pharmacy.Check>(); for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++) { info = new Neusoft.HISFC.Models.Pharmacy.Check(); info.PlaceNO = this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColPlaceCode].Text; //库位号 info.Item.ID = this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColDrugNO].Text; //药品编码 info.BatchNO = this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColBatchNO].Text; //批号 info.IsAdd = true; //是否附加 1 附加药品 this.chooseData.Add(info); } return(1); }
/// <summary> /// 对盘点附加信息保存 /// </summary> /// <param name="deptNO"></param> public void Save(string deptNO) { if (!this.IsValid()) { return; } this.txtFilter.Text = ""; this.dt.DefaultView.RowFilter = "1=1"; for (int i = 0; i < this.dt.DefaultView.Count; i++) { this.dt.DefaultView[i].EndEdit(); } //定义事务 Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); //t.BeginTransaction(); this.itemManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); DateTime sysTime = this.itemManager.GetDateTimeFromSysDateTime(); Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("正在进行保存.请稍候..."); Application.DoEvents(); if (this.itemManager.DeleteCheckAdd(deptNO) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(Language.Msg("保存前删除原附加信息发生错误" + this.itemManager.Err)); return; } for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++) { Neusoft.HISFC.Models.Pharmacy.Check info = new Neusoft.HISFC.Models.Pharmacy.Check(); info.Item.ID = this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColDrugNO].Text; //药品编码 info.StockDept = this.privDept; //库房科室 info.PlaceNO = this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColPlaceCode].Text; //货位号 info.BatchNO = this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColBatchNO].Text; //批号 info.Operation.Oper.ID = this.itemManager.Operator.ID; info.Operation.Oper.OperTime = sysTime; //操作信息 if (this.itemManager.InsertCheckAdd(info) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); if (this.itemManager.DBErrCode == 1) { Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(Language.Msg("数据已存在,不能重复维护!\n" + "药品名称:" + this.neuSpread1_Sheet1.Cells[i, (int)ColumnSet.ColTradeName].Text + " 库位号:" + info.PlaceNO)); return; } else { Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(Language.Msg(this.itemManager.Err)); return; } } } Neusoft.FrameWork.Management.PublicTrans.Commit(); Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(Language.Msg("保存成功")); }