SqlConnection scn = new SqlConnection();//连接设定
    Access acc = new Access();   //操作基础类

    string beginDate = "";
    string enddate = "";
    string txtUserid = "";

    /// <summary>
    /// 国际惯例取字符串
    /// </summary>
    ///<param name="scn">连接的SqlDataConnection</param>
    private void getscnstr(SqlConnection Scn)
    {
        if (scn.ConnectionString == "")
        {
            Scn.ConnectionString = acc.ScnConnStr;
        }
    }

    /// <summary>
    /// 国际惯例芝麻开门
    /// </summary>
    /// <param name="scn">连接的SqlDataConnection</param>
    private void OpenConn(SqlConnection Scn)
    {
        if (scn.State == ConnectionState.Closed)
        {
            Scn.Open();
        }
    }

    private void MessageBoxShow(String Errstr)//信息提示
    {
        Response.Write("<scr" + "ipt> alert('" + Errstr + "') </scr" + "ipt>");
    }

 private DataTable GetSpdt(out DataTable spdt,string seUserid,string BeginDate,string Enddate)
    {
        try
        {
            spdt = null;
            string Userid = (string)(Session["LoginUser"]);
            string UserAuthority = (string)(Session["Authority"]);

            getscnstr(scn);
            OpenConn(scn);

            string sqlstr2 = "SELECT * FROM uvw_IsPrincipal WHERE FnAME='" + Userid + "' AND IsPrincipal=1 ";
            DataTable dt2 = acc.GetSereachData(scn, sqlstr2);
            if (dt2.Rows.Count == 0)
            {
                    seUserid = Userid;
            }

            getscnstr(scn);
            OpenConn(scn);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "usp_DalayReoprt";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = scn;

            cmd.Parameters.Add("@PositionCode", SqlDbType.VarChar);
            cmd.Parameters["@PositionCode"].Value = UserAuthority;
            cmd.Parameters.Add("@Code", SqlDbType.VarChar);
            cmd.Parameters["@Code"].Value = "'%"+seUserid+"%'";
            cmd.Parameters.Add("@BeingDate", SqlDbType.VarChar);
            cmd.Parameters["@BeingDate"].Value = "'"+BeginDate+"'";
            cmd.Parameters.Add("@EndDate", SqlDbType.VarChar);
            cmd.Parameters["@EndDate"].Value = "'" + Enddate + "'";

            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            //DataTable DDT = new DataTable();
            //DataSet ds=new DataSet();
            sda.Fill(spdt);
            //spdt = ds.Tables[0];
            return  spdt;
        }
        catch (Exception ex)
        {
            MessageBoxShow(ex.ToString());
            spdt = null;
            return spdt;
        }        
    }

 private void getscnstr(SqlConnection Scn)
    {
        if (scn.ConnectionString == "")
        {
            Scn.ConnectionString = acc.ScnConnStr;
        }
    }