private void piechart(string title, string data, ArrayList leg) { StringBuilder pie = new StringBuilder(); StringBuilder legend = new StringBuilder(); graphTitle.Text = title; legend.Append("<table cellSpacing=0 cellPadding=2 border=0 style=\"border:1px solid black\">"); legend.Append("<tr><td style=\"border-bottom:1px solid black;font-size:1px;\"> </td><td style=\"border-bottom:1px solid black\"> </td><td class=normal style=\"border-bottom:1px solid black\" width=\"50px\">n</td><td class=normal style=\"border-bottom:1px solid black\" width=\"80px\">%</td></tr>"); Pie_chart pc = new Pie_chart(); for (int i = 0; i < leg.Count; i++) { Legenda l = (Legenda)leg[i]; legend.AppendFormat("<tr><td width=\"10px\" style=\"border-bottom:1px solid black;border-right:1px solid black\"><table cellpadding=0 cellspacing=0 width=\"10px\"><tr><td bgcolor=\"{0}\" style=\"font-size:9px\"> </td></tr></table></td><td class=normal style=\"border-bottom:1px solid black\">{1}</td>", pc.color[i].Name, l.title); legend.AppendFormat("<td class=normal style=\"border-bottom:1px solid black\">{0}</td>", l.value.ToString()); legend.AppendFormat("<td class=normal style=\"border-bottom:1px solid black\">{0}%</td></tr>", l.percent.ToString("###.00")); } pc.Dispose(); legend.Append("</table"); Legend.Text = legend.ToString(); pie.AppendFormat("<img src=\"/chart/pie.aspx?data={0}\">", data); Trace.Warn(pie.ToString()); Result.Text = pie.ToString(); tableData.Visible = false; graphResult.Visible = true; }
private void DashPortIndustry() { string companyLead = RadioButtonList1.SelectedValue; StringBuilder dashQuery = new StringBuilder(); ArrayList ar = new ArrayList(); ArrayList arlegend = new ArrayList(); string finalQuery = String.Empty; DataTable dt; if (companyLead == "0" || companyLead == "2") { dashQuery.AppendFormat("SELECT * FROM DASH1_COMPANYINDUSTRY_VIEW"); string opp = getOpportunity(); if (opp.Length > 0) { opp = " AND (" + opp + ")"; } finalQuery = dashQuery.ToString() + opp + " ORDER BY COMPANYTYPEID"; dt = DatabaseConnection.CreateDataset(finalQuery).Tables[0]; foreach (DataRow dr in dt.Rows) { bool exists = false; for (int i = 0; i < ar.Count; i++) { IndustryPercent temp = (IndustryPercent)ar[i]; if (temp.industryid == Convert.ToInt32(dr["CompanyTypeID"])) { temp.ntimes = temp.ntimes + 1; ar[i] = temp; exists = true; break; } } if (!exists) { IndustryPercent newindustry = new IndustryPercent(); newindustry.industryid = Convert.ToInt32(dr["CompanyTypeID"]); newindustry.industryname = dr["CompanyIndustry"].ToString(); newindustry.ntimes = 1; ar.Add(newindustry); } } } if (companyLead == "0" || companyLead == "1") { dashQuery.Length = 0; dashQuery.AppendFormat("SELECT * FROM DASH1_LEADINDUSTRY_VIEW"); string opp = getOpportunity(); if (opp.Length > 0) { opp = " AND (" + opp + ")"; } finalQuery = dashQuery.ToString() + opp + " ORDER BY INDUSTRY"; dt = DatabaseConnection.CreateDataset(finalQuery).Tables[0]; foreach (DataRow dr in dt.Rows) { bool exists = false; for (int i = 0; i < ar.Count; i++) { IndustryPercent temp = (IndustryPercent)ar[i]; if (temp.industryid == Convert.ToInt32(dr["Industry"])) { temp.ntimes = temp.ntimes + 1; ar[i] = temp; exists = true; break; } } if (!exists) { IndustryPercent newindustry = new IndustryPercent(); newindustry.industryid = Convert.ToInt32(dr["Industry"]); newindustry.industryname = dr["LeadIndustry"].ToString(); newindustry.ntimes = 1; ar.Add(newindustry); } } } int total = 0; double percTotal = 0; string res = String.Empty; for (int i = 0; i < ar.Count; i++) { IndustryPercent temp = (IndustryPercent)ar[i]; total += temp.ntimes; } for (int i = 0; i < ar.Count; i++) { IndustryPercent temp = (IndustryPercent)ar[i]; string indName = (temp.industryid == 0) ?Root.rm.GetString("Das1txt14") : temp.industryname; double percent = Math.Round(Convert.ToDouble(temp.ntimes) * 100 / Convert.ToDouble(total), 0); percTotal += percent; Legenda leg = new Legenda(); leg.title = indName; leg.value = temp.ntimes; leg.percent = percent; arlegend.Add(leg); res += indName + "|" + temp.ntimes + "|"; } try { piechart(Root.rm.GetString("Das1txt17"), res.Substring(0, res.Length - 1), arlegend); } catch { graphTitle.Text = Root.rm.GetString("Das1txt38"); } }
private void DashPortIndustry() { string companyLead = RadioButtonList1.SelectedValue; StringBuilder dashQuery = new StringBuilder(); ArrayList ar = new ArrayList(); ArrayList arlegend = new ArrayList(); string finalQuery = String.Empty; DataTable dt; if (companyLead == "0" || companyLead == "2") { dashQuery.AppendFormat("SELECT * FROM DASH1_COMPANYINDUSTRY_VIEW"); finalQuery = dashQuery.ToString() + " ORDER BY COMPANYTYPEID"; dt = DatabaseConnection.CreateDataset(finalQuery).Tables[0]; foreach (DataRow dr in dt.Rows) { bool exists = false; for (int i = 0; i < ar.Count; i++) { IndustryRevenue temp = (IndustryRevenue)ar[i]; if (temp.industryId == Convert.ToInt32(dr["CompanyTypeID"])) { switch (Drop2.SelectedValue) { case "0": temp.revenue += Convert.ToDecimal(dr["expectedrevenue"]); break; case "1": temp.revenue += Convert.ToDecimal(dr["incomeprobability"]); break; case "2": temp.revenue += Convert.ToDecimal(dr["amountclosed"]); break; } ar[i] = temp; exists = true; break; } } if (!exists) { IndustryRevenue newindustry = new IndustryRevenue(); newindustry.industryId = Convert.ToInt32(dr["CompanyTypeID"]); newindustry.industryName = dr["CompanyIndustry"].ToString(); switch (Drop2.SelectedValue) { case "0": newindustry.revenue += Convert.ToDecimal(dr["expectedrevenue"]); break; case "1": newindustry.revenue += Convert.ToDecimal(dr["incomeprobability"]); break; case "2": newindustry.revenue += Convert.ToDecimal(dr["amountclosed"]); break; } ar.Add(newindustry); } } } if (companyLead == "0" || companyLead == "1") { dashQuery.Length = 0; dashQuery.AppendFormat("SELECT * FROM DASH1_LEADINDUSTRY_VIEW"); finalQuery = dashQuery.ToString() + " ORDER BY INDUSTRY"; dt = DatabaseConnection.CreateDataset(finalQuery).Tables[0]; foreach (DataRow dr in dt.Rows) { bool exists = false; for (int i = 0; i < ar.Count; i++) { IndustryRevenue temp = (IndustryRevenue)ar[i]; if (temp.industryId == Convert.ToInt32(dr["Industry"])) { switch (Drop2.SelectedValue) { case "0": temp.revenue += Convert.ToDecimal(dr["expectedrevenue"]); break; case "1": temp.revenue += Convert.ToDecimal(dr["incomeprobability"]); break; case "2": temp.revenue += Convert.ToDecimal(dr["amountclosed"]); break; } ar[i] = temp; exists = true; break; } } if (!exists) { IndustryRevenue newindustry = new IndustryRevenue(); newindustry.industryId = Convert.ToInt32(dr["Industry"]); newindustry.industryName = dr["LeadIndustry"].ToString(); switch (Drop2.SelectedValue) { case "0": newindustry.revenue += Convert.ToDecimal(dr["expectedrevenue"]); break; case "1": newindustry.revenue += Convert.ToDecimal(dr["incomeprobability"]); break; case "2": newindustry.revenue += Convert.ToDecimal(dr["amountclosed"]); break; } ar.Add(newindustry); } } } decimal total = 0; double percTotal = 0; string res = String.Empty; for (int i = 0; i < ar.Count; i++) { IndustryRevenue temp = (IndustryRevenue)ar[i]; total += temp.revenue; } for (int i = 0; i < ar.Count; i++) { IndustryRevenue temp = (IndustryRevenue)ar[i]; string indName = temp.revenue.ToString("c"); double percent = Math.Round(Convert.ToDouble(temp.revenue) * 100 / Convert.ToDouble(total), 0); percTotal += percent; Legenda leg = new Legenda(); leg.title = (temp.industryId == 0) ?Root.rm.GetString("Das1txt14") : temp.industryName; leg.value = temp.revenue; leg.percent = percent; arlegend.Add(leg); res += indName + "|" + Math.Round(temp.revenue, 0) + "|"; } try { switch (Drop2.SelectedValue) { case "0": piechart(Root.rm.GetString("Das1txt23"), res.Substring(0, res.Length - 1), arlegend); break; case "1": piechart(Root.rm.GetString("Das1txt24"), res.Substring(0, res.Length - 1), arlegend); break; case "2": piechart(Root.rm.GetString("Das1txt25"), res.Substring(0, res.Length - 1), arlegend); break; } } catch { graphTitle.Text = Root.rm.GetString("Das1txt38"); } }
private void DashPortAddress(string type) { string companyLead = RadioButtonList1.SelectedValue; Trace.Warn("companylead", companyLead); StringBuilder dashQuery = new StringBuilder(); ArrayList ar = new ArrayList(); ArrayList arlegend = new ArrayList(); DataTable dt; if (companyLead == "0" || companyLead == "2") { string opp = getOpportunity(); if (opp.Length > 0) { opp = " AND (" + opp + ")"; } dashQuery.AppendFormat("SELECT DISTINCT {0},COUNT({0}) AS NTIMES FROM DASH1_COMPANYINDUSTRY_VIEW WHERE {1} GROUP BY {0}", type, opp); dt = DatabaseConnection.CreateDataset(dashQuery.ToString()).Tables[0]; foreach (DataRow dr in dt.Rows) { Trace.Warn("C " + dr[type].ToString().ToUpper(), dr["ntimes"].ToString()); AddressPercent newsales = new AddressPercent(); newsales.address = dr[type].ToString().ToUpper(); newsales.ntimes = Convert.ToInt32(dr["ntimes"]); ar.Add(newsales); } } if (companyLead == "0" || companyLead == "1") { dashQuery.Length = 0; string opp = getOpportunity(); if (opp.Length > 0) { opp = " AND (" + opp + ")"; } dashQuery.AppendFormat("SELECT DISTINCT {0},COUNT({0}) AS NTIMES FROM DASH1_LEADINDUSTRY_VIEW WHERE {1} GROUP BY {0}", type, opp); dt = DatabaseConnection.CreateDataset(dashQuery.ToString()).Tables[0]; foreach (DataRow dr in dt.Rows) { Trace.Warn("L " + dr[type].ToString().ToUpper(), dr["ntimes"].ToString()); bool exists = false; for (int i = 0; i < ar.Count; i++) { AddressPercent temp = (AddressPercent)ar[i]; if (temp.address == dr[type].ToString().ToUpper()) { temp.ntimes += Convert.ToInt32(dr["ntimes"]); ar[i] = temp; exists = true; break; } } if (!exists) { AddressPercent newsales = new AddressPercent(); newsales.address = dr[type].ToString().ToUpper(); newsales.ntimes = Convert.ToInt32(dr["ntimes"]); ar.Add(newsales); } } } int total = 0; double percTotal = 0; string res = String.Empty; for (int i = 0; i < ar.Count; i++) { AddressPercent temp = (AddressPercent)ar[i]; total += temp.ntimes; } for (int i = 0; i < ar.Count; i++) { AddressPercent temp = (AddressPercent)ar[i]; string nationName = (temp.address.Length == 0) ?Root.rm.GetString("Das1txt14") : temp.address; double percent = Math.Round(Convert.ToDouble(temp.ntimes) * 100 / Convert.ToDouble(total), 3); percTotal += percent; Legenda leg = new Legenda(); leg.title = nationName; leg.value = temp.ntimes; leg.percent = percent; arlegend.Add(leg); res += nationName + "|" + temp.ntimes + "|"; } string title = String.Empty; switch (type) { case "Nation": title = Root.rm.GetString("Das1txt19"); break; case "Province": title = Root.rm.GetString("Das1txt20"); break; case "City": title = Root.rm.GetString("Das1txt21"); break; } try { piechart(title, res.Substring(0, res.Length - 1), arlegend); } catch { graphTitle.Text = Root.rm.GetString("Das1txt38"); } }
private void DashPortAddress(string type) { string companyLead = RadioButtonList1.SelectedValue; Trace.Warn("companylead", companyLead); StringBuilder dashQuery = new StringBuilder(); ArrayList ar = new ArrayList(); ArrayList arlegend = new ArrayList(); DataTable dt; if (companyLead == "0" || companyLead == "2") { switch (Drop2.SelectedValue) { case "0": dashQuery.AppendFormat("SELECT DISTINCT {0},SUM(EXPECTEDREVENUE) AS NTIMES FROM DASH1_COMPANYINDUSTRY_VIEW GROUP BY {0}", type); break; case "1": dashQuery.AppendFormat("SELECT DISTINCT {0},SUM(INCOMEPROBABILITY) AS NTIMES FROM DASH1_COMPANYINDUSTRY_VIEW GROUP BY {0}", type); break; case "2": dashQuery.AppendFormat("SELECT DISTINCT {0},SUM(AMOUNTCLOSED) AS NTIMES FROM DASH1_COMPANYINDUSTRY_VIEW GROUP BY {0}", type); break; } dt = DatabaseConnection.CreateDataset(dashQuery.ToString()).Tables[0]; foreach (DataRow dr in dt.Rows) { Trace.Warn("C " + dr[type].ToString().ToUpper(), dr["ntimes"].ToString()); AddressRevenue newsales = new AddressRevenue(); newsales.address = dr[type].ToString().ToUpper(); newsales.revenue = Convert.ToInt32(dr["ntimes"]); ar.Add(newsales); } } if (companyLead == "0" || companyLead == "1") { dashQuery.Length = 0; switch (Drop2.SelectedValue) { case "0": dashQuery.AppendFormat("SELECT DISTINCT {0},SUM(EXPECTEDREVENUE) AS NTIMES FROM DASH1_LEADINDUSTRY_VIEW GROUP BY {0}", type); break; case "1": dashQuery.AppendFormat("SELECT DISTINCT {0},SUM(INCOMEPROBABILITY) AS NTIMES FROM DASH1_LEADINDUSTRY_VIEW GROUP BY {0}", type); break; case "2": dashQuery.AppendFormat("SELECT DISTINCT {0},SUM(AMOUNTCLOSED) AS NTIMES FROM DASH1_LEADINDUSTRY_VIEW GROUP BY {0}", type); break; } dt = DatabaseConnection.CreateDataset(dashQuery.ToString()).Tables[0]; foreach (DataRow dr in dt.Rows) { Trace.Warn("L " + dr[type].ToString().ToUpper(), dr["ntimes"].ToString()); bool exists = false; for (int i = 0; i < ar.Count; i++) { AddressRevenue temp = (AddressRevenue)ar[i]; if (temp.address == dr[type].ToString().ToUpper()) { temp.revenue += Convert.ToDecimal(dr["ntimes"]); ar[i] = temp; exists = true; break; } } if (!exists) { AddressRevenue newsales = new AddressRevenue(); newsales.address = dr[type].ToString().ToUpper(); newsales.revenue = Convert.ToDecimal(dr["ntimes"]); ar.Add(newsales); } } } decimal total = 0; double percTotal = 0; string res = String.Empty; for (int i = 0; i < ar.Count; i++) { AddressRevenue temp = (AddressRevenue)ar[i]; total += temp.revenue; } for (int i = 0; i < ar.Count; i++) { AddressRevenue temp = (AddressRevenue)ar[i]; string indName = temp.revenue.ToString("c"); double percent = Math.Round(Convert.ToDouble(temp.revenue) * 100 / Convert.ToDouble(total), 0); percTotal += percent; Legenda leg = new Legenda(); leg.title = (temp.address.Length == 0) ?Root.rm.GetString("Das1txt14") : temp.address; leg.value = temp.revenue; leg.percent = percent; arlegend.Add(leg); res += indName + "|" + Math.Round(temp.revenue, 0) + "|"; } string title = String.Empty; switch (type) { case "Nation": switch (Drop2.SelectedValue) { case "0": title = Root.rm.GetString("Das1txt29"); break; case "1": title = Root.rm.GetString("Das1txt30"); break; case "2": title = Root.rm.GetString("Das1txt31"); break; } break; case "Province": switch (Drop2.SelectedValue) { case "0": title = Root.rm.GetString("Das1txt32"); break; case "1": title = Root.rm.GetString("Das1txt33"); break; case "2": title = Root.rm.GetString("Das1txt34"); break; } break; case "City": switch (Drop2.SelectedValue) { case "0": title = Root.rm.GetString("Das1txt35"); break; case "1": title = Root.rm.GetString("Das1txt36"); break; case "2": title = Root.rm.GetString("Das1txt37"); break; } break; } try { piechart(title, res.Substring(0, res.Length - 1), arlegend); } catch { graphTitle.Text = Root.rm.GetString("Das1txt38"); } }