/// <summary>
/// 根据sql语句插叙医疗组维护信息
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
private List <Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct> ExcuteQueryMedicalTeamForDoctBySql(string strSql)
{
int returnValue = this.ExecQuery(strSql);
if (returnValue < 0)
{
return(null);
}
List <Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct> medicalTeamForDoctList = new List <Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct>();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medicalTeamForDoctObj = new Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct();
medicalTeamForDoctObj.MedcicalTeam.Dept.ID = this.Reader[0].ToString();
medicalTeamForDoctObj.MedcicalTeam.ID = this.Reader[1].ToString();
medicalTeamForDoctObj.Doct.ID = this.Reader[2].ToString();
medicalTeamForDoctObj.Doct.Name = this.Reader[3].ToString();
medicalTeamForDoctObj.Oper.ID = this.Reader[5].ToString();
medicalTeamForDoctObj.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[4].ToString());
medicalTeamForDoctObj.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString());
medicalTeamForDoctList.Add(medicalTeamForDoctObj);
}
this.Reader.Close();
return(medicalTeamForDoctList);
}
private int Save()
{
if (this.cmbDoct.SelectedItem == null)
{
MessageBox.Show("请选择医生");
return(-1);
}
Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medicalTeamForDoct = new Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct();
medicalTeamForDoct.IsValid = true;
medicalTeamForDoct.MedcicalTeam = this.medicalTeam;
medicalTeamForDoct.Oper.ID = this.medicalTeamForDoctLogic.Operator.ID;
medicalTeamForDoct.Oper.OperTime = this.medicalTeamForDoctLogic.GetDateTimeFromSysDateTime();
medicalTeamForDoct.Doct = this.cmbDoct.SelectedItem as Neusoft.FrameWork.Models.NeuObject;
int returnValue = this.medicalTeamForDoctLogic.InsertMedicalTeamForDoct(medicalTeamForDoct);
if (returnValue < 0)
{
MessageBox.Show("插入医生失败!\n" + this.medicalTeamForDoctLogic.Err);
return(-1);
}
MessageBox.Show("添加成功");
this.DialogResult = DialogResult.OK;
return(1);
}
/// <summary>
/// 插入或删除信息
/// </summary>
/// <param name="sqlIndex"></param>
/// <param name="medicalTeam"></param>
/// <returns></returns>
private int InsertOrUpdateTable(string sqlIndex, Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medicalTeamForDoct)
{
string[] args = this.GetArgs(medicalTeamForDoct);
string strSql = string.Empty;
int returnValue = this.Sql.GetSql(sqlIndex, ref strSql);
if (returnValue < 0)
{
this.Err = "查询" + sqlIndex + "对应的sql语句失败！\n" + this.Sql.Err;
return(-1);
}
try
{
strSql = string.Format(strSql, args);
}
catch (Exception ex)
{
this.Err = "格式化字符串出错!\n" + ex.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 停用启用医生
/// </summary>
/// <param name="isValidFlag"></param>
/// <returns></returns>
private int ProcessDoctValidFlag(bool isValidFlag)
{
Neusoft.HISFC.Models.Order.Inpatient.MedicalTeam obj = this.neuSpread1_Sheet1.ActiveRow.Tag as Neusoft.HISFC.Models.Order.Inpatient.MedicalTeam;
int returnValue = 0;
string errText = string.Empty;
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
int j = 0;
for (int i = 0; i < this.neuSpread1_Sheet1.RowCount; i++)
{
bool isSelectecd = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.neuSpread2_Sheet1.Cells[i, 0].Value);
if (isSelectecd)
{
j++;
Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medcialTeamForDoctObj = this.neuSpread2_Sheet1.Rows[i].Tag as Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct;
returnValue = this.medicalTeamForDoctLogic.UpdateValidFlag(medcialTeamForDoctObj.MedcicalTeam.Dept.ID, medcialTeamForDoctObj.MedcicalTeam.ID, medcialTeamForDoctObj.Doct.ID);
if (returnValue < 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("更新医生状态出错!\n" + this.medicalTeamForDoctLogic.Err);
return(-1);
}
}
}
if (j == 0) //没有选择
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("请选择要更新的医生");
return(-1);
}
else
{
Neusoft.FrameWork.Management.PublicTrans.Commit();
if (isValidFlag)
{
MessageBox.Show("启用成功");
}
else
{
MessageBox.Show("停用成功");
}
}
this.QueryDoctByDeptAndMedicalTeam(obj.Dept.ID, obj.ID);
return(1);
}
private string[] GetArgs(Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medicalTeamForDoct)
{
string[] args = new string[]
{
medicalTeamForDoct.MedcicalTeam.Dept.ID,
medicalTeamForDoct.MedcicalTeam.ID,
medicalTeamForDoct.Doct.ID,
medicalTeamForDoct.Doct.Name,
medicalTeamForDoct.Oper.OperTime.ToString(),
medicalTeamForDoct.Oper.ID,
Neusoft.FrameWork.Function.NConvert.ToInt32(medicalTeamForDoct.IsValid).ToString()
};
return(args);
}
/// <summary>
/// 根据科室和医疗组信息查询医生信息
/// </summary>
/// <param name="deptCode"></param>
/// <param name="medicalTeamCode"></param>
/// <returns></returns>
private int QueryDoctByDeptAndMedicalTeam(string deptCode, string medicalTeamCode)
{
this.neuSpread2_Sheet1.Rows.Count = 0;
List <Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct> medicalTeamForDoctList = this.medicalTeamForDoctLogic.QueryQueryMedicalTeamForDoctInfo(deptCode, medicalTeamCode, "All");
if (medicalTeamForDoctList == null)
{
MessageBox.Show("查询医生出错!\n" + this.medicalTeamForDoctLogic.Err);
return(-1);
}
for (int i = 0; i < medicalTeamForDoctList.Count; i++)
{
Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct obj = medicalTeamForDoctList[i];
this.neuSpread2_Sheet1.Rows.Add(0, 1);
this.neuSpread2_Sheet1.Cells[0, 1].Text = obj.Doct.Name;
this.neuSpread2_Sheet1.Cells[0, 2].Value = obj.IsValid;
this.neuSpread2_Sheet1.Rows[0].Tag = obj;
}
return(1);
}
public void RefreshInfo()
{
this.Nodes.Clear();
if (manager == null)
{
manager = new Neusoft.HISFC.BizProcess.Integrate.RADT();
}
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.Base.Employee per = Neusoft.FrameWork.Management.Connection.Operator as Neusoft.HISFC.Models.Base.Employee;
//节点说明
al.Add("分管患者|patient");
try
{
ArrayList al1 = new ArrayList();
al1 = this.manager.QueryPatientByHouseDoc(per, Neusoft.HISFC.Models.Base.EnumInState.I, per.Dept.ID);
foreach (Neusoft.HISFC.Models.RADT.PatientInfo PatientInfo1 in al1)
{
al.Add(PatientInfo1);
}
}
catch (Exception ex)
{
MessageBox.Show("查找分管患者出错\n！" + ex.Message + this.manager.Err);
}
al.Add("本科室患者|DeptPatient");
addPatientList(al, Neusoft.HISFC.Models.Base.EnumInState.I);
al.Add("会诊患者|ConsultationPatient");
try
{
ArrayList al1 = new ArrayList();
Neusoft.FrameWork.Management.DataBaseManger dbManager = new Neusoft.FrameWork.Management.DataBaseManger();
DateTime dt = dbManager.GetDateTimeFromSysDateTime();
DateTime dt1 = new DateTime(dt.Year, dt.Month, dt.Day, 0, 0, 0, 0);
DateTime dt2 = new DateTime(dt.Year, dt.AddDays(1).Month, dt.AddDays(1).Day, 0, 0, 0, 0);
al1 = this.manager.QueryPatientByConsultation(dbManager.Operator, dt1, dt2, per.Dept.ID);
foreach (Neusoft.HISFC.Models.RADT.PatientInfo PatientInfo1 in al1)
{
al.Add(PatientInfo1);
}
}
catch (Exception ex)
{
MessageBox.Show("查找会诊患者出错\n！" + ex.Message + this.manager.Err);
}
al.Add("授权患者|PermissionPatient");
try
{
ArrayList al1 = new ArrayList();
al1 = this.manager.QueryPatientByPermission(Neusoft.FrameWork.Management.Connection.Operator);
foreach (Neusoft.HISFC.Models.RADT.PatientInfo PatientInfo1 in al1)
{
al.Add(PatientInfo1);
}
}
catch (Exception ex)
{
MessageBox.Show("查找授权患者出错\n！" + ex.Message + this.manager.Err);
}
try
{
al.Add("查找患者|QueryPatient");
}
catch (Exception ex)
{
MessageBox.Show("查找患者出错\n！" + ex.Message + this.manager.Err);
}
//{AC6A5576-BA29-4dba-8C39-E7C5EBC7671E} 增加医疗组处理
al.Add("医疗组内患者|TeamPatient");
if (this.medicalTeamForDoctBizlogic == null)
{
this.medicalTeamForDoctBizlogic = new Neusoft.HISFC.BizLogic.Order.MedicalTeamForDoct();
}
List <Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct> medicalTeamForDoctList =
this.medicalTeamForDoctBizlogic.QueryQueryMedicalTeamForDoctInfo(per.Dept.ID, per.ID);
if (medicalTeamForDoctList == null)
{
MessageBox.Show("查询医疗组失败!\n" + this.medicalTeamForDoctBizlogic.Err);
}
if (medicalTeamForDoctList.Count > 0)
{
Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medcialObj = medicalTeamForDoctList[0];
addPatientListMedialTeam(al, Neusoft.HISFC.Models.Base.EnumInState.I, medcialObj.MedcicalTeam.ID);
}
this.SetPatient(al);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="medicalTeam"></param>
/// <returns></returns>
public int UpdateMedicalTeamForDoct(Neusoft.HISFC.Models.Order.Inpatient.MedicalTeamForDoct medicalTeamForDoct)
{
return(this.InsertOrUpdateTable("MedicalTeamForDoct.Update", medicalTeamForDoct));
}