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); }