期初打印明细查询优化

cnf

7 天以前 eb86c89d85599da5b3f237a0e1214e45f6a90225

 WebApi/Gs.Report/XlsInOutController.cs

@@ -89,6 +89,78 @@
        }
    }


    /// <summary>
    ///导出xls，动态解析存储过程参数
    /// </summary>
    /// <param name="mode"></param>
    /// <returns></returns>

    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<ExpandoObject> XlsOutView_NEW([FromBody] dynamic mode)
    {
        string rptParameter = mode.outParameter;
        var paramDict = new Dictionary<string, object>();
        // 动态解析参数
        if (mode.outParams != null)
        {
            foreach (var prop in mode.outParams)
            {
                string name = prop.Name;
                object value = prop.Value;
                paramDict.Add(name, value);
            }
        }
        var _pdfFloder = AppSettingsHelper.getValueByKey("DownPath");
        var _pdfName = Guid.NewGuid() + ".xls";
        var _pdfSaveFolder = Path.Combine(AppContext.BaseDirectory, _pdfFloder);
        if (!Directory.Exists(_pdfSaveFolder))
            Directory.CreateDirectory(_pdfSaveFolder);
        var pdfSavePath = Path.Combine(_pdfSaveFolder, _pdfName);
        dynamic m = new ExpandoObject();
        try
        {
            var dset = RunProcedure(rptParameter, paramDict);
            if (dset == null || dset.Tables.Count <= 0)
                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Exception, "没有查询到任何数据");
            var ary = new ArrayList();
            ExcelHelper.ExportAryHead(dset.Tables[0], ary, pdfSavePath);
            m.fileUrl = "down/" + _pdfName;
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "读取成功！");
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), ex.Message);
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Exception, "读取失败," + ex.Message);
        }
    }


    /// <summary>
    /// 通用存储过程执行方法
    /// </summary>
    private DataSet RunProcedure(string procName, IDictionary<string, object> paramDict)
    {
        var dset = new DataSet();
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var comm = new SqlCommand(procName, conn))
            {
                comm.CommandType = CommandType.StoredProcedure;
                // 动态添加参数
                foreach (var kvp in paramDict)
                {
                    comm.Parameters.AddWithValue("@" + kvp.Key, kvp.Value == null ? DBNull.Value : kvp.Value.ToString());
                }
                using (var adapter = new SqlDataAdapter(comm))
                {
                    adapter.Fill(dset, "0");
                }
            }
        }
        return dset;
    }

    /// <summary>
    ///     根据参数读取存储过程名称
    /// </summary>
@@ -446,6 +518,7 @@
            { "检验水平", "t9" },
            { "接受水平", "t10" },
            { "检验要求", "t11" },
            { "样品基数", "t12" },
        };
        string tmpGuid = mode.tmpGuid;
        string strType = mode.strType;//用于判断iqc,ipqc首检，ipqc巡检，fqc
@@ -483,6 +556,7 @@
                catch (Exception ex)
                {
                    rtnInt = -1;
                    LogHelper.Debug(this.ToString(), "XlsInItemJyxm:" + ex.Message);
                    sbMsg.Append("操作失败：" + ex.Message);
                }
                finally
@@ -517,6 +591,7 @@
        {
            _it = 0;
            _msg = "操作失败：读取文件时发生错误:" + ex.Message;
            LogHelper.Debug("", "XlsInItemJyxm:" + ex.Message);
        }

        if (string.IsNullOrEmpty(files))
@@ -567,6 +642,9 @@
                {
                    _it = 0;
                    _msg = "操作失败，bulkCopy读取上传文件发生错误：" + ex.Message;

                    LogHelper.Debug("", "XlsInItemJyxm:" + ex.Message);

                }
            }
        }