public static ClsBindGrid pGridCfg_Get(String GridName) { List<ClsBindGrid> List_Grid = Do_Methods.DeserializeObjectFromFile_Json<List<ClsBindGrid>>(Layer01_Constants.CnsPathGridCfg); if (List_Grid == null) { List_Grid = new List<ClsBindGrid>(); } ClsBindGrid Grid = List_Grid.FirstOrDefault(O => O.pName == GridName); if (Grid == null) { Grid = new ClsBindGrid() { pName = GridName }; } return Grid; }
void Test_Form2_Load(object sender, EventArgs e) { Do_Globals.gSettings.pConnectionString = @"User ID=sa; Password=Administrator1; Initial Catalog=Damit; Data Source=.\SQL_2K8R2;"; ClsBindGrid GridDef = new ClsBindGrid(); GridDef.pColumns.Add(new ClsBindGridColumn("Name")); GridDef.pColumns.Add(new ClsBindGridColumn("Code")); ClsMayari Obj = new ClsMayari(null); this.ucFilter1.Setup(this.ucGrid1, GridDef, Obj.List_Empty()); this.ucGrid1.Setup_FromBase("Test", Obj, GridDef, new List<string>() { "MayariID" }, false, true, true); }
public static void pGridCfg_Set(String GridName, ClsBindGrid Value) { List<ClsBindGrid> List_Grid = (List<ClsBindGrid>)Do_Methods.DeserializeObjectFromFile_Json(typeof(List<ClsBindGrid>), Layer01_Constants.CnsPathGridCfg); if (List_Grid == null) { List_Grid = new List<ClsBindGrid>(); } ClsBindGrid Grid = List_Grid.FirstOrDefault(O => O.pName == GridName); if (Grid == null) { List_Grid.Add(Value); } else { Grid.pColumns = Value.pColumns; } Do_Methods.SerializeObjectToFile_Json(List_Grid, Layer01_Constants.CnsPathGridCfg); }
public static void BindGrid( C1TrueDBGrid Grid , String GridName , DataTable Dt_Source , ClsBindGrid GridDef , Boolean IsDefault = false , Boolean IsSelect = false) { ClsBindGrid GridDef_Cfg = Layer01_Config.pGridCfg_Get(GridName); if (((GridDef.pColumns.Count != GridDef_Cfg.pColumns.Count) || IsDefault)) { GridDef_Cfg.pColumns = GridDef.pColumns; Layer01_Config.pGridCfg_Set(GridName, GridDef_Cfg); } if (IsSelect) { if (!Dt_Source.Columns.Contains("IsSelect")) { Dt_Source.Columns.Add("IsSelect", typeof(Boolean)); } foreach (DataRow Dr in Dt_Source.Rows) { Dr["IsSelect"] = false; } foreach (var Item in GridDef_Cfg.pColumns) { Item.pOrderIndex++; } ClsBindGridColumn Gc_New = new ClsBindGridColumn(); GridDef_Cfg.pColumns.Add(Gc_New); Gc_New.pFieldName = "IsSelect"; Gc_New.pFieldDesc = "Is Select?"; Gc_New.pWidth = 80; Gc_New.pHorizontalAlign = Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Center; Gc_New.pOrderIndex = 0; } InitializeGrid(Grid); Grid.DataSource = Dt_Source; Grid.Splits[0].CaptionHeight = 45; BindGrid_SetColumns(Grid, GridDef_Cfg); }
public void Setup(ClsBindGrid GridDef, DataTable Dt_Source) { List<ClsBindGridColumn> GridDef_Columns = GridDef.pColumns; this.mFilterFields = new List<UcFilter_Field>(); foreach ( ClsBindGridColumn Item_Gc in (from O in GridDef_Columns where O.pIsFilter == true select O)) { UcFilter_Field Field = new UcFilter_Field(); Field.FieldName = Item_Gc.pFieldName; Field.FieldDesc = Item_Gc.pFieldDesc; if (Dt_Source.Columns.Contains(Item_Gc.pFieldName)) { Field.DataType = Dt_Source.Columns[Item_Gc.pFieldName].DataType; } this.mFilterFields.Add(Field); } Layer01_Methods.BindCombo(this.Cbo_Field, this.mFilterFields, "FieldDesc", "FieldName"); //[-] this.mDt_FilterItems = new DataTable(); this.mDt_FilterItems.Columns.Add("Key", typeof(Int64)); this.mDt_FilterItems.Columns.Add("Field", typeof(String)); this.mDt_FilterItems.Columns.Add("Field_Condition", typeof(String)); this.mDt_FilterItems.Columns.Add("Btn_Delete", typeof(String)); Layer01_Methods_C1.InitializeGrid(this.Grid_Filters); this.Grid_Filters.FilterBar = false; this.Grid_Filters.AllowFilter = false; this.Grid_Filters.DataSource = this.mDt_FilterItems; ClsBindGrid GridDef_FilterItems = new ClsBindGrid(); GridDef_FilterItems.pColumns.Add(new ClsBindGridColumn("Field", "Field", 100)); GridDef_FilterItems.pColumns.Add(new ClsBindGridColumn("Field_Condition", "Condition", 200)); GridDef_FilterItems.pColumns.Add(new ClsBindGridColumn("Btn_Delete", "", 100, "", Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button, Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Center)); Layer01_Methods_C1.BindGrid_SetColumns(this.Grid_Filters, GridDef_FilterItems); this.Setup_EventHandlers(); }
public static void BindGrid_SetColumns( C1TrueDBGrid Grid , ClsBindGrid GridDef) { List<ClsBindGridColumn> GridDef_Columns = GridDef.pColumns; List<String> List_Columns = (from O in GridDef_Columns orderby O.pOrderIndex select O.pFieldName).ToList(); SetGridColumnArrangement(Grid, List_Columns); foreach (Split Sp in Grid.Splits) { foreach (C1DisplayColumn Dc in Sp.DisplayColumns) { var Inner_ItemColumn = GridDef_Columns.FirstOrDefault(O => O.pFieldName == Dc.DataColumn.DataField); if (Inner_ItemColumn != null) { Dc.Width = Inner_ItemColumn.pWidth; Dc.DataColumn.Caption = Inner_ItemColumn.pFieldDesc; Dc.Locked = !Inner_ItemColumn.pIsEnabled; Dc.FetchStyle = true; switch (Inner_ItemColumn.pHorizontalAlign) { case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Center: Dc.Style.HorizontalAlignment = AlignHorzEnum.Center; break; case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Far: Dc.Style.HorizontalAlignment = AlignHorzEnum.Far; break; case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_General: Dc.Style.HorizontalAlignment = AlignHorzEnum.General; break; case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Justify: Dc.Style.HorizontalAlignment = AlignHorzEnum.Justify; break; case Layer01_Constants.eSystem_Lookup_HorizontalAlign.Grid_HorizontalAlign_Near: Dc.Style.HorizontalAlignment = AlignHorzEnum.Near; break; default: Dc.Style.HorizontalAlignment = AlignHorzEnum.Justify; break; } switch (Inner_ItemColumn.pFieldType) { case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button: Dc.ButtonAlways = true; Dc.ButtonText = true; Dc.Locked = true; Dc.Frozen = true; break; } } else { Dc.Visible = false; Dc.AllowSizing = false; } Dc.HeadingStyle.HorizontalAlignment = AlignHorzEnum.Justify; } } }
void Setup( String GridName , eSourceType SourceType , Object Datasource , ClsBindGrid GridDefinition , Boolean IsSelection = false , List<String> List_TableKey = null , Boolean AllowSort = false , Boolean AllowPaging = false , Boolean IsDefault = false) { this.mProperties = new UcGrid_Properties(); this.mProperties.SourceType = SourceType; switch (SourceType) { case eSourceType.Base: this.mProperties.Datasource_Base = (ClsBase)Datasource; break; case eSourceType.DataTable: this.mProperties.Datasource_Dt = (DataTable)Datasource; break; case eSourceType.Table: this.mProperties.Datasource_TableName = (String)Datasource; break; case eSourceType.QuerySource: this.mProperties.Datasource_QuerySource = (Do_Constants.Str_QuerySource)Datasource; break; } this.mProperties.GridDefinition = GridDefinition; this.mProperties.IsSelection = IsSelection; //this.mProperties.TableKey = KeyName; this.mProperties.List_TableKey = List_TableKey; this.mProperties.AllowSort = AllowSort; this.mProperties.AllowPaging = AllowPaging; this.mProperties.GridName = GridName; this.BindGrid(IsDefault); this.Setup_EventHandlers(); }
public void Setup_FromTable( String GridName , String Datasource_TableName , ClsBindGrid GridDefinition , List<String> List_TableKey = null , Boolean IsSelection = false , Boolean AllowSort = false , Boolean AllowPaging = false , Boolean IsDefault = false) { this.Setup( GridName , eSourceType.Table , Datasource_TableName , GridDefinition , IsSelection , List_TableKey , AllowSort , AllowPaging , IsDefault); }
public void Setup_FromQuerySource( String GridName , Do_Constants.Str_QuerySource DataSource_QuerySource , ClsBindGrid GridDefinition , List<String> List_TableKey = null , Boolean IsSelection = false , Boolean AllowSort = false , Boolean AllowPaging = false , Boolean IsDefault = false) { this.Setup( GridName , eSourceType.QuerySource , DataSource_QuerySource , GridDefinition , IsSelection , List_TableKey , AllowSort , AllowPaging , IsDefault); }
//[-] public static ClsBindGrid GetBindGrid(String Name) { ClsBindGrid GridDef = new ClsBindGrid() { pName = Name }; DataTable Dt_Def = Do_Methods_Query.GetQuery(@"System_BindDefinition", "", "Name = '" + Name + "'"); if (Dt_Def.Rows.Count == 0) { throw new Exception("Specified BindDefinition not found."); } DataRow Dr_Def = Dt_Def.Rows[0]; //GridDef.pTableName = Do_Methods.Convert_String(Dr_Def["TableName"]); //GridDef.pTableKey = Do_Methods.Convert_String(Dr_Def["TableKey"]); //GridDef.pDesc = Do_Methods.Convert_String(Dr_Def["Desc"]); //GridDef.pCondition = Do_Methods.Convert_String(Dr_Def["Condition"]); //GridDef.pSort = Do_Methods.Convert_String(Dr_Def["Sort"]); DataTable Dt_DefColumns = Do_Methods_Query.GetQuery(@"udf_System_BindDefinition('" + Name + @"')", "", "", "OrderIndex"); foreach (DataRow Dr in Dt_DefColumns.Rows) { GridDef.pColumns.Add(new ClsBindGridColumn( Do_Methods.Convert_String(Dr["Name"]) , Do_Methods.Convert_String(Dr["Desc"]) , Do_Methods.Convert_Int32(Dr["Width"]) , Do_Methods.Convert_String(Dr["NumberFormat"]) , Do_Methods.ParseEnum<Layer01_Constants.eSystem_Lookup_FieldType>(Do_Methods.Convert_String(Dr["System_LookupID_FieldType"])) , Do_Methods.ParseEnum<Layer01_Constants.eSystem_Lookup_HorizontalAlign>(Do_Methods.Convert_String(Dr["System_LookupID_HorizontalAlign"])) , !Do_Methods.Convert_Boolean(Dr["IsHidden"]) , !Do_Methods.Convert_Boolean(Dr["IsReadOnly"]) , Do_Methods.Convert_Boolean(Dr["IsFilter"]))); } return GridDef; }
public void Setup(Interface_FilterTarget FilterTarget, ClsBindGrid GridDef, DataTable Dt_Source) { this.mFilterTarget = FilterTarget; this.EvFilter += new DsFilter(UcFilter_EvFilter); this.Setup(GridDef, Dt_Source); }