/// <summary> /// 向交班记录中添加数据,最重要是添加表中的标题,用于添加病人里面的确认按钮后,添加数据 /// </summary> /// <param name="handoverRecord"></param> /// <returns></returns> public int AddHandoverRecordTitle(HandoverRecord handoverRecord) { string sql = @"insert into PUB_交班记录(ID, 标题, 记录时间, 预留字段, 病区ID, 病人ID, 记录人, 是否作废) values(record_id_seq.nextval, :Title, sysdate+1/3, '1', :WardID, :PatientId, :RecordUser, 0) "; OracleParameter[] prms = new OracleParameter[] { new OracleParameter("Title", OracleDbType.Varchar2, 4000) { Value = handoverRecord.title }, new OracleParameter("WardID", OracleDbType.Varchar2, 36) { Value = handoverRecord.wardId }, new OracleParameter("PatientId", OracleDbType.Varchar2, 36) { Value = handoverRecord.patientId }, new OracleParameter("RecordUser", OracleDbType.Varchar2, 20) { Value = handoverRecord.recordUser } }; return(OracleHelper.ExecuteNonQuery(sql, CommandType.Text, prms)); }
/// <summary> /// 向交班记录中添加数据,主要是对每个班次病人情况的详细说明,主要是添加内容 /// </summary> /// <returns></returns> public int AddHandoverRecordContent(HandoverRecord handoverRecord) { string sql = @"insert into PUB_交班记录 (ID,内容,记录时间, 预留字段, 病区ID, 病人ID, 记录人, 是否作废) values(record_id_seq.nextval, :Content, to_date(:RecordTime, 'yyyy-mm-dd hh24:mi:ss'), '1', :WardID, :PatientId, :RecordUser, 0)"; OracleParameter[] prms = new OracleParameter[] { new OracleParameter("Content", OracleDbType.Varchar2, 4000) { Value = handoverRecord.content }, new OracleParameter("RecordTime", OracleDbType.Varchar2, 32) { Value = handoverRecord.recordTime }, new OracleParameter("WardID", OracleDbType.Varchar2, 36) { Value = handoverRecord.wardId }, new OracleParameter("PatientId", OracleDbType.Varchar2, 36) { Value = handoverRecord.patientId }, new OracleParameter("RecordUser", OracleDbType.Varchar2, 20) { Value = handoverRecord.recordUser } }; return(OracleHelper.ExecuteNonQuery(sql, CommandType.Text, prms)); }