/// <summary>
/// 增加手术资料
/// </summary>
/// <param name="thisApparatus">手术资料对象</param>
/// <returns>0 success -1 fail</returns>
public int AddOpsApparatus(Neusoft.HISFC.Models.Operation.OpsApparatus thisApparatus)
{
string strSql = string.Empty;
string strStatus = Neusoft.FrameWork.Function.NConvert.ToInt32(thisApparatus.IsValid).ToString();
if (this.Sql.GetSql("Operator.OpsApparatus.AddOpsApparatus.1", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, thisApparatus.ID.ToString(), thisApparatus.Name, thisApparatus.UserCode, //3
thisApparatus.SpellCode, thisApparatus.TradeMark, thisApparatus.AppaSource, thisApparatus.AppaModel, //7
thisApparatus.BuyDate.ToString(), thisApparatus.Price.ToString(), thisApparatus.Unit, //10
strStatus, thisApparatus.Producer, thisApparatus.Saler, thisApparatus.Level, thisApparatus.Remark, //15
thisApparatus.User.ID.ToString());
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
if (this.ExecNoQuery(strSql) == -1)
{
return(-1);
}
return(0);
}
/// <summary>
/// 获取手术资料列表
/// </summary>
/// <returns>手术资料对象数组</returns>
public ArrayList GetOpsApparatus()
{
ArrayList OpsApparatusAl = new ArrayList();
string strSql = string.Empty;
if (this.Sql.GetSql("Operator.OpsApparatus.GetOpsApparatus.1", ref strSql) == -1)
{
// TODO: should return null
return(OpsApparatusAl);
}
this.ExecQuery(strSql);
try
{
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Operation.OpsApparatus thisApparatus = new Neusoft.HISFC.Models.Operation.OpsApparatus();
thisApparatus.ID = Reader[0].ToString(); //手术资料代码
thisApparatus.Name = Reader[1].ToString(); //手术资料名称
thisApparatus.UserCode = Reader[2].ToString(); //输入码
thisApparatus.SpellCode = Reader[3].ToString(); //拼音码
thisApparatus.TradeMark = Reader[4].ToString(); //品牌
thisApparatus.AppaSource = Reader[5].ToString(); //产地
thisApparatus.AppaModel = Reader[6].ToString(); //型号
thisApparatus.BuyDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[7].ToString()); //购入日期
thisApparatus.Price = System.Convert.ToDecimal(Reader[8].ToString()); //价格
thisApparatus.Unit = Reader[9].ToString(); //单位
string strStatus = Reader[10].ToString(); //1已用/0未用
thisApparatus.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(strStatus);
thisApparatus.Producer = Reader[11].ToString(); //生产厂家
thisApparatus.Saler = Reader[12].ToString(); //经销商
thisApparatus.Level = Reader[13].ToString(); //1贵重2普通
thisApparatus.Remark = Reader[14].ToString(); //备注
OpsApparatusAl.Add(thisApparatus);
}
}
catch (Exception ex)
{
this.Err = "获得手术资料信息出错！" + ex.Message;
this.ErrCode = "-1";
this.WriteErr();
this.Reader.Close();
return(OpsApparatusAl);
}
this.Reader.Close();
return(OpsApparatusAl);
}
