Ejemplo n.º 1
0
    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();
    }
Ejemplo n.º 2
0
    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;
    }