/// <summary> /// 插入已对照信息 /// </summary> /// <param name="compare">obj ICD对照实体</param> /// <returns>出现错误 返回 -1 成功 返回 1</returns> /// Creator: [email protected] 2005/05/30 public int InsertCompare(Neusoft.HISFC.Models.HealthRecord.ICDCompare compare) { try { //定义字符变量 ,存储SQL语句 string strSql = ""; //获得SQL语句 if (this.Sql.GetSql("Case.ICDDML.InsertCompare", ref strSql) == -1) { this.Err = "获取SQL语句失败"; return(-1); } //有效性 string isValid = ""; if (compare.IsValid) { isValid = "1"; } else { isValid = "0"; } //try //{ // //格式化SQL语句 // strSql = string.Format(strSql, compare.ICD9.ID, compare.ICD9.Name, compare.ICD10.ID, // compare.ICD10.Name, isValid, compare.OperInfo.ID, compare.ICD9.SpellCode, // compare.ICD9.UserCode, compare.ICD9.KeyCode); //} //catch (Exception ex) //{ // this.Err = "SQL语句赋值出错!" + ex.Message; // return -1; //} string[] str = new string[] { compare.ICD9.ID, compare.ICD9.Name, compare.ICD10.ID, compare.ICD10.Name, isValid, compare.OperInfo.ID, compare.ICD9.SpellCode, compare.ICD9.UserCode, compare.ICD9.KeyCode }; //执行插入操作 return(this.ExecNoQuery(strSql, str)); } catch (Exception ex) { this.Err = ex.Message; //捕获错误 return(-1); //返回错误 } }
/// <summary> /// 向对照表添加一行 /// </summary> /// <param name="obj">对照信息</param> /// <param name="row"></param> private void SetRowCompare(Neusoft.HISFC.Models.HealthRecord.ICDCompare obj, DataRow row) { row["诊断码9"] = obj.ICD9.ID; row["诊断名称9"] = obj.ICD9.Name; row["诊断码10"] = obj.ICD10.ID; row["诊断名称10"] = obj.ICD10.Name; row["拼音码"] = obj.ICD9.SpellCode; row["统计代码"] = obj.ICD9.UserCode; row["有效性"] = obj.IsValid; row["sequence_no"] = obj.ICD9.KeyCode; row["操作员编码"] = obj.OperInfo.ID; row["操作员"] = obj.OperInfo.Name; row["操作时间"] = obj.OperInfo.OperTime; }
/// <summary> /// 从Reader 中读取信息 存到 数组中 /// </summary> /// <returns>错误返回 null 成功返回 数组</returns> /// Creator: [email protected] 2005/05/30 private ArrayList QueryICDCompare(string strSql) { try { this.ExecQuery(strSql); //定义动态数组 ,存储查询出来的数据集 ArrayList arryCompare = new ArrayList(); //定义变量 ,存储数据 Neusoft.HISFC.Models.HealthRecord.ICDCompare compare = null; while (this.Reader.Read()) { compare = new Neusoft.HISFC.Models.HealthRecord.ICDCompare(); compare.ICD9.ID = Reader[0].ToString(); //ICD9编码 compare.ICD9.Name = Reader[1].ToString(); //ICD9名称 compare.ICD10.ID = Reader[2].ToString(); //ICD10编码 compare.ICD10.Name = Reader[3].ToString(); //ICD10名称 compare.OperInfo.ID = Reader[4].ToString(); //录入操作员工号 compare.OperInfo.Name = Reader[5].ToString(); //录入操作员姓名 compare.OperInfo.OperTime = NConvert.ToDateTime(Reader[6]); compare.IsValid = NConvert.ToBoolean(Reader[7].ToString()); //有效性 compare.ICD9.SpellCode = Reader[8].ToString(); //拼音 compare.ICD9.UserCode = Reader[9].ToString(); //自定义 compare.ICD9.KeyCode = Reader[10].ToString(); arryCompare.Add(compare); //添家到动态数组中 compare = null; //释放资源 } this.Reader.Close(); //关闭Reader return(arryCompare); } catch (Exception ex) { //出现错误 this.Err = ex.Message; if (!this.Reader.IsClosed) //如果没有释放 Reader { this.Reader.Close(); //关闭Reader } return(null); } }
/// <summary> /// 获取对照信息 /// </summary> /// <returns></returns> private Neusoft.HISFC.Models.HealthRecord.ICDCompare GetInfo() { //定义变量 Neusoft.HISFC.Models.HealthRecord.ICDCompare info = new Neusoft.HISFC.Models.HealthRecord.ICDCompare(); try { //ICD9 的编码 info.ICD9 = textBoxICD9.Tag as Neusoft.HISFC.Models.HealthRecord.ICD; info.ICD10 = textBoxICD10.Tag as Neusoft.HISFC.Models.HealthRecord.ICD; info.IsValid = true; //操作员 info.OperInfo.ID = myICD.Operator.ID; } catch (Exception e) { MessageBox.Show(e.Message); info = null; } return(info); }
/// <summary> /// ICD对照 /// </summary> private void CompareICD() { try { //数据验证失败 if (!ISValid()) { return; } icdCompare = GetInfo(); if (icdCompare == null) { return; } //定义事务 Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(myICD.Connection); ////开始事务 //t.BeginTransaction(); myICD.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); //执行插入操作 int iReturn = 0; //返回值 iReturn = myICD.InsertCompare(icdCompare); if (iReturn > 0) { //提交 Neusoft.FrameWork.Management.PublicTrans.Commit(); //显示刚刚增加的信息 this.tabControl1.SelectedIndex = 2; //获取操作时间 icdCompare.OperInfo.OperTime = myICD.GetDateTimeFromSysDateTime(); //操作员信息 icdCompare.OperInfo.ID = myICD.Operator.ID; icdCompare.OperInfo.Name = myICD.Operator.Name; //从ICD9 列表 中删除 对照完的行 DeleteICD9(icdCompare.ICD9); //从在界面上 增加对照信息。 AddICDCompare(); icdCompare = null; //准备下次输入 //清空数据 ClearICD(); MessageBox.Show("保存对照成功"); // //指定显示界面 // this.tabControl1.SelectedIndex = 1; // //指定光标位置 // textSearchICD9.Focus(); } else { //回退 Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(myICD.Err + " 保存对照失败"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }