/// <summary>
/// 绑定Grid
/// </summary>
protected void BindGrid()
{
UStockCheckDetail_JoeyBB stockCheckDetail_JoeyBB = new UStockCheckDetail_JoeyBB();
DataSet ds = new DataSet();
try
{
// this.StrWhere = "StockCheckBillNo = '"+this.tbStockCheckBillNo.Text.ToString().Trim()+"'";
//string sql = "select * from vUStockCheckDetail_Joey where StockCheckBillNo = '" + this.tbStockCheckBillNo.Text.ToString().Trim() + "'";
string StockCheckBillNo = this.tbStockCheckBillNo.Text.ToString().Trim();
string material = this.tbMaterial.Text.ToString().Trim();
string boxno = this.tbBoxNo.Text.ToString().Trim();
string wareNo = this.ddlWare.SelectedValue;
string warelocatorNo = this.TextBox2.Text.ToString().Trim();
string empNm = this.TextBox1.Text.ToString().Trim();
string CheckResult = this.ddStockResult.SelectedValue;
string strStartDt = "";
string strEndDt = "";
//开始盘点日期
if (!string.IsNullOrEmpty(this.tbStockStartDt.Text.Trim()))
{
strStartDt = this.tbStockStartDt.Text.Trim().ToUpper();
}
//截止盘点日期
if (!string.IsNullOrEmpty(this.tbStockEndDt.Text.Trim()))
{
strEndDt = this.tbStockEndDt.Text.Trim().ToUpper();
}
string sql = "exec [dbo].[Report_GetStcockResult] '" + StockCheckBillNo + "','" + material + "','" + boxno + "','" + wareNo + "','" + warelocatorNo + "','" + empNm + "','" + CheckResult + "','" + strStartDt + "','" + strEndDt + "'";
DataTable dt = SQLHelperDM.ExecuteDataSet(HS.Config.SqlDataObject.GetJoeyConnectionString, sql).Tables[0];
this.grid.DataSource = dt;
this.grid.DataBind();
//赋值记录条数、页面总数
this.Label3.Text = dt.Rows.Count.ToString();
this.Label2.Text = this.grid.PageCount.ToString();
this.currPage.Text = (this.grid.PageIndex + 1).ToString();
}
finally
{
stockCheckDetail_JoeyBB.Dispose();
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
bool retChecked = false;
UStockCheckDetail_JoeyBB stockCheckDetail_JoeyBB = new UStockCheckDetail_JoeyBB();
try
{
//获取选中的数据Id
foreach (GridViewRow gvrow in this.grid.Rows)
{
CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
if (chkId.Checked == true)
{
retChecked = true;
int id = int.Parse(chkId.ValidationGroup);
stockCheckDetail_JoeyBB.DeleteRecord(id);
}
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
return;
}
finally
{
stockCheckDetail_JoeyBB.Dispose();
}
if (retChecked)
{
this.BindGrid();
}
}
