public List <Neusoft.HISFC.Models.Order.CheckSlip> MyQuderSlip(string sql)
{
List <Neusoft.HISFC.Models.Order.CheckSlip> list = new List <Neusoft.HISFC.Models.Order.CheckSlip>();
try
{
if (this.ExecQuery(sql) == -1)
{
return(null);
}
while (Reader.Read())
{
Neusoft.HISFC.Models.Order.CheckSlip checkslip = new Neusoft.HISFC.Models.Order.CheckSlip();
checkslip.CheckSlipNo = this.Reader[0].ToString(); //单号
checkslip.CardNo = this.Reader[1].ToString(); //门诊号
checkslip.InpatientNO = this.Reader[2].ToString(); //住院号
checkslip.Doct_dept = this.Reader[3].ToString(); //开立科室代码
checkslip.ZsInfo = this.Reader[4].ToString(); //主诉
checkslip.YxtzInfo = this.Reader[5].ToString(); //阳性体征
checkslip.YxsyInfo = this.Reader[6].ToString(); //阳性实验检查结果
checkslip.DiagName = this.Reader[7].ToString(); //主诊断
checkslip.ItemNote = this.Reader[8].ToString(); //检查部位
checkslip.EmcFlag = this.Reader[9].ToString(); //是否加急(0普通/1加急)
checkslip.MoNote = this.Reader[10].ToString(); //备注
checkslip.ExtFlag1 = this.Reader[11].ToString(); //医嘱项目
checkslip.ExtFlag2 = this.Reader[12].ToString(); //患者科室
checkslip.ExtFlag3 = this.Reader[13].ToString(); //患者病区
checkslip.ExtFlag4 = this.Reader[14].ToString(); //床号
checkslip.ApplyDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[15]);
checkslip.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[16]);
list.Add(checkslip);
}
}
catch (Exception e)
{
this.Err = "申请单信息出错!" + e.Message;
this.ErrCode = e.Message;
this.WriteErr();
return(null);
}
finally
{
Reader.Close();
}
return(list);
}
public List <Neusoft.HISFC.Models.Order.CheckSlip> QueryPatineInfo(string InpatientNo)
{
string sql = "";
if (this.Sql.GetSql("Order.InmainInfo.SelectByInpatient", ref sql) == -1)
{
this.Err = this.Sql.Err;
return(null);
}
sql = string.Format(sql, InpatientNo);
List <Neusoft.HISFC.Models.Order.CheckSlip> list = new List <Neusoft.HISFC.Models.Order.CheckSlip>();
try
{
if (this.ExecQuery(sql) == -1)
{
return(null);
}
while (Reader.Read())
{
Neusoft.HISFC.Models.Order.CheckSlip checkslip = new Neusoft.HISFC.Models.Order.CheckSlip();
checkslip.ExtFlag2 = this.Reader[0].ToString();
checkslip.ExtFlag3 = this.Reader[1].ToString();
checkslip.ExtFlag4 = this.Reader[2].ToString();
list.Add(checkslip);
}
Reader.Close();
}
catch (Exception e)
{
if (Reader.IsClosed == false)
{
Reader.Close();
}
this.Err = "读取患者基本信息出错!" + e.Message;
this.ErrCode = e.Message;
this.WriteErr();
return(null);
}
return(list);
}
public int UpdateCheckSlip(Neusoft.HISFC.Models.Order.CheckSlip checkslip)
{
string sql = "";
if (this.Sql.GetSql("Order.CheckSlip.Update", ref sql) == -1)
{
this.Err = this.Sql.Err;
return(-1);
}
try
{
sql = string.Format(sql, checkslip.CheckSlipNo, checkslip.Doct_dept, checkslip.ZsInfo, checkslip.YxtzInfo, checkslip.YxsyInfo,
checkslip.DiagName, checkslip.ItemNote, checkslip.EmcFlag, checkslip.MoNote, checkslip.ExtFlag1, checkslip.OperDate);
return(this.ExecNoQuery(sql));
}
catch (Exception e)
{
this.Err = "更新检查申请单出错![Order.CheckSlip.Update]" + e.Message;
this.ErrCode = e.Message;
return(-1);
}
}
protected Neusoft.HISFC.Models.Order.CheckSlip getSlip()
{
this.checkslip = new Neusoft.HISFC.Models.Order.CheckSlip();
int i = this.checkSlip.QueryByMoOrder(((Neusoft.FrameWork.Models.NeuObject)(order)).ID);
if (i != -1 && i != 0)
{
this.getSlip();
this.checkslip.CheckSlipNo = i.ToString();
}
this.checkslip.InpatientNO = this.neuInpatientNo.Text;
this.checkslip.Doct_dept = this.Order.ReciptDept.ID.ToString();
this.checkslip.ZsInfo = this.txtMain.Text;
this.checkslip.YxtzInfo = this.neuRichTextBox1.Text;
this.checkslip.YxsyInfo = this.neuRichTextBox2.Text;
this.checkslip.ItemNote = this.neuItemNote.Text;
this.checkslip.DiagName = this.tbDignose.Text;
this.checkslip.ExtFlag1 = this.tbItem.Text;
this.checkslip.MoNote = this.tbNote.Text;
this.checkslip.ApplyDate = this.checkSlip.GetDateTimeFromSysDateTime();
this.checkslip.OperDate = this.checkSlip.GetDateTimeFromSysDateTime();
return(this.checkslip);
}
public int InsertCheckSlip(Neusoft.HISFC.Models.Order.CheckSlip checkslip)
{
string sql = "";
if (this.Sql.GetSql("Order.CheckSlip.Insert", ref sql) == -1)
{
this.Err = this.Sql.Err;
return(-1);
}
try
{
checkslip.CheckSlipNo = this.GetSequence("Order.CheckSlip.Seq");
sql = string.Format(sql, checkslip.CheckSlipNo, checkslip.CardNo, checkslip.InpatientNO, checkslip.Doct_dept, checkslip.ZsInfo,
checkslip.YxtzInfo, checkslip.YxsyInfo, checkslip.DiagName, checkslip.ItemNote, checkslip.EmcFlag, checkslip.MoNote, checkslip.ExtFlag1,
checkslip.ExtFlag2, checkslip.ExtFlag3, checkslip.ExtFlag4, checkslip.ApplyDate, checkslip.OperDate);
return(this.ExecNoQuery(sql));
}
catch (Exception e)
{
this.Err = "插入检查申请单出错![Order.CheckSlip.Insert]" + e.Message;
this.ErrCode = e.Message;
return(-1);
}
}
