public static void PrepareColumns(dynamic source, DataControlFieldCollection columns, Func<string, string> headerNameFormatter)
{
// if ViewState is enabled, the columns info will be persisted between requests and we only want to add the column
// the first time the grid is requested.
if (columns.Count == 0)
{
// at this point, the datasource must have been prepared and it must be a list
var properties = source[0].GetType().GetProperties();
foreach (var property in properties)
{
var name = property.Name;
var field = new BoundField
{
DataField = name,
HeaderText =
headerNameFormatter == null
? SeperateNamesWithSpace(name)
: headerNameFormatter(name),
SortExpression = name,
HtmlEncode = false
};
if (property.PropertyType.Name == "DateTime")
{
field.DataFormatString = "{0:dd-MMM-yyyy}";
}
columns.Add(field);
}
}
}
/// <summary>
/// Initialize ItemTemplate object for Each TemplateField column.
/// </summary>
/// <param name="columns">Column collection</param>
private void SetColumnItemTemplates(DataControlFieldCollection columns)
{
if (columns.Count > 0)
{
if (((TemplateField)Columns[0]).ItemTemplate == null)
{
((TemplateField)Columns[0]).ItemTemplate =
new CompiledBindableTemplateBuilder(BuildPropertyDropDown, null);
}
if (((TemplateField)Columns[1]).ItemTemplate == null)
{
((TemplateField)Columns[1]).ItemTemplate =
new CompiledBindableTemplateBuilder(BuildOperatorDropDown, null);
}
if (((TemplateField)Columns[2]).ItemTemplate == null)
{
((TemplateField)Columns[2]).ItemTemplate =
new CompiledBindableTemplateBuilder(BuildValueTextBox, null);
}
if (((TemplateField)Columns[3]).ItemTemplate == null)
{
((TemplateField)Columns[3]).ItemTemplate =
new CompiledBindableTemplateBuilder(BuildConditionDropDown, null);
}
if (((TemplateField)Columns[4]).ItemTemplate == null)
{
((TemplateField)Columns[4]).ItemTemplate =
new CompiledBindableTemplateBuilder(BuildAddRemoveButton, null);
}
}
}
public ColumnIndexer(DataControlFieldCollection columns)
{
_columns = columns;
columns.FieldsChanged += Columns_OnFieldsChanged;
_gridColumnIndexes = new Dictionary <string, int>();
RefreshColumns();
}
public void DataControlFieldCollection_Add()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
collection.Add(new BoundField());
Assert.AreEqual(1, collection.Count, "Add");
}
private int GetGridViewColumnIndex(DataControlFieldCollection columns, string columnName)
{
int index = -1;
foreach (DataControlField field in columns)
{
if (index == -1)
{
string headerName = "";
if (field is BoundField)
{
headerName = ((BoundField)field).HeaderText;
}
else if (field is TemplateField)
{
headerName = ((TemplateField)field).HeaderText;
}
if (headerName == columnName)
{
index = columns.IndexOf(field);
}
}
}
return(index);
}
public int DoExcell(string ruta, DataTable dt, DataControlFieldCollection col)
{
colCampos = col;
FileStream fs = new FileStream(ruta, FileMode.Create,
FileAccess.ReadWrite);
w = new StreamWriter(fs);
string bgColor = "", fontColor = "";
bgColor = " bgcolor=\"Blue\" ";
fontColor = " style=\"font-size: 12px;color: white;\" ";
EscribeCabecera(dt.TableName.ToUpper());
w.Write(@"<tr >");
foreach (DataControlField dcf in colCampos)
{
if (dcf is BoundField || dcf is TemplateField)
{
w.Write(@" <td {0} {1}> {2} </td>", bgColor, fontColor, dcf.HeaderText);
}
}
w.Write(@" </tr >");
foreach (DataRow dr in dt.Rows)
{
EscribeLinea(dr);
}
EscribePiePagina();
w.Close();
return(0);
}
private void ShowGrid()
{
EGV.AutoGenerateColumns = false;
DataControlFieldCollection dcfc = EGV.Columns;
dcfc.Clear();
TemplateField tf = new TemplateField();
CheckBox ch = new CheckBox();
tf.HeaderText = "选择";
BoundField bf1 = new BoundField();
bf1.HeaderText = "ID";
bf1.DataField = "ID";
bf1.HeaderStyle.Width = Unit.Percentage(5);
bf1.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
bf1.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
dcfc.Add(bf1);
DataTable dt = this.bfield.GetModelFieldListall(DataConverter.CLng(this.HdnModelID.Value));
foreach (DataRow dr in dt.Rows)
{
if (DataConverter.CBool(dr["ShowList"].ToString()))
{
ButtonField Link3 = new ButtonField();
Link3.ButtonType = ButtonType.Link;
Link3.HeaderText = dr["FieldAlias"].ToString();
Link3.DataTextField = dr["FieldName"].ToString();
Link3.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
Link3.ItemStyle.Width = Unit.Percentage(10);
Link3.ItemStyle.CssClass = "overflow:hidden;text-overflow:ellipsis";
dcfc.Add(Link3);
}
}
ButtonField Link = new ButtonField();
Link.ButtonType = ButtonType.Link;
Link.HeaderText = "修改";
Link.Text = "修改";
Link.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
Link.ItemStyle.Width = Unit.Percentage(10);
dcfc.Add(Link);
ButtonField Link1 = new ButtonField();
Link1.ButtonType = ButtonType.Link;
Link1.HeaderText = "删除";
Link1.Text = "删除";
Link1.ItemStyle.Width = Unit.Percentage(10);
Link1.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
Link1.CausesValidation = true;
dcfc.Add(Link1);
}
private void SetDataFields(DBSNAPGridView sdg, DataGridControl dc)
{
DataControlFieldCollection cols = sdg.Columns;
foreach (DataControlField col in cols)
{
string dfieldname = string.Empty;
try
{
Type t = col.GetType();
dfieldname =
(string)t.InvokeMember("DataField", System.Reflection.BindingFlags.GetProperty, null, col, new object[] { });
}
catch
{
}
if (dfieldname != string.Empty || dfieldname.Trim() != string.Empty)
{
DataField dfield = new DataField();
dfield.Name = dfieldname.Trim();
dc.SQLB.DataFields.Add(dfield);
}
}
}
/// <summary>
/// Creates Default GridView Columns
/// </summary>
/// <param name="columns">Column collection</param>
private void CreateGridViewColumns(DataControlFieldCollection columns)
{
this.Columns.Clear();
TemplateField propertyColumn = new TemplateField();
propertyColumn.HeaderText = Resources.GlobalResource.FilterPropertyColumnHeader;
propertyColumn.ItemTemplate = new CompiledBindableTemplateBuilder(BuildPropertyDropDown, null);
columns.Add(propertyColumn);
TemplateField operatorColumn = new TemplateField();
operatorColumn.HeaderText = Resources.GlobalResource.FilterOperatorColumnHeader;
operatorColumn.ItemTemplate = new CompiledBindableTemplateBuilder(BuildOperatorDropDown, null);
columns.Add(operatorColumn);
TemplateField valueColumn = new TemplateField();
valueColumn.HeaderText = Resources.GlobalResource.FilterValueColumnHeader;
valueColumn.ItemTemplate = new CompiledBindableTemplateBuilder(BuildValueTextBox, null);
columns.Add(valueColumn);
TemplateField conditionColumn = new TemplateField();
conditionColumn.HeaderText = Resources.GlobalResource.FilterConditionColumnHeader;
conditionColumn.ItemTemplate = new CompiledBindableTemplateBuilder(BuildConditionDropDown, null);
columns.Add(conditionColumn);
TemplateField addRemoveColumn = new TemplateField();
addRemoveColumn.ItemTemplate = new CompiledBindableTemplateBuilder(BuildAddRemoveButton, null);
columns.Add(addRemoveColumn);
}
protected void GV_List_Sorting(Object sender, GridViewSortEventArgs e)
{
DataControlFieldCollection dcfc = ((GridView)sender).Columns;
for (int i = 6; i < dcfc.Count; i++)
{
DataControlField dcf = dcfc[i];
if (dcf.SortExpression == e.SortExpression)
{
ColumnNum = i - 6;
string qty = "Qty" + (i - 6).ToString();
string actQty = "ActQty" + (i - 6).ToString();
string requiredQty = "RequiredQty" + (i - 6).ToString();
this.ScheduleDate = DateTime.Parse(e.SortExpression);
//todo wintime or starttime
this.hfLastScheduleTime.Value = dcf.FooterText;
DateTime?lastScheduleDate = null;
if (this.hfLastScheduleTime.Value != string.Empty)
{
lastScheduleDate = DateTime.Parse(this.hfLastScheduleTime.Value);
}
IList <MrpShipPlanView> mrpShipPlanViews = TheMrpShipPlanViewMgr.GetMrpShipPlanViews((isFlow ? this.flowOrLoc : null), (!isFlow ? this.flowOrLoc : null), this.itemCode, this.EffDate, null, null);
DetachedCriteria criteria = DetachedCriteria.For <ExpectTransitInventoryView>();
criteria.Add(Expression.Eq("EffectiveDate", this.EffDate));
IList <ExpectTransitInventoryView> transitInventoryViews = this.TheCriteriaMgr.FindAll <ExpectTransitInventoryView>(criteria);
ScheduleView scheduleView = TheMrpShipPlanViewMgr.TransferMrpShipPlanViews2ScheduleView(mrpShipPlanViews, transitInventoryViews, this.rblFlowOrLoc.SelectedValue, this.rblDateType.SelectedValue);
foreach (ScheduleBody body in scheduleView.ScheduleBodys)
{
PropertyInfo qtyProp = typeof(ScheduleBody).GetProperty(qty);
PropertyInfo actQtyProp = typeof(ScheduleBody).GetProperty(actQty);
PropertyInfo requiredQtyProp = typeof(ScheduleBody).GetProperty(requiredQty);
body.Qty0 = (decimal)qtyProp.GetValue(body, null);
body.ActQty0 = (decimal)actQtyProp.GetValue(body, null);
body.RequiredQty0 = (decimal)requiredQtyProp.GetValue(body, null);
}
this.GV_Order.DataSource = scheduleView.ScheduleBodys;
this.GV_Order.DataBind();
this.fld_Search.Visible = false;
this.div_OrderDetail.Visible = true;
this.div_MRP_Detail.Visible = false;
this.fld_Group.Visible = false;
if (isFlow)
{
this.tbFlow.Text = this.flowOrLoc;
dotbFlow_TextChanged(this.flowOrLoc);
}
//this.ucShift.Date = DateTime.Today;
break;
}
}
}
public static void SetHeaderStyle(
StateBag viewState,
DataControlFieldCollection columns,
string AscendingClassName,
string DescendingClassName)
{
SortDirection sortDirection = SortDirection.Ascending;
if (viewState[Const.SortDirection] != null)
{
sortDirection = (SortDirection)viewState[Const.SortDirection];
}
var column = viewState[Const.SortExpression] as string;
if (typeof(BoundField) == columns.GetType())
{
foreach (BoundField field in columns)
{
if (field.DataField == column)
{
field.HeaderStyle.CssClass = sortDirection == SortDirection.Ascending ? AscendingClassName : DescendingClassName;
}
else
{
field.HeaderStyle.CssClass = string.Empty;
}
}
}
}
//=====================================================================
// FunctionName : CustomColumnIndex
/// <summary>
/// 自定义显示列位置
/// </summary>
//=====================================================================
protected override void CustomColumnIndex()
{
DataControlFieldCollection dcListColunms = new DataControlFieldCollection();
dcListColunms = gvList.Columns.CloneFields();
DataControlFieldCollection dcPrintColunms = new DataControlFieldCollection();
dcPrintColunms = gvPrint.Columns.CloneFields();
int intTempColumnIndex = 0;
// 主表显示列位置改变
intTempColumnIndex = Convert.ToInt32(txtDMColumnIndex.Text);
if (intTempColumnIndex != intDMColumnIndex)
{
gvList.Columns.RemoveAt(intTempColumnIndex);
gvList.Columns.Insert(intTempColumnIndex, dcListColunms[intDMColumnIndex]);
gvPrint.Columns.RemoveAt(intTempColumnIndex - 1);
gvPrint.Columns.Insert(intTempColumnIndex - 1, dcPrintColunms[intDMColumnIndex - 1]);
intDMColumnIndex = intTempColumnIndex;
}
intTempColumnIndex = Convert.ToInt32(txtLXColumnIndex.Text);
if (intTempColumnIndex != intLXColumnIndex)
{
gvList.Columns.RemoveAt(intTempColumnIndex);
gvList.Columns.Insert(intTempColumnIndex, dcListColunms[intLXColumnIndex]);
gvPrint.Columns.RemoveAt(intTempColumnIndex - 1);
gvPrint.Columns.Insert(intTempColumnIndex - 1, dcPrintColunms[intLXColumnIndex - 1]);
intLXColumnIndex = intTempColumnIndex;
}
intTempColumnIndex = Convert.ToInt32(txtMCColumnIndex.Text);
if (intTempColumnIndex != intMCColumnIndex)
{
gvList.Columns.RemoveAt(intTempColumnIndex);
gvList.Columns.Insert(intTempColumnIndex, dcListColunms[intMCColumnIndex]);
gvPrint.Columns.RemoveAt(intTempColumnIndex - 1);
gvPrint.Columns.Insert(intTempColumnIndex - 1, dcPrintColunms[intMCColumnIndex - 1]);
intMCColumnIndex = intTempColumnIndex;
}
intTempColumnIndex = Convert.ToInt32(txtSJDMColumnIndex.Text);
if (intTempColumnIndex != intSJDMColumnIndex)
{
gvList.Columns.RemoveAt(intTempColumnIndex);
gvList.Columns.Insert(intTempColumnIndex, dcListColunms[intSJDMColumnIndex]);
gvPrint.Columns.RemoveAt(intTempColumnIndex - 1);
gvPrint.Columns.Insert(intTempColumnIndex - 1, dcPrintColunms[intSJDMColumnIndex - 1]);
intSJDMColumnIndex = intTempColumnIndex;
}
intTempColumnIndex = Convert.ToInt32(txtSMColumnIndex.Text);
if (intTempColumnIndex != intSMColumnIndex)
{
gvList.Columns.RemoveAt(intTempColumnIndex);
gvList.Columns.Insert(intTempColumnIndex, dcListColunms[intSMColumnIndex]);
gvPrint.Columns.RemoveAt(intTempColumnIndex - 1);
gvPrint.Columns.Insert(intTempColumnIndex - 1, dcPrintColunms[intSMColumnIndex - 1]);
intSMColumnIndex = intTempColumnIndex;
}
// 一对一对应表显示列改变
}
private void InitializeMembers()
{
this.parentEntity = null;
this.childrenType = EntityType.Unknown;
this.entityGroup = Registry.EntityGroup.Unknown;
this.text = null;
this.columns = new DataControlFieldCollection();
}
} // end method
/*
private static IEnumerable<Assembly> GetBinAssemblies(this IHttpController controller) {
var assemblies = new List<Assembly>();
string path = Assembly.GetExecutingAssembly().Location;
if (File.Exists(path))
path = Path.GetDirectoryName(path);
foreach (string dllFilename in Directory.GetFiles(path, "*.dll"))
assemblies.Add(Assembly.LoadFile(dllFilename));
return assemblies;
} // end method
*/
public static int GetColumnIndex(this GridView gridView, string columnName) {
DataControlFieldCollection columns = gridView.Columns;
int index = -1;
for (int c = 0; c < columns.Count && index == -1; c++)
if (columns[c].HeaderText == columnName)
index = c;
return index;
} // end method
public void DataControlFieldCollection_RemoveAt()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
collection.Add(new BoundField());
Assert.AreEqual(1, collection.Count, "CollectionCount");
collection.RemoveAt(0);
Assert.AreEqual(0, collection.Count, "RemoveAtIndex");
}
public void DataControlFieldCollection_Contains()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
BoundField field = new BoundField();
collection.Add(field);
bool result = collection.Contains(field);
Assert.AreEqual(true, result, "Contains");
}
public void DataControlFieldCollection_Clone()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
collection.Add(new BoundField());
Assert.AreEqual(1, collection.Count, "Add");
DataControlFieldCollection clone = collection.CloneFields();
Assert.AreEqual(1, clone.Count, "Clone");
}
public static DataControlField GetColumnByHeaderText(this DataControlFieldCollection dataControlFieldCollection, string headerText)
{
foreach (var column in DataControlFieldCollection)
{
if (column.HeaderText == headerText)
{
return(column);
}
}
}
public static void AssignColumName(DataControlFieldCollection col, string name, object value)
{
for (int i = 0; i < col.Count; i++)
{
if (col[i].HeaderText == name)
{
col[i].HeaderText = value as string;
}
}
}
private void HideGridViewColumnByHeader(GridView gridView, string columnName)
{
DataControlFieldCollection columns = gridView.Columns;
int indexOfColumn = GetGridViewColumnIndex(columns, columnName);
if (indexOfColumn >= 0)
{
columns[indexOfColumn].Visible = false;
}
}
public static int GetColumnIndex(this DataControlFieldCollection columns, string columnName, StringComparison comparison = StringComparison.CurrentCultureIgnoreCase)
{
for (int index = 0; index < columns.Count; index++)
{
if (columns[index].HeaderText.Equals(columnName, comparison))
{
return(index);
}
}
return(-1);
}
public static void renameEnrolledColumn_FieldsChanged(object sender, EventArgs e)
{
DataControlFieldCollection columns = (DataControlFieldCollection)sender;
foreach (DataControlField field in columns)
{
if (field.HeaderText == "Enrolled at Test Time")
{
field.HeaderText = "Enrolled in Tested Grade(s) at Test Time";
}
}
}
public void DataControlFieldCollection_IndexOf()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
BoundField field = new BoundField();
int result;
result = collection.IndexOf(field);
Assert.AreEqual(-1, result, "NotExistFieldIndex");
collection.Add(field);
result = collection.IndexOf(field);
Assert.AreEqual(0, result, "ExistFieldIndex");
}
public void DataControlFieldCollection_Remove()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
BoundField field = new BoundField();
collection.Add(field);
Assert.AreEqual(1, collection.Count, "CollectionCount");
collection.Remove(null);
Assert.AreEqual(1, collection.Count, "RemoveNotExistField");
collection.Remove(field);
Assert.AreEqual(0, collection.Count, "RemoveExistField");
}
public void DataControlFieldCollection_Insert()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
BoundField field = new BoundField();
collection.Add(new BoundField());
collection.Add(new BoundField());
Assert.AreEqual(2, collection.Count, "CollectionCount");
collection.Insert(0, field);
int result = collection.IndexOf(field);
Assert.AreEqual(0, result, "Insert");
}
void Columns_FieldsChanged(object sender, EventArgs e)
{
DataControlFieldCollection columns = (DataControlFieldCollection)sender;
foreach (DataControlField field in columns)
{
if (GlobalValues.Grade.Key == GradeKeys.Combined_PreK_12 &&
field.HeaderText == "Enrolled at Test Time")
{
field.HeaderText = "Enrolled in Tested Grade(s) at Test Time";
}
}
}
public void DataControlFieldCollection_CopyTo()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
collection.Add(new BoundField());
DataControlField[] fields = new DataControlField[collection.Count];
Array array = new DataControlField[collection.Count];
collection.CopyTo(fields, 0);
Assert.AreEqual(1, fields.Length, "CopyToDataControlField");
collection.CopyTo(array, 0);
Assert.AreEqual(1, array.Length, "CopyToArray");
}
public void DataControlFieldCollection_GetEnumerator()
{
DataControlFieldCollection collection = new DataControlFieldCollection();
collection.Add(new BoundField());
IEnumerator numerator = collection.GetEnumerator();
Assert.IsNotNull(numerator, "GetEnumerator");
if (!(numerator is IEnumerator))
{
Assert.Fail("IEnumerator not been created");
}
}
private int GetColumnIndex(string SortExpression, DataControlFieldCollection columns)
{
int num = 0;
foreach (DataControlField field in columns)
{
if (field.SortExpression == SortExpression)
{
return(num);
}
num++;
}
return(num);
}
public StandardGridViewTemplateGenerator(ListItemType type, DataControlFieldCollection columns = null)
{
Type = type;
Columns = columns;
if (columns != null)
{
InitialColumns = new DataControlFieldCollection();
// Save the columns initialy defined for the gridview
foreach (DataControlField column in columns)
{
InitialColumns.Add(column);
}
}
}
