public override void Refresh() { base.Refresh(); // setLangThis(); // initRoom(); initReserved(); // if (selectRoomID != 0) { DevExpress.XtraGrid.Views.Base.ColumnView c = gridControlRoomLeave.MainView as DevExpress.XtraGrid.Views.Base.ColumnView; // gvControlRoomLeave.FocusedRowHandle = c.LocateByValue("room_id", selectRoomID); // selectRoomID = 0; } if (selectReserveID != 0) { DevExpress.XtraGrid.Views.Base.ColumnView c = gridControlReserved.MainView as DevExpress.XtraGrid.Views.Base.ColumnView; // gvControlReserved.FocusedRowHandle = c.LocateByValue("reserve_room_id", selectReserveID); // selectReserveID = 0; } // changeRow(); }
private void CheckSequrityDetail(DevExpress.XtraGrid.Views.Base.ColumnView view) { view.Columns["ShipsMD5"].Visible = false; view.Columns["ShipsMD5DetailID"].Visible = false; view.Columns["ShipsMD5ID"].Visible = false; view.Columns["AddTime"].Visible = false; view.Columns["ShipNumber"].Caption = "№ отгрузки"; view.Columns["Customer"].Caption = "Клиент"; view.Columns["LegalName"].Caption = "Юр. лицо"; view.Columns["ShipDate"].Caption = "Дата отгр"; view.Columns["FilePath"].Visible = false; view.Columns["AdvancePayment"].Caption = "Предв расчет"; view.Columns["Completed"].Caption = "Комплектация"; view.Columns["FinalPayment"].Caption = "Окон. расчет"; view.Columns["Invoiced"].Caption = "Выст. счет-фактура"; view.Columns["Paid"].Caption = "Оплачено"; view.Columns["Shiped"].Caption = "Отгружено"; foreach (var a in Security.ValuesAndDescriptions.Where(a => a.Value[1] != "DontShowField")) { view.Columns[a.Value[0]].OptionsColumn.AllowEdit = ((Security.ShipControl & a.Key) == a.Key); if ((Security.ShipControl & a.Key) != a.Key) { //view.Columns.Remove(view.Columns[a.Value]); } } ApplySecurityDetails(view); }
/// <summary> /// 取消冻结。 /// </summary> /// <param name="xtraGrid"></param> public void UnSixedColumn(DevExpress.XtraGrid.GridControl xtraGrid) { DevExpress.XtraGrid.Views.Base.ColumnView girdView = xtraGrid.MainView as DevExpress.XtraGrid.Views.Base.ColumnView; if (girdView.FocusedColumn == null) return; for (int i = girdView.Columns.Count - 1; i > -1; i--) { girdView.Columns[i].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.None; } }
private void StudenQuery() { gridControl1.DataSource = StudentInfo.SimpleQuery(1, int.MaxValue, _key, out _pageTotal); gridView1.FocusedRowHandle = _selectionRow; DevExpress.XtraGrid.Views.Base.ColumnView columnView = gridControl1.FocusedView as DevExpress.XtraGrid.Views.Base.ColumnView; columnView.MoveBy(0); gridControl1.RefreshDataSource(); }
private void AddGridColumn(DevExpress.XtraGrid.Views.Base.ColumnView view, string fieldName, string caption, DevExpress.XtraEditors.Repository.RepositoryItem item, string format, DevExpress.Utils.FormatType type) { DevExpress.XtraGrid.Columns.GridColumn column = view.Columns.AddField(fieldName); column.Caption = caption; column.ColumnEdit = item; column.DisplayFormat.FormatType = type; column.DisplayFormat.FormatString = format; column.VisibleIndex = view.VisibleColumns.Count; }
//handler used in order to validate a new row void gridViewListaComprasEspeciales_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = sender as DevExpress.XtraGrid.Views.Base.ColumnView; DevExpress.XtraGrid.Columns.GridColumn costosColumn = view.Columns[1]; if (view.GetRowCellValue(e.RowHandle, costosColumn).ToString() == null || view.GetRowCellValue(e.RowHandle, costosColumn).ToString().Trim().Length == 0) { e.Valid = false; view.SetColumnError(costosColumn, "Columna Costos no puede estar vacia", DevExpress.XtraEditors.DXErrorProvider.ErrorType.Critical); } }
private void Query() { gridControl1.DataSource = PayRecordInfo.SimpleQuery(_pageIndex, _pageSize, _key, out _pageTotal); gridView1.FocusedRowHandle = _selectionRow; DevExpress.XtraGrid.Views.Base.ColumnView columnView = gridControl1.FocusedView as DevExpress.XtraGrid.Views.Base.ColumnView; columnView.MoveBy(0); gridControl1.RefreshDataSource(); _page.SetPage(_pageIndex, _pageSize, _pageTotal); }
public static void SetFocusedRow <T>(this DevExpress.XtraGrid.Views.Base.ColumnView gView, T entity) { if (entity == null) { gView.FocusInvalidRow(); } else { gView.FocusedRowHandle = gView.FindRow(entity); } }
private IGridColumnModelSynchronizer GetColumnInfo(GridColumn column, DevExpress.XtraGrid.Views.Base.ColumnView columnView) { IGridColumnModelSynchronizer result = null; var modelSynchronizersHolder = columnView as IModelSynchronizersHolder; if (modelSynchronizersHolder != null) { result = modelSynchronizersHolder.GetSynchronizer(column) as IGridColumnModelSynchronizer; } return(result); }
private void _gdSUB_VIEW_RowStyle(object sender, RowStyleEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = (DevExpress.XtraGrid.Views.Base.ColumnView)sender; if (view.IsValidRowHandle(e.RowHandle)) { if (view.GetRowCellValue(e.RowHandle, "USE_YN") != null && view.GetRowCellValue(e.RowHandle, "USE_YN").ToString() == "N") { e.Appearance.BackColor = Color.Tomato; } } }
void EnsureCurrentObject() { if ((View).CurrentObject == null) { DevExpress.XtraGrid.Views.Base.ColumnView gridView = ((IColumnViewEditor)((ListView)View).Editor).ColumnView; gridView.ActiveEditor.IsModified = true; ((IGridInplaceEdit)gridView.ActiveEditor).GridEditingObject = (View).CurrentObject; gridView.RefreshEditor(true); } }
private void gridViewMaster_MasterRowExpanded(object sender, DevExpress.XtraGrid.Views.Grid.CustomMasterRowEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = gridViewMaster.GetDetailView(e.RowHandle, e.RelationIndex) as GridView; GridView gridView = gridViewMaster.GetDetailView(e.RowHandle, e.RelationIndex) as GridView; gridView.CustomDrawCell -= detailView_CustomDrawCell; gridView.CustomDrawCell += detailView_CustomDrawCell; //view.ViewCaption = "Text " + e.RowHandle.ToString(); CheckSequrityDetail(view); }
/// <summary> /// 冻结列 /// </summary> /// <param name="girdView"></param> public void FixedFocusColumn(DevExpress.XtraGrid.GridControl xtraGrid) { DevExpress.XtraGrid.Views.Base.ColumnView girdView = xtraGrid.MainView as DevExpress.XtraGrid.Views.Base.ColumnView; if (girdView.FocusedColumn == null) return; int index = girdView.FocusedColumn.VisibleIndex; foreach (DevExpress.XtraGrid.Columns.GridColumn dc in girdView.Columns) { if (dc.VisibleIndex > index) continue; dc.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left; } }
private void _gdSUB_VIEW_RowStyle(object sender, RowStyleEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = (DevExpress.XtraGrid.Views.Base.ColumnView)sender; if (view.IsValidRowHandle(e.RowHandle)) { if (view.GetRowCellValue(e.RowHandle, "USE_YN") != null && view.GetRowCellValue(e.RowHandle, "USE_YN").ToString() == "N") { e.Appearance.BackColor = Color.Tomato; } } //(Color)view.GetRowCellValue(e.RowHandle, "Color"); //view.SetRowCellValue(e.RowHandle, view.Columns["PART_UNITCOST_START_DATE"], DateTime.Today); }
/// <summary> /// 获取Grid当前选择 某个字段值 /// </summary> /// <param name="view">gridView对象</param> /// <param name="ColName">字段名</param> /// <returns></returns> public string GetGridViewColValue(DevExpress.XtraGrid.Views.Base.ColumnView view, string ColName) { string value = string.Empty; if (view.RowCount == 0) { return(value); } DevExpress.XtraGrid.Columns.GridColumn colvalue = view.Columns.ColumnByFieldName(ColName); value = view.GetRowCellValue(view.FocusedRowHandle, colvalue).ToString(); return(value); }
private void grd_view_purchase_return_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = sender as DevExpress.XtraGrid.Views.Base.ColumnView; if (view.FocusedColumn.VisibleIndex == 3) { double stock_qty = bllUtility.Val(view.GetRowCellDisplayText(view.FocusedRowHandle, "Stock")); double pr_qty = bllUtility.Val(e.Value.ToString()); if (pr_qty > stock_qty) { e.Valid = false; e.ErrorText = "You can not return more then stock qty !"; view.SetColumnError(view.Columns["PRQty"], e.ErrorText); return; } } }
private void gridViewMain_ShownEditor(object sender, EventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = (DevExpress.XtraGrid.Views.Base.ColumnView)sender; XPDataTableObject row = (XPDataTableObject)gridViewMain.GetRow(gridViewMain.FocusedRowHandle); if (row == null) { return; } if (row.GetMemberValue("jointocheck") == null || Convert.ToBoolean(row.GetMemberValue("jointocheck")) == false) { view.ActiveEditor.Properties.ReadOnly = true; } else { view.ActiveEditor.Properties.ReadOnly = false; } }
private void gridView1_CustomDrawEmptyForeground(object sender, DevExpress.XtraGrid.Views.Base.CustomDrawEventArgs e) { string s = string.Empty; DevExpress.XtraGrid.Views.Base.ColumnView view = sender as DevExpress.XtraGrid.Views.Base.ColumnView; BindingSource dataSource = view.DataSource as BindingSource; if (dataSource == null) { s = "没有数据 QAQ"; } else if (dataSource.Count == 0) { s = "没有找到符合条件的数据 QAQ"; } Font font = new Font("微软雅黑", 10, FontStyle.Bold); Rectangle r = new Rectangle(e.Bounds.Left + 5, e.Bounds.Top + 5, e.Bounds.Width - 5, e.Bounds.Height - 5); e.Graphics.DrawString(s, font, Brushes.Black, r); }
private void ApplySecurityDetails(DevExpress.XtraGrid.Views.Base.ColumnView view) { foreach (var a in Security.ValuesAndDescriptionsDetail.Where(a => a.Value[1] == "DontShowField")) { var column = view.Columns.ColumnByFieldName(a.Key.ToString()); if (column != null) { column.Visible = false; } //XtraGrid.Columns[a.Value[0]].Visible = false; } foreach (var a in Security.ValuesAndDescriptionsDetail.Where(a => ((a.Value[0] != "Editable") || (Security.ReadOnlyForShips)))) { var column = view.Columns.ColumnByFieldName(a.Key.ToString()); if (column != null) { column.OptionsColumn.AllowEdit = false; } //XtraGrid.Columns[a.Key.ToString()].OptionsColumn.AllowEdit = false; } }
DevExpress.XtraGrid.Views.Base.ColumnView GetLevelDefaultViewCore(IModelListView masterModelListView, ExpressApp.MasterDetail.Win.IMasterDetailColumnView masterGridView, int rowHandle, int relationIndex, List <MasterDetailRuleInfo> masterDetailRules) { var modelDetailRelationCalculator = new ModelDetailRelationCalculator(masterModelListView, masterGridView, masterDetailRules); bool isRelationSet = modelDetailRelationCalculator.IsRelationSet(rowHandle, relationIndex); if (isRelationSet) { IModelListView childModelListView = modelDetailRelationCalculator.GetChildModelListView(rowHandle, relationIndex); ListView listView = GetListView(modelDetailRelationCalculator, rowHandle, relationIndex, childModelListView); DevExpress.XtraGrid.Views.Base.ColumnView defaultXpandXafGridView = null; EventHandler[] listViewOnControlsCreated = { null }; ListView view = listView; listViewOnControlsCreated[0] = (sender, args) => { defaultXpandXafGridView = ((IColumnViewEditor)((ListView)sender).Editor).GridView; view.ControlsCreated -= listViewOnControlsCreated[0]; }; listView.ControlsCreated += listViewOnControlsCreated[0]; listView.CreateControls(); return(defaultXpandXafGridView); } return(null); }
private void ucBankaListesi_Load(object sender, EventArgs e) { taksitlistesi(); if (this.Tag != null) { if (this.Tag.ToString() != "") { DevExpress.XtraGrid.Views.Base.ColumnView view = gridView1; view.ActiveFilter.Add(view.Columns["Firmaadi"], new DevExpress.XtraGrid.Columns.ColumnFilterInfo("[Firmaadi] Like '" + this.Tag.ToString() + "'", "")); } } Yazdirma_islemleri yi = new Yazdirma_islemleri(); yi.GridTasarimYukle(gridView1, "SenetlerGrid"); gridView1.ExpandAllGroups(); gridView1.ExpandGroupRow(0); //gridView1.ActiveFilterString = this.Tag.ToString(); }
//handler used in order to validate a new row void gridViewCompras_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = sender as DevExpress.XtraGrid.Views.Base.ColumnView; DevExpress.XtraGrid.Columns.GridColumn column1 = view.Columns[3]; DevExpress.XtraGrid.Columns.GridColumn columnCostoUnidad = view.Columns[4]; DevExpress.XtraGrid.Columns.GridColumn columnInsumo = view.Columns[2]; if (view.GetRowCellValue(e.RowHandle, column1).ToString() == null || view.GetRowCellValue(e.RowHandle, column1).ToString().Trim().Length == 0) { e.Valid = false; view.SetColumnError(column1, "Cantidad no puede ser vacio", DevExpress.XtraEditors.DXErrorProvider.ErrorType.Critical); } else if (view.GetRowCellValue(e.RowHandle, columnCostoUnidad).ToString() == null || view.GetRowCellValue(e.RowHandle, columnCostoUnidad).ToString().Trim().Length == 0) { e.Valid = false; view.SetColumnError(columnCostoUnidad, "Costo Unidad no puede ser vacio", DevExpress.XtraEditors.DXErrorProvider.ErrorType.Critical); } else if (view.GetRowCellValue(e.RowHandle, columnInsumo).ToString() == null || view.GetRowCellValue(e.RowHandle, columnInsumo).ToString().Trim().Length == 0) { e.Valid = false; view.SetColumnError(columnInsumo, "Debe seleccionar insumo", DevExpress.XtraEditors.DXErrorProvider.ErrorType.Critical); } }
private void gridViewComprarlista_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = sender as DevExpress.XtraGrid.Views.Base.ColumnView; // TODO: columnCantidad is declared but is never used. Use this local or remove it please. // TODO: columnCostoUnidad is declared but is never used. Use this local or remove it please. DevExpress.XtraGrid.Columns.GridColumn columnCantidad = view.Columns[3]; DevExpress.XtraGrid.Columns.GridColumn columnCostoUnidad = view.Columns[4]; DataRow row; row = gridViewComprarlista.GetDataRow(e.RowHandle); if (row == null) //|| row[0].ToString() == string.Empty) { // TODO: lote is declared but is never used. Use this local or remove it please. string lote = "select Cantidad from Insumo where InsumoId=" + e.Value.ToString( ); // lote = CommonUtils.ConexionBD.EjecutarConsultaEspecial(lote); // gridViewComprarlista.SetRowCellValue(gridViewComprarlista.FocusedRowHandle, gridViewComprarlista.Columns["Cantidad"], lote); return; } else if (row[0].ToString( ) == string.Empty) { // return; } if ((e.Value.ToString( ).Trim( ) == string.Empty) && gridViewComprarlista.FocusedColumn.FieldName != "Descripcion") { ribbonControl.Enabled = false; return; } else { ribbonControl.Enabled = true; } object[] array = new object[5]; array[0] = row[0].ToString( ); //id array[1] = row[7].ToString( ); //insumo id array[2] = int.Parse(row[2].ToString( )).ToString( ); //cantidad array[3] = row[3].ToString( ); //costo unidad array[4] = row[5].ToString( ); //descripcion if (gridViewComprarlista.FocusedColumn.FieldName == "Cantidad") { if (e.Value.ToString( ) != string.Empty) { string a = e.Value.ToString( ).Replace(".", ""); array[2] = int.Parse(a); } } else if (gridViewComprarlista.FocusedColumn.FieldName == "CostoUnidad") { array[3] = e.Value.ToString( ); } else if (gridViewComprarlista.FocusedColumn.FieldName == "InsumoId") { array[1] = e.Value.ToString( ); } else if (gridViewComprarlista.FocusedColumn.FieldName == "Descripcion") { array[4] = e.Value.ToString( ); } if (dictionaryOfRows.ContainsKey(row[0].ToString( ))) { dictionaryOfRows.Remove(row[0].ToString( )); } dictionaryOfRows.Add (row[0].ToString( ), array); }
private void AddGridColumn(DevExpress.XtraGrid.Views.Base.ColumnView view, string fieldName, string caption) { AddGridColumn(view, fieldName, caption, null); }
private void AddGridColumn(DevExpress.XtraGrid.Views.Base.ColumnView view, string fieldName, string caption, DevExpress.XtraEditors.Repository.RepositoryItem item) { AddGridColumn(view, fieldName, caption, item, "", DevExpress.Utils.FormatType.None); }
public GridColumnCollection(DevExpress.XtraGrid.Views.Base.ColumnView view) : base(view) { }
private void gridView5_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView columna = sender as DevExpress.XtraGrid.Views.Base.ColumnView; string nomcliente = ""; Int64 IdCliente = 0; clsCuenta cuenta = new clsCuenta(); clsClienteMaster clienteselecccionado = new clsClienteMaster(false); if (e.Column.FieldName == "Cliente.NombreFantasia") { nomcliente = columna.EditingValue.ToString(); //Console.WriteLine("nomCliente--->"+nomcliente); if (nomcliente.Trim() != "") { ddlP1Cliente.SelectedIndex = 0; for (int i = 0; i < ddlP1Cliente.Properties.Items.Count; i++) { if (ddlP1Cliente.Properties.Items[i].ToString().Trim() == nomcliente.Trim()) { ddlP1Cliente.SelectedIndex = i; break; } } //Console.WriteLine("index seleccionado--->" + ddlP1Cliente.SelectedIndex); if (ddlP1Cliente.SelectedIndex == 0) { clienteselecccionado = new clsClienteMaster(true) { NombreFantasia = columna.EditingValue.ToString(), NombreCompañia = columna.EditingValue.ToString(), Tipo = Enums.TipoPersona.CuentaPaperless, EstadoCuenta = Enums.Estado.Habilitado }; PaperlessAsignacionActual.DataUsuario1.Paso1HousesBL[e.RowHandle].TipoCliente = null; } else { clienteselecccionado = (clsClienteMaster)this.ddlP1Cliente.SelectedItem; if (clienteselecccionado.Id != 0) { PaperlessTipoCliente ptc = new PaperlessTipoCliente(); var transaccion = LogicaNegocios.Clientes.clsCuentas.BuscarCuentaPorId(clienteselecccionado.Id); if (transaccion != null) { cuenta = (clsCuenta)transaccion.ObjetoTransaccion; if (cuenta != null && cuenta.ClienteMaster.ClienteMasterTipoCliente != null) { if (cuenta.ClienteMaster.ClienteMasterTipoCliente.Count.Equals(0) || cuenta.ClienteMaster.ClienteMasterTipoCliente.Count > 1) { PaperlessAsignacionActual.DataUsuario1.Paso1HousesBL[e.RowHandle].TipoCliente = null; } else { ptc.Nombre = cuenta.ClienteMaster.ClienteMasterTipoCliente[0].Nombre; ptc.Id = cuenta.ClienteMaster.ClienteMasterTipoCliente[0].Id; PaperlessAsignacionActual.DataUsuario1.Paso1HousesBL[e.RowHandle].TipoCliente = ptc; } } else { PaperlessAsignacionActual.DataUsuario1.Paso1HousesBL[e.RowHandle].TipoCliente = null; } } } if (clienteselecccionado.NombreFantasia.Length.Equals(0)) { clienteselecccionado.NombreFantasia = clienteselecccionado.NombreCompañia; } } } PaperlessAsignacionActual.DataUsuario1.Paso1HousesBL[e.RowHandle].Cliente = clienteselecccionado; } if (e.Column.FieldName == "TipoCliente.Nombre") { PaperlessAsignacionActual.DataUsuario1.Paso1HousesBL[e.RowHandle].TipoCliente = (PaperlessTipoCliente)columna.EditingValue; } }
private void dgv_KQ_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (DanhSachCum.RowCount > 0) { //SplashScreenManager.ShowForm(typeof(WaitForm2)); Double DTB_Max_Detail = 0; Double DTB_Min_Detail = 10; DevExpress.XtraGrid.Views.Base.ColumnView bw = (DevExpress.XtraGrid.Views.Base.ColumnView)dgv_DanhSachCum.FocusedView; DataRow dr1 = bw.GetDataRow(0); double center = Convert.ToDouble(DanhSachCum.GetRowCellValue(DanhSachCum.FocusedRowHandle, "Cen").ToString()); dgv_ChiTietCum.DataSource = null; dgv_TongHopTheoLop.DataSource = null; String[] Class = new String[frm_Main.path_src.dt.Rows.Count]; int COU_Class = 0; int NUM_Class = 0; KMEDOIDS_Result.dt_View_Clustering_Detail = new DataTable(); KMEDOIDS_Result.dt_View_Clustering_Detail.Columns.Add(new DataColumn("f_masv")); KMEDOIDS_Result.dt_View_Clustering_Detail.Columns.Add(new DataColumn("f_lop")); KMEDOIDS_Result.dt_View_Clustering_Detail.Columns.Add(new DataColumn("f_ho")); KMEDOIDS_Result.dt_View_Clustering_Detail.Columns.Add(new DataColumn("f_ten")); KMEDOIDS_Result.dt_View_Clustering_Detail.Columns.Add(new DataColumn("f_dtb")); for (int i = 0; i < Subjects.COU_Subjects; i++) { KMEDOIDS_Result.dt_View_Clustering_Detail.Columns.Add(new DataColumn(Subjects.ARR_Subjects[i])); } //DataRow dr; for (int i = 0; i < frm_Main.path_src.dt.Rows.Count; i++) { if (Convert.ToDouble(Students.EXCEL[i, 5]) == center) { KMEDOIDS_Result.dr_View_Clustering_Detail = KMEDOIDS_Result.dt_View_Clustering_Detail.NewRow(); KMEDOIDS_Result.dr_View_Clustering_Detail["f_masv"] = Students.EXCEL[i, 0]; KMEDOIDS_Result.dr_View_Clustering_Detail["f_lop"] = Students.EXCEL[i, 3]; KMEDOIDS_Result.dr_View_Clustering_Detail["f_ho"] = Students.EXCEL[i, 1]; KMEDOIDS_Result.dr_View_Clustering_Detail["f_ten"] = Students.EXCEL[i, 2]; KMEDOIDS_Result.dr_View_Clustering_Detail["f_dtb"] = Math.Round(Convert.ToDouble(Students.EXCEL[i, 4]), 2); for (int j = 0; j < Subjects.COU_Subjects; j++) { KMEDOIDS_Result.dr_View_Clustering_Detail[Subjects.ARR_Subjects[j]] = Students.EXCEL[i, 6 + j]; } KMEDOIDS_Result.dt_View_Clustering_Detail.Rows.Add(KMEDOIDS_Result.dr_View_Clustering_Detail); Class[NUM_Class] = Students.EXCEL[i, 3]; NUM_Class++; if (Math.Round(Convert.ToDouble(Students.EXCEL[i, 4]), 2) > DTB_Max_Detail) { DTB_Max_Detail = Math.Round(Convert.ToDouble(Students.EXCEL[i, 4]), 2); } if (Math.Round(Convert.ToDouble(Students.EXCEL[i, 4]), 2) < DTB_Min_Detail) { DTB_Min_Detail = Math.Round(Convert.ToDouble(Students.EXCEL[i, 4]), 2); } } } dgv_ChiTietCum.DataSource = KMEDOIDS_Result.dt_View_Clustering_Detail; String[,] Class_Detail = new String[NUM_Class, 3]; Class_Detail[0, 0] = Class[0]; Class_Detail[0, 1] = "1"; Class_Detail[0, 2] = "1%"; COU_Class++; for (int i = 1; i < NUM_Class; i++) { int similar_class = 0; for (int j = 0; j < COU_Class; j++) { if (Class[i] == Class_Detail[j, 0]) { Class_Detail[j, 1] = (Convert.ToInt32(Class_Detail[j, 1]) + 1).ToString(); similar_class++; } } if (similar_class == 0) { Class_Detail[COU_Class, 0] = Class[i]; Class_Detail[COU_Class, 1] = "1"; COU_Class++; } } for (int i = 0; i < NUM_Class; i++) { Class_Detail[i, 2] = (Math.Round(Convert.ToDouble(Class_Detail[i, 1]) / Convert.ToDouble(DanhSachCum.GetRowCellValue(DanhSachCum.FocusedRowHandle, "SoPT").ToString()), 4) * 100).ToString() + " %"; } DataTable dt_th = new DataTable(); dt_th.Columns.Add(new DataColumn("TenLop")); dt_th.Columns.Add(new DataColumn("SoLuong")); dt_th.Columns.Add(new DataColumn("TyLe_Lop")); DataRow dr_th; for (int i = 0; i < COU_Class; i++) { dr_th = dt_th.NewRow(); dr_th["TenLop"] = Class_Detail[i, 0]; dr_th["SoLuong"] = Class_Detail[i, 1]; dr_th["TyLe_Lop"] = Class_Detail[i, 2]; dt_th.Rows.Add(dr_th); } dgv_TongHopTheoLop.DataSource = dt_th; txt_DiemTB_Max.Text = DTB_Max_Detail.ToString(); txt_DiemTB_Min.Text = DTB_Min_Detail.ToString(); } }
private void gridViewComprasInsumos_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DevExpress.XtraGrid.Views.Base.ColumnView view = sender as DevExpress.XtraGrid.Views.Base.ColumnView; DataRow row; row = gridViewComprasInsumos.GetDataRow(e.RowHandle); if (row == null)//|| row[0].ToString() == string.Empty) { return; } else if (row[0].ToString() == string.Empty) { // return; } if ((e.Value.ToString().Trim() == string.Empty) && gridViewComprasInsumos.FocusedColumn.FieldName != "Descripcion") { ribbonControl.Enabled = false; return; } else { ribbonControl.Enabled = true; } dataHasChanged = true; object[] array = new object[5]; array[0] = row[0].ToString(); //id array[1] = row[7].ToString(); //insumo id array[2] = int.Parse(row[2].ToString()).ToString(); //cantidad array[3] = row[3].ToString(); //costo unidad array[4] = row[5].ToString(); //descripcion if (gridViewComprasInsumos.FocusedColumn.FieldName == "Cantidad") { if (e.Value.ToString() != string.Empty) { string a = e.Value.ToString().Replace(".", ""); array[2] = int.Parse(a); if (row[3].ToString() != string.Empty) { string costoTotal = (float.Parse(a) * float.Parse(row[3].ToString())).ToString(); gridViewComprasInsumos.SetRowCellValue(gridViewComprasInsumos.FocusedRowHandle, gridViewComprasInsumos.Columns[4], costoTotal); } } } else if (gridViewComprasInsumos.FocusedColumn.FieldName == "CostoUnidad") { array[3] = e.Value.ToString(); if (row[2].ToString() != string.Empty && e.Value.ToString() != string.Empty) { string costoTotal = (float.Parse(e.Value.ToString()) * float.Parse(row[2].ToString())).ToString(); gridViewComprasInsumos.SetRowCellValue(gridViewComprasInsumos.FocusedRowHandle, gridViewComprasInsumos.Columns[4], costoTotal); } } else if (gridViewComprasInsumos.FocusedColumn.FieldName == "InsumoId") { array[1] = e.Value.ToString(); gridViewComprasInsumos.SetRowCellValue(gridViewComprasInsumos.FocusedRowHandle, gridViewComprasInsumos.Columns[7], CommonUtils.ConexionBD.EjecutarConsultaEspecial("select Cantidad from Insumo where InsumoId='" + e.Value.ToString() + "' ")); gridViewComprasInsumos.SetRowCellValue(gridViewComprasInsumos.FocusedRowHandle, gridViewComprasInsumos.Columns[8], CommonUtils.ConexionBD.EjecutarConsultaEspecial("select Unidad from Insumo where InsumoId='" + e.Value.ToString() + "' ")); } else if (gridViewComprasInsumos.FocusedColumn.FieldName == "Descripcion") { array[4] = e.Value.ToString(); } if (dictionaryOfRows.ContainsKey(row[0].ToString())) { dictionaryOfRows.Remove(row[0].ToString()); } dictionaryOfRows.Add (row[0].ToString(), array); }