/// <summary>
/// 获得项目信息
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
protected ArrayList myGetSNOPMED(string sql)
{
if (this.ExecQuery(sql) == -1)
{
return(null);
}
ArrayList al = new ArrayList();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.EPR.SNOMED item = new Neusoft.HISFC.Models.EPR.SNOMED();
item.ID = this.Reader[0].ToString();
item.Name = this.Reader[1].ToString();
item.SNOPCode = this.Reader[2].ToString();
item.EnglishName = this.Reader[3].ToString();
item.DiagnoseCode = this.Reader[4].ToString();
item.ParentCode = this.Reader[5].ToString();
item.Memo = this.Reader[6].ToString();
item.SpellCode = this.Reader[7].ToString();
item.WBCode = this.Reader[8].ToString();
item.UserCode = this.Reader[9].ToString();
item.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[10]);
try
{
item.User01 = this.Reader[11].ToString(); //isleaf
}
catch { }
al.Add(item);
}
this.Reader.Close();
return(al);
}
/// <summary>
/// 插入一条SNOPMED记录
/// <param name="s">snomed</param>
/// </summary>
/// <returns></returns>
public int InsertSNOMED(Neusoft.HISFC.Models.EPR.SNOMED s)
{
string strSQL = "";
//取SQL语句
if (this.Sql.GetSql("EPR.SNOMED.Insert", ref strSQL) == -1)
{
this.Err = "没有找到EPR.SNOMED.Delet.1字段!";
return(-1);
}
try
{
strSQL = string.Format(strSQL, s.ParentCode, s.ID, s.SNOPCode, s.Name, s.EnglishName, s.SpellCode, s.WBCode, s.DiagnoseCode, s.Memo, s.UserCode, s.SortID);
}
catch { return(-1); }
return(this.ExecNoQuery(strSQL));
}
/// <summary>
/// 更新单个项目列表的父级编码
/// <param name="code">编码</param>
/// </summary>
/// <returns></returns>
public int UpdateSNOPMEDParentCode(Neusoft.HISFC.Models.EPR.SNOMED s)
{
string strSQL = "";
//取SQL语句
if (this.Sql.GetSql("EPR.SNOMED.Update.2", ref strSQL) == -1)
{
this.Err = "没有找到EPR.SNOMED.Update.2字段!";
return(-1);
}
try
{
strSQL = string.Format(strSQL, s.ParentCode);
}
catch { return(-1); }
return(this.ExecNoQuery(strSQL));
}
protected override int OnSave(object sender, object neuObject)
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("正在保存....");
Application.DoEvents();
Neusoft.HISFC.BizProcess.Factory.Function.BeginTransaction();
bool save = true;
bool insert = false;
bool del = false;
bool update = false;
string strinsert = "";
string strupdate = "";
//遍历RowState为Added的所有行
foreach (DataRow dr in ds.Tables["cnp_com_snopmed"].Select("", "", DataViewRowState.Added))
{
Neusoft.HISFC.Models.EPR.SNOMED snomedObject = new Neusoft.HISFC.Models.EPR.SNOMED();
snomedObject.ID = dr["ID"].ToString();
snomedObject.Name = dr["NAME"].ToString();
snomedObject.SNOPCode = dr["SNOPCODE"].ToString();
snomedObject.EnglishName = dr["ENGLISHNAME"].ToString();
snomedObject.DiagnoseCode = dr["DIAGNOSECODE"].ToString();
snomedObject.ParentCode = dr["PARENTCODE"].ToString();
snomedObject.Memo = dr["MEMO"].ToString();
snomedObject.SpellCode = dr["SPELLCODE"].ToString();
snomedObject.WBCode = dr["WBCODE"].ToString();
snomedObject.UserCode = dr["USERCODE"].ToString();
snomedObject.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(dr["SORTID"].ToString());
//调用业务层添加方法
if (Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.InsertSNOMED(snomedObject) == -1)
{
Neusoft.HISFC.BizProcess.Factory.Function.RollBack();
strinsert = dr["id"].ToString();
strinsert = strinsert + "\n";
insert = true;
save = false;
}
}
if (insert)
{
MessageBox.Show("添加失败！\n" + strinsert);
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(-1);
}
//遍历RowState为Deleted的所有行
foreach (DataRow dr in ds.Tables["cnp_com_snopmed"].Select("", "", DataViewRowState.Deleted))
{
string id = dr[0, DataRowVersion.Original].ToString();
//调用业务层删除方法
if (Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.DelSNOPMEDByCode(id) == -1)
{
Neusoft.HISFC.BizProcess.Factory.Function.RollBack();
del = true;
save = false;
}
}
if (del)
{
MessageBox.Show("删除失败！");
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(-1);
}
//遍历RowState为Modified的所有行
foreach (DataRow dr in ds.Tables["cnp_com_snopmed"].Select("", "", DataViewRowState.ModifiedCurrent))
{
Neusoft.HISFC.Models.EPR.SNOMED snomedObject = new Neusoft.HISFC.Models.EPR.SNOMED();
snomedObject.ID = dr["ID"].ToString();
snomedObject.Name = dr["NAME"].ToString();
snomedObject.SNOPCode = dr["SNOPCODE"].ToString();
snomedObject.EnglishName = dr["ENGLISHNAME"].ToString();
snomedObject.DiagnoseCode = dr["DIAGNOSECODE"].ToString();
snomedObject.ParentCode = dr["PARENTCODE"].ToString();
snomedObject.Memo = dr["MEMO"].ToString();
snomedObject.SpellCode = dr["SPELLCODE"].ToString();
snomedObject.WBCode = dr["WBCODE"].ToString();
snomedObject.UserCode = dr["USERCODE"].ToString();
snomedObject.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(dr["SORTID"].ToString());
//调用业务层修改方法
if (Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.UpdateSNOMED(snomedObject) == -1)
{
Neusoft.HISFC.BizProcess.Factory.Function.RollBack();
strupdate = dr["id"].ToString();
strupdate = strupdate + "\n";
update = true;
save = false;
}
}
if (update)
{
MessageBox.Show("修改失败\n" + strupdate);
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
return(-1);
}
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
if (save)
{
ds.Tables["cnp_com_snopmed"].AcceptChanges();
Neusoft.HISFC.BizProcess.Factory.Function.Commit();
MessageBox.Show("保存成功！");
return(0);
}
else
{
return(-1);
}
}
public int InsertSNOMED(Neusoft.HISFC.Models.EPR.SNOMED s)
{
Neusoft.HISFC.BizLogic.EPR.SNOMED manager = new Neusoft.HISFC.BizLogic.EPR.SNOMED();
this.SetDB(manager);
return(manager.InsertSNOMED(s));
}
public int UpdateSNOPMEDParentCode(Neusoft.HISFC.Models.EPR.SNOMED s)
{
Neusoft.HISFC.BizLogic.EPR.SNOMED manager = new Neusoft.HISFC.BizLogic.EPR.SNOMED();
this.SetDB(manager);
return(manager.UpdateSNOPMEDParentCode(s));
}
