private string[] getInfo(Neusoft.HISFC.Models.HealthRecord.Lend info)
{
string[] str = new string[26];
str[0] = info.CaseBase.PatientInfo.ID; //住院流水号
str[1] = info.CaseBase.CaseNO; //病人住院号
str[2] = info.CaseBase.PatientInfo.Name; //病人姓名
str[3] = info.CaseBase.PatientInfo.Sex.ID.ToString(); //性别
str[4] = info.CaseBase.PatientInfo.Birthday.ToString(); //出生日期
str[5] = info.CaseBase.PatientInfo.PVisit.InTime.ToString(); //入院日期
str[6] = info.CaseBase.PatientInfo.PVisit.OutTime.ToString(); //出院日期
str[7] = info.CaseBase.InDept.ID; //入院科室代码
str[8] = info.CaseBase.InDept.Name; //入院科室名称
str[9] = info.CaseBase.OutDept.ID; //出院科室代码
str[10] = info.CaseBase.OutDept.Name; //出院科室名称
str[11] = info.EmployeeInfo.ID; //借阅人代号
str[12] = info.EmployeeInfo.Name; //借阅人姓名
str[13] = info.EmployeeDept.ID; //借阅人所在科室代码
str[14] = info.EmployeeDept.Name; //借阅人所在科室名称
str[15] = info.LendDate.ToString(); //借阅日期
str[16] = info.PrerDate.ToString(); //预定还期
str[17] = info.LendKind; //借阅性质
str[18] = info.LendStus; //病历状态 1借出/2返还
str[19] = info.ID; //操作员代号
str[20] = info.OperInfo.OperTime.ToString(); //操作时间
str[21] = info.ReturnOperInfo.ID; //归还操作员代号
str[22] = info.ReturnDate.ToString(); //实际归还日期
str[23] = info.CardNO; //卡号
str[24] = info.Memo; //返还情况
str[25] = info.SeqNO; //返还情况
return(str);
}
private ArrayList GetInfo()
{
ArrayList list = new ArrayList();
for (int i = 0; i < this.fpSpread1_Sheet1.Rows.Count; i++)
{
if (this.fpSpread1_Sheet1.Cells[i, (int)Cols.Check].Value == null || fpSpread1_Sheet1.Cells[i, (int)Cols.Check].Value.ToString().ToUpper() != "TRUE")
{
continue;
}
Neusoft.HISFC.Models.HealthRecord.Lend obj = (Neusoft.HISFC.Models.HealthRecord.Lend)fpSpread1_Sheet1.Rows[i].Tag;
if (obj == null)
{
MessageBox.Show("获取病案信息出错");
return(null);
}
#region 校验
for (int j = 0; j < this.fpSpread1_Sheet1.Rows.Count; j++)
{
if (i == j)
{
continue;
}
if (fpSpread1_Sheet1.Cells[i, (int)Cols.CaseNO].Text == fpSpread1_Sheet1.Cells[j, (int)Cols.CaseNO].Text)
{
if (this.fpSpread1_Sheet1.Cells[j, (int)Cols.Check].Value == null)
{
MessageBox.Show("病案号相同的必须全部选中");
return(null);
}
if (this.fpSpread1_Sheet1.Cells[j, (int)Cols.Check].Value.ToString().ToUpper() != "TRUE")
{
MessageBox.Show("病案号相同的必须全部选中");
return(null);
}
}
}
#endregion
if (cbContinueLend.Checked) //续借
{
obj.PrerDate = dtContinue.Value;
}
else if (cbReturn.Checked) //返还
{
obj.ReturnDate = dtReturn.Value; //实际返还时间
obj.ReturnOperInfo.ID = card.Operator.ID; //返还操作员
obj.LendStus = "2"; //状态
obj.Memo = this.txReturn.Text; //是否完好
}
else
{
obj.LendStus = "1"; //状态
}
list.Add(obj);
}
return(list);
}
/// <summary>
/// 显示信息
/// </summary>
/// <param name="obj"></param>
private void SetInfo(Neusoft.HISFC.Models.HealthRecord.Lend obj)
{
CardNO.Text = obj.CardNO;
txName.Text = obj.EmployeeInfo.Name;
txDept.Text = obj.EmployeeDept.Name;
dtContinue.Value = Neusoft.FrameWork.Function.NConvert.ToDateTime(card.GetSysDate());
dtReturn.Value = Neusoft.FrameWork.Function.NConvert.ToDateTime(card.GetSysDate());
txReturn.Text = obj.Memo;
}
/// <summary>
/// 归还
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int ReturnCase(Neusoft.HISFC.Models.HealthRecord.Lend info)
{
string[] arrStr = getInfo(info);
string strSql = "";
if (this.Sql.GetSql("Case.CaseCard.ReturnCase", ref strSql) == -1)
{
return(-1);
}
strSql = string.Format(strSql, arrStr);
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 私有函数
/// </summary>
/// <returns></returns>
private ArrayList QueryLendInfoBase()
{
try
{
ArrayList list = new ArrayList();
Neusoft.HISFC.Models.HealthRecord.Lend info = null;
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.HealthRecord.Lend();
info.CaseBase.PatientInfo.ID = this.Reader[0].ToString(); //住院流水号
info.CaseBase.CaseNO = this.Reader[1].ToString(); //病人住院号
info.CaseBase.PatientInfo.Name = this.Reader[2].ToString(); //病人姓名
info.CaseBase.PatientInfo.Sex.ID = this.Reader[3].ToString(); //性别
info.CaseBase.PatientInfo.Birthday = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[4].ToString()); //出生日期
info.CaseBase.PatientInfo.PVisit.InTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[5].ToString()); //入院日期
info.CaseBase.PatientInfo.PVisit.OutTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString()); //出院日期
info.CaseBase.InDept.ID = this.Reader[7].ToString(); //入院科室代码
info.CaseBase.InDept.Name = this.Reader[8].ToString(); //入院科室名称
info.CaseBase.OutDept.ID = this.Reader[9].ToString(); //出院科室代码
info.CaseBase.OutDept.Name = this.Reader[10].ToString(); //出院科室名称
info.EmployeeInfo.ID = this.Reader[11].ToString(); //借阅人代号
info.EmployeeInfo.Name = this.Reader[12].ToString(); //借阅人姓名
info.EmployeeDept.ID = this.Reader[13].ToString(); //借阅人所在科室代码
info.EmployeeDept.Name = this.Reader[14].ToString(); //借阅人所在科室名称
info.LendDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[15].ToString()); //借阅日期
info.PrerDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[16].ToString()); //预定还期
info.LendKind = this.Reader[17].ToString(); //借阅性质
info.LendStus = this.Reader[18].ToString(); //病历状态 1借出/2返还
info.ID = this.Reader[19].ToString(); //操作员代号
info.OperInfo.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[20].ToString()); //操作时间
info.ReturnOperInfo.ID = this.Reader[21].ToString(); //归还操作员代号
info.ReturnDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[22].ToString()); //实际归还日期
info.CardNO = this.Reader[23].ToString(); //卡号
info.Memo = this.Reader[24].ToString(); //返还情况
info.SeqNO = this.Reader[25].ToString(); //发生序号
list.Add(info);
}
this.Reader.Close();
return(list);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(null);
}
}
private int ValidState(Neusoft.HISFC.Models.HealthRecord.Lend obj)
{
if (CardNO.Text == null && CardNO.Text == "")
{
MessageBox.Show("请输入借阅卡号");
return(-1);
}
if (caseNo.Text == null && caseNo.Text == "")
{
MessageBox.Show("请输入借阅卡号");
return(-1);
}
if (comType.Text == "")
{
MessageBox.Show("借阅方式");
return(-1);
}
if (this.txReturnTime.Value <= System.DateTime.Now)
{
MessageBox.Show("预计归还日期不能小于当前时间");
return(-1);
}
return(1);
}
private ArrayList GetLendInfo()
{
ArrayList list = new ArrayList();
if (this.caseMain.RowCount == 0)
{
MessageBox.Show("请选择借阅的病案信息");
return(list);
}
if (Cardinfo == null)
{
MessageBox.Show("请选择借阅的病案信息");
return(null);
}
if (comType.Text != "内借" && comType.Text != "外借")
{
MessageBox.Show("请选择借阅方式");
return(null);
}
if (txReturnTime.Value < System.DateTime.Now)
{
System.TimeSpan sp = System.DateTime.Now - txReturnTime.Value;
if (sp.Days > 1)
{
MessageBox.Show("预计归还日期不能小于当前日期");
return(null);
}
}
for (int i = 0; i < this.caseMain.RowCount; i++)
{
//{B6105962-245E-4106-89F2-3469B2065617}
//Neusoft.HISFC.Models.HealthRecord.Lend Saveinfo = new Neusoft.HISFC.Models.HealthRecord.Lend();
Neusoft.HISFC.Models.HealthRecord.Base objBase = (Neusoft.HISFC.Models.HealthRecord.Base) this.caseMain.Rows[i].Tag;
ArrayList tempList = this.baseDml.QueryCaseBaseInfoByCaseNO(objBase.CaseNO);
foreach (Neusoft.HISFC.Models.HealthRecord.Base tempObj in tempList)
{
//{B6105962-245E-4106-89F2-3469B2065617}
Neusoft.HISFC.Models.HealthRecord.Lend Saveinfo = new Neusoft.HISFC.Models.HealthRecord.Lend();
Saveinfo.SeqNO = this.card.GetSequence("Case.CaseCard.LendCase.Seq");
if (Saveinfo.SeqNO == null || Saveinfo.SeqNO == "")
{
MessageBox.Show("获取序号失败");
return(null);
}
if (tempObj.LendStat == "O") //是字母 O
{
MessageBox.Show("该病案已经借出.");
return null;
}
Saveinfo.CaseBase.CaseNO = tempObj.CaseNO;
Saveinfo.CaseBase.PatientInfo.ID = tempObj.PatientInfo.ID; //住院流水号
Saveinfo.CaseBase.CaseNO = tempObj.CaseNO; //病人住院号
Saveinfo.CaseBase.PatientInfo.Name = tempObj.PatientInfo.Name; //病人姓名
Saveinfo.CaseBase.PatientInfo.Sex.ID = tempObj.PatientInfo.Sex.ID; //性别
Saveinfo.CaseBase.PatientInfo.Birthday = tempObj.PatientInfo.Birthday; //出生日期
Saveinfo.CaseBase.PatientInfo.PVisit.InTime = tempObj.PatientInfo.PVisit.InTime; //入院日期
Saveinfo.CaseBase.PatientInfo.PVisit.OutTime = tempObj.PatientInfo.PVisit.OutTime; //出院日期
Saveinfo.CaseBase.InDept.ID = tempObj.InDept.ID; //入院科室代码
Saveinfo.CaseBase.InDept.Name = tempObj.InDept.Name; //入院科室名称
Saveinfo.CaseBase.OutDept.ID = tempObj.OutDept.ID; //出院科室代码
Saveinfo.CaseBase.OutDept.Name = tempObj.OutDept.Name; //出院科室名称
Saveinfo.EmployeeInfo.ID = Cardinfo.EmployeeInfo.ID; //借阅人代号
Saveinfo.EmployeeInfo.Name = Cardinfo.EmployeeInfo.Name; //借阅人姓名
Saveinfo.EmployeeDept.ID = Cardinfo.DeptInfo.ID; //借阅人所在科室代码
Saveinfo.EmployeeDept.Name = Cardinfo.DeptInfo.Name; //借阅人所在科室名称
Saveinfo.LendDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(baseDml.GetSysDate()); //借阅日期
Saveinfo.PrerDate = txReturnTime.Value; //预定还期
if (this.comType.Text == "内借")
{
Saveinfo.LendKind = "1";; //借阅性质
}
else if (this.comType.Text == "外借")
{
Saveinfo.LendKind = "2";; //借阅性质
}
Saveinfo.LendStus = "1";; //病历状态 1借出/2返还
Saveinfo.ID = baseDml.Operator.ID; //操作员代号
Saveinfo.OperInfo.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(baseDml.GetSysDate()); //操作时间
Saveinfo.ReturnOperInfo.ID = ""; //归还操作员代号
Saveinfo.ReturnDate = Neusoft.FrameWork.Function.NConvert.ToDateTime("3000-1-1"); //实际归还日期
Saveinfo.CardNO = CardNO.Text; //卡号
list.Add(Saveinfo);
}
}
return(list);
}
