Esempio n. 1
0
    private DataTable GetData1()
    {
        string      planType    = base.Request["PlanType"].ToString();
        Fund_Report fund_Report = new Fund_Report();
        string      arg_27_0    = this.txtProject.Text;
        string      arg_33_0    = this.txtContract.Text;
        int         planYear    = DateTime.Now.Year;
        int         planMonth   = DateTime.Now.Month;

        if (this.txtDate.Text.ToString() != "")
        {
            string[] array = this.txtDate.Text.ToString().Split(new char[]
            {
                '-'
            });
            int      num    = 0;
            string[] array2 = array;
            for (int i = 0; i < array2.Length; i++)
            {
                string value = array2[i];
                if (num == 0)
                {
                    planYear = Convert.ToInt32(value);
                }
                else
                {
                    if (num == 1)
                    {
                        planMonth = Convert.ToInt32(value);
                    }
                }
                num++;
            }
        }
        DataTable payoutPlanInfo = fund_Report.getPayoutPlanInfo(base.UserCode, planYear, planMonth, this.txtProject.Text, this.hfldContract.Value, planType);
        decimal   d  = 0m;
        decimal   d2 = 0m;
        decimal   d3 = 0m;
        decimal   d4 = 0m;

        for (int j = 0; j < payoutPlanInfo.Rows.Count; j++)
        {
            d  += Convert.ToDecimal(payoutPlanInfo.Rows[j]["beforePlanMoney"].ToString());
            d2 += Convert.ToDecimal(payoutPlanInfo.Rows[j]["conPayMoney"].ToString());
            d3 += Convert.ToDecimal(payoutPlanInfo.Rows[j]["ExecuteVariation"].ToString());
            d4 += Convert.ToDecimal(payoutPlanInfo.Rows[j]["PlanMoney"].ToString());
            if (payoutPlanInfo.Rows[j][2].ToString() == "小计")
            {
                payoutPlanInfo.Rows[j]["beforePlanMoney"]  = d.ToString();
                payoutPlanInfo.Rows[j]["conPayMoney"]      = d2.ToString();
                payoutPlanInfo.Rows[j]["ExecuteVariation"] = d3.ToString();
                payoutPlanInfo.Rows[j]["PlanMoney"]        = d4.ToString();
                d  = 0m;
                d2 = 0m;
                d3 = 0m;
                d4 = 0m;
            }
        }
        return(payoutPlanInfo);
    }
Esempio n. 2
0
    private DataTable GetData()
    {
        Fund_Report fund_Report = new Fund_Report();
        int         planYear    = DateTime.Now.Year;
        int         planMonth   = DateTime.Now.Month;

        if (this.txtDate.Text.ToString() != "")
        {
            string[] array = this.txtDate.Text.ToString().Split(new char[]
            {
                '-'
            });
            int      num    = 0;
            string[] array2 = array;
            for (int i = 0; i < array2.Length; i++)
            {
                string value = array2[i];
                if (num == 0)
                {
                    planYear = Convert.ToInt32(value);
                }
                else
                {
                    if (num == 1)
                    {
                        planMonth = Convert.ToInt32(value);
                    }
                }
                num++;
            }
        }
        return(fund_Report.GetIndirectInfo(planYear, planMonth, this.hdnProjectCode.Value));
    }
Esempio n. 3
0
    private DataTable GetData()
    {
        string      planType    = base.Request["PlanType"].ToString();
        Fund_Report fund_Report = new Fund_Report();
        string      arg_27_0    = this.txtProject.Text;
        string      arg_33_0    = this.txtContract.Text;
        int         planYear    = DateTime.Now.Year;
        int         planMonth   = DateTime.Now.Month;

        if (this.txtDate.Text != "")
        {
            string[] array = this.txtDate.Text.Split(new char[]
            {
                '-'
            });
            int      num    = 0;
            string[] array2 = array;
            for (int i = 0; i < array2.Length; i++)
            {
                string value = array2[i];
                if (num == 0)
                {
                    planYear = Convert.ToInt32(value);
                }
                else
                {
                    if (num == 1)
                    {
                        planMonth = Convert.ToInt32(value);
                    }
                }
                num++;
            }
        }
        return(fund_Report.getPayoutPlanInfo(base.UserCode, planYear, planMonth, this.txtProject.Text, this.hfldContract.Value, planType));
    }
Esempio n. 4
0
    private DataTable GetData()
    {
        string      text        = base.Request["PlanType"].ToString();
        Fund_Report fund_Report = new Fund_Report();
        string      arg_27_0    = this.txtProject.Text;
        int         planYear    = DateTime.Now.Year;
        int         planMonth   = DateTime.Now.Month;

        if (this.txtDate.Text.ToString() != "")
        {
            string[] array = this.txtDate.Text.ToString().Split(new char[]
            {
                '-'
            });
            int      num    = 0;
            string[] array2 = array;
            for (int i = 0; i < array2.Length; i++)
            {
                string value = array2[i];
                if (num == 0)
                {
                    planYear = Convert.ToInt32(value);
                }
                else
                {
                    if (num == 1)
                    {
                        planMonth = Convert.ToInt32(value);
                    }
                }
                num++;
            }
        }
        DataTable dataTable = new DataTable();

        if (text == "allplan")
        {
            dataTable.Columns.Add("prjguid");
            dataTable.Columns.Add("prjname");
            dataTable.Columns.Add("lastplanincome");
            dataTable.Columns.Add("lastplanpayout");
            dataTable.Columns.Add("lastactuallyincome");
            dataTable.Columns.Add("lastincomecpl");
            dataTable.Columns.Add("lastactuallypayout");
            dataTable.Columns.Add("lastpayoutcpl");
            dataTable.Columns.Add("thisincome");
            dataTable.Columns.Add("thispayout");
            DataTable planInfo  = fund_Report.GetPlanInfo(base.UserCode, planYear, planMonth, "income", this.txtProject.Text);
            DataTable planInfo2 = fund_Report.GetPlanInfo(base.UserCode, planYear, planMonth, "payout", this.txtProject.Text);
            foreach (DataRow dataRow in planInfo.Rows)
            {
                DataRow dataRow2 = dataTable.NewRow();
                dataRow2["prjguid"]            = dataRow["PrjGuid"];
                dataRow2["prjname"]            = dataRow["PrjName"];
                dataRow2["lastplanincome"]     = dataRow["planMoney"];
                dataRow2["lastactuallyincome"] = dataRow["conPayMoney"];
                dataRow2["lastincomecpl"]      = dataRow["ratio"];
                dataRow2["thisincome"]         = dataRow["NewPlanMoney"];
                DataRow[] array3 = planInfo2.Select(" prjguid='" + dataRow["prjguid"] + "' ");
                if (array3.Length != 0)
                {
                    dataRow2["lastplanpayout"]     = array3[0]["planMoney"];
                    dataRow2["lastactuallypayout"] = array3[0]["conPayMoney"];
                    dataRow2["lastpayoutcpl"]      = array3[0]["ratio"];
                    dataRow2["thispayout"]         = array3[0]["NewPlanMoney"];
                    dataTable.Rows.Add(dataRow2);
                }
            }
            return(dataTable);
        }
        dataTable = fund_Report.GetPlanInfo(base.UserCode, planYear, planMonth, text, this.txtProject.Text);
        return(dataTable);
    }