protected void btnDelete_Click(object sender, System.EventArgs e) { System.Collections.Generic.List <TreasuryStorckParms> list = new System.Collections.Generic.List <TreasuryStorckParms>(); foreach (GridViewRow gridViewRow in this.gvwTreasury.Rows) { CheckBox checkBox = gridViewRow.FindControl("chkSelectSingle") as CheckBox; if (checkBox != null && checkBox.Checked) { string resourcCode = this.gvwTreasury.DataKeys[gridViewRow.RowIndex]["ResourceCode"].ToString(); decimal sprice = System.Convert.ToDecimal(this.gvwTreasury.DataKeys[gridViewRow.RowIndex]["sprice"].ToString()); string cropId = this.gvwTreasury.DataKeys[gridViewRow.RowIndex]["CorpId"].ToString(); list.Add(new TreasuryStorckParms { cropId = cropId, sprice = sprice, resourcCode = resourcCode }); } } TreasuryStockBll treasuryStockBll = new TreasuryStockBll(); string selectedValue = this.tvTreasury.SelectedValue; treasuryStockBll.DeleteByUnite(selectedValue, list); this.BindGridView(selectedValue); }
public DataTable GetExportDataSource() { DataTable dataTable = new DataTable(); dataTable.Columns.Add("序号"); dataTable.Columns.Add("资源编号"); dataTable.Columns.Add("资源名称"); dataTable.Columns.Add("规格"); dataTable.Columns.Add("品牌"); dataTable.Columns.Add("型号"); dataTable.Columns.Add("技术参数"); dataTable.Columns.Add("单位"); dataTable.Columns.Add("单价"); dataTable.Columns.Add("数量"); dataTable.Columns.Add("小计"); dataTable.Columns.Add("供应商"); dataTable.Columns.Add("仓库名称"); DataTable treasuryData = new TreasuryStockBll().GetTreasuryData(this.txtResourceName.Text.Trim(), this.txtResourceCode.Text.Trim(), this.txtTrea.Text.Trim(), this.txtCorpName.Text.Trim(), base.UserCode, this.txtSpecification.Text.Trim(), this.txtBrand.Text.Trim(), this.txtModelNumber.Text.Trim()); if (treasuryData.Rows.Count > 0) { for (int i = 0; i < treasuryData.Rows.Count; i++) { DataRow dataRow = dataTable.NewRow(); dataRow["序号"] = (i + 1).ToString(); dataRow["资源编号"] = treasuryData.Rows[i]["scode"].ToString(); dataRow["资源名称"] = treasuryData.Rows[i]["ResourceName"].ToString(); dataRow["规格"] = treasuryData.Rows[i]["Specification"].ToString(); dataRow["品牌"] = treasuryData.Rows[i]["Brand"].ToString(); dataRow["型号"] = treasuryData.Rows[i]["ModelNumber"]; dataRow["技术参数"] = treasuryData.Rows[i]["TechnicalParameter"]; dataRow["单位"] = treasuryData.Rows[i]["Name"].ToString(); dataRow["数量"] = treasuryData.Rows[i]["snumber"].ToString(); dataRow["单价"] = treasuryData.Rows[i]["sprice"].ToString(); dataRow["小计"] = treasuryData.Rows[i]["total"].ToString(); dataRow["供应商"] = treasuryData.Rows[i]["CorpName"].ToString(); dataRow["仓库名称"] = treasuryData.Rows[i]["tname"].ToString(); dataTable.Rows.Add(dataRow); } DataRow dataRow2 = dataTable.NewRow(); dataRow2["序号"] = "合计"; dataRow2["资源编号"] = ""; dataRow2["资源名称"] = ""; dataRow2["规格"] = ""; dataRow2["品牌"] = ""; dataRow2["型号"] = ""; dataRow2["技术参数"] = ""; dataRow2["单位"] = ""; dataRow2["数量"] = ""; dataRow2["单价"] = ""; dataRow2["小计"] = Convert.ToString(treasuryData.Compute("Sum(total)", string.Empty)); dataRow2["供应商"] = ""; dataRow2["仓库名称"] = ""; dataTable.Rows.Add(dataRow2); } return(dataTable); }
private void BindGvw() { DataTable treasuryData = new TreasuryStockBll().GetTreasuryData(this.txtResourceName.Text.Trim(), this.txtResourceCode.Text.Trim(), this.txtTrea.Text.Trim(), this.txtCorpName.Text.Trim(), base.UserCode, this.txtSpecification.Text.Trim(), this.txtBrand.Text.Trim(), this.txtModelNumber.Text.Trim()); if (treasuryData.Rows.Count == 0) { treasuryData.Rows.Add(treasuryData.NewRow()); this.gvwTreasury.DataSource = treasuryData; this.gvwTreasury.DataBind(); this.gvwTreasury.Rows[0].Visible = false; return; } this.gvwTreasury.DataSource = treasuryData; this.gvwTreasury.DataBind(); string total = Convert.ToString(treasuryData.Compute("Sum(total)", string.Empty)); GridViewUtility.AddTotalRow(this.gvwTreasury, total, 10); }