void LoadData()
{
if (m_Report == null)
{
m_bIsNew = true;
m_Report = new CReport();
m_Report.Ctx = Program.Ctx;
m_Report.RPT_ReportCatalog_id = m_Catalog_id;
m_Report.B_Company_id = m_Company.Id;
}
txtName.Text = m_Report.Name;
dataGridStatItem.Rows.Clear();
foreach (CBaseObject obj in m_Report.StatItemMgr.GetList())
{
CStatItem StatItem = (CStatItem)obj;
if (StatItem.ItemType == CStatItem.enumItemType.Field)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(StatItem.FW_Table_id);
if (table == null)
{
continue;
}
CColumn column = (CColumn)table.ColumnMgr.Find(StatItem.FW_Column_id);
if (column == null)
{
continue;
}
dataGridStatItem.Rows.Add(1);
DataGridViewRow item = dataGridStatItem.Rows[dataGridStatItem.Rows.Count - 1];
item.Cells[0].Value = table.Name;
item.Cells[1].Value = column.Name;
//DataGridViewComboBoxCell cbCell = (DataGridViewComboBoxCell)item.Cells[2];
//if(cbCell!=null)
// cbCell.Value = "val";
item.Cells[2].Value = StatItem.GetStatTypeName();
item.Cells[3].Value = StatItem.GetOrderName();
item.Tag = StatItem;
}
else
{
dataGridStatItem.Rows.Add(1);
DataGridViewRow item = dataGridStatItem.Rows[dataGridStatItem.Rows.Count - 1];
item.Cells[0].Value = StatItem.Name;
item.Cells[1].Value = StatItem.Formula;
//DataGridViewComboBoxCell cbCell = (DataGridViewComboBoxCell)item.Cells[2];
//if(cbCell!=null)
// cbCell.Value = "val";
item.Cells[2].Value = StatItem.GetStatTypeName();
item.Cells[3].Value = StatItem.GetOrderName();
item.Tag = StatItem;
}
}
txtFilter.Text = m_Report.Filter;
}
void GetData()
{
CReport Report = GetReport();
List <CBaseObject> lstObj = Report.StatItemMgr.GetList();
//按序号排序
List <CStatItem> sortObj = new List <CStatItem>();
foreach (CBaseObject obj in lstObj)
{
CStatItem StatItem = (CStatItem)obj;
sortObj.Add(StatItem);
}
sortObj.Sort();
string sData = "";
foreach (CStatItem StatItem in sortObj)
{
string sTableName = "", sColumnName = "";
CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(StatItem.FW_Table_id);
if (table != null)
{
sTableName = table.Name;
CColumn column = (CColumn)table.ColumnMgr.Find(StatItem.FW_Column_id);
if (column != null)
{
sColumnName = column.Name;
}
}
sData += string.Format("{{ \"id\": \"{0}\",\"FW_Table_id\":\"{1}\",\"TableName\":\"{2}\",\"FW_Column_id\":\"{3}\", \"ColumnName\":\"{4}\", \"StatType\":\"{5}\", \"StatTypeName\":\"{6}\", \"Order\":\"{7}\", \"OrderName\":\"{8}\" }},"
, StatItem.Id
, StatItem.FW_Table_id
, sTableName
, StatItem.FW_Column_id
, sColumnName
, (int)StatItem.StatType
, StatItem.GetStatTypeName()
, (int)StatItem.Order
, StatItem.GetOrderName());
}
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
