/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private int Save()
{
message = GetMessage();
try
{
Neusoft.HISFC.BizProcess.Factory.Function.BeginTransaction();
int returnValue = 0;
returnValue = Neusoft.HISFC.BizProcess.Factory.Function.IntegrateEPR.InsertMessage(message);
if (returnValue == -1)
{
Neusoft.HISFC.BizProcess.Factory.Function.RollBack();
MessageBox.Show("插入失败！" + Neusoft.HISFC.BizProcess.Factory.Function.IntegrateManager.Err);
return(-1);
}
else
{
Neusoft.HISFC.BizProcess.Factory.Function.Commit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(1);
}
public int UpdateNurseSheetSetting(Neusoft.HISFC.Models.Base.Message obj)
{
Neusoft.HISFC.BizLogic.EPR.NurseTend nurseTendManager = new Neusoft.HISFC.BizLogic.EPR.NurseTend();
this.SetDB(nurseTendManager);
return(nurseTendManager.UpdateNurseSheetSetting(obj));
}
public int UpdateMessage(Neusoft.HISFC.Models.Base.Message message)
{
Neusoft.HISFC.BizLogic.EPR.Message messageManager = new Neusoft.HISFC.BizLogic.EPR.Message();
this.SetDB(messageManager);
return(messageManager.UpdateMessage(message));
}
/// <summary>
/// 查询所有消息
/// </summary>
/// <returns></returns>
public ArrayList QueryEmrId(string InpatientNo)
{
string strSql = "";
Neusoft.HISFC.Models.Base.Message message = null;
ArrayList lis = new ArrayList();
if (this.Sql.GetSql("EPR.MESSAGE.QUERY1", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, InpatientNo);
this.ExecQuery(strSql);
while (this.Reader.Read())
{
message = new Neusoft.HISFC.Models.Base.Message();
message.ID = this.Reader[0].ToString();
message.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[1].ToString());
message.Oper.ID = this.Reader[2].ToString();
message.Oper.Name = this.Reader[3].ToString();
message.Text = this.Reader[4].ToString();
message.Receiver.ID = this.Reader[5].ToString();
message.Receiver.Name = this.Reader[6].ToString();
message.ReceiverDept.ID = this.Reader[7].ToString();
message.ReceiverDept.Name = this.Reader[8].ToString();
message.IsRecieved = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[9].ToString());
message.Emr.ID = this.Reader[10].ToString();
message.InpatientNo = this.Reader[11].ToString();
message.Emr.User01 = this.Reader[12].ToString();
message.ReplyType = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[13].ToString());
message.Emr.Name = this.Reader[14].ToString();
message.SenderDept.ID = this.Reader[15].ToString();
message.SenderDept.Name = this.Reader[16].ToString();
message.Name = this.Reader[17].ToString();
lis.Add(message);
}
this.Reader.Close();
}
catch (Exception ex)
{
this.WriteErr();
return(null);
}
return(lis);
}
/// <summary>
/// 有参构造函数
/// </summary>
/// <param name="id"></param>
public frmReply(Neusoft.HISFC.Models.Base.Message message, Form parent)
{
InitializeComponent();
this.message = message;
setInfoToControls();
this.ComboBox1.Enabled = false;
this.linkLabel1.Visible = false;
if (message.InpatientNo != "")
{
this.linkLabel1.Visible = true;
}
this.parent = parent;
}
/// <summary>
/// 取得所有在用护理记录设置
/// </summary>
/// <returns></returns>
public ArrayList QueryNurseSheetSettingList()
{
string strSql = "";
Neusoft.HISFC.Models.Base.Message obj = null;
ArrayList lis = new ArrayList();
if (this.Sql.GetSql("EPR.NURSE.QueryNurseSetting", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql);
this.ExecQuery(strSql);
while (this.Reader.Read())
{
obj = new Neusoft.HISFC.Models.Base.Message(); //ID
obj.ID = this.Reader[0].ToString(); //ID
obj.Name = this.Reader[1].ToString(); //Dept_Code
obj.Memo = this.Reader[2].ToString(); //Dept_Name
obj.User01 = this.Reader[3].ToString(); //File_Name
obj.User02 = this.Reader[4].ToString(); //Data
obj.User03 = this.Reader[5].ToString();
obj.Oper.ID = this.Reader[6].ToString(); //Oper_Code
obj.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[7].ToString()); //Oper_Date
lis.Add(obj);
}
this.Reader.Close();
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
return(null);
}
return(lis);
}
/// <summary>
/// 获取页面上的数据
/// </summary>
/// <returns></returns>
private Neusoft.HISFC.Models.Base.Message GetMessage()
{
Neusoft.HISFC.Models.Base.Message message = new Neusoft.HISFC.Models.Base.Message();
message.Receiver.Name = this.comboBox1.Text;
message.Receiver.ID = this.comboBox1.Tag.ToString();
Neusoft.HISFC.Models.Base.Employee receiver = managerManager.GetPersonByID(message.Receiver.ID);
message.ReceiverDept.ID = receiver.Dept.ID;
message.ReceiverDept.Name = receiver.Dept.Name;
message.Name = this.textBox1.Text.Trim();
message.Text = this.richTextBox1.Text.Trim();
message.Oper.OperTime = System.DateTime.Now;
message.Oper.Name = Neusoft.FrameWork.Management.Connection.Operator.Name;
message.Oper.ID = Neusoft.FrameWork.Management.Connection.Operator.ID;
Neusoft.HISFC.Models.Base.Employee oper = managerManager.GetPersonByID(message.Oper.ID);
message.SenderDept.ID = oper.Dept.ID;
message.SenderDept.Name = oper.Dept.Name;
message.ReplyType = -1;
message.InpatientNo = lis[3].ToString(); //eprId
message.Emr.User01 = lis[1].ToString(); // patient.Name
message.Emr.Name = lis[2].ToString(); //emrname
message.Emr.ID = lis[0].ToString();
return(message);
}
/// <summary>
/// 把数据存入实体中
/// </summary>
/// <returns></returns>
private Neusoft.HISFC.Models.Base.Message GetMessage()
{
Neusoft.HISFC.Models.Base.Message message = new Neusoft.HISFC.Models.Base.Message();
message.Receiver.Name = this.ComboBox1.Text;
message.Receiver.ID = this.ComboBox1.Tag.ToString();
Neusoft.HISFC.Models.Base.Employee receiver = managerManager.GetPersonByID(message.Receiver.ID);
message.ReceiverDept.ID = receiver.Dept.ID;
message.ReceiverDept.Name = receiver.Dept.Name;
message.Name = this.textBox1.Text.Trim();
message.Text = this.richTextBox1.Text.Trim();
message.Oper.OperTime = System.DateTime.Now;
message.Oper.Name = Neusoft.FrameWork.Management.Connection.Operator.Name;
message.Oper.ID = Neusoft.FrameWork.Management.Connection.Operator.ID;
Neusoft.HISFC.Models.Base.Employee oper = managerManager.GetPersonByID(message.Oper.ID);
message.SenderDept.ID = oper.Dept.ID;
message.SenderDept.Name = oper.Dept.Name;
message.ReplyType = this.comboBox2.Items.IndexOf(this.comboBox2.Text);
message.ID = this.richTextBox2.Tag.ToString();
message.IsRecieved = true;
return(message);
}
/// <summary>
/// 修改消息状态
/// </summary>
/// <param name="message"></param>
/// <returns></returns>
public int UpdateMessage(Neusoft.HISFC.Models.Base.Message message)
{
string strSql = "";
if (this.Sql.GetSql("EPR.MESSAGE.UPDATE", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, message.IsRecieved, message.ReplyType, message.ID);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = "接口错误！" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 修改护理记录设置
/// </summary>
/// <param name="obj">护理记录设置实体</param>
/// <returns>成功，返回1</returns>
public int UpdateNurseSheetSetting(Neusoft.HISFC.Models.Base.Message obj)
{
string strSql = "";
if (this.Sql.GetSql("EPR.NURSE.UpdateNurseSetting", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, obj.ID, obj.Name, obj.Memo, obj.User01, obj.User03, obj.Oper.ID);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = "接口错误！" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.InputLong(strSql, obj.User02));
}
/// <summary>
/// 插入一条消息
/// </summary>
/// <param name="message"></param>
/// <returns></returns>
public int InsertMessage(Neusoft.HISFC.Models.Base.Message message)
{
string strSql = "";
if (this.Sql.GetSql("EPR.MESSAGE.INSERT", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, message.Oper.OperTime, message.Oper.ID, message.Oper.Name, message.Text, message.Receiver.ID, message.Receiver.Name, message.ReceiverDept.ID, message.ReceiverDept.Name, false
, message.Emr.ID, message.InpatientNo, message.Emr.User01, -1, message.Emr.Name, message.Oper.ID, message.Oper.Name, message.Name);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = "接口错误！" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(strSql));
}
