C#

zead jalil wrote:

Please let me know if there is a tool can do that or how we can build this tool.

public string SimpleReport(string title, string head, bool disp_head, int size, string csvHeader, string sizes, ref ArrayList myReport)
{
	if (myReport.Count == 0)
		return "";

	ArrayList lstHeader = new ArrayList(),
				lstContent = new ArrayList(),
				lstTableSizes = new ArrayList(),
				lstMessages = new ArrayList(),
				lstFilters = new ArrayList(),
				lst_sub_tbl_head = new ArrayList();

	lstContent.Add(myReport);
	lstMessages.Add(title);
	lstTableSizes.Add(size);

	string[] par = csvHeader.Split(','); 
	
	if (sizes == "")
	{
		for (int t = 0; t < par.Length; ++t)
		{
			sizes += (size / par.Length).ToString() + ",";
		}

		sizes = sizes.TrimEnd(',');
	}

	for (int t = 0; t < par.Length; ++t)
		lst_sub_tbl_head.Add(par[t]);

	lstHeader.Add(lst_sub_tbl_head);

	return CodeReport ( title, head, disp_head, ref lstHeader, ref lstContent, sizes );
}

public string SimpleReport(string title, int size, string csvHeader, string sizes, ref ArrayList myReport)
{
	return SimpleReport(title, "Resultados", size, csvHeader, sizes, ref myReport);
}

public string SimpleReportAlt(string title, int size, string csvHeader, string sizes, ref ArrayList myReport)
{
	return SimpleReport("", title, size, csvHeader, sizes, ref myReport);
}

public bool changeColor = false;

public string CodeReport ( string info, string head, bool disp_head, ref ArrayList lstHeader, ref ArrayList lstContents, string sizes )
{
	string[] s_pw = sizes.Split(',');

	int t_size = 0;

	for (int t = 0; t < s_pw.Length; ++t)
		t_size += Convert.ToInt32(s_pw[t]);
	
	StringBuilder sb = new StringBuilder();

	sb.Append(info + "<span style='font-size:12px'><section class='widget2'><table class='table table-hover'>");

	ArrayList tmp_head_cur_categ = lstHeader[0] as ArrayList;
	ArrayList tmp_content_cur_categ = lstContents[0] as ArrayList;

	if (disp_head)
	{
		sb.Append("<thead><tr>");

		for (int t = 0; t < tmp_head_cur_categ.Count; ++t)
		{
			string cont = tmp_head_cur_categ[t].ToString();

			sb.Append("<th valign='top' align='left'><b>" + cont + "</b></th>");
		}

		sb.Append("</tr></thead>");
	}

	sb.Append("<tbody>");

	for (int t = 0; t < tmp_content_cur_categ.Count; ++t)
	{
		ArrayList tmp_line = tmp_content_cur_categ[t] as ArrayList;

		sb.Append("<tr>");

		for (int g = 0; g < tmp_line.Count; ++g)
			sb.Append("<td valign='top' width=\"" + s_pw[g] + "px\">" + tmp_line[g].ToString() + "</td>");

		sb.Append("</tr>");
	}

	sb.Append("</tbody></table></section></span>");

	return sb.ToString();
}

// sample

List<UserData> lst_report = new List<UserData>();

// add elements here...

ArrayList myReport = new ArrayList();

for (int t = 0; t < lst_report.Count; ++t)
{
	UserData p = lst_report[t];
	ArrayList columns = new ArrayList();

	columns.Add("<a href='SamplePage.aspx?cod=" + p["id"] + "'>" + p["login"] + "</a>");
	columns.Add(p["name"]);
	columns.Add(p["email"]);

	myReport.Add(columns);
}

LitRes.Text = var_util.SimpleReport(  "", 0, "Login,Full Name,Email", "100,180,120", ref myReport);

John Torjo wrote:

1. why start at 7:7 (i and j)? Why go until grid_lic.ColumnCount -1 instead of grid_lic.ColumnCount?

John Torjo wrote:

2. Your i and j iterate through columsn onlyl not through rows at all.

John Torjo wrote:

3. Why do you set that CurrentRow.Cells[3] to false or true?

John Torjo wrote:

4. Why the double statements (Convert.ToBoolean...)?

John Torjo wrote:

6. You need to first check ALL cells to see if they are all true or not, so that you'll know how to set them

Member 11449447 wrote:

John Torjo wrote:

4. Why the double statements (Convert.ToBoolean...)?

Because being checkboxes, only booleans are read.

"Convert.ToBoolean(grid_lic.CurrentRow.Cells[i].Value = false);"

public void CheckGrid()
{
  List<int> trueIndices = new List<int>();
  for (int i = 7; i < GridItems.Count - 1; i++)
  {
    if (GridItems[i])
    {
      trueIndices.Add(i);
    }
  }
  bool setValue = trueIndices.Count == 0 || trueIndices.Count != GridItems.Count - 8;
  for (int i = 7; i < GridItems.Count - 1; i++)
  {
    GridItems[i] = setValue;
  }
}