//报警删除 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string key1 = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); string key2 = GridView1.DataKeys[e.RowIndex].Values[1].ToString(); int flag = DataOperate.deleteInvoiceInfo(key1, key2); if (flag > 0) { string invoiceType = this.DropDownList1.SelectedValue.ToString(); //起始日期 string startDate = this.startDate.Text; //结束日期 string endDate = this.endDate.Text; //string endDate = this.DropDownList_DepotType.SelectedValue; //填充数据源 //GridView1.DataSource = CheckStatBll.getCheckStatByCondition(materialType, depotId, depotType, goodsName); string operatorID = Request.LogonUserIdentity.Name; DataSet ds = DataOperate.exportInvoiceInfo(invoiceType, startDate, endDate, operatorID); DataSet ds1 = DataOperate.queryInvoiceInfo(invoiceType, startDate, endDate, operatorID); GridView1.DataSource = ds1.Tables[0]; GridView1.DataKeyNames = new string[] { "InvoiceCode", "InvoiceNumber" };//主键 GridView1.DataBind(); GridView2.DataSource = ds.Tables[1]; GridView2.DataBind(); Response.Write("<script language=javascript>alert('删除发票代码:" + key1 + ",号码:" + key2 + "记录成功!');</script>"); } else { Response.Write("<script language=javascript>alert('删除发票记录失败!');</script>"); } }
protected void search_Click(object sender, EventArgs e) { //发票类型代码:00所有/01专票/04普票 string invoiceType = this.DropDownList1.SelectedValue.ToString(); //起始日期 string startDate = this.startDate.Text; //结束日期 string endDate = this.endDate.Text; string operatorID = Request.LogonUserIdentity.Name; if (invoiceType != "" && startDate != "" && endDate != "" && operatorID != "") { DataSet ds = DataOperate.queryInvoiceInfo(invoiceType, startDate, endDate, operatorID); GridView1.DataSource = ds.Tables[0]; GridView1.DataKeyNames = new string[] { "InvoiceCode", "InvoiceNumber" };//主键 GridView1.DataBind(); if (!(ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)) { Response.Write("<script language=javascript>alert('该时间段内没有该类型发票!');</script>"); } } else { Response.Write("<script language=javascript>alert('请完善查询起止日期!');</script>"); } }
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { //GridView1.PageIndex = e.NewPageIndex; //GridView1.DataBind(); // 得到该控件 GridView theGrid = sender as GridView; int newPageIndex = 0; if (e.NewPageIndex == -3) { //点击了Go按钮 TextBox txtNewPageIndex = null; //GridView较DataGrid提供了更多的API,获取分页块可以使用BottomPagerRow 或者TopPagerRow,当然还增加了HeaderRow和FooterRow GridViewRow pagerRow = theGrid.BottomPagerRow; if (pagerRow != null) { //得到text控件 txtNewPageIndex = pagerRow.FindControl("txtNewPageIndex") as TextBox; } if (txtNewPageIndex != null) { //得到索引 newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; } } else { //点击了其他的按钮 newPageIndex = e.NewPageIndex; } //防止新索引溢出 newPageIndex = newPageIndex < 0 ? 0 : newPageIndex; newPageIndex = newPageIndex >= theGrid.PageCount ? theGrid.PageCount - 1 : newPageIndex; //得到新的值 theGrid.PageIndex = newPageIndex; //发票类型代码:00所有/01专票/04普票 string invoiceType = this.DropDownList1.SelectedValue.ToString(); //起始日期 string startDate = this.startDate.Text; //结束日期 string endDate = this.endDate.Text; string operatorID = Request.LogonUserIdentity.Name; if (invoiceType != "" && startDate != "" && endDate != "" && operatorID != "") { //重新绑定 DataSet ds = DataOperate.queryInvoiceInfo(invoiceType, startDate, endDate, operatorID); GridView1.DataSource = ds.Tables[0]; GridView1.DataKeyNames = new string[] { "InvoiceCode", "InvoiceNumber" };//主键 theGrid.DataBind(); if (!(ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)) { Response.Write("<script language=javascript>alert('该时间段内没有该类型发票!');</script>"); } } else { Response.Write("<script language=javascript>alert('请完善查询起止日期!');</script>"); } }