private void btAdd4_Click(object sender, EventArgs e) { if (cbMasterTable.SelectedIndex == -1) { return; } DataItem item = (DataItem)cbMasterTable.SelectedItem; CTable tb = (CTable)item.Data; if (cbMasterColumn4.SelectedIndex == -1) { MessageBox.Show("请选择字段!"); return; } if (cbSign4.SelectedIndex == -1) { MessageBox.Show("请选择比较符号!"); return; } if (txtVal4.Text.Trim() == "") { MessageBox.Show("请输入字段值!"); return; } DataItem item2 = (DataItem)cbMasterColumn4.SelectedItem; CColumn col = (CColumn)item2.Data; CViewFilter vf = new CViewFilter(); vf.Ctx = Program.Ctx; vf.UI_View_id = m_View.Id; vf.AndOr = (cbAndOr.SelectedIndex == 0) ? "and" : "or"; vf.FW_Table_id = tb.Id; vf.FW_Column_id = col.Id; vf.Sign = (CompareSign)cbSign4.SelectedIndex; vf.Val = txtVal4.Text.Trim(); m_View.ViewFilterMgr.AddNew(vf); dataGridView4.Rows.Add(1); DataGridViewRow rowNew = dataGridView4.Rows[dataGridView4.Rows.Count - 1]; rowNew.Cells[0].Value = vf.AndOr; rowNew.Cells[1].Value = col.Name; rowNew.Cells[2].Value = vf.GetSignName(); rowNew.Cells[3].Value = vf.Val; rowNew.Tag = vf; txtVal4.Text = ""; }
void GetData() { string sData = ""; int iCount = 0; if (Session["ViewFilterMgr"] != null) { SortedList <Guid, CViewFilterMgr> sortObj = (SortedList <Guid, CViewFilterMgr>)Session["ViewFilterMgr"]; if (sortObj.ContainsKey(m_View.Id)) { CViewFilterMgr ViewFilterMgr = sortObj[m_View.Id]; ViewFilterMgr.IsLoad = true; //避免从数据库装载 List <CBaseObject> lstObj = ViewFilterMgr.GetList(); foreach (CBaseObject obj in lstObj) { CViewFilter ViewFilter = (CViewFilter)obj; CColumn col = (CColumn)m_Table.ColumnMgr.Find(ViewFilter.FW_Column_id); if (col == null) { continue; } sData += string.Format("{{ \"id\": \"{0}\",\"AndOr\":\"{1}\",\"Column\":\"{2}\",\"Sign\":\"{3}\", \"Val\":\"{4}\" }}," , ViewFilter.Id , ViewFilter.AndOr.Equals("and", StringComparison.OrdinalIgnoreCase) ? "与" : "或" , col.Name , ViewFilter.GetSignName() , ViewFilter.Val); iCount++; } } } sData = sData.TrimEnd(",".ToCharArray()); sData = "[" + sData + "]"; string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}" , sData, iCount); Response.Write(sJson); }
void GetData() { string sData = ""; int iCount = 0; List <CBaseObject> lstObj = m_View.ViewFilterMgr.GetList(); List <CViewFilter> sortObj = new List <CViewFilter>(); foreach (CBaseObject obj in lstObj) { CViewFilter ViewFilter = (CViewFilter)obj; sortObj.Add(ViewFilter); } sortObj.Sort(); foreach (CViewFilter ViewFilter in sortObj) { CColumn col = (CColumn)m_MTable.ColumnMgr.Find(ViewFilter.FW_Column_id); if (col == null) { continue; } sData += string.Format("{{ \"id\": \"{0}\",\"AndOr\":\"{1}\",\"Column\":\"{2}\",\"Sign\":\"{3}\", \"Val\":\"{4}\" }}," , ViewFilter.Id , ViewFilter.AndOr.Equals("and", StringComparison.OrdinalIgnoreCase)?"与":"或" , col.Name , ViewFilter.GetSignName() , ViewFilter.Val); iCount++; } sData = sData.TrimEnd(",".ToCharArray()); sData = "[" + sData + "]"; string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}" , sData, iCount); Response.Write(sJson); }
void LoadGridView4() { if (cbMasterTable.SelectedIndex == -1) { return; } DataItem item = (DataItem)cbMasterTable.SelectedItem; CTable tb = (CTable)item.Data; txtMasterTable4.Text = tb.Name; List <CBaseObject> lstObj = m_View.ViewFilterMgr.GetList(); List <CViewFilter> sortObj = new List <CViewFilter>(); foreach (CBaseObject obj in lstObj) { CViewFilter vf = (CViewFilter)obj; sortObj.Add(vf); } sortObj.Sort(); dataGridView4.Rows.Clear(); foreach (CViewFilter vf in sortObj) { CColumn column = (CColumn)tb.ColumnMgr.Find(vf.FW_Column_id); if (column == null) { continue; } dataGridView4.Rows.Add(1); DataGridViewRow rowNew = dataGridView4.Rows[dataGridView4.Rows.Count - 1]; rowNew.Cells[0].Value = vf.AndOr; rowNew.Cells[1].Value = column.Name; rowNew.Cells[2].Value = vf.GetSignName(); rowNew.Cells[3].Value = vf.Val; rowNew.Tag = vf; } }