//分页 protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { string po_no = id_po_NO.Value.Trim(); string item_name = id_item_Name.Value.Trim(); string receipt_no = id_receipt_NO.Value.Trim(); GridView1.PageIndex = e.NewPageIndex; Receive_mtlDC receive_mtlDC = new Receive_mtlDC();//po退回的DataCenter对象 DataSet ds = receive_mtlDC.getSomeFieldsByReceipt_noAndPO_noAndItem_name(receipt_no, po_no, item_name); GridView1.DataSource = ds; GridView1.DataBind(); }
//查询 protected void select_click(object sender, EventArgs e) { string po_no = id_po_NO.Value.Trim(); string item_name = id_item_Name.Value.Trim(); string receipt_no = id_receipt_NO.Value.Trim(); Receive_mtlDC receive_mtlDC = new Receive_mtlDC();//po退回的DataCenter对象 DataSet ds = receive_mtlDC.getSomeFieldsByReceipt_noAndPO_noAndItem_name(receipt_no, po_no, item_name); if (ds == null) { PageUtil.showToast(this, "未查询到数据!"); id_receipt_NO.Value = ""; id_item_Name.Value = ""; id_po_NO.Value = ""; return; } else { DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { try { dt.Rows[i]["rcv_qty"] = int.Parse(dt.Rows[i]["rcv_qty"].ToString()) - int.Parse(dt.Rows[i]["return_qty"].ToString()) - int.Parse(dt.Rows[i]["deliver_qty"].ToString()); } catch (Exception ex) { //PageUtil.showToast(this, "数据异常"); Console.Write(ex.Source); } } GridView1.DataSource = ds; GridView1.DataBind(); } }