110,536
社区成员
发帖
与我相关
我的任务
分享
string sql_str = "SELECT 线上配送订单结果表.订单业种结果,线上配送订单结果表.扩销金额结果, 线上配送订单结果表.订单笔数" +
" FROM 线上配送订单结果表 INNER JOIN 业种维度名称表 ON 线上配送订单结果表.订单业种结果=业种维度名称表.维度业种"+
" UNION ALL SELECT 超市店铺名称,超市扩销金额,超市订单笔数 FROM 线上配送订单表超市结果";
cmd = new OleDbCommand(sql_str, conn);
conn.Open();
find_do = new OleDbDataAdapter();
find_do.SelectCommand = cmd;
ds = new DataSet();
find_do.Fill(ds, "rs");
conn.Close();
DataTable dataTable = ds.Tables["rs"];
int ab = 0;
DataGridViewRowCollection rows = this.d_xs2.Rows;
foreach(DataGridViewRow row in rows)
{
ab += Convert.ToInt32(row.Cells[1].Value);
}
DataRow dataRows;
dataRows = dataTable.NewRow();
dataRows[0] = "合计";
dataRows[1] = ab;
dataTable.Rows.Add(dataRows);
this.d_xs2.DataSource = dataTable;