/// <summary>
/// 插入随访安排记录
/// </summary>
public int Insert(Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange visitArrange)
{
string strSQL = this.GetStrSql("HealthReacord.Visit.VisitArrange.Insert");
try
{
string[] strParm = this.GetParam(visitArrange);
strSQL = string.Format(strSQL, strParm);
}
catch (Exception ex)
{
this.Err = "赋值时候出错！" + ex.Message;
return(-1);
}
// 执行SQL并返回
return(this.ExecNoQuery(strSQL));
}
/// <summary>
/// 根据实体获取sql参数
/// </summary>
/// <param name="visitArrange"></param>
/// <returns></returns>
private string[] GetParam(Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange visitArrange)
{
string[] strParm = new string[12];
strParm[0] = visitArrange.CardNO;
strParm[1] = visitArrange.PatientName;
strParm[2] = visitArrange.LastDate.ToString();
strParm[3] = visitArrange.VisitTimes.ToString();
strParm[4] = visitArrange.State;
strParm[5] = visitArrange.VisitOper.ID;
strParm[6] = visitArrange.VisitOper.OperTime.ToString();
strParm[7] = visitArrange.Oper.ID;
strParm[8] = visitArrange.Oper.OperTime.ToString();
strParm[9] = visitArrange.User01;
strParm[10] = visitArrange.User02;
strParm[11] = visitArrange.User03;
//返回数组
return(strParm);
}
/// <summary>
/// 根据查询得到随访安排泛型
/// </summary>
/// <param name="strSql"></param>
/// <param name="dtBegin"></param>
/// <param name="endTime"></param>
/// <returns></returns>
private List <Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange> GetVisitArrange(string strSql, params object[] args)
{
try
{
strSql = string.Format(strSql, args);
this.ExecQuery(strSql);
List <Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange> list = new List <Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange>();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange va = new Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange();
va.CardNO = this.Reader[0].ToString();
va.PatientName = this.Reader[1].ToString();
va.LastDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[2].ToString());
va.VisitTimes = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[3].ToString());
va.State = this.Reader[4].ToString();
va.VisitOper.ID = this.Reader[5].ToString();
va.VisitOper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString());
va.Oper.ID = this.Reader[7].ToString();
va.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[8].ToString());
va.User01 = this.Reader[9].ToString();
va.User02 = this.Reader[10].ToString();
va.User03 = this.Reader[11].ToString();
list.Add(va);
}
return(list);
}
catch (Exception ex)
{
this.Err = "执行sql语句失败！" + ex.Message;
return(null);
}
finally
{
this.Reader.Close();
}
}
