4,819
社区成员




private void BindCrv()
{
ReportDocument doc = new ReportDocument();
string path = Server.MapPath("CrystalReport1.rpt");
doc.FileName = path;
SqlConnection dbCon = PubClass.GetSqlConnection();
SqlDataAdapter da = new SqlDataAdapter("wsp_report_1", dbCon);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@hoscode", SqlDbType.VarChar, 20).Value = this.ddlDanw.SelectedValue;
da.SelectCommand.Parameters.Add("@qssj", SqlDbType.DateTime).Value = DateTime.Parse(this.txtRq1.Text + " 00:00:00");
da.SelectCommand.Parameters.Add("@jssj", SqlDbType.DateTime).Value = DateTime.Parse(this.txtRq2.Text + " 23:59:59");
da.SelectCommand.Parameters.Add("@sheng", SqlDbType.VarChar, 40).Value = this.DropDownList1.SelectedValue;
da.SelectCommand.Parameters.Add("@city", SqlDbType.VarChar, 40).Value = this.DropDownList2.SelectedValue;
da.SelectCommand.Parameters.Add("@qixian", SqlDbType.VarChar, 60).Value = this.DropDownList3.SelectedValue;
da.SelectCommand.Parameters.Add("@xiangz", SqlDbType.VarChar, 50).Value = this.DropDownList4.SelectedValue;
DataSet ds = new DataSet1();
dbCon.Open();
da.Fill(ds, "wsp_report_1");
dbCon.Close();
doc.SetDataSource(ds.Tables["wsp_report_1"]);
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField.Name = "sj";
discreteVal.Value = this.txtRq1.Text + " - " + this.txtRq2.Text;
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
paramField = new ParameterField();
discreteVal = new ParameterDiscreteValue();
paramField.Name = "diq";
string strDiq = this.DropDownList1.SelectedItem.Text + this.DropDownList2.SelectedItem.Text + this.DropDownList3.SelectedItem.Text + this.DropDownList4.SelectedItem.Text;
if(strDiq == "")
{
strDiq = "全部地区";
}
discreteVal.Value = strDiq;
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
paramField = new ParameterField();
discreteVal = new ParameterDiscreteValue();
paramField.Name = "danw";
string strDanw = this.ddlDanw.SelectedItem.Text;
if(strDanw == "")
{
strDanw = "全部单位";
}
discreteVal.Value = strDanw;
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
this.CRV.ParameterFieldInfo = paramFields;
this.CRV.ReportSource = doc;
}
protected void CRV_Navigate(object source, NavigateEventArgs e)
{
BindCrv();
}
protected void CRV_ReportRefresh(object source, ViewerEventArgs e)
{
BindCrv();
}
protected void CRV_Search(object source, SearchEventArgs e)
{
BindCrv();
}