/// <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();
}
}