采购订单、送货单页面查询条件及影藏列调整

YL

2022-02-25 fa81723ece156a1bf7df0652d65c61bc255c6dc0

 WebSRM/App_Data/MssqlReportData.cs

@@ -14,9 +14,11 @@
    //连接SQL Server数据库的连接串，应该修改为与实际一致。如果是运行Grid++Report本身的例子，应该首先附加例子数据库到
    //SQL Server2000/2005数据库上。
    //public const string SqlConnStr = "Data Source=(local);Initial Catalog=gridreport;Persist Security Info=True;User ID=sa;Password=;";
    // public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";
    //public const string SqlConnStr = "Data Source=47.96.97.237,15127;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";
    //夏宝
    public const string SqlConnStr = "Data Source=192.168.1.239;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";
    public const string SqlConnStr = "Data Source=192.168.1.239;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";
    //安瑞
    //public const string SqlConnStr = "Data Source=.;Initial Catalog=HX_LimsSys;Persist Security Info=True;User ID=HX_USER;Password=lc@841022;";

    //public string sServer;
    //public string sDataBase;
@@ -72,12 +74,37 @@
    //根据查询SQL,产生提供给报表生成需要的 XML 或 JSON 数据
    protected static void DoGenDetailData(System.Web.UI.Page DataPage, string QuerySQL, ResponseDataType DataType, bool IsJSON)
    {
        LogService.Write(QuerySQL);
        //SqlConnection conn = new SqlConnection(SqlConnStr);
        //try
        //{
        //    conn.Open();
        //    LogService.Write("Connection opened.");
        //    LogService.Write("Connection Properties:");
        //    LogService.Write("Connection String:{0}", conn.ConnectionString);
        //    LogService.Write("Database:{0}", conn.Database);
        //    LogService.Write("DataSource:{0}", conn.DataSource);
        //    LogService.Write("ServerVersion:{0}", conn.ServerVersion);
        //    LogService.Write("State:{0}", conn.State.ToString());
        //    LogService.Write("WorkstationId:{0}", conn.WorkstationId);
        //}
        //catch (SqlException e)
        //{
        //    LogService.Write("Error: " + e);
        //}
        //finally
        //{
        //    conn.Close();
        //    LogService.Write("Connection close.");
        //}
        SqlConnection ReportConn = new SqlConnection(SqlConnStr);
        SqlDataAdapter ReportDataAdapter = new SqlDataAdapter(QuerySQL, ReportConn);
        DataSet ReportDataSet = new DataSet();
        ReportConn.Open();
        //LogService.Write("State:" + ReportConn.State);
        ReportDataAdapter.Fill(ReportDataSet);
        ReportConn.Close();
        //LogService.Write("hangshu :" + ReportDataSet.Tables[0].Rows.Count);

        if (IsJSON)
            JSONReportData.GenDataSet(DataPage, ReportDataSet, DataType);