/// <summary>
/// 向肿瘤明细表中插入一条数据
/// </summary>
/// <param name="info"></param>
/// <returns>出现异常返回－1 成功返回1 插入失败返回 0</returns>
public int InsertTumourDetail(Neusoft.HISFC.Models.HealthRecord.TumourDetail info)
{
string strSql = "";
if (this.Sql.GetSql("Case.Tumour.InsertTumourDetail", ref strSql) == -1)
{
return(-1);
}
try
{
info.OperInfo.ID = this.Operator.ID;
//获取索引值
info.HappenNO = Neusoft.FrameWork.Function.NConvert.ToInt32(this.GetSequence("Case.Tumour.GetSequence"));
object[] mm = GetInfo(info);
if (mm == null)
{
this.Err = "业务层从实体中获取字符数组出错";
return(-1);
}
strSql = string.Format(strSql, mm);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 更新肿瘤明细表中得数据
/// </summary>
/// <param name="info"></param>
/// <returns>出现异常返回－1 成功返回1更新失败返回 0 </returns>
public int UpdateTumourDetail(Neusoft.HISFC.Models.HealthRecord.TumourDetail info)
{
string strSql = "";
if (this.Sql.GetSql("Case.Tumour.UpdateTumourDetail", ref strSql) == -1)
{
return(-1);
}
try
{
info.OperInfo.ID = this.Operator.ID;
object[] mm = GetInfo(info);
if (mm == null)
{
this.Err = "业务层从实体中获取字符数组出错";
return(-1);
}
strSql = string.Format(strSql, mm);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
public ArrayList GetTumourDetail(string inpatienNo)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Case.Tumour.GetTumourDetail", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, inpatienNo);
//查询
this.ExecQuery(strSql);
Neusoft.HISFC.Models.HealthRecord.TumourDetail info = null;
List = new ArrayList();
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.HealthRecord.TumourDetail();
info.InpatientNO = Reader[0].ToString();
info.HappenNO = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[1].ToString());
info.CureDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[2].ToString());
info.DrugInfo.ID = Reader[3].ToString();
info.DrugInfo.Name = Reader[4].ToString();
info.Qty = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[5].ToString());
info.Unit = Reader[6].ToString();
info.Period = Reader[7].ToString();
info.Result = Reader[8].ToString();
info.OperInfo.ID = Reader[9].ToString();
List.Add(info);
info = null;
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
if (!this.Reader.IsClosed)
{
this.Reader.Close();
}
List = null;
}
return(List);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteTumourDetail(Neusoft.HISFC.Models.HealthRecord.TumourDetail info)
{
string strSql = "";
if (this.Sql.GetSql("Case.Tumour.DeleteTumourDetail", ref strSql) == -1)
{
return(-1);
}
try
{
//格式化字符串
strSql = string.Format(strSql, info.InpatientNO, info.HappenNO);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
private object[] GetInfo(Neusoft.HISFC.Models.HealthRecord.TumourDetail info)
{
try
{
object[] s = new object[10];
s[0] = info.InpatientNO; //住院流水号
s[1] = info.HappenNO; //发生序号
s[2] = info.CureDate.ToString(); //治疗日期
s[3] = info.DrugInfo.ID; //药物代码
s[4] = info.DrugInfo.Name; //药物名称
s[5] = info.Qty.ToString(); //剂量
s[6] = info.Unit; //单位
s[7] = info.Period; //疗程
s[8] = info.Result; // 疗效
s[9] = info.OperInfo.ID; // 操作员代号
return(s);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(null);
}
}
