public void GetTable(ref List <string> head, ref DataTable table, ref double sum, string licensetype, string comcode, string startdate, string enddate, ref bool error)
{
var list = svc.GetMoveCompanyOut(licensetype, comcode, Convert.ToDateTime(startdate), Convert.ToDateTime(enddate));
if (list.IsError)
{
error = true;
}
else if (list.DataResponse == null || list.DataResponse.Tables[0] == null)
{
error = true;
}
else
{
DataTable oldTable = list.DataResponse.Tables[0];
for (int i = 2; i < oldTable.Columns.Count; i++)
{
if (oldTable.Columns[i].ColumnName != "TOTALS")
{
head.Add(oldTable.Columns[i].ColumnName.Replace("COMP_", ""));
}
}
for (int i = 0; i < oldTable.Columns.Count - 2; i++)
{
table.Columns.Add("A" + i, typeof(string));
}
table.Columns.Add("A20", typeof(string));
// double sum = 0;
for (int i = 0; i < oldTable.Rows.Count; i++)
{
DataRow row = table.NewRow();
for (int t = 0; t < table.Columns.Count; t++)
{
row[t] = oldTable.Rows[i][t + 1].ToString();
if (t == table.Columns.Count - 1)
{
sum += oldTable.Rows[i][t + 1].ToString().ToDouble();
}
}
table.Rows.Add(row);
}
}
}
