protected void BindGv() { this.AspNetPager1.RecordCount = EReport.GetEvenAnalysis(this.txtPrjCode.Text.Trim(), this.txtPrjName.Text.Trim(), 0, 0, base.UserCode, this.hfldIsWBSRelevance.Value).Rows.Count; this.dtEvenAnalysis = EReport.GetEvenAnalysis(this.txtPrjCode.Text.Trim(), this.txtPrjName.Text.Trim(), this.AspNetPager1.PageSize, this.AspNetPager1.CurrentPageIndex, base.UserCode, this.hfldIsWBSRelevance.Value); dtEvenAnalysis.Columns.Add("ysk", System.Type.GetType("System.Double")); dtEvenAnalysis.Columns.Add("dsk", System.Type.GetType("System.Double")); //DataTable dt= this.incometContractBll.GetReportTb(this.txtConType.Text.Trim(), this.txtPrjName.Value, this.txtContractCode.Text.Trim(), this.txtContractName.Text.Trim(), this.txtStartTime.Text.Trim(), this.txtEndTime.Text.Trim(), this.txtParty.Value.Trim(), "Payment", strWhere, this.dropPrjKindClass.SelectedValue, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize); DataTable dt = this.incometContractBll.GetReportTb("", "", "", "", "", "", "", "Payment", "", "", 1, 99999999); foreach (DataRow dr1 in dtEvenAnalysis.Rows) { double ii = 0.00; foreach (DataRow dr2 in dt.Rows) { if (dr1["PrjName"].ToString() == dr2["prjName"].ToString()) { ii += Convert.ToDouble(dr2["CllectionPrice"].ToString()); } } dr1["ysk"] = ii; dr1["dsk"] = Convert.ToDouble(dr1["ContractBud"].ToString()) - ii; } this.gvCost.DataSource = this.dtEvenAnalysis; this.gvCost.DataBind(); }
protected void ComputeTotal() { this.AspNetPager1.CurrentPageIndex = 1; DataTable evenAnalysis = EReport.GetEvenAnalysis(this.txtPrjCode.Text.Trim(), this.txtPrjName.Text.Trim(), 0, 0, base.UserCode, this.hfldIsWBSRelevance.Value); //evenAnalysis.Columns.Add("ysk"); evenAnalysis.Columns.Add("ysk", System.Type.GetType("System.Double")); evenAnalysis.Columns.Add("dsk", System.Type.GetType("System.Double")); //evenAnalysis.Columns["ysk"].DataType = Type.GetType("System.Double"); //evenAnalysis.Columns.Add("dsk"); //evenAnalysis.Columns["dsk"].DataType = Type.GetType("System.Double"); //DataTable dt= this.incometContractBll.GetReportTb(this.txtConType.Text.Trim(), this.txtPrjName.Value, this.txtContractCode.Text.Trim(), this.txtContractName.Text.Trim(), this.txtStartTime.Text.Trim(), this.txtEndTime.Text.Trim(), this.txtParty.Value.Trim(), "Payment", strWhere, this.dropPrjKindClass.SelectedValue, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize); DataTable dt = this.incometContractBll.GetReportTb("", "", "", "", "", "", "", "Payment", "", "", 1, 99999999); foreach (DataRow dr1 in evenAnalysis.Rows) { double ii = 0.00; foreach (DataRow dr2 in dt.Rows) { if (dr1["PrjName"].ToString() == dr2["prjName"].ToString()) { ii += Convert.ToDouble(dr2["CllectionPrice"].ToString()); } } dr1["ysk"] = ii; dr1["dsk"] = Convert.ToDouble(dr1["ContractBud"].ToString()) - ii; } string[] array = new string[7]; if (evenAnalysis.Rows.Count != 0) { array[0] = System.Convert.ToDecimal(evenAnalysis.Compute("sum(ContractBud)", "1>0")).ToString("0.000"); array[1] = System.Convert.ToDecimal(evenAnalysis.Compute("sum(DirectCost)", "1>0")).ToString("0.000"); array[2] = System.Convert.ToDecimal(evenAnalysis.Compute("sum(IndirectCost)", "1>0")).ToString("0.000"); array[3] = System.Convert.ToDecimal(evenAnalysis.Compute("sum(GainLoss)", "1>0")).ToString("0.000"); array[5] = System.Convert.ToDecimal(evenAnalysis.Compute("sum(ysk)", "1>0")).ToString("0.000"); array[6] = System.Convert.ToDecimal(evenAnalysis.Compute("sum(dsk)", "1>0")).ToString("0.000"); } else { array[0] = "0.000"; array[1] = "0.000"; array[2] = "0.000"; array[3] = "0.000"; array[5] = "0.000"; array[6] = "0.000"; } if (System.Convert.ToDecimal(array[0]) != 0m) { decimal d = System.Convert.ToDecimal(array[3]) / System.Convert.ToDecimal(array[0]); array[4] = (decimal.Floor(d * 10000m) / 100m).ToString() + "%"; } else { array[4] = "0.00%"; } int[] value = new int[] { 3, 4, 5, 6, 7, 8, 9 }; this.ViewState["Total"] = array; this.ViewState["index"] = value; }