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