コード例 #1
0
        /// <summary>
        /// 将列的代码和行的代码转换成中文名称
        /// </summary>
        /// <param name="tbData"></param>
        /// <param name="style"></param>
        private static void ConvertCodeToName(BaseReport report)
        {
            for (int i = 0; i < report.BaseReportData.Rows.Count; i++)
            {
                string id = Convert.IsDBNull(report.BaseReportData.Rows[i]["ID"]) ? "0" : report.BaseReportData.Rows[i]["ID"].ToString( ).Trim( );
                id = id.Trim( ) == "" ? "0" : id;
                string code = Convert.IsDBNull(report.BaseReportData.Rows[i]["CODE"]) ? "0" : report.BaseReportData.Rows[i]["CODE"].ToString( ).Trim( );

                if (report is DoctorIncomeReport || report is TollerIncomeReport)
                {
                    id = PublicDataReader.GetEmployeeNameById(Convert.ToInt32(id));
                }
                else if (report is DepartmentIncomeReport)
                {
                    id = PublicDataReader.GetDeptNameById(Convert.ToInt32(id));
                }
                else if (report is PatientTypeIncomReport)
                {
                    id = PublicDataReader.GetPatientTypeNameByCode(id);
                }

                id = id.Trim( ) == "" ? "<未指定>" : id;
                if (report.StatType != StatClassType.收费支付类型)
                {
                    code = GetItemNameByCode(code, report.StatType);
                }

                report.BaseReportData.Rows[i]["ID"]   = id;
                report.BaseReportData.Rows[i]["CODE"] = code;
            }
        }
コード例 #2
0
ファイル: ReportClass.cs プロジェクト: yendux/BlueCloudHIS1.2
        /// <summary>
        /// 获取挂号统计报表(NAME,DATE,NUM)
        /// </summary>
        /// <param name="ViewType">0-按医生 1-按科室</param>
        /// <param name="beginDate"></param>
        /// <param name="endDate"></param>
        /// <returns></returns>
        public static DataSet GetRegisterReport(int ViewType, DateTime beginDate, DateTime endDate)
        {
            DataTable tbReg = GetRegisterData(beginDate, endDate);

            DataTable tbResultByName = new DataTable( );

            tbResultByName.TableName = "TB_A";
            tbResultByName.Columns.Add("CODE", Type.GetType("System.String"));
            tbResultByName.Columns.Add("NAME", Type.GetType("System.String"));
            tbResultByName.Columns.Add("NUM", Type.GetType("System.Int32"));
            tbResultByName.Columns.Add("MONEY", Type.GetType("System.Decimal"));

            DataTable tbResultByDate = new DataTable( );

            tbResultByDate.TableName = "TB_B";
            tbResultByDate.Columns.Add("DATE", Type.GetType("System.String"));
            tbResultByDate.Columns.Add("NUM", Type.GetType("System.Int32"));

            string fileName = "";

            if (ViewType == 0)
            {
                fileName = "PRESDOCCODE";
            }
            else
            {
                fileName = "PRESDEPTCODE";
            }

            for (int i = 0; i < tbReg.Rows.Count; i++)
            {
                string    code = tbReg.Rows[i][fileName].ToString().Trim();
                DataRow[] drs  = tbResultByName.Select("CODE='" + code + "'");
                if (drs.Length == 0)
                {
                    DataRow dr = tbResultByName.NewRow( );
                    dr["CODE"] = code;
                    if (ViewType == 0)
                    {
                        dr["NAME"] = code == "" ? "未指定" : PublicDataReader.GetEmployeeNameById(Convert.ToInt32(code));
                    }
                    else
                    {
                        dr["NAME"] = code == "" ? "未指定" : PublicDataReader.GetDeptNameById(Convert.ToInt32(code));
                    }

                    dr["NUM"] = tbReg.Rows[i]["REGNUM"];
                    tbResultByName.Rows.Add(dr);
                }
                else
                {
                    drs[0]["NUM"] = Convert.ToInt32(tbReg.Rows[i]["REGNUM"]) + (Convert.IsDBNull(drs[0]["NUM"]) ? 0 : Convert.ToInt32(drs[0]["NUM"]));
                }
                //日期
                drs = tbResultByDate.Select("DATE='" + Convert.ToDateTime(tbReg.Rows[i]["PRESDATE"]).ToString("yyyy-MM-dd") + "'");
                if (drs.Length == 0)
                {
                    DataRow dr = tbResultByDate.NewRow( );
                    dr["DATE"] = Convert.ToDateTime(tbReg.Rows[i]["PRESDATE"]).ToString("yyyy-MM-dd");
                    dr["NUM"]  = tbReg.Rows[i]["REGNUM"];
                    tbResultByDate.Rows.Add(dr);
                }
                else
                {
                    int num  = Convert.IsDBNull(drs[0]["NUM"]) ? 0 : Convert.ToInt32(drs[0]["NUM"]);
                    int num1 = Convert.IsDBNull(tbReg.Rows[i]["REGNUM"]) ? 0 : Convert.ToInt32(tbReg.Rows[i]["REGNUM"]);
                    num           = num + num1;
                    drs[0]["NUM"] = num;
                }
            }

            DataSet dsResult = new DataSet( );

            dsResult.Tables.Add(tbResultByName);
            dsResult.Tables.Add(tbResultByDate);

            return(dsResult);
        }