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); }
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)); }
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)); }
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); }