/// <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("保存成功"));
}
