//hàm set giá trị của 1 số kiểu datetime khi nhận vào là 1 combobox và 1 spin public DateTime?SetValueDatetime(SpinnerField sp, ComboBox cbb, int ngay) { if (sp.Text == "1900" || sp.Text == "" || sp.Value == null) { return(null); } if (cbb.SelectedItem.Value != null) { return(new DateTime(int.Parse(sp.Text), int.Parse(cbb.Value.ToString()), 1)); } return(null); }
public static SpinnerField AddSpinnerField(string fieldName, string title, int MinValue, int MaxValue) { SpinnerField sf = new SpinnerField(); sf.ID = fieldName; sf.FieldLabel = title; sf.Width = Unit.Pixel(300); sf.MinValue = MinValue; sf.MaxValue = MaxValue; sf.AllowDecimals = true; sf.DecimalPrecision = 0; sf.IncrementValue = 1; return(sf); }
/// <summary> /// Load column vào GridPanel /// </summary> private void AddColumn() { if (columnList == null) { columnList = GridController.GetInstance().GetColumnInfo(this.ID, TableName, 1); } datatable = DataController.DataHandler.GetInstance().ExecuteDataTable("select top 1 * from " + TableName); if (columnList.FirstOrDefault() == null) { foreach (DataColumn item in datatable.Columns) { Column column = new Column(); column.DataIndex = item.ColumnName; column.Header = item.ColumnName; GridPanel1.ColumnModel.Columns.Add(column); if (item.DataType.ToString().Equals("System.DateTime")) { column.Renderer.Fn = "GetDateFormat"; } if (column.Editor.Count == 0) { switch (GetColumnDataType(datatable, item.ColumnName)) { case "System.Decimal": case "System.Int32": Ext.Net.SpinnerField spin = new SpinnerField(); spin.ID = item.ColumnName + "spin"; column.Editor.Add(spin); break; case "System.DateTime": Ext.Net.DateField df = new Ext.Net.DateField(); df.ID = item.ColumnName + "datefield"; column.Editor.Add(df); break; case "System.String": Ext.Net.TextField text = new Ext.Net.TextField(); text.ID = item.ColumnName + "string"; column.Editor.Add(text); break; case "System.Boolean": Ext.Net.Checkbox chk = new Checkbox(); chk.ID = item.ColumnName + "chk"; column.Editor.Add(chk); break; } } } } else { string listener = ""; bool hasComboBox = false; foreach (GridPanelColumnInfo columnInfo in columnList) { Column column = new Column(); column.DataIndex = columnInfo.ColumnName; column.Header = columnInfo.ColumnHeader; if (columnInfo.Width.HasValue && columnInfo.Width != 0) { column.Width = columnInfo.Width.Value; } GridPanel1.ColumnModel.Columns.Add(column); if (string.IsNullOrEmpty(columnInfo.RenderJS) == false) { column.Renderer.Fn = columnInfo.RenderJS; } if (columnInfo.AllowComboBoxOnGrid && string.IsNullOrEmpty(columnInfo.TableName) == false) { hasComboBox = true; Ext.Net.ComboBox cbBox = new ComboBox(); cbBox.LoadingText = "Đang tải..."; cbBox.ID = "combo" + columnInfo.ColumnName; cbBox.DisplayField = "displayField"; cbBox.ValueField = "valueField"; cbBox.EnableViewState = false; column.Editor.Add(cbBox); Store store = CreateStore(cbBox.ID); cbBox.Store.Add(store); storeList.Add(new StoreDaTa(store, columnInfo.ComboBoxTable, columnInfo.DisplayFieldComboBox, columnInfo.ValueFieldComboBox, columnInfo.WhereFilterComboBox, columnInfo.ColumnName, columnInfo.MasterColumnComboID.Value, columnInfo.ID)); if (columnInfo.MasterColumnComboID.HasValue && columnInfo.MasterColumnComboID.Value != 0) { GridPanelColumnInfo col = columnList.Where(p => p.ID == columnInfo.MasterColumnComboID.Value).FirstOrDefault(); if (col != null) { listener += string.Format("case \"{0}\": this.getColumnModel().getCellEditor(e.column, e.row).field.allQuery = e.record.get('{1}');break;", columnInfo.ColumnName, col.ColumnName); } } } if (column.Editor.Count == 0) { switch (columnInfo.DataType) { case "System.Decimal": case "System.Int32": Ext.Net.SpinnerField spin = new SpinnerField(); spin.ID = columnInfo.ColumnName + "spin"; column.Editor.Add(spin); break; case "System.DateTime": Ext.Net.DateField df = new Ext.Net.DateField(); df.ID = columnInfo.ColumnName + "datefield"; column.Editor.Add(df); break; case "System.String": Ext.Net.TextField text = new Ext.Net.TextField(); text.ID = columnInfo.ColumnName + "string"; column.Editor.Add(text); break; case "System.Boolean": Ext.Net.Checkbox chk = new Checkbox(); chk.ID = columnInfo.ColumnName + "chk"; column.Editor.Add(chk); break; } } } if (!string.IsNullOrEmpty(listener)) { GridPanel1.Listeners.BeforeEdit.Handler = "switch (e.field) {" + listener + "}"; } if (hasComboBox) { GridPanel1.Listeners.AfterEdit.Handler = Store1.ClientID + ".commitChanges();"; GridPanel1.DirectEvents.AfterEdit.Event += new ComponentDirectEvent.DirectEventHandler(AfterEdit_Event); GridPanel1.DirectEvents.AfterEdit.ExtraParams.Add(new Ext.Net.Parameter("id", "e.record.id", ParameterMode.Raw)); GridPanel1.DirectEvents.AfterEdit.ExtraParams.Add(new Ext.Net.Parameter("field", "e.field", ParameterMode.Raw)); GridPanel1.DirectEvents.AfterEdit.ExtraParams.Add(new Ext.Net.Parameter("record", "e.record.data", ParameterMode.Raw, true)); GridPanel1.DirectEvents.AfterEdit.ExtraParams.Add(new Ext.Net.Parameter("value", "e.value", ParameterMode.Raw)); } } }
public void ClearControl(Control control, bool setcolor) { TextField tf = control as TextField; NumberField nf = control as NumberField; TextArea ta = control as TextArea; SpinnerField sf = control as SpinnerField; Checkbox cb = control as Checkbox; DropDownField ddf = control as DropDownField; ComboBox cbb = control as ComboBox; DateField df = control as DateField; TriggerField tgf = control as TriggerField; MultiCombo mc = control as MultiCombo; if (setcolor) { if (tgf != null) { tgf.Reset(); tgf.StyleSpec = "color:black"; } if (df != null) { df.Reset(); df.Call("setMaxValue", null); df.Call("setMinValue", null); df.StyleSpec = "color:black"; } if (mc != null) { mc.Reset(); mc.StyleSpec = "color:black"; } if (cbb != null) { cbb.Reset(); cbb.StyleSpec = "color:black"; } if (ddf != null) { ddf.Reset(); ddf.StyleSpec = "color:black"; } if (cb != null) { cb.Reset(); cb.StyleSpec = "color:black"; } if (sf != null) { sf.Reset(); sf.StyleSpec = "color:black"; } if (ta != null) { ta.Reset(); ta.StyleSpec = "color:black"; } if (nf != null) { nf.Reset(); nf.StyleSpec = "color:black"; } if (tf != null) { tf.Reset(); tf.StyleSpec = "color:black"; } if (control.HasControls()) { foreach (Control child in control.Controls) { ClearControl(child, setcolor); } } } else { if (tgf != null) { tgf.Reset(); } if (df != null) { df.Reset(); df.Call("setMaxValue", null); df.Call("setMinValue", null); } if (mc != null) { mc.Reset(); } if (cbb != null) { cbb.Reset(); } if (ddf != null) { ddf.Reset(); } if (cb != null) { cb.Reset(); } if (sf != null) { sf.Reset(); } if (ta != null) { ta.Reset(); } if (nf != null) { nf.Reset(); } if (tf != null) { tf.Reset(); } if (control.HasControls()) { foreach (Control child in control.Controls) { ClearControl(child, setcolor); } } } }