Exemple #1
0
        /// <summary>
        /// Task 90 打印文件生成函数
        /// TODO:仅实现了HTML格式的打印
        /// </summary>
        /// <param name="printConfigCode"></param>
        /// <returns></returns>
        public List <string> CreatePrintFiles(string templateFileName, string configFileName, string templateFileType, DataSet dataSet, string tempPrintFilePath, string tempPrintFilePathConfig)
        {
            StringBuilder sbTemplate = new StringBuilder();

            using (StreamReader sr = new StreamReader(templateFileName, Encoding.Default))
            {
                sbTemplate.Append(sr.ReadToEnd());
            }
            ///字段匹配配置文件格式:
            XmlWrapper xmlWrapper = new XmlWrapper(configFileName, LoadType.FromFile);
            ///主表配置信息
            PrintConfigXmlTableInfo printConfigXmlTableInfo = xmlWrapper.XmlToObject("/Table", typeof(PrintConfigXmlTableInfo)) as PrintConfigXmlTableInfo;

            if (string.IsNullOrEmpty(printConfigXmlTableInfo.AutoPrintFlag))
            {
                sbTemplate = sbTemplate.Replace("$AutoPrintFlag$", string.Empty);
            }
            else
            {
                if (printConfigXmlTableInfo.AutoPrintFlag.ToLower() == "true")
                {
                    sbTemplate = sbTemplate.Replace("$AutoPrintFlag$", "<script>window.onload = function () {window.print();function colseAfterPrint() {if (p = document.execCommand('print')) window.close();else setTimeout('colseAfterPrint();', 1000);}colseAfterPrint();}</script>");
                }
                else
                {
                    sbTemplate = sbTemplate.Replace("$AutoPrintFlag$", string.Empty);
                }
            }
            ///主表配置字段信息
            List <object> printConfigXmlFieldInfos = xmlWrapper.XmlToList("/Table/Field", typeof(PrintConfigXmlFieldInfo));
            ///明细行配置
            PrintConfigXmlDetailsInfo printConfigXmlDetailsInfo = xmlWrapper.XmlToObject("/Table/Details", typeof(PrintConfigXmlDetailsInfo)) as PrintConfigXmlDetailsInfo;
            ///明细行字段
            List <object> printConfigXmlDetailInfos = xmlWrapper.XmlToList("/Table/Details/Field", typeof(PrintConfigXmlFieldInfo));

            DataTable dataTable = dataSet.Tables[printConfigXmlTableInfo.TableName];

            if (dataTable == null && dataSet.Tables.Count > 0)
            {
                dataTable = dataSet.Tables[0];
            }
            List <string> printFiles = new List <string>();

            if (dataTable == null)
            {
                return(printFiles);
            }

            foreach (DataRow dr in dataTable.Rows)
            {
                ///主表填充
                string printContent = FillPrintContent(sbTemplate.ToString(), printConfigXmlFieldInfos, dr, tempPrintFilePath, tempPrintFilePathConfig);
                if (printConfigXmlDetailsInfo == null)
                {
                    string   saveFileName = printConfigXmlTableInfo.PrintFileName + "_" + DateTime.Now.Ticks + "." + templateFileType;
                    FileInfo fileInfo     = new FileInfo(saveFileName);
                    File.WriteAllText(tempPrintFilePath + @"\" + saveFileName
                                      , printContent
                                      , Encoding.GetEncoding("GB2312"));
                    printFiles.Add(tempPrintFilePathConfig + "/" + saveFileName);
                    continue;
                }
                string[] relationFields = printConfigXmlDetailsInfo.RelationFields.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
                string   conditions     = string.Empty;
                for (int i = 0; i < relationFields.Length; i++)
                {
                    string[] relationField = relationFields[i].Split(new char[] { '*' }, StringSplitOptions.RemoveEmptyEntries);
                    if (relationField.Length != 2)
                    {
                        continue;
                    }
                    conditions += "and " + relationField[0] + " = '" + dr[relationField[1]] + "'";
                }
                DataTable dtDetail = dataSet.Tables[printConfigXmlDetailsInfo.TableName];
                if (printConfigXmlDetailsInfo.TableName == printConfigXmlTableInfo.TableName)
                {
                    dtDetail = dataTable;
                }
                if (dtDetail == null && dataSet.Tables.Count > 1)
                {
                    dtDetail = dataSet.Tables[1];
                }
                if (dtDetail == null)
                {
                    string   saveFileName = printConfigXmlTableInfo.PrintFileName + "_" + DateTime.Now.Ticks + "." + templateFileType;
                    FileInfo fileInfo     = new FileInfo(saveFileName);
                    File.WriteAllText(tempPrintFilePath + @"\" + saveFileName
                                      , printContent
                                      , Encoding.GetEncoding("GB2312"));
                    printFiles.Add(tempPrintFilePathConfig + "/" + saveFileName);
                    continue;
                }
                ///明细数据
                DataRow[] detailTable;
                if (conditions.Length > 0)
                {
                    detailTable = dtDetail.Select(conditions.Substring(4));
                }
                else
                {
                    detailTable = new DataRow[dtDetail.Rows.Count];
                    for (int i = 0; i < dtDetail.Rows.Count; i++)
                    {
                        detailTable[i] = dtDetail.Rows[i];
                    }
                }

                ///每页最多几行明细
                int pageRowCnt = printConfigXmlDetailsInfo.MaxRow;

                int totalRowCnt = detailTable.Length;

                string detalRowTemplate = CreateHtmlDetailRowTemplate(sbTemplate.ToString());
                if (string.IsNullOrEmpty(detalRowTemplate))
                {
                    string   saveFileName = printConfigXmlTableInfo.PrintFileName + "_" + DateTime.Now.Ticks + "." + templateFileType;
                    FileInfo fileInfo     = new FileInfo(saveFileName);
                    File.WriteAllText(tempPrintFilePath + @"\" + saveFileName
                                      , printContent
                                      , Encoding.GetEncoding("GB2312"));
                    printFiles.Add(tempPrintFilePathConfig + "/" + saveFileName);
                    continue;
                }
                string emptyRowTemplate = CreateHtmlEmptyRowTemplate(detalRowTemplate);

                StringBuilder detailSb = new StringBuilder();
                ///当前页码
                int pageIndex = 0;
                while (totalRowCnt > 0)
                {
                    for (int i = 0; i < pageRowCnt; i++)
                    {
                        if (totalRowCnt > i)
                        {
                            ///
                            string detalRow = FillPrintContent(detalRowTemplate, printConfigXmlDetailInfos, detailTable[pageIndex * pageRowCnt + i], tempPrintFilePath, tempPrintFilePathConfig);
                            detailSb.Append(detalRow);
                            continue;
                        }
                        if (printConfigXmlDetailsInfo.FillEmpty)
                        {
                            detailSb.Append(emptyRowTemplate);
                        }
                    }
                    string   saveFileName = printConfigXmlTableInfo.PrintFileName + "_" + pageIndex + "_" + DateTime.Now.Ticks + "." + templateFileType;
                    FileInfo fileInfo     = new FileInfo(saveFileName);
                    File.WriteAllText(tempPrintFilePath + @"\" + saveFileName
                                      , printContent.Replace(detalRowTemplate, detailSb.ToString())
                                      , Encoding.GetEncoding("GB2312"));
                    printFiles.Add("../" + tempPrintFilePathConfig + "/" + saveFileName);
                    ///页码递增
                    pageIndex++;
                    ///
                    totalRowCnt -= pageRowCnt;
                    detailSb.Clear();
                    ///
                }
            }
            return(printFiles);
        }
Exemple #2
0
        public string CreatePrintFileByPageEntity(string templateFileName, string configFileName, string templateFileType, DataSet dataSet, string tempPrintFilePath, string tempPrintFilePathConfig)
        {
            StringBuilder sbTemplate  = new StringBuilder();
            StringBuilder tempBuilder = new StringBuilder();

            using (StreamReader sr = new StreamReader(templateFileName, Encoding.Default))
            {
                sbTemplate.Append(sr.ReadToEnd());
            }
            ///字段匹配配置文件格式:
            XmlWrapper xmlWrapper = new XmlWrapper(configFileName, LoadType.FromFile);
            ///主表配置信息
            PrintConfigXmlTableInfo printConfigXmlTableInfo = xmlWrapper.XmlToObject("/Table", typeof(PrintConfigXmlTableInfo)) as PrintConfigXmlTableInfo;
            ///主表配置字段信息
            List <object> printConfigXmlFieldInfos = xmlWrapper.XmlToList("/Table/Field", typeof(PrintConfigXmlFieldInfo));
            ///明细行配置
            PrintConfigXmlDetailsInfo printConfigXmlDetailsInfo = xmlWrapper.XmlToObject("/Table/Details", typeof(PrintConfigXmlDetailsInfo)) as PrintConfigXmlDetailsInfo;
            ///明细行字段
            List <object> printConfigXmlDetailInfos = xmlWrapper.XmlToList("/Table/Details/Field", typeof(PrintConfigXmlFieldInfo));
            DataTable     dataTable = dataSet.Tables[printConfigXmlTableInfo.TableName];

            if (dataTable == null && dataSet.Tables.Count > 0)
            {
                dataTable = dataSet.Tables[0];
            }
            string printFile = string.Empty;

            if (dataTable == null)
            {
                return(printFile);
            }
            if (dataTable.Rows.Count == 0)
            {
                return(printFile);
            }

            #region 变量初始化
            string        saveFileName    = string.Empty;
            StringBuilder bodymainBuilder = new StringBuilder();
            int           IsEspecial      = printConfigXmlTableInfo.IsEspecial;
            int           MaxRow;
            bool          FillEmpty = false;
            #endregion

            if (IsEspecial == 0)
            {
                MaxRow    = printConfigXmlDetailsInfo.MaxRow;
                FillEmpty = printConfigXmlDetailsInfo.FillEmpty;

                string pagetemplate = string.Empty;

                foreach (DataRow dr in dataTable.Rows)
                {
                    #region 获取明细数据源根据配置关联字段
                    string conditions = string.Empty;
                    conditions = "1 = 1";
                    string[] relationFields = printConfigXmlDetailsInfo.RelationFields.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);

                    string[] valueStr1 = relationFields[0].Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
                    string[] valueStr2 = relationFields[1].Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);

                    for (int i = 0; i < valueStr1.Length; i++)
                    {
                        conditions += "AND " + valueStr1[i] + " = '" + dr[valueStr2[i]].ToString() + "'";
                    }

                    DataRow[] dtDetail = dataSet.Tables[1].Select(conditions);
                    #endregion

                    int    allrows    = dtDetail.Length;                                                                                           //获取总行数
                    int    allpages   = (int)Math.Ceiling(decimal.Parse(allrows.ToString()) / decimal.Parse(MaxRow.ToString()));                   //获取总页数
                    int    emptycount = allpages * MaxRow - allrows;                                                                               //需要补空白行数
                    string mainStr    = CreateHtmlMaindivTemplate(sbTemplate.ToString());
                    pagetemplate = sbTemplate.ToString().Replace(mainStr, "<!--replacement_markers_allpages-->");                                  //整个页面填充标记
                    string detailsStr   = CreateHtmlDetailsTemplate(sbTemplate.ToString());
                    string tabfirstStr  = mainStr.Replace(detailsStr, "<!--replacement_markers_first-->");                                         //传入主数据填充 <!--replacement_markers_first--> => detailsStr
                    string detailRowStr = CreateHtmlDetailTemplate(sbTemplate.ToString());                                                         //传入明细填充数据
                    string printContent = FillPrintContent(tabfirstStr, printConfigXmlFieldInfos, dr, tempPrintFilePath, tempPrintFilePathConfig); ///主表填充
                    printContent = printContent.Replace(@"$PageCount$", allpages.ToString());
                    string tabsecondStr = detailsStr.Replace(detailRowStr, "<!--replacement_markers_second-->");                                   // <!--replacement_markers_second--> => detailRowStr
                    if (allrows == 0)
                    {
                        string printContentnew = printContent.Replace(@"$PageThis$", "1");
                        if (FillEmpty)
                        {
                            for (int i = 0; i < MaxRow; i++)
                            {
                                string emptyRowTemplate = CreateHtmlEmptyRowTemplate(detailRowStr);
                                tempBuilder.AppendLine(emptyRowTemplate);
                            }
                        }
                        string alldetailesStr = tabsecondStr.Replace("<!--replacement_markers_second-->", tempBuilder.ToString());
                        string pagemiandivStr = printContentnew.Replace("<!--replacement_markers_first-->", alldetailesStr);
                        bodymainBuilder.AppendLine(pagemiandivStr);
                        tempBuilder.Clear();
                    }

                    int sIndex   = 0;
                    int thispage = 1;
                    foreach (DataRow drDetails in dtDetail)
                    {
                        string rowTemplate = detailRowStr;
                        string detalRow    = FillPrintContent(rowTemplate, printConfigXmlDetailInfos, drDetails, tempPrintFilePath, tempPrintFilePathConfig);
                        detalRow = detalRow.Replace("$RowId$", (sIndex + 1).ToString());
                        tempBuilder.AppendLine(detalRow);

                        if (allrows > 1)
                        {
                            if ((sIndex + 1) % MaxRow == 0)
                            {
                                string printContentnew = printContent.Replace(@"$PageThis$", thispage.ToString());
                                thispage = thispage + 1;
                                string alldetailesStr = tabsecondStr.Replace("<!--replacement_markers_second-->", tempBuilder.ToString());
                                string pagemiandivStr = printContentnew.Replace("<!--replacement_markers_first-->", alldetailesStr);
                                bodymainBuilder.AppendLine(pagemiandivStr);
                                bodymainBuilder.AppendLine("<div class=\"PageNext\"></div>");
                                tempBuilder.Clear();
                            }
                        }
                        else
                        {
                            string printContentnew = printContent.Replace(@"$PageThis$", thispage.ToString());
                            if (FillEmpty)
                            {
                                for (int i = 0; i < emptycount; i++)
                                {
                                    string emptyRowTemplate = CreateHtmlEmptyRowTemplate(detailRowStr);
                                    tempBuilder.AppendLine(emptyRowTemplate);
                                }
                            }
                            string alldetailesStr = tabsecondStr.Replace("<!--replacement_markers_second-->", tempBuilder.ToString());
                            string pagemiandivStr = printContentnew.Replace("<!--replacement_markers_first-->", alldetailesStr);
                            bodymainBuilder.AppendLine(pagemiandivStr);
                            tempBuilder.Clear();
                        }

                        sIndex++;
                    }
                    if (tempBuilder.Length > 0)
                    {
                        if (FillEmpty)
                        {
                            for (int i = 0; i < emptycount; i++)
                            {
                                string emptyRowTemplate = CreateHtmlEmptyRowTemplate(detailRowStr);
                                tempBuilder.AppendLine(emptyRowTemplate);
                            }
                        }

                        string alldetailesStr = tabsecondStr.Replace("<!--replacement_markers_second-->", tempBuilder.ToString());
                        printContent = printContent.Replace(@"$PageThis$", thispage.ToString());
                        string pagemiandivStr = printContent.Replace("<!--replacement_markers_first-->", alldetailesStr);
                        bodymainBuilder.AppendLine(pagemiandivStr);
                        bodymainBuilder.AppendLine("<div class=\"PageNext\"></div>");
                        tempBuilder.Clear();
                    }
                }
                pagetemplate = pagetemplate.Replace("<!--replacement_markers_allpages-->", bodymainBuilder.ToString());

                saveFileName = printConfigXmlTableInfo.PrintFileName + "_" + DateTime.Now.Ticks + "." + templateFileType;
                FileInfo fileInfo = new FileInfo(saveFileName);
                File.WriteAllText(tempPrintFilePath + @"\" + saveFileName
                                  , pagetemplate.ToString()
                                  , Encoding.GetEncoding("GB2312"));
                return("../" + tempPrintFilePathConfig + "/" + saveFileName);
            }
            else if (IsEspecial == 1)
            {
                #region 单Table实体支持一页打印多个
                FillEmpty = printConfigXmlDetailsInfo.FillEmpty;
                MaxRow    = printConfigXmlDetailsInfo.MaxRow;

                int allrows  = dataTable.Rows.Count;                                                //获取总行数
                int allpages = (int)Math.Ceiling(Convert.ToDecimal((allrows / MaxRow).ToString())); //获取总页数

                int i = 0;
                foreach (DataRow dr in dataTable.Rows)
                {
                    string detalsTemplate   = CreateHtmlDetailsTemplate(sbTemplate.ToString());
                    string detalRowTemplate = CreateHtmlDetailRowTemplate(sbTemplate.ToString());
                    string detalRow         = FillPrintContent(detalRowTemplate, printConfigXmlDetailInfos, dataTable.Rows[i], tempPrintFilePath, tempPrintFilePathConfig);
                    detalRow = detalRow.Replace(@"$PageCount$", allrows.ToString());
                    detalRow = detalRow.Replace(@"$PageThis$", (i + 1).ToString());
                    tempBuilder.AppendLine(detalRow);

                    if (allrows > 1)
                    {
                        if ((i + 1) % MaxRow == 0)
                        {
                            detalsTemplate = detalsTemplate.Replace(detalRowTemplate, tempBuilder.ToString());
                            bodymainBuilder.AppendLine(detalsTemplate);
                            bodymainBuilder.AppendLine("<div class=\"PageNext\"></div>");
                            tempBuilder.Clear();
                        }
                    }
                    else
                    {
                        detalsTemplate = detalsTemplate.Replace(detalRowTemplate, tempBuilder.ToString());
                        bodymainBuilder.AppendLine(detalsTemplate);
                        tempBuilder.Clear();
                    }

                    i++;
                }
                if (tempBuilder.Length > 0)
                {
                    string detalsTemplate   = CreateHtmlDetailsTemplate(sbTemplate.ToString());
                    string detalRowTemplate = CreateHtmlDetailRowTemplate(sbTemplate.ToString());
                    detalsTemplate = detalsTemplate.Replace(detalRowTemplate, tempBuilder.ToString());
                    bodymainBuilder.AppendLine(detalsTemplate);
                    tempBuilder.Clear();
                }
                sbTemplate   = sbTemplate.Replace(CreateHtmlDetailsTemplate(sbTemplate.ToString()), bodymainBuilder.ToString());
                saveFileName = printConfigXmlTableInfo.PrintFileName + "_" + DateTime.Now.Ticks + "." + templateFileType;
                FileInfo fileInfo = new FileInfo(saveFileName);
                File.WriteAllText(tempPrintFilePath + @"\" + saveFileName
                                  , sbTemplate.ToString()
                                  , Encoding.GetEncoding("GB2312"));
                return("../" + tempPrintFilePathConfig + "/" + saveFileName);

                #endregion
            }
            return(saveFileName);
        }