public CView Convert(DataTable dataTable) { var view = new CView(); view.Column = new List <CColumn>(); foreach (var row2 in dataTable.Rows) { var row = row2 as DataRow; view.ViewName = (string)row[4]; view.Schema = new CSchema { SchemaName = (string)row[5] }; var column = new CColumn(view) { ColumnName = (string)row[0], ColumnTypeRaw = (string)row[1], ColumnSqlDbType = SqlMapper.ParseValueAsSqlDbType((string)row[1]), ColumnType = SqlMapper.GetDbType((string)row[1]), ColumnLength = row[3] != DBNull.Value ? (int)row[3] : -1, ColumnDescription = row[6] != DBNull.Value ? (string)row[6] : null }; view.Column.Add(column); } return(view); }
void LoadDetailColumn() { if (cbDetailTable.SelectedIndex == -1) { return; } DataItem item = (DataItem)cbDetailTable.SelectedItem; CTable tb = (CTable)item.Data; txtDetailTable.Text = tb.Name; CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj(); listDetailColumn.Items.Clear(); List <CBaseObject> lstObj = tb.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn column = (CColumn)obj; ListViewItem it = new ListViewItem(); it.Text = column.Name; it.Tag = column; listDetailColumn.Items.Add(it); if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null) { it.Checked = true; } } }
private IEnumerable <string> GetColumnOperators(CColumn column) { var list = new List <string>(); string opString = string.Empty; switch (GetMappingType(column.DbType.ToString()).ToString()) { case "System.DateTime": case "System.Int16": case "System.Int32": case "System.Int64": case "System.Double": opString = "=,<>,>,>=,<,<=,Is,Is Not"; break; case "System.Boolean": opString = "=,<>,Is,Is Not"; break; default: opString = "=,<>,Like,Is,Is Not"; break; } foreach (string op in opString.Split(new char[] { ',' })) { if (!list.Contains(op)) { list.Add(op); } } return(list); }
void GetData() { string tid = Request["tid"]; if (string.IsNullOrEmpty(tid)) { Response.End(); return; } CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(tid)); if (table == null) { Response.End(); return; } string sData = ""; List <CBaseObject> lstObj = table.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn col = (CColumn)obj; sData += string.Format("{{ \"id\": \"{0}\",\"Name\":\"{1}\", \"Code\":\"{2}\", \"ColType\":\"{3}\" }}," , col.Id, col.Name, col.Code, CColumn.ConvertColTypeToString(col.ColType)); } sData = sData.TrimEnd(",".ToCharArray()); sData = "[" + sData + "]"; string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}" , sData, lstObj.Count); Response.Write(sJson); }
void LoadDetailColumn() { if (cbDetailTable.SelectedIndex == -1) { return; } CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(cbDetailTable.SelectedItem.Value)); CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id); m_bIsLoadingData = true; listDetailColumn.Items.Clear(); List <CBaseObject> lstObj = table.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn column = (CColumn)obj; ListItem it = new ListItem(column.Name, column.Id.ToString()); listDetailColumn.Items.Add(it); if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null) { it.Selected = true; } } m_bIsLoadingData = false; }
private void cbPNodeIDCol_SelectedIndexChanged(object sender, EventArgs e) { if (cbPNodeIDCol.SelectedItem == null) { return; } DataItem item = (DataItem)cbPNodeIDCol.SelectedItem; CColumn column = (CColumn)item.Data; switch (column.ColType) { case ColumnType.int_type: case ColumnType.long_type: { txtRootFilter.Text = string.Format("{0}=0", column.Code); break; } case ColumnType.string_type: { txtRootFilter.Text = string.Format("({0}='' or {0} is null)", column.Code); break; } case ColumnType.guid_type: case ColumnType.ref_type: { txtRootFilter.Text = string.Format("{0}='{{00000000-0000-0000-0000-000000000000}}'", column.Code); break; } } }
public string GetColumnRefDefaultVal(CColumnDefaultValInViewDetail cdvivd, CColumn col) { CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable); CBaseObjectMgr BaseObjectMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(RefTable.Code, Guid.Empty); if (BaseObjectMgr == null) { BaseObjectMgr = new CBaseObjectMgr(); BaseObjectMgr.TbCode = RefTable.Code; BaseObjectMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString()); } CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol); CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol); List <CBaseObject> lstObjRef = BaseObjectMgr.GetList(); string defval = GetColumnDefaultVal(cdvivd, col).ToString(); foreach (CBaseObject objRef in lstObjRef) { string val = objRef.GetColValue(RefCol).ToString(); if (defval == val) { return(objRef.GetColValue(RefShowCol).ToString()); } } return(""); }
//设置文件上传路径 static public void SetUploadPath() { CContext ctx = GetCtx(); string sPath = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["VirtualDir"]); //设置默认文件上传路径 ctx.UploadPath = sPath + "\\UploadPath\\"; if (!Directory.Exists(ctx.UploadPath)) { Directory.CreateDirectory(ctx.UploadPath); } //设置产品图片上传路径 string sUploadPath = sPath + "\\Store\\ProductImg\\"; if (!Directory.Exists(sUploadPath)) { Directory.CreateDirectory(sUploadPath); } CTable table = ctx.TableMgr.FindByCode("SP_ProductImg"); if (table != null) { CColumn col = (CColumn)table.ColumnMgr.FindByCode("Url"); if (col != null) { col.UploadPath = sUploadPath; } } }
private void listMasterColumn_ItemChecked(object sender, ItemCheckedEventArgs e) { CColumn column = (CColumn)e.Item.Tag; if (e.Item.Checked) { CColumnInView civ = new CColumnInView(); civ.Ctx = Program.Ctx; civ.FW_Column_id = column.Id; civ.FW_Table_id = column.FW_Table_id; civ.Caption = column.Name; civ.UI_View_id = m_View.Id; m_View.ColumnInViewMgr.AddNew(civ); dataGridView.Rows.Add(1); DataGridViewRow rowNew = dataGridView.Rows[dataGridView.Rows.Count - 1]; rowNew.Cells[0].Value = column.Name; rowNew.Cells[0].ReadOnly = true; rowNew.Cells[1].Value = civ.Caption; rowNew.Tag = civ; } else { for (int i = 0; i < dataGridView.Rows.Count; i++) { CColumnInView civ = (CColumnInView)dataGridView.Rows[i].Tag; if (civ.FW_Column_id == column.Id) { m_View.ColumnInViewMgr.Delete(civ); dataGridView.Rows.RemoveAt(i); break; } } } }
void viewGrid_CellClick(object sender, DataGridViewCellEventArgs e) { if (View == null) { return; } if (viewGrid.dataGridView.CurrentRow == null) { return; } CViewDetail vd = (CViewDetail)View.ViewDetailMgr.GetFirstObj(); viewDetailGrid.ViewDetail = vd; CTable table = (CTable)Program.Ctx.TableMgr.Find(vd.FW_Table_id); if (table == null) { return; } CBaseObject obj = (CBaseObject)viewGrid.dataGridView.CurrentRow.Tag; CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, obj.Id); if (objMgr == null) { objMgr = obj.GetSubObjectMgr(table.Code, typeof(CBaseObjectMgr)); } if (objMgr == null) { CColumn colP = (CColumn)obj.Table.ColumnMgr.Find(vd.PrimaryKey); if (colP == null) { return; } CColumn colF = (CColumn)table.ColumnMgr.Find(vd.ForeignKey); if (colF == null) { return; } object objVal = obj.GetColValue(colP); string sVal = objVal.ToString(); bool bIsStr = false; if (colP.ColType == ColumnType.string_type || colP.ColType == ColumnType.text_type || colP.ColType == ColumnType.ref_type || colP.ColType == ColumnType.guid_type || colP.ColType == ColumnType.datetime_type) { sVal = string.Format("'{0}'", sVal); bIsStr = true; } objMgr = new CBaseObjectMgr(); objMgr.Ctx = Program.Ctx; objMgr.TbCode = table.Code; objMgr.m_Parent = obj; string sWhere = string.Format(" {0}={1}", colF.Code, bIsStr ? sVal : objVal); objMgr.Load(sWhere, false); } viewDetailGrid.BaseObjectMgr = objMgr; }
void LoadData() { listSelColumn.Items.Clear(); foreach (CBaseObject obj in m_Report.StatItemMgr.GetList()) { CStatItem StatItem = (CStatItem)obj; ListViewItem item = new ListViewItem(); 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); item.Text = table.Name; item.SubItems.Add(column.Name); } else { item.Text = StatItem.Name; item.SubItems.Add(StatItem.Formula); } item.Tag = StatItem; listSelColumn.Items.Add(item); } }
void LoadMasterColumn() { if (cbMasterTable.SelectedIndex == -1) { return; } DataItem item = (DataItem)cbMasterTable.SelectedItem; CTable tb = (CTable)item.Data; txtMasterTable.Text = tb.Name; listMasterColumn.Items.Clear(); cbMasterColumn4.Items.Clear(); List <CBaseObject> lstObj = tb.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn column = (CColumn)obj; ListViewItem it = new ListViewItem(); it.Text = column.Name; it.Tag = column; listMasterColumn.Items.Add(it); if (m_View.ColumnInViewMgr.FindByColumn(column.Id) != null) { it.Checked = true; } DataItem it2 = new DataItem(column.Name, column); cbMasterColumn4.Items.Add(it2); } }
void LoadDetailColumn() { if (cbDetailTable2.SelectedIndex == -1) { return; } m_bIsLoadingData = true;//避免触发Item_Checked事件 DataItem item = (DataItem)cbDetailTable2.SelectedItem; CTable table = (CTable)item.Data; CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id); listDetailColumn.Items.Clear(); List <CBaseObject> lstObj = table.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn column = (CColumn)obj; ListViewItem it = new ListViewItem(); it.Text = column.Name; it.Tag = column; listDetailColumn.Items.Add(it); if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null) { it.Checked = true; } } m_bIsLoadingData = false; }
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 LoadHeader() { if (Company == null) { return; } if (dataGridView == null) { return; } dataGridView.Columns.Clear(); List <CBaseObject> lstCol = Company.WorkflowDefMgr.Table.ColumnMgr.GetList(); foreach (CBaseObject obj in lstCol) { CColumn col = (CColumn)obj; //if (!col.IsVisible) // continue; DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } }
void LoadDetailColumn() { CViewDetail ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj(); if (ViewDetail == null) { return; } CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(ViewDetail.FW_Table_id); txtDetailTable.Text = table.Name; listDetailColumn.Items.Clear(); List <CBaseObject> lstObj = table.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn column = (CColumn)obj; ListItem it = new ListItem(column.Name, column.Id.ToString()); listDetailColumn.Items.Add(it); if (ViewDetail.ColumnInViewDetailMgr.FindByColumn(column.Id) != null) { it.Selected = true; } } }
void trd() { timer1.Enabled = true; m_baseMgr = new CBaseObjectMgr(); m_baseMgr.Ctx = Program.Ctx; m_baseMgr.TbCode = "test5"; CTable tb = Program.Ctx.TableMgr.FindByCode("test5"); CColumn col = tb.ColumnMgr.FindByCode("val"); double dblCount = 0; while (m_bIsStart) { //for (int i = 0; i < 100; i++) //{ CBaseObject obj = new CBaseObject(); obj.Ctx = Program.Ctx; obj.TbCode = "test5"; Random rand = new Random(); obj.SetColValue(col, rand.NextDouble() * 10); m_baseMgr.AddNew(obj, true); dblCount++; this.Invoke(new myEventHandler(ChangeLabelText), new object[] { dblCount.ToString() }); //} //m_baseMgr.Save(true); } }
private void button2_Click(object sender, EventArgs e) { CTable tb = Program.Ctx.TableMgr.FindByCode("test5"); CColumn col = tb.ColumnMgr.FindByCode("val"); DateTime now1 = DateTime.Now; double dlbSum = 0; List <CBaseObject> lst = m_baseMgr.GetList(); //foreach (CBaseObject obj in lst) //{ // //dlbSum += obj.m_arrNewVal["val"].DoubleVal; //} int idx = lst[0].GetColIdx("val"); for (int i = 0; i < lst.Count; i++) { CBaseObject obj = lst[i]; dlbSum += obj.GetColValue2(idx).DoubleVal; } DateTime now2 = DateTime.Now; TimeSpan span = now2 - now1; string sText = string.Format("求和:{0} ,耗时:{1}", dlbSum, span.TotalSeconds); MessageBox.Show(sText); }
void LoadHeader() { if (BaseObjectMgr == null) { return; } if (dataGridView == null) { return; } dataGridView.Columns.Clear(); bool bHas = false; if (View != null) { List <CBaseObject> lstCIV = View.ColumnInViewMgr.GetList(); if (lstCIV.Count > 0) { bHas = true; foreach (CBaseObject obj in lstCIV) { CColumnInView civ = (CColumnInView)obj; CColumn col = (CColumn)BaseObjectMgr.Table.ColumnMgr.Find(civ.FW_Column_id); if (col == null) { continue; } DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } } } if (!bHas) { List <CBaseObject> lstCol = baseObjectMgr.Table.ColumnMgr.GetList(); foreach (CColumn col in lstCol) { //if (!col.IsVisible) // continue; DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } } //工作流 if (m_bShowWorkflow) { DataGridViewTextBoxColumn columnWF = new DataGridViewTextBoxColumn(); columnWF.Name = "workflow"; columnWF.HeaderText = "工作流"; dataGridView.Columns.Add(columnWF); } }
void LoadHeader() { if (ViewDetail == null) { return; } if (dataGridView == null) { return; } dataGridView.Columns.Clear(); CTable table = (CTable)Program.Ctx.TableMgr.Find(ViewDetail.FW_Table_id); if (table == null) { return; } bool bHas = false; List <CBaseObject> lstCIVD = ViewDetail.ColumnInViewDetailMgr.GetList(); if (lstCIVD.Count > 0) { bHas = true; foreach (CBaseObject obj in lstCIVD) { CColumnInViewDetail civd = (CColumnInViewDetail)obj; CColumn col = (CColumn)table.ColumnMgr.Find(civd.FW_Column_id); if (col == null) { continue; } DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } } if (!bHas) { List <CBaseObject> lstCol = table.ColumnMgr.GetList(); foreach (CColumn col in lstCol) { //if (!col.IsVisible) // continue; DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } } ////工作流 //DataGridViewTextBoxColumn columnWF = new DataGridViewTextBoxColumn(); //columnWF.Name = "workflow"; //columnWF.HeaderText = "工作流"; //dataGridView.Columns.Add(columnWF); }
void LoadGridView() { if (cbTable.SelectedIndex == -1) { return; } DataItem item = (DataItem)cbTable.SelectedItem; CTable table = (CTable)item.Data; m_SelTable = table; List <CBaseObject> lstObj = table.ColumnMgr.GetList(); dataGridView.Rows.Clear(); foreach (CBaseObject obj in lstObj) { CColumn col = (CColumn)obj; if (col.Code.Equals("id", StringComparison.OrdinalIgnoreCase) || col.Code.Equals("Creator", StringComparison.OrdinalIgnoreCase) || col.Code.Equals("Created", StringComparison.OrdinalIgnoreCase) || col.Code.Equals("Updator", StringComparison.OrdinalIgnoreCase) || col.Code.Equals("Updated", StringComparison.OrdinalIgnoreCase)) { continue; } if (table.Id == m_View.FW_Table_id) //主表 { CColumnDefaultValInView cdviv = m_View.ColumnDefaultValInViewMgr.FindByColumn(col.Id); dataGridView.Rows.Add(1); DataGridViewRow rowNew = dataGridView.Rows[dataGridView.Rows.Count - 1]; rowNew.Cells[0].Value = col.Name; rowNew.Cells[0].ReadOnly = true; if (cdviv != null) { rowNew.Cells[1].Value = cdviv.DefaultVal; rowNew.Cells[2].Value = cdviv.ReadOnly; } rowNew.Tag = col; } else //从表 { CViewDetail ViewDetail = m_View.ViewDetailMgr.FindByTable(table.Id); CColumnDefaultValInViewDetail cdvivd = ViewDetail.ColumnDefaultValInViewDetailMgr.FindByColumn(col.Id); dataGridView.Rows.Add(1); DataGridViewRow rowNew = dataGridView.Rows[dataGridView.Rows.Count - 1]; rowNew.Cells[0].Value = col.Name; rowNew.Cells[0].ReadOnly = true; if (cdvivd != null) { rowNew.Cells[1].Value = cdvivd.DefaultVal; rowNew.Cells[2].Value = cdvivd.ReadOnly; } rowNew.Tag = col; } } }
public virtual void IsDropOnColumn(CColumn column) { if (column == null || this.m_RectTransform == null) { return; } this.m_Column = column; this.m_RectTransform.SetParent(this.m_Column.transform); }
void GetCondiction() { string Table_id = Request["Table_id"]; string Column_id = Request["Column_id"]; string Val = Request["Val"]; CTable table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(new Guid(Table_id)); if (table == null) { return; } CColumn col = (CColumn)table.ColumnMgr.Find(new Guid(Column_id)); if (col == null) { return; } if (col.ColType == ColumnType.int_type || col.ColType == ColumnType.long_type || col.ColType == ColumnType.numeric_type || col.ColType == ColumnType.bool_type) { if (Val == "") { Val = "0"; } else { try { Convert.ToDouble(Val); } catch { return; } } } else { if (Val == "") { Val = "''"; } else { if (Val[0] != '\'') { Val = "\'" + Val; } if (Val[Val.Length - 1] != '\'') { Val += "\'"; } } } Response.Write(Val); }
public void SetColumnVisible(CColumn col, bool bVisible) { foreach (DataGridViewColumn column in dataGridView.Columns) { if (column.Name.Equals(col.Code, StringComparison.OrdinalIgnoreCase)) { column.Visible = bVisible; } } }
private void btOk_Click(object sender, EventArgs e) { if (listColumn.SelectedItems.Count == 0) { MessageBox.Show("请选择一项!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } m_SelColumn = (CColumn)listColumn.SelectedItems[0].Tag; DialogResult = DialogResult.OK; }
//日期型字段是否显示时间部分 public string GetShowTimel(CColumn col) { if (m_sortShowTimeColumn.ContainsKey(col.Code)) { return("true"); } else { return("false"); } }
private CQuerieResult GetFavoritesData() { CQuerieResult q = new CQuerieResult(); var db = Services.XServices.Instance.GetService <Services.XDatabase>(); List <string> favorites = db.GetFavorites(); CColumn[] columns = new CColumn[2]; CRow[] rows = new CRow[favorites.Count]; columns[0] = new CColumn() { DisplayDescription = "Name" }; columns[1] = new CColumn() { DisplayDescription = "Description" }; //columns[2] = new CColumn() { DisplayDescription = "Pic" }; q.Columns = columns; q.Rows = rows; int i = 0; foreach (var item in favorites) { CRow row = new CRow(); CObject output = Newtonsoft.Json.JsonConvert.DeserializeObject <CObject>(item); m_Query.SetMainObject(output); row.Items = new CCell[2]; row.Items[0] = new CCell() { Text = output.Name, UID = output.UID, Picture = output.Picture }; row.Items[1] = new CCell() { Text = output.Description, UID = output.UID, Picture = output.Picture }; //row.Items[2] = new CCell() { Text = output.Picture, UID = output.UID, Picture = output.Picture }; row.UID = output.UID; rows[i] = row; i++; } m_Query.SetNavigator(this.Navigator.Database); m_Query.Query = q; m_Query.ShowListQuery(); return(q); }
void LoadColumn() { cbColumn.Items.Clear(); List <CBaseObject> lstObj = m_Table.ColumnMgr.GetList(); foreach (CBaseObject obj in lstObj) { CColumn col = (CColumn)obj; ListItem item = new ListItem(col.Name, col.Id.ToString()); cbColumn.Items.Add(item); } }
void PostData() { CUser user = (CUser)Session["User"]; COrg BaseObject = new COrg(); BaseObject.Ctx = Global.GetCtx(Session["TopCompany"].ToString()); BaseObject.Creator = user.Id; List <CBaseObject> lstCol = m_Table.ColumnMgr.GetList(); bool bHasVisible = false; foreach (CBaseObject obj in lstCol) { CColumn col = (CColumn)obj; if (col.Code.Equals("id", StringComparison.OrdinalIgnoreCase)) { continue; } else if (col.Code.Equals("Created", StringComparison.OrdinalIgnoreCase)) { continue; } else if (col.Code.Equals("Creator", StringComparison.OrdinalIgnoreCase)) { //BaseObject.SetColValue(col, Program.User.Id); continue; } else if (col.Code.Equals("Updated", StringComparison.OrdinalIgnoreCase)) { continue; } else if (col.Code.Equals("Updator", StringComparison.OrdinalIgnoreCase)) { //BaseObject.SetColValue(col, Program.User.Id); continue; } BaseObject.SetColValue(col, Request.Params[col.Code]); bHasVisible = true; } if (!bHasVisible) { Response.Write("没有可修改字段!"); return; } if (!m_Company.OrgMgr.AddNew(BaseObject, true)) { Response.Write("添加失败!"); return; } }
void LoadHeader() { if (BaseObjectMgr == null) { return; } if (dataGridView == null) { return; } dataGridView.Columns.Clear(); bool bHas = false; if (TableInFormControl != null) { List <CBaseObject> lstCIWC = TableInFormControl.ColumnInTableInFormControlMgr.GetList(); if (lstCIWC.Count > 0) { bHas = true; foreach (CBaseObject obj in lstCIWC) { CColumnInTableInFormControl ciwc = (CColumnInTableInFormControl)obj; CColumn col = (CColumn)BaseObjectMgr.Table.ColumnMgr.Find(ciwc.FW_Column_id); if (col == null) { continue; } DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } } } if (!bHas) { List <CBaseObject> lstCol = baseObjectMgr.Table.ColumnMgr.GetList(); foreach (CColumn col in lstCol) { //if (!col.IsVisible) // continue; DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = col.Code; column.HeaderText = col.Name; column.Tag = col; dataGridView.Columns.Add(column); } } }