protected void BtnToReport_Click(object sender, EventArgs e)
{
if (IsNullorEmpty(this.txtKey.Text.Trim()))
{
this.MsgForm("料號不能位空!請輸入料號進行列印!");
return;
}
MyRpt.Init();
DataSet ds_Main = BindData(this.txtKey.Text);//綁定GridView
MyRpt.ReportID = "0001";
MyRpt.ReportTitle = "料號倉庫查詢";
MyRpt.ReportName = "wms_houselist_byitem.rpt";
MyRpt.ReportDataSetMain = ds_Main;
SC.MySqlBase.ReSetConnectionString();
this.OpenPreview();
}
private DataSet BindData(string keyword)
{
SqlParameter[] parm = new SqlParameter[1];
parm[0] = new SqlParameter("@item", keyword);
DataSet ds = MySqlBase.GetVarsAsDataSet("wms_warehouse_Byitem_qry", parm);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
return ds;
}