/// <summary> /// 设置图表的曲线颜色 /// </summary> public static void SetChartColor(Infragistics.WebUI.UltraWebChart.UltraChart UltraChart1, string Source) { try { // Infragistics.UltraChart.Resources.Appearance.PaintElement pe = new Infragistics.UltraChart.Resources.Appearance.PaintElement(); // this.UltraChart1.ColorModel.Skin.PEs.Add(pe); string[] arrSource = Source.Split(",".ToCharArray()); UltraChart1.ColorModel.Skin.PEs.Clear(); foreach(string val in arrSource) { Infragistics.UltraChart.Resources.Appearance.PaintElement pe = new Infragistics.UltraChart.Resources.Appearance.PaintElement(); BLL.CashFlowSource source = BLL.CashFlowRule.GetCashFlowSourceById(val); if (source != null) { pe.Fill = source.Color; } UltraChart1.ColorModel.Skin.PEs.Add( pe); } } catch(Exception ex) { throw ex; } }
/* * public static DataTable GenerateRtpFinI(string ProjectCode) * { * try * { * DataTable tb = BLL.SalBudgetRule.GetSalPBSType(false); * * tb.Columns.Add("PBSTypeNameHtml"); * * foreach(DataRow dr in tb.Rows) * { * int Deep = BLL.ConvertRule.ToInt(dr["Deep"]); * string PBSTypeName = BLL.ConvertRule.ToString(dr["PBSTypeName"]); * * string space = ""; * for(int i=1;i<Deep;i++) * { * space = space + " "; * } * * dr["PBSTypeNameHtml"] = space + PBSTypeName; * } * * return tb; * } * catch(Exception ex) * { * throw ex; * } * } */ /* * public static DataTable GenerateRtpFinIO(string ProjectCode) * { * try * { * //取数据 * QueryAgent qa = new Rms.ORMap.QueryAgent(); * try * { * string sql = string.Format("select * from cbs where ProjectCode = '{0}' order by FullCode", ProjectCode); * DataSet ds = qa.ExecSqlForDataSet(sql); * DataTable tb = ds.Tables[0]; * * tb.Columns.Add("CostNameHtml"); * * foreach(DataRow dr in tb.Rows) * { * int Deep = BLL.ConvertRule.ToInt(dr["Deep"]); * string CostName = BLL.ConvertRule.ToString(dr["CostName"]); * * string space = ""; * for(int i=1;i<Deep;i++) * { * space = space + " "; * } * * dr["CostNameHtml"] = space + CostName; * } * * return tb; * } * finally * { * qa.Dispose(); * } * } * catch(Exception ex) * { * throw ex; * } * } */ private void LoadGrid() { try { string ProjectCode = this.txtProjectCode.Value; string Source = BLL.ConvertRule.ToString(Request.QueryString["Source"]); string MonthType = BLL.ConvertRule.ToString(Request.QueryString["MonthType"]); BLL.CashFlowSource source = BLL.CashFlowRule.GetCashFlowSourceById(Source); string SourceDesc = (source != null)?source.Desc:""; this.lblSourceName.Text = SourceDesc; int StartY = BLL.ConvertRule.ToInt(this.ucCostBudgetSelectMonth.MonthStart); int EndY = BLL.ConvertRule.ToInt(this.ucCostBudgetSelectMonth.MonthEnd); //标题 this.lblMonthTypeName.Text = BLL.CashFlowRule.GetMonthTypeName(MonthType); //年度展开 string html_title1 = ""; string html_title2 = ""; int MonthCount = 0; BLL.CashFlowRule.GenerateYearTitleHtml(MonthType, StartY, EndY, ref html_title1, ref html_title2, ref MonthCount); ViewState["html_title1"] = html_title1; ViewState["html_title2"] = html_title2; ViewState["MonthCount"] = MonthCount; //生成现金流表 DataSet ds = BLL.CashFlowRule.GenerateCashFlowList(ProjectCode, StartY, EndY, MonthType, Source); //流入 DataTable tbI = ds.Tables["CashFlowI"]; tbI.Columns.Add("PBSTypeNameHtml"); foreach (DataRow dr in tbI.Rows) { int Deep = BLL.ConvertRule.ToInt(dr["Deep"]); string PBSTypeName = BLL.ConvertRule.ToString(dr["PBSTypeName"]); string space = ""; for (int i = 1; i < Deep; i++) { space = space + " "; } dr["PBSTypeNameHtml"] = space + PBSTypeName; } DataView dvI = new DataView(tbI, "Deep > 0", "PBSTypeFullID", DataViewRowState.CurrentRows); this.dgListI.DataSource = dvI; this.dgListI.DataBind(); DataView dvITotal = new DataView(tbI, "Deep = 0", "PBSTypeFullID", DataViewRowState.CurrentRows); this.dgListITotal.DataSource = dvITotal; this.dgListITotal.DataBind(); //流出 DataTable tbO = ds.Tables["CashFlowO"]; tbO.Columns.Add("CostNameHtml"); foreach (DataRow dr in tbO.Rows) { int Deep = BLL.ConvertRule.ToInt(dr["Deep"]); string CostName = BLL.ConvertRule.ToString(dr["CostName"]); string space = ""; for (int i = 1; i < Deep; i++) { space = space + " "; } dr["CostNameHtml"] = space + CostName; } DataView dvO = new DataView(tbO, "Deep > 0", "CostFullID", DataViewRowState.CurrentRows); this.dgListO.DataSource = dvO; this.dgListO.DataBind(); DataView dvOTotal = new DataView(tbO, "Deep = 0", "CostFullID", DataViewRowState.CurrentRows); this.dgListOTotal.DataSource = dvOTotal; this.dgListOTotal.DataBind(); //总计 DataTable tbTotal = ds.Tables["CashFlowTotal"]; this.dgListTotal.DataSource = tbTotal; this.dgListTotal.DataBind(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(Rms.Web.JavaScript.Alert(true, "显示报表出错:" + ex.Message)); } }
private void LoadGrid() { try { Source = this.sltSource.Value; MonthType = this.sltMonthType.Value; //Source = BLL.ConvertRule.ToString(Request.QueryString["Source"]); //MonthType = BLL.ConvertRule.ToString(Request.QueryString["MonthType"]); //项目 ProjectCodes = this.ucSelectProjectMulti.Value; if (ProjectCodes == "") { foreach (DataRow dr in user.m_EntityDataAccessProject.CurrentTable.Rows) { ProjectCodes += BLL.ConvertRule.ToString(dr["ProjectCode"]) + ","; } if (ProjectCodes.Length > 0) { ProjectCodes = ProjectCodes.Substring(0, ProjectCodes.Length - 1); } } // Response.Write(Rms.Web.JavaScript.Alert(true, "user:"******"," + user.m_EntityDataAccessProject.CurrentTable.Rows.Count.ToString())); BLL.CashFlowSource source = BLL.CashFlowRule.GetCashFlowSourceById(Source); string SourceDesc = (source != null)?source.Desc:""; this.lblSourceName.Text = SourceDesc; BeginYm = this.ucCostBudgetSelectMonth.MonthStart.Replace("-", ""); EndYm = this.ucCostBudgetSelectMonth.MonthEnd.Replace("-", ""); BeginY = BLL.ConvertRule.ToInt(BeginYm.Substring(0, 4)); EndY = BLL.ConvertRule.ToInt(EndYm.Substring(0, 4)); //年度展开 string html_title1 = ""; string html_title2 = ""; int MonthCount = 0; GenerateYearTitleHtml(ref html_title1, ref html_title2, ref MonthCount); ViewState["html_title1"] = html_title1; ViewState["html_title2"] = html_title2; ViewState["MonthCount"] = MonthCount; //生成现金流表 GenerateCashFlow(); DataView dvDtl = new DataView(tbHtml, "Type = ''", "ProjectName", DataViewRowState.CurrentRows); this.dgList.DataSource = dvDtl; this.dgList.DataBind(); //总计 DataView dvSum = new DataView(tbHtml, "Type = 'SUM'", "ProjectName", DataViewRowState.CurrentRows); this.dgListTotal.DataSource = dvSum; this.dgListTotal.DataBind(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); Response.Write(Rms.Web.JavaScript.Alert(true, "显示报表出错:" + ex.Message)); } }