/// <summary>
/// 向随访明细表中插入一条新记录
/// </summary>
/// <returns>影响的行数、-1 失败</returns>
public int Insert(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord, string sequ)
{
string strSQL = "";
//读取SQL语句
if (this.Sql.GetSql("HealthReacord.Visit.VisitRecord.Insert", ref strSQL) == -1)
{
this.Err = "没有找到HealthReacord.Visit.VisitRecord.Insert字段!";
return(-1);
}
try
{
//获取随访明细流水号
visitRecord.ID = sequ;
//获取传递参数数组
string[] strParm = this.GetVisitRecordParmItem(visitRecord);
strSQL = string.Format(strSQL, strParm);
}
catch (Exception ex)
{
this.Err = "赋值时候出错!" + ex.Message;
return(-1);
}
//执行SQL语句并返回
return(this.ExecNoQuery(strSQL));
}
/// <summary>
/// 删除随访记录明细
/// </summary>
/// <returns>成功返回 0;失败返回 -1</returns>
private int DeleteRecord()
{
if (MessageBox.Show("是否作废选择的历史随访信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)
== DialogResult.Yes)
{
visitRecordManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
for (int i = 0; i < fpVisitRecord_Sheet1.Rows.Count; i++)
{
if (this.fpVisitRecord_Sheet1.Cells[i, 0].Text == true.ToString())
{
Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord
= fpVisitRecord_Sheet1.Rows[i].Tag
as Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord;//Tag中的对象
if (visitRecord != null)
{
if (visitRecordManager.DelVisitRecord(visitRecord.ID) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
//t.RollBack();
MessageBox.Show("删除联系人发生错误:" + visitRecordManager.Err);
return(-1);
}
}
}
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
#region 重新加载随访明细
if (fp_Sheet1.ActiveRowIndex > -1)
{
//当前选择的随访患者病历号
string cardNo = fp_Sheet1.Cells[fp_Sheet1.ActiveRowIndex, 1].Text.Trim();
if (!string.IsNullOrEmpty(cardNo))
{
if (QueryVisitRecordByCardNo(cardNo) == -1)
{
MessageBox.Show("明细信息查询失败");
}
}
}
#endregion
}
return(0);
}
/// <summary>
/// 新增方法,插入随访明细,并更新随访主记录
/// </summary>
/// <param name="visitRecord">随访明细实体</param>
/// <param name="sequ">随访记录唯一ID</param>
/// <param name="visit">随访主记录实体</param>
/// <returns>成功返回 0;失败返回 -1;</returns>
public int InsertAndUpdateVisit(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord
, string sequ, Neusoft.HISFC.Models.HealthRecord.Visit.Visit visit)
{
if (InsertVisitRecordInfo(visitRecord, sequ) == -1)
{
return(-1);
}
if (UpdateVisit(visit) == -1)
{
return(-1);
}
return(0);
}
/// <summary>
/// 更新随访记录明细
/// </summary>
/// <param name="visitRecord">随访明细记录</param>
/// <returns>影响的行数、-1 失败</returns>
public int UpdateVisitRecord(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord)
{
this.SetDB(visitRecordManager);
int intReturn = visitRecordManager.Update(visitRecord);
if (intReturn < 0)
{
this.Err = visitRecordManager.Err;
return(-1);
}
return(intReturn);
}
/// <summary>
/// 插入随访记录明细
/// </summary>
/// <param name="visitRecord">随访明细记录</param>
/// <returns>影响的行数、-1 失败</returns>
public int InsertVisitRecordInfo(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord, string sequ)
{
this.SetDB(visitRecordManager);
int intReturn = visitRecordManager.Insert(visitRecord, sequ);
if (intReturn < 0)
{
this.Err = visitRecordManager.Err;
return(-1);
}
return(intReturn);
}
/// <summary>
/// 随访信息录入
/// </summary>
/// <param name="visitRecord"></param>
/// <returns>影响的行数、-1 失败</returns>
public int Update(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord)
{
string strSQL = "";
//读取SQL语句
if (this.Sql.GetSql("HealthReacord.Visit.VisitRecord.Update", ref strSQL) == -1)
{
this.Err = "没有找到HealthReacord.Visit.VisitRecord.Update字段！";
return(-1);
}
try
{
string[] strParm = this.GetVisitRecordParmItem(visitRecord);
strSQL = string.Format(strSQL, strParm);
}
catch (Exception ex)
{
this.Err = "赋值时出错！" + ex.Message;
return(-1);
}
//执行SQL语句并返回
return(this.ExecNoQuery(strSQL));
}
/// <summary>
/// 根据SQl语句读取随访明细信息
/// </summary>
/// <param name="strSQL"></param>
/// <returns></returns>
private ArrayList ExecQueryBySQL(string strSQL)
{
this.ExecQuery(strSQL);
ArrayList list = new ArrayList();
Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord = null;
try
{
while (this.Reader.Read())
{
visitRecord = new Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord();
visitRecord.ID = this.Reader[0].ToString();
visitRecord.Patient.PID.CardNO = this.Reader[1].ToString();
visitRecord.Circs.ID = this.Reader[2].ToString();
visitRecord.DeadReason.ID = this.Reader[3].ToString();
visitRecord.DeadTime = NConvert.ToDateTime(this.Reader[4].ToString());
if (this.Reader[5].ToString().Equals("1"))
{
visitRecord.IsDead = true;
}
else
{
visitRecord.IsDead = false;
}
if (this.Reader[6].ToString().Equals("1"))
{
visitRecord.IsRecrudesce = true;
}
else
{
visitRecord.IsRecrudesce = false;
}
if (this.Reader[7].ToString().Equals("1"))
{
visitRecord.IsSequela = true;
}
else
{
visitRecord.IsSequela = false;
}
if (this.Reader[8].ToString().Equals("1"))
{
visitRecord.IsSuccess = true;
}
else
{
visitRecord.IsSuccess = false;
}
if (this.Reader[9].ToString().Equals("1"))
{
visitRecord.IsTransfer = true;
}
else
{
visitRecord.IsTransfer = false;
}
visitRecord.RecrudesceTime = NConvert.ToDateTime(this.Reader[10].ToString());
visitRecord.ResultOper.ID = this.Reader[11].ToString();
visitRecord.ResultOper.OperTime = NConvert.ToDateTime(this.Reader[12].ToString());
visitRecord.Sequela.ID = this.Reader[13].ToString();
visitRecord.Symptom.ID = this.Reader[14].ToString();
visitRecord.TransferPosition.ID = this.Reader[15].ToString();
visitRecord.VisitOper.ID = this.Reader[16].ToString();
visitRecord.VisitOper.OperTime = NConvert.ToDateTime(this.Reader[17].ToString());
visitRecord.VisitType.ID = this.Reader[18].ToString();
#region {E9F858A6-BDBC-4052-BA57-68755055FB80}
//随访方式
visitRecord.VisitType.Name = this.Reader[44].ToString();
visitRecord.Symptom.Name = this.Reader[45].ToString();
visitRecord.VisitResult.Name = this.Reader[46].ToString();
#endregion
visitRecord.WriteBackPerson = this.Reader[19].ToString();
if (this.Reader[20].ToString().Equals("1"))
{
visitRecord.IsPassive = true;
}
else
{
visitRecord.IsPassive = false;
}
if (this.Reader[21].ToString().Equals("1"))
{
visitRecord.LinkWay.IsLinkMan = true;
}
else
{
visitRecord.LinkWay.IsLinkMan = false;
}
visitRecord.LinkWay.LinkMan.Name = this.Reader[22].ToString();
visitRecord.LinkWay.LinkWayType.ID = this.Reader[23].ToString();
visitRecord.LinkWay.Relation.ID = this.Reader[24].ToString();
if (this.Reader[25].ToString().Equals("1"))
{
visitRecord.IsResult = true;
}
else
{
visitRecord.IsResult = false;
}
visitRecord.LinkWay.ZIP = this.Reader[26].ToString();
//visitRecord.ResultOper.Name = this.Reader[37].ToString();
if (this.Reader[27].ToString().Equals("1"))
{
visitRecord.IsWorkLoad = true;
}
else
{
visitRecord.IsWorkLoad = false;
}
visitRecord.LinkWay.Address = this.Reader[28].ToString();
visitRecord.LinkWay.Mail = this.Reader[29].ToString();
visitRecord.LinkWay.Phone = this.Reader[30].ToString();
visitRecord.LinkWay.OtherLinkway = this.Reader[31].ToString();
visitRecord.User01 = this.Reader[32].ToString();
visitRecord.User02 = this.Reader[33].ToString();
visitRecord.User03 = this.Reader[34].ToString();
visitRecord.Circs.Name = this.Reader[35].ToString();
visitRecord.DeadReason.Name = this.Reader[36].ToString();
visitRecord.Sequela.Name = this.Reader[37].ToString();
visitRecord.TransferPosition.Name = this.Reader[38].ToString();
visitRecord.LinkWay.LinkWayType.Name = this.Reader[39].ToString();
visitRecord.LinkWay.Relation.Name = this.Reader[40].ToString();
visitRecord.ResultOper.Name = this.Reader[41].ToString();
visitRecord.VisitOper.Name = this.Reader[42].ToString();
list.Add(visitRecord);
}
}
catch (Exception ex)
{
this.Err = "读取随访明细出错！" + ex.Message;
return(null);
}
finally
{
this.Reader.Close();
}
//返回数组
return(list);
}
/// <summary>
/// 获取insert或update的参数
/// </summary>
/// <param name="linkway">随访明细记录类</param>
/// <returns>返回参数数组</returns>
private string[] GetVisitRecordParmItem(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord)
{
string[] strParm = new string[36];
strParm[0] = visitRecord.ID;
strParm[1] = visitRecord.Patient.PID.CardNO;
strParm[2] = visitRecord.Circs.ID;
strParm[3] = visitRecord.DeadReason.ID;
strParm[4] = visitRecord.DeadTime.ToString();
if (visitRecord.IsDead)
{
strParm[5] = "1";
}
else
{
strParm[5] = "0";
}
if (visitRecord.IsRecrudesce)
{
strParm[6] = "1";
}
else
{
strParm[6] = "0";
}
if (visitRecord.IsSequela)
{
strParm[7] = "1";
}
else
{
strParm[7] = "0";
}
if (visitRecord.IsSuccess)
{
strParm[8] = "1";
}
else
{
strParm[8] = "0";
}
if (visitRecord.IsTransfer)
{
strParm[9] = "1";
}
else
{
strParm[9] = "0";
}
strParm[10] = visitRecord.RecrudesceTime.ToString();
strParm[11] = visitRecord.ResultOper.ID;
strParm[12] = visitRecord.ResultOper.OperTime.ToString();
strParm[13] = visitRecord.Sequela.ID;
strParm[14] = visitRecord.Symptom.ID;
strParm[15] = visitRecord.TransferPosition.ID;
strParm[16] = visitRecord.VisitOper.ID;
strParm[17] = visitRecord.VisitOper.OperTime.ToString();
strParm[18] = visitRecord.VisitType.ID;
strParm[19] = visitRecord.WriteBackPerson;
if (visitRecord.IsPassive)
{
strParm[20] = "1";
}
else
{
strParm[20] = "0";
}
if (visitRecord.LinkWay.IsLinkMan)
{
strParm[21] = "1";
}
else
{
strParm[21] = "0";
}
strParm[22] = visitRecord.LinkWay.LinkMan.Name;
strParm[23] = visitRecord.LinkWay.LinkWayType.ID;
strParm[24] = visitRecord.LinkWay.Relation.ID;
if (visitRecord.IsResult)
{
strParm[25] = "1";
}
else
{
strParm[25] = "0";
}
strParm[26] = visitRecord.LinkWay.ZIP;
if (visitRecord.IsWorkLoad)
{
strParm[27] = "1";
}
else
{
strParm[27] = "0";
}
strParm[28] = visitRecord.LinkWay.Address;
strParm[29] = visitRecord.LinkWay.Mail;
strParm[30] = visitRecord.LinkWay.Phone;
strParm[31] = visitRecord.LinkWay.OtherLinkway;
strParm[32] = visitRecord.User01;
strParm[33] = visitRecord.User02;
strParm[34] = visitRecord.User03;
#region {E9F858A6-BDBC-4052-BA57-68755055FB80}
strParm[35] = visitRecord.VisitResult.ID;
#endregion
//返回数组
return(strParm);
}
/// <summary>
/// 获取随访明细信息
/// </summary>
/// <param name="cardNo">病历号</param>
/// <returns>成功返回 0;失败返回 -1</returns>
private int QueryVisitRecordByCardNo(string cardNo)
{
//随访明细列表
ArrayList list = new ArrayList();
list = visitRecordManager.QueryByCardNo(cardNo);
if (list == null)
{
return(0);
}
fpVisitRecord_Sheet1.Rows.Count = list.Count;
for (int i = 0; i < list.Count; i++)
{
Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord
= list[i] as Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord;
if (visitRecord != null)
{
this.fpVisitRecord_Sheet1.Cells[i, 1].Text = visitRecord.VisitOper.OperTime.ToShortDateString(); //随访时间
this.fpVisitRecord_Sheet1.Cells[i, 2].Text = visitRecord.LinkWay.LinkMan.Name; //联系人
this.fpVisitRecord_Sheet1.Cells[i, 3].Text = visitRecord.VisitType.Name; //随访方式
this.fpVisitRecord_Sheet1.Cells[i, 4].Text = visitRecord.VisitResult.Name; //随访结果
this.fpVisitRecord_Sheet1.Cells[i, 5].Text = visitRecord.Circs.Name; //一般情况名称
this.fpVisitRecord_Sheet1.Cells[i, 6].Text = visitRecord.Symptom.Name; //症状表现
this.fpVisitRecord_Sheet1.Cells[i, 7].Text = visitRecord.IsDead ? "是" : "否"; //是否死亡
this.fpVisitRecord_Sheet1.Cells[i, 8].Text = visitRecord.DeadTime.ToString(); //死亡时间
this.fpVisitRecord_Sheet1.Cells[i, 9].Text = visitRecord.DeadReason.Name; //死亡原因
this.fpVisitRecord_Sheet1.Cells[i, 10].Text = visitRecord.IsRecrudesce ? "是" : "否"; //是否复发
this.fpVisitRecord_Sheet1.Cells[i, 11].Text = visitRecord.RecrudesceTime.ToString(); //复法时间
this.fpVisitRecord_Sheet1.Cells[i, 12].Text = visitRecord.IsSequela ? "是" : "否"; //是否有后遗症
this.fpVisitRecord_Sheet1.Cells[i, 13].Text = visitRecord.Sequela.Name; //后遗症
this.fpVisitRecord_Sheet1.Cells[i, 14].Text = visitRecord.IsTransfer ? "是" : "否"; //是否转移
this.fpVisitRecord_Sheet1.Cells[i, 15].Text = visitRecord.TransferPosition.Name; //后遗症
this.fpVisitRecord_Sheet1.Rows[i].Tag = visitRecord;
}
}
return(0);
}
