/// <summary>
/// 根据身份证号获取性别
/// </summary>
/// <param name="idNO">身份证号</param>
/// <returns></returns>
public static Neusoft.FrameWork.Models.NeuObject GetSexFromIdNO(string idNO, ref string err)
{
if (Neusoft.FrameWork.WinForms.Classes.Function.CheckIDInfo(idNO, ref err) < 0)
{
return(null);
}
if (idNO.Length == 15)
{
idNO = Neusoft.FrameWork.WinForms.Classes.Function.TransIDFrom15To18(idNO);
}
int flag = Neusoft.FrameWork.Function.NConvert.ToInt32((idNO.Substring(16, 1)));
FrameWork.Models.NeuObject sexobj = new Neusoft.FrameWork.Models.NeuObject();
HISFC.Models.Base.SexEnumService sexlist = new Neusoft.HISFC.Models.Base.SexEnumService();
if (flag % 2 == 0)
{
sexobj.ID = HISFC.Models.Base.EnumSex.F.ToString();
sexobj.Name = sexlist.GetName(HISFC.Models.Base.EnumSex.F);
}
else
{
sexobj.ID = HISFC.Models.Base.EnumSex.M.ToString();
sexobj.Name = sexlist.GetName(HISFC.Models.Base.EnumSex.M);
}
return(sexobj);
}
/// <summary>
/// 进入PACU的病人统计
/// </summary>
/// <param name="DeptID">科室编码</param>
/// <param name="BeginTime">起始时间</param>
/// <param name="EndTime">终止时间</param>
/// <returns>符合条件的数据行数组（元素为反映数据行信息的数组）</returns>
public ArrayList GetReport12(string DeptID, DateTime BeginTime, DateTime EndTime)
{
ArrayList al = new ArrayList();
ArrayList alDataRow = new ArrayList();
Neusoft.HISFC.Models.Base.SexEnumService sex = new Neusoft.HISFC.Models.Base.SexEnumService();
string strCount = string.Empty;
string strSql = string.Empty;
if (this.Sql.GetSql("Operator.OpsReport.GetReport12", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, DeptID, BeginTime.ToString(), EndTime.ToString());
}
catch (Exception ex)
{
this.Err = "Operator.OpsReport.GetReport12";
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
if (strSql == null)
{
return(null);
}
this.ExecQuery(strSql);
try
{
while (this.Reader.Read())
{
alDataRow.Clear();
sex.ID = Reader[0].ToString();
strCount = Reader[1].ToString();
//将当前行数据加载
alDataRow.Add(sex.Name);
alDataRow.Add(strCount);
al.Add(alDataRow.Clone());
}
}
catch (Exception ex)
{
this.Err = "Operator.OpsReport.GetReport12";
this.ErrCode = ex.Message;
this.WriteErr();
this.Reader.Close();
return(null);
}
this.Reader.Close();
return(al);
}
/// <summary>
/// 手术患者信息查询
/// </summary>
/// <param name="BeginTime">起始时间</param>
/// <param name="EndTime">终止时间</param>
/// <returns>符合条件的数据行数组（元素为反映数据行信息的数组）</returns>
public ArrayList GetReport03(DateTime BeginTime, DateTime EndTime)
{
ArrayList al = new ArrayList();
ArrayList alDataRow = new ArrayList();
//Neusoft.HISFC.BizLogic.Manager.UserManager userManager = new Neusoft.HISFC.BizLogic.Manager.UserManager();
#region 获取数据的变量
string strName = string.Empty; //姓名
string strBedNo = string.Empty; //床号
string strPatientNo = string.Empty; //住院号/病案号
Neusoft.HISFC.Models.Base.SexEnumService sex = new Neusoft.HISFC.Models.Base.SexEnumService(); //性别
//获取年龄
int iBirthYear = 0; //出生年
int iThisYear = 0; //本年
string strAge = string.Empty; //年龄
string strDiagnose = string.Empty; //术前诊断
string strItem = string.Empty; //手术名称(主手术)
string strEnterDate = string.Empty; //开始手术时间
string strOutDate = string.Empty; //结束手术时间
string strOpsDoct = string.Empty; //手术医生
string strAnesType = string.Empty; //麻醉方式
Neusoft.FrameWork.Models.NeuObject OpsKind = new Neusoft.FrameWork.Models.NeuObject(); //手术分类
#endregion
string strSql = string.Empty;
if (this.Sql.GetSql("Operator.OpsReport.GetReport03", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, BeginTime.ToString(), EndTime.ToString());
}
catch (Exception ex)
{
this.Err = "Operator.OpsReport.GetReport03";
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
if (strSql == null)
{
return(null);
}
this.ExecQuery(strSql);
try
{
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Base.Employee employee = new Neusoft.HISFC.Models.Base.Employee();
alDataRow.Clear();
strName = Reader[0].ToString(); //姓名
strBedNo = Reader[1].ToString(); //床号
strPatientNo = Reader[2].ToString(); //住院号/病案号
sex.ID = Reader[3].ToString(); //性别
iBirthYear = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[4].ToString()).Year;
iThisYear = this.GetDateTimeFromSysDateTime().Year;
strAge = System.Convert.ToString(iThisYear - iBirthYear); //年龄
strDiagnose = Reader[5].ToString(); //术前诊断
strItem = Reader[6].ToString(); //手术名称
strEnterDate = Reader[7].ToString(); //手术开始时间
strOutDate = Reader[8].ToString(); //手术结束时间
employee.ID = Reader[9].ToString();
strOpsDoct = employee.Name; //手术医生
strAnesType = Reader[10].ToString(); //麻醉方式
OpsKind.ID = Reader[11].ToString(); //手术分类
switch (OpsKind.ID.ToString())
{
case "1": //普通
OpsKind.Name = "普通";
break;
case "2": //急诊
OpsKind.Name = "急诊";
break;
case "3": //感染
OpsKind.Name = "感染";
break;
default:
OpsKind.Name = string.Empty;
break;
}
//将当前行数据加载
alDataRow.Add(strName);
alDataRow.Add(strBedNo);
alDataRow.Add(strPatientNo);
alDataRow.Add(sex.Name);
alDataRow.Add(strAge);
alDataRow.Add(strDiagnose);
alDataRow.Add(strItem);
alDataRow.Add(strEnterDate);
alDataRow.Add(strOutDate);
alDataRow.Add(strOpsDoct);
alDataRow.Add(strAnesType);
alDataRow.Add(OpsKind.Name);
al.Add(alDataRow.Clone());
}
}
catch (Exception ex)
{
this.Err = "Operator.OpsReport.GetReport03";
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
this.Reader.Close();
return(al);
}
