// InitGridColumns 初始化表格函数 (只有一个DataTable参数) public List <GridColumn> InitGridColumns(DataTable ds) { List <GridColumn> columns = new List <GridColumn>(); RenderField field = null; columns.Add(new RowNumberField()); //为表格创建动态列 for (int i = 1; i < ds.Columns.Count; i++) { field = new RenderField(); field.HeaderText = ds.Columns[i].ToString(); field.DataField = ds.Columns[i].ToString(); if (i == ds.Columns.Count - 1) { field.BoxFlex = 1; } if (ds.Columns[i].ToString() == "专业名称") { field.Width = 200; } field.MinWidth = 100; columns.Add(field); } return(columns); }
private void LoadData() { ViewBag.Grid1DataSource = GetSourceData(); List <GridColumn> columns = new List <GridColumn>(); columns.Add(new RowNumberField()); // Name var nameField = new RenderField(); nameField.Width = 100; nameField.ColumnID = "Name"; nameField.DataField = "Name"; nameField.HeaderText = "收费项目"; nameField.ExpandUnusedSpace = true; columns.Add(nameField); // YearData var yearDataField = new RenderField(); yearDataField.ColumnID = "YearData"; yearDataField.DataField = "YearData"; yearDataField.HeaderText = "年份数据(隐藏)"; yearDataField.Hidden = true; columns.Add(yearDataField); // 年份列 RenderField rf; for (int i = _minYear; i <= _maxYear; i++) { rf = new RenderField(); rf.Width = 120; rf.HeaderText = i + "年"; rf.FieldType = FieldType.Int; rf.ColumnID = "Year_" + i; NumberBox nb = new NumberBox(); nb.NoNegative = true; nb.ID = "Year_" + i + "_Editor"; nb.Required = true; rf.Editor.Add(nb); columns.Add(rf); } // 合计列 rf = new RenderField(); rf.Width = 120; rf.HeaderText = "合计"; rf.FieldType = FieldType.Int; rf.ColumnID = "TotalFee"; columns.Add(rf); ViewBag.Grid1Columns = columns.ToArray(); ViewBag.StartupScript = String.Format("window._MINYEAR={0};window._MAXYEAR={1};", _minYear, _maxYear); }
private void InitGridColumns() { List <GridColumn> columns = new List <GridColumn>(); RenderField field = null; columns.Add(new RowNumberField()); field = new RenderField(); field.HeaderText = "性别"; field.DataField = "Gender"; field.FieldType = FieldType.Int; field.RendererFunction = "renderGender"; field.Width = 80; columns.Add(field); field = new RenderField(); field.HeaderText = "入学年份"; field.DataField = "EntranceYear"; field.FieldType = FieldType.Int; field.Width = 100; columns.Add(field); RenderCheckField checkfield = new RenderCheckField(); checkfield.HeaderText = "是否在校"; checkfield.DataField = "AtSchool"; checkfield.RenderAsStaticField = true; checkfield.Width = 100; columns.Add(checkfield); field = new RenderField(); field.HeaderText = "所学专业"; field.DataField = "Major"; field.RendererFunction = "renderMajor"; field.ExpandUnusedSpace = true; columns.Add(field); field = new RenderField(); field.HeaderText = "分组"; field.DataField = "Group"; field.RendererFunction = "renderGroup"; field.Width = 80; columns.Add(field); field = new RenderField(); field.HeaderText = "注册日期"; field.DataField = "LogTime"; field.FieldType = FieldType.Date; field.Renderer = Renderer.Date; field.RendererArgument = "yyyy-MM-dd"; field.Width = 100; columns.Add(field); ViewBag.Grid1Columns = columns.ToArray(); }
protected void GridGoods_RowDataBound(object sender, GridRowEventArgs e) { //渲染颜色 DataRowView row = e.DataItem as DataRowView; string DHZQ1 = row["DHZQ1"].ToString(); RenderField rDHZQ1 = GridGoods.FindColumn("DHZQ1") as RenderField; if (DHZQ1 == "A") { e.CellCssClasses[rDHZQ1.ColumnIndex] = "color1"; } }
//AddOtherColumn 为“添加专业”表格添加额外行 public List <GridColumn> AddOtherColumn(List <GridColumn> columns) { RenderField field1 = null; field1 = new RenderField(); field1.HeaderText = "添加"; field1.RendererFunction = "renderAction3"; field1.MinWidth = 80; field1.BoxFlex = 1; columns.Add(field1); return(columns); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //using (var appdb = new AppContext()) //{ // IQueryable<Provider> pq = appdb.providers; // ddlSupplierId.DataSource = pq.ToList(); // ddlSupplierId.DataTextField = "Name"; // ddlSupplierId.DataValueField = "Name"; // ddlSupplierId.DataBind(); //} LoadData(); if (CheckPower("ProviderEdit")) { RenderField column = Grid1.FindColumn("ProviderName") as RenderField; column.EnableColumnEdit = !column.EnableColumnEdit; } } }
protected void Grid1_RowDataBound(object sender, FineUIPro.GridRowEventArgs e) { // e.DataItem -> System.Data.DataRowView or custom class. // e.RowIndex -> Current row index. // e.Values -> Rendered html for each column of this row. Infobasis.Data.DataEntity.Company company = e.DataItem as Infobasis.Data.DataEntity.Company; CompanyStatus companyStatus = (CompanyStatus)company.CompanyStatus; RenderField rfCompnyStatus = Grid1.FindColumn("CompanyStatus") as RenderField; if (companyStatus == CompanyStatus.Expired) { //e.RowCssClass = "Expired-Company"; e.CellAttributes[rfCompnyStatus.ColumnIndex]["data-color"] = "Expired-Company"; } else if (companyStatus == CompanyStatus.Disabled) { //e.RowCssClass = "Disabled-Company"; e.CellAttributes[rfCompnyStatus.ColumnIndex]["data-color"] = "Disabled-Company"; } }
public void Run() { Console.WindowHeight = 38; Console.WindowWidth = 120; int fieldHeight = 28; int fieldWidth = 28; Field game = new Field(); game.CreateField(fieldHeight, fieldWidth); RenderField render = new RenderField(); render.DrawBorders(game.GameField); bool exit = false; while (!exit) { if (Console.KeyAvailable) { ConsoleKey key = Console.ReadKey(true).Key; if (key == ConsoleKey.A) { Random random = new Random(); int[] animalPos = new int[] { random.Next(fieldHeight), random.Next(fieldWidth) }; Prey antilope = new Prey(animalPos, Constants.Health, Constants.PreySpeed, Constants.PreyFOV, 'A'); game.AddAnimal(antilope); //continue; } if (key == ConsoleKey.L) { Random random = new Random(); int[] animalPos = new int[] { random.Next(fieldHeight), random.Next(fieldWidth) }; Predator lion = new Predator(animalPos, Constants.Health, Constants.LionSpeed, Constants.LionFOV, 'L'); game.AddAnimal(lion); //continue; } if (key == ConsoleKey.Escape) { exit = true; //continue; } } Surroundings getSurroundings = new Surroundings(); getSurroundings.AnalizeField(game.GameField); render.DrawField(game.GameField); //Think think = new Think(); //think.WatchAround(game.GameField); //think.SortByDistance(); Thread.Sleep(1000 / 24); } }
// InitGridColumns 初始化表格函数 (DataTable参数+校验表参数) public List <GridColumn> InitGridColumns(DataTable ds, DataView VerifyDv, string MajorId) { List <GridColumn> columns = new List <GridColumn>(); RenderField field = null; TextBox NewControl1 = null; // 单文本 TextArea NewControl2 = null; // 文本框 DatePicker NewControl3 = null; // 日期 DropDownList NewControl4 = null; // 单选框和其他字段和复选框 NumberBox NewControl5 = null; // 数值 ListItem NewList = null; // 单选下拉列表 string RadioValue = null; // 单选列表值 string VerifyType = null; // 校验字段类型 string VerifyValue = null; // 校验值 string sSQL = null; DataView DependedTable = null; // 其他字段 - 依赖的表 int DependedTableId; // 其他字段 - 依赖的表名 int DependedAttriId; // 其他字段 - 依赖的属性ID int DisplayOrder; // 其他字段 - 依赖字段的显示顺序 int i; int j; columns.Add(new RowNumberField()); //为表格创建动态列 for (i = 1; i < ds.Columns.Count; i++) { field = new RenderField(); field.HeaderText = ds.Columns[i].ToString(); field.DataField = ds.Columns[i].ToString(); if (i == ds.Columns.Count - 1) { field.BoxFlex = 1; } field.MinWidth = 80; VerifyType = VerifyDv[i - 1][3].ToString(); VerifyValue = VerifyDv[i - 1][5].ToString(); if (VerifyType == "单文本") { NewControl1 = new TextBox(); field.Editor.Add(NewControl1); } else if (VerifyType == "文本框") { NewControl2 = new TextArea(); field.Editor.Add(NewControl2); } else if (VerifyType == "日期") { NewControl3 = new DatePicker(); field.FieldType = FieldType.Date; field.Renderer = Renderer.Date; field.RendererArgument = "yyyyMMdd"; field.Editor.Add(NewControl3); } else if (VerifyType == "单选") { NewControl4 = new DropDownList(); while (VerifyValue != null) { // 截取校验值并赋值给RadioValue RadioValue = VerifyValue.IndexOf('$') >= 0 ? (VerifyValue.Substring(0, VerifyValue.IndexOf('$'))) : VerifyValue; // 创建新列表元素并加入下拉列表中 NewList = new ListItem(); NewList.Text = RadioValue; NewList.Value = RadioValue; NewControl4.Items.Add(NewList); // 移除校验值中已经确认的值 VerifyValue = VerifyValue.IndexOf('$') >= 0 ? VerifyValue.Remove(0, VerifyValue.IndexOf("$") + 1) : null; } field.Editor.Add(NewControl4); } else if (VerifyType == "复选框") { NewControl4 = new DropDownList(); NewControl4.EnableMultiSelect = true; while (VerifyValue != null) { // 截取校验值并赋值给RadioValue RadioValue = VerifyValue.IndexOf('$') >= 0 ? (VerifyValue.Substring(0, VerifyValue.IndexOf('$'))) : VerifyValue; // 创建新列表元素并加入下拉列表中 NewList = new ListItem(); NewList.Text = RadioValue; NewList.Value = RadioValue; NewControl4.Items.Add(NewList); // 移除校验值中已经确认的值 VerifyValue = VerifyValue.IndexOf('$') >= 0 ? VerifyValue.Remove(0, VerifyValue.IndexOf("$") + 1) : null; } field.Editor.Add(NewControl4); } else if (VerifyType == "数值") { field.FieldType = FieldType.Int; NewControl5 = new NumberBox(); NewControl5.NoDecimal = true; field.Editor.Add(NewControl5); } else if (VerifyType == "其他字段") { NewControl4 = new DropDownList(); DependedTableId = Convert.ToInt32(VerifyValue.Substring(0, VerifyValue.IndexOf('$'))); DependedAttriId = Convert.ToInt32(VerifyValue.Substring(VerifyValue.IndexOf('$') + 1)); sSQL = "SELECT attriDisplayOrder FROM [dbo].[tableAttributeArrange] WHERE tableID = " + DependedTableId + " AND attributeID = " + DependedAttriId; DisplayOrder = Convert.ToInt32(SqlHelper.getDataSource(sSQL)[0][0].ToString()); sSQL = "exec [dbo].[GetTableDataList] " + DependedTableId + ",'" + Session["SchoolId"] + "','" + MajorId + "'"; DependedTable = SqlHelper.getDataSource(sSQL); for (j = 0; j < DependedTable.Count; j++) { RadioValue = DependedTable[j][DisplayOrder].ToString(); NewList = new ListItem(); NewList.Text = RadioValue; NewList.Value = RadioValue; NewControl4.Items.Add(NewList); } field.Editor.Add(NewControl4); } columns.Add(field); } return(columns); }