protected void btnSCBB_Click(object sender, EventArgs e)
{
Label6.Text = "";
RuK_DuiBiReport model = new RuK_DuiBiReport();;
model.YEAR = txtYEAR.Text;
model.MONTH = txtMOUTH.Text;
// model.LB = Convert.ToInt32(rbl1.SelectedItem.Text);
model.LB = Convert.ToInt32(rbl1.SelectedValue);
string token = Convert.ToString(HttpContext.Current.Session["token"]);
DataTable dt = Report.RuK_DuiBiReport(model, token);
dt.Columns.Add("平均单价环比", typeof(string));
dt.Columns.Add("平均单价同比", typeof(string));
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (Convert.ToDecimal(dr["price1"]) == 0)
{
dr["平均单价环比"] = 0.00 + "%";
}
else
{
dr["平均单价环比"] = Math.Round(Convert.ToDecimal((Convert.ToDecimal(dr["price2"]) - Convert.ToDecimal(dr["price1"])) / Convert.ToDecimal(dr["price1"]) * 100), 2, MidpointRounding.AwayFromZero) + "%";
}
if (Convert.ToDecimal(dr["Lastprice2"]) == 0)
{
dr["平均单价同比"] = 0.00 + "%";
}
else
{
dr["平均单价同比"] = Math.Round(Convert.ToDecimal(((Convert.ToDecimal(dr["price2"]) - Convert.ToDecimal(dr["Lastprice2"])) / Convert.ToDecimal(dr["Lastprice2"]) * 100)), 2, MidpointRounding.AwayFromZero) + "%";
}
}
if (rbl1.SelectedValue == "1")
{
dt.Columns["mtName"].ColumnName = "物料名称";
dt.Columns["typeName"].ColumnName = "类别名称";
dt.Columns["mtUnit"].ColumnName = "单位";
dt.Columns["LastmtNumber2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购数量";
dt.Columns["LastmtTotal2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购金额";
dt.Columns["Lastprice2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月平均单价";
dt.Columns["mtNumber1"].ColumnName = "上月采购数量";
dt.Columns["mtTotal1"].ColumnName = "上月采购金额";
dt.Columns["price1"].ColumnName = "上月平均单价";
dt.Columns["mtNumber2"].ColumnName = txtMOUTH.Text + "月采购数量";
dt.Columns["mtTotal2"].ColumnName = txtMOUTH.Text + "月采购金额";
dt.Columns["price2"].ColumnName = txtMOUTH.Text + "月平均单价";
}
if (rbl1.SelectedValue == "2")
{
// dt.Columns["mtName"].ColumnName = "物料名称";
dt.Columns["typeName"].ColumnName = "类别名称";
dt.Columns["mtUnit"].ColumnName = "单位";
dt.Columns["LastmtNumber2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购数量";
dt.Columns["LastmtTotal2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购金额";
dt.Columns["Lastprice2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月平均单价";
dt.Columns["mtNumber1"].ColumnName = "上月采购数量";
dt.Columns["mtTotal1"].ColumnName = "上月采购金额";
dt.Columns["price1"].ColumnName = "上月平均单价";
dt.Columns["mtNumber2"].ColumnName = txtMOUTH.Text + "月采购数量";
dt.Columns["mtTotal2"].ColumnName = txtMOUTH.Text + "月采购金额";
dt.Columns["price2"].ColumnName = txtMOUTH.Text + "月平均单价";
}
// BANDHJ(dt);
}
else
{
Label6.Text = "没有数据！";
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
public DataTable RuK_DuiBiReport(RuK_DuiBiReport model, string ptoken)
{
return(client.RuK_DuiBiReport(model, ptoken));
}
protected void btnDC_Click(object sender, EventArgs e)
{
RuK_DuiBiReport model = new RuK_DuiBiReport();;
model.YEAR = txtYEAR.Text;
model.MONTH = txtMOUTH.Text;
model.LB = 1;
string token = Convert.ToString(HttpContext.Current.Session["token"]);
DataTable dt = Report.RuK_DuiBiReport(model, token);
AddColumns(dt);
model.LB = 2;
DataTable dt2 = Report.RuK_DuiBiReport(model, token);
AddColumns(dt2);
//dt.Columns.Add("平均单价环比", typeof(string));
//dt.Columns.Add("平均单价同比", typeof(string));
if (dt.Rows.Count > 0 && dt2.Rows.Count > 0)
{
//foreach (DataRow dr in dt.Rows)
//{
// if (Convert.ToDecimal(dr["price1"]) == 0)
// {
// dr["平均单价环比"] = 0.00 + "%";
// }
// else
// {
// dr["平均单价环比"] = Math.Round(Convert.ToDecimal((Convert.ToDecimal(dr["price2"]) - Convert.ToDecimal(dr["price1"])) / Convert.ToDecimal(dr["price1"]) * 100), 2, MidpointRounding.AwayFromZero) + "%";
// }
// if (Convert.ToDecimal(dr["Lastprice2"]) == 0)
// {
// dr["平均单价同比"] = 0.00 + "%";
// }
// else
// {
// dr["平均单价同比"] = Math.Round(Convert.ToDecimal(((Convert.ToDecimal(dr["price2"]) - Convert.ToDecimal(dr["Lastprice2"])) / Convert.ToDecimal(dr["Lastprice2"]) * 100)), 2, MidpointRounding.AwayFromZero) + "%";
// }
//}
dt.Columns["mtName"].ColumnName = "物料名称";
dt.Columns["typeName"].ColumnName = "类别名称";
dt.Columns["mtUnit"].ColumnName = "单位";
dt.Columns["LastmtNumber2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购数量";
dt.Columns["LastmtTotal2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购金额";
dt.Columns["Lastprice2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月平均单价";
dt.Columns["mtNumber1"].ColumnName = "上月采购数量";
dt.Columns["mtTotal1"].ColumnName = "上月采购金额";
dt.Columns["price1"].ColumnName = "上月平均单价";
dt.Columns["mtNumber2"].ColumnName = txtMOUTH.Text + "月采购数量";
dt.Columns["mtTotal2"].ColumnName = txtMOUTH.Text + "月采购金额";
dt.Columns["price2"].ColumnName = txtMOUTH.Text + "月平均单价";
// dt.Columns["mtName"].ColumnName = "物料名称";
dt2.Columns["typeName"].ColumnName = "类别名称";
dt2.Columns["mtUnit"].ColumnName = "单位";
dt2.Columns["LastmtNumber2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购数量";
dt2.Columns["LastmtTotal2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月采购金额";
dt2.Columns["Lastprice2"].ColumnName = "上年" + Convert.ToInt32(txtMOUTH.Text) + "月平均单价";
dt2.Columns["mtNumber1"].ColumnName = "上月采购数量";
dt2.Columns["mtTotal1"].ColumnName = "上月采购金额";
dt2.Columns["price1"].ColumnName = "上月平均单价";
dt2.Columns["mtNumber2"].ColumnName = txtMOUTH.Text + "月采购数量";
dt2.Columns["mtTotal2"].ColumnName = txtMOUTH.Text + "月采购金额";
dt2.Columns["price2"].ColumnName = txtMOUTH.Text + "月平均单价";
NpoiExcel(dt, dt2, "入库对比表");
}
}
