/// <summary>
/// 根据报表编码获取报表实体
/// </summary>
/// <param name="ParentGroupID">父级组编码</param>
/// <param name="GroupID">本级组编码</param>
/// <param name="ReportID">报表编码</param>
/// <returns></returns>
public Neusoft.HISFC.Models.Base.Report GetReport(string ParentGroupID, string GroupID, string ReportID)
{
Neusoft.HISFC.Models.Base.Report Report = new Neusoft.HISFC.Models.Base.Report();
string strSql = "";
string strSqlwhere = "";
if (this.Sql.GetSql("Manager.Report.GetReport.Select.1", ref strSql) == -1)
{
return(null);
}
if (this.Sql.GetSql("Manager.Report.GetReport.Where.1", ref strSqlwhere) == -1)
{
return(null);
}
try
{
//获取手术室正台分配信息
strSqlwhere = string.Format(strSqlwhere, ParentGroupID, GroupID, ReportID);
}
catch {}
if (strSql == null)
{
return(null);
}
if (strSqlwhere == null)
{
return(null);
}
strSql = strSql + " \n " + strSqlwhere;
this.ExecQuery(strSql);
try
{
while (this.Reader.Read())
{
//Reader[0]父级组别编码
//Reader[1]本级组别编码
//Reader[2]报表编码
Report.ID = Reader[2].ToString(); //报表编码
Report.Name = Reader[3].ToString(); //报表名称
Report.CtrlName = Reader[4].ToString(); //控件名称
Report.Parm = Reader[5].ToString(); //传入参数
Report.SpecialFlag = Reader[6].ToString(); //特殊标记
Report.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(Reader[7].ToString()); //是否有效
Report.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[10].ToString()); //序号
}
}
catch (Exception ex)
{
this.Err = "HisFC.Manager.Report.GetReport where1";
this.ErrCode = "获得报表信息出错！" + ex.Message;
this.WriteErr();
return(null);
}
this.Reader.Close();
return(Report);
}
/// <summary>
/// 修改报表
/// </summary>
/// <returns>0 success -1 fail</returns>
public int UpdateReport(Neusoft.HISFC.Models.Base.Report info)
{
string strSql = "";
if (this.Sql.GetSql("Management.Manager.Report.UpdateReport", ref strSql) == -1)
{
return(-1);
}
try
{
string OperId = this.Operator.ID;
string IsValid = "";
if (info.IsValid)
{
IsValid = "1";
}
else
{
IsValid = "0";
}
strSql = string.Format(strSql, info.Name, info.CtrlName, info.Parm, info.SpecialFlag, IsValid, OperId, info.ID, info.SortID);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 按组显示报表
/// </summary>
/// <param name="GroupID"></param>
/// <returns></returns>
public ArrayList GetReportAllByGroupID(string GroupID)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Management.Manager.Report.GetReportAllByGroupID", ref strSql) == -1)
{
return(null);
}
strSql = string.Format(strSql, GroupID);
this.ExecQuery(strSql);
try
{
List = new ArrayList();
Neusoft.HISFC.Models.Base.Report Report = null;
while (this.Reader.Read())
{
Report = new Neusoft.HISFC.Models.Base.Report();
//Reader[0]父级组别编码
//Reader[1]本级组别编码
//Reader[2]报表编码
Report.ID = Reader[2].ToString(); //报表编码
Report.Name = Reader[3].ToString(); //报表名称
Report.CtrlName = Reader[4].ToString(); //控件名称
Report.Parm = Reader[5].ToString(); //传入参数
Report.SpecialFlag = Reader[6].ToString(); //特殊标记
Report.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(Reader[7].ToString()); //是否有效
Report.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[10].ToString()); //序号
List.Add(Report);
Report = null;
}
}
catch (Exception ex)
{
this.Err = "HisFC.Manager.Report.GetReport where1";
this.ErrCode = "获得报表信息出错！" + ex.Message;
return(null);
}
this.Reader.Close();
return(List);
}
/// <summary>
/// 删除报表
/// </summary>
/// <returns>0 success -1 fail</returns>
public int DelReport(Neusoft.HISFC.Models.Base.Report info)
{
string strSql = "";
if (this.Sql.GetSql("Management.Manager.Report.DelReport", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.ParentCode, info.ID);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
