/// <summary>
/// 删除记录
/// </summary>
private void DeleteTerminal( )
{
if (this.neuSpread1.ActiveSheet.Rows.Count <= 0)
{
return;
}
DialogResult result = MessageBox.Show(Language.Msg("确实要删除该数据吗？"), "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.No)
{
return;
}
//定义数据库事务
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Transaction t = new Transaction( Connection.Instance );
//t.BeginTransaction( );
this.drugStore.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
try
{
int i = this.neuSpread1.ActiveSheet.ActiveRowIndex;
if (i < 0)
{
return;
}
//已经保存的数据、从数据库删除
if (this.neuSpread1.ActiveSheet.Cells[i, 7].Text == "0")
{
Neusoft.HISFC.Models.Pharmacy.DrugSPETerminal info = this.neuSpread1.ActiveSheet.Rows[i].Tag as Neusoft.HISFC.Models.Pharmacy.DrugSPETerminal;
if (info == null)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(Language.Msg("删除特殊终端信息时发生类型转换错误!"));
return;
}
//删除数据
if (this.drugStore.DeleteDrugSPETerminal(info) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.drugStore.Err);
return;
}
}
//从sheet中移除
this.neuSpread1.ActiveSheet.Rows.Remove(i, 1);
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show(Language.Msg("删除成功"));
}
catch (Exception ex)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(ex.Message);
return;
}
}
/// <summary>
/// 添加记录
/// </summary>
private void AddTerminal( )
{
//判断是否有权限操作
if (!this.isPrivilegeEdit)
{
return;
}
if (this.currDrugTerminal == null)
{
return;
}
//定义特殊终端实体
Neusoft.HISFC.Models.Pharmacy.DrugSPETerminal info = new Neusoft.HISFC.Models.Pharmacy.DrugSPETerminal( );
info.Terminal = this.currDrugTerminal;
try
{
int rowCount = this.neuSpread1.ActiveSheet.Rows.Count;
//添加一行
this.neuSpread1.ActiveSheet.Rows.Add(rowCount, 1);
//终端名称
this.neuSpread1.ActiveSheet.Cells[rowCount, 0].Value = this.currDrugTerminal.Name;
//终端ID
this.neuSpread1.ActiveSheet.Cells[rowCount, 5].Value = this.currDrugTerminal.ID;
//操作员
this.neuSpread1.ActiveSheet.Cells[rowCount, 3].Value = this.drugStore.Operator.Name;
//操作时间
this.neuSpread1.ActiveSheet.Cells[rowCount, 4].Value = this.drugStore.GetDateTimeFromSysDateTime();
//实体
this.neuSpread1.ActiveSheet.Rows[rowCount].Tag = info;
//新增标志
this.neuSpread1.ActiveSheet.Cells[rowCount, 7].Text = "1";
}
catch
{
MessageBox.Show(this.neuSpread1.ActiveSheet.Rows.Count.ToString());
}
}
