private void ViewCellMerge(object sender, CellMergeEventArgs e) { if (_MergeColumns.Contains(e.Column.FieldName) == false) { return; } bool is_merge = false; int idx = _MergeColumns.IndexOf(e.Column.FieldName); if (idx > 0) { for (int i = 0; i < idx; i++) { string bas1 = this.GetValue(e.RowHandle1, _MergeColumns[i]) == null ? null : this.GetValue(e.RowHandle1, _MergeColumns[i]).ToString(); string bas2 = this.GetValue(e.RowHandle2, _MergeColumns[i]) == null ? null : this.GetValue(e.RowHandle2, _MergeColumns[i]).ToString(); is_merge = (bas1 == bas2); if (is_merge == false) { break; } } } else { is_merge = true; } string val_1 = this.GetValue(e.RowHandle1, e.Column.FieldName) == null ? null : this.GetValue(e.RowHandle1, e.Column.FieldName).ToString(); string val_2 = this.GetValue(e.RowHandle2, e.Column.FieldName) == null ? null : this.GetValue(e.RowHandle2, e.Column.FieldName).ToString(); e.Merge = (is_merge && (val_1 == val_2)); e.Handled = true; }
/// <summary> /// 设置Grid单元格合并 /// </summary> private void gridViewOrderList_CellMerge(object sender, CellMergeEventArgs e) { try { GridView view = sender as GridView; string firstColumnFieldName = "AutoId"; switch (e.Column.FieldName) { case "DelayWarehousing": case "WarehouseWarrantDate": case "WarehouseWarrant": case "WWQty": break; default: { string valueFirstColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, firstColumnFieldName)); string valueFirstColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, firstColumnFieldName)); string valueOtherColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, e.Column.FieldName)); string valueOtherColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, e.Column.FieldName)); e.Merge = valueFirstColumn1 == valueFirstColumn2 && valueOtherColumn1 == valueOtherColumn2; e.Handled = true; } break; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--设置Grid单元格合并错误。", ex); } }
/// <summary> /// 设置Grid单元格合并 /// </summary> private void gridViewDurationStock_CellMerge(object sender, CellMergeEventArgs e) { try { GridView view = sender as GridView; string firstColumnFieldName = "CodeFileName"; switch (e.Column.FieldName) { case "CodeName": case "CodeNo": case "CodeSpec": case "Brand": case "CatgName": case "MaterialVersion": case "CodeWeight": { string valueFirstColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, firstColumnFieldName)); string valueFirstColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, firstColumnFieldName)); string valueOtherColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, e.Column.FieldName)); string valueOtherColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, e.Column.FieldName)); e.Merge = valueFirstColumn1 == valueFirstColumn2 && valueOtherColumn1 == valueOtherColumn2; e.Handled = true; } break; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--设置Grid单元格合并错误。", ex); } }
private void tvMasterGrid_CellMerge(object sender, CellMergeEventArgs e) { try { List <string> _Fields = new List <string> { "STK_HGT" }; if (_Fields.Contains(e.Column.FieldName)) { var _row1 = this.gridMaster.GetRow(e.RowHandle1); var _row2 = this.gridMaster.GetRow(e.RowHandle2); if (_row1 != null && _row2 != null) { if (_row1 is StockInfo && _row2 is StockInfo) { e.Merge = (_row1 as StockInfo).GroupEquals(_row2 as StockInfo); e.Handled = true; } } } } catch (Exception err) { this.BaseClass.Error(err); } }
private void gvwRR_CellMerge(object sender, CellMergeEventArgs e) { try { if (e.RowHandle1 < 0 || gvwRR.RowCount == 0) { return; } e.Merge = false; e.Handled = true; if (e.Column.FieldName == "YMD") { string model1 = gvwRR.GetRowCellDisplayText(e.RowHandle1, "MODEL_NAME").Trim(); string model2 = gvwRR.GetRowCellDisplayText(e.RowHandle2, "MODEL_NAME").Trim(); string ymd1 = gvwRR.GetRowCellDisplayText(e.RowHandle1, "YMD").Trim(); string ymd2 = gvwRR.GetRowCellDisplayText(e.RowHandle2, "YMD").Trim(); if (ymd1 == ymd2 && model1 == model2) { e.Merge = true; } else { e.Merge = false; } } } catch (Exception ex) { } }
private void grvUCList_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column.FieldName != "NhanVien.MaNhanVien" && e.Column.FieldName != "NhanVien.HoTen") { e.Merge = false; e.Handled = true; } }
private void gridView_CellMerge(object sender, CellMergeEventArgs e) { if (gridView.GetRow(e.RowHandle1) == gridSource.TargetEditor || gridView.GetRow(e.RowHandle2) == gridSource.TargetEditor) { e.Handled = true; e.Merge = false; } }
private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { //if (e.Column.FieldName != "Folder_") // return; //GridView view = sender as GridView; //var val1 = view.GetRowCellValue(e.RowHandle1, e.Column) + ""; //var val2 = view.GetRowCellValue(e.RowHandle2, e.Column) + ""; //e.Merge = val1 == val2; //e.Handled = true; }
private void gridViewInvoiceDetail_CellMerge(object sender, CellMergeEventArgs e) { if (!(e.Column == colItemName || e.Column == colUnit || e.Column == colManufacturer || e.Column == colOrderdQuantity)) { return; } var guid1 = gridViewInvoiceDetail.GetRowCellValue(e.RowHandle1, colguid).ToString(); var guid2 = gridViewInvoiceDetail.GetRowCellValue(e.RowHandle2, colguid).ToString(); e.Merge = guid1 == guid2; e.Handled = true; }
private void gbList_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column == this.gbList.Columns["TotalHour"]) { string str = Convert.ToString(this.gbList.GetRowCellValue(e.RowHandle1, this.gbList.Columns["EmployeeCode"])); string str1 = Convert.ToString(this.gbList.GetRowCellValue(e.RowHandle2, this.gbList.Columns["EmployeeCode"])); e.Handled = true; if (str == str1) { e.Merge = true; e.Handled = false; } } }
/// <summary> /// GridControl控件单元格合并控制,只有当单元格为Class,且GroupIndex值相等时的才可以合并 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { GridView view = sender as GridView; string value1 = view.GetDataRow(e.RowHandle1)["GroupIndex"].ToString(); string value2 = view.GetDataRow(e.RowHandle2)["GroupIndex"].ToString(); if (e.Column.FieldName == "Class") { string value3 = view.GetDataRow(e.RowHandle1)["Class"].ToString(); string value4 = view.GetDataRow(e.RowHandle2)["Class"].ToString(); e.Merge = value1 == value2 && value3 == value4; e.Handled = true; } }
private void gridViewOrderDetailsForApproval_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column != colRequestedQuantity) { return; } var itemName1 = gridOrderDetailView.GetRowCellValue(e.RowHandle1, colItemName).ToString(); var unit1 = gridOrderDetailView.GetRowCellValue(e.RowHandle1, colUnit).ToString(); var itemName2 = gridOrderDetailView.GetRowCellValue(e.RowHandle2, colItemName).ToString(); var unit2 = gridOrderDetailView.GetRowCellValue(e.RowHandle2, colUnit).ToString(); e.Merge = itemName1.Equals(itemName2) && unit1.Equals(unit2); e.Handled = true; }
private void OnCellMerge(object sender, CellMergeEventArgs e) { if (e.Column.FieldName == "replenishmentInstruction" || e.Column.FieldName == "sentDate" || e.Column.FieldName == "valueDate" || e.Column.FieldName == "memberBankName" || e.Column.FieldName == "pml") { bool canBemerge = SameCellValues("replenishmentInstruction", e.RowHandle1, e.RowHandle2) && SameCellValues("sentDate", e.RowHandle1, e.RowHandle2) && SameCellValues("valueDate", e.RowHandle1, e.RowHandle2) && SameCellValues("memberBankName", e.RowHandle1, e.RowHandle2) && SameCellValues("pml", e.RowHandle1, e.RowHandle2); e.Merge = canBemerge; } else { e.Merge = false; } e.Handled = true; }
private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { #region 合并行 GridView view = sender as GridView; string firstColumnFieldName = "cInvCode", secondColumnFieldName = "cInvName"; if (e.Column.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True) { string valueFirstColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, view.Columns[firstColumnFieldName])); string valueFirstColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, view.Columns[firstColumnFieldName])); string valueSecondColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, view.Columns[secondColumnFieldName])); string valueSecondColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, view.Columns[secondColumnFieldName])); e.Merge = valueFirstColumn1 == valueFirstColumn2 && valueSecondColumn1 == valueSecondColumn2; e.Handled = true; } #endregion }
private void gvList_CellMerge(object sender, CellMergeEventArgs e) { GridView view = sender as GridView; try { if (e.Column.FieldName == "Customer" || e.Column.FieldName == "POType" || e.Column.FieldName == "Model") { string val1 = view.GetRowCellValue(e.RowHandle1, e.Column).ToString(); string val2 = view.GetRowCellValue(e.RowHandle2, e.Column).ToString(); e.Merge = (val1 == val2); e.Handled = true; return; } } catch (Exception ex) { } }
//单元格合并 private void GridView_CellMerge(object sender, CellMergeEventArgs e) { //if (e.Column.FieldName == "Sales") //{ GridView view = sender as GridView; string val1 = view.GetRowCellValue(e.RowHandle1, e.Column).ToString(); string val2 = view.GetRowCellValue(e.RowHandle2, e.Column).ToString(); e.Merge = (val1 == val2); e.Handled = true; //} //else if (e.Column.FieldName == "CustomerNo") //{ // GridView view = sender as GridView; // string val1 = view.GetRowCellValue(e.RowHandle1, "CustomerNo").ToString(); // string val2 = view.GetRowCellValue(e.RowHandle2, "CustomerNo").ToString(); // e.Merge = (val1 == val2); // e.Handled = true; //} }
/// <summary> /// 영업장명 머지 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView_CellMerge(object sender, CellMergeEventArgs e) { try { if (e.Column != gridView.Columns["SALE_AMT"]) { return; } int value1 = Convert.ToInt32(gridView.GetRowCellValue(e.RowHandle1, e.Column)); int value2 = Convert.ToInt32(gridView.GetRowCellValue(e.RowHandle2, e.Column)); if (Math.Sign(value1) == Math.Sign(value2)) { e.Merge = true; e.Handled = true; } } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
private void gvCollectedData_CellMerge(object sender, CellMergeEventArgs e) { if (e.CellValue1.ToString() == e.CellValue2.ToString()) e.Merge = true; else e.Merge = false; e.Handled = true; }
private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column.FieldName != ColStock.FieldName) return; var value1 = gridViewDetail.GetRowCellValue(e.RowHandle1, ColVet); var value2 = gridViewDetail.GetRowCellValue(e.RowHandle2, ColVet); if (!value1.Equals(value2)) { e.Merge = false; e.Handled = true; } }
private void brvQrySummary_CellMerge(object sender, CellMergeEventArgs e) { BandedGridView editor = sender as BandedGridView; decimal num1 = (decimal)editor.GetRowCellValue(e.RowHandle1, "ITEM_GROUP"); decimal num2 = (decimal)editor.GetRowCellValue(e.RowHandle2, "ITEM_GROUP"); switch (e.Column.Name) { case "col_ITEM_GROUP": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_REP_DATE": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_SCAN_TIME": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_MC_NO": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_PRODUCT_NO": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; default: e.Merge = false; break; } e.Handled = true; }
private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { //gridView1. //e.Column.View. }
private void gridRecieveView_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column.FieldName == "StockCode" || e.Column.FieldName == "Item Name" || e.Column.FieldName == "UnitID" || e.Column.FieldName == "Manufacturer" || e.Column.FieldName == "NotReceived" || e.Column.FieldName == "InvoicedQty" ) { var dr1 = (sender as GridView).GetDataRow(e.RowHandle1); var dr2 = (sender as GridView).GetDataRow(e.RowHandle2); e.Merge = dr1["Item Name"].ToString() == dr2["Item Name"].ToString() && dr1["UnitID"].ToString() == dr2["UnitID"].ToString() && dr1["Manufacturer"].ToString() == dr2["Manufacturer"].ToString() && dr1["CopyGUID"].ToString() == dr2["CopyGUID"].ToString(); e.Handled = true; } }
private void gridPutAwayNonPalletizedView_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column != colReceivedQuantity) return; var itemName1 = gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle1, colItemName4).ToString(); var itemName2 = gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle2, colItemName4).ToString(); var unit1 = Convert.ToInt16(gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle1, colUnit4)); var unit2 = Convert.ToInt16(gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle2, colUnit4)); var manufacturer1 = Convert.ToInt16(gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle1, colManufacturer4)); var manufacturer2 = Convert.ToInt16(gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle2, colManufacturer4)); var batchNo1 = gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle1, colBatchNo4).ToString(); var batchNo2 = gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle2, colBatchNo4).ToString(); var expDate1 = gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle1, colExpiry2).ToString(); var expDate2 = gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle2, colExpiry2).ToString(); var recQty1 = Convert.ToDecimal(gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle1, colReceivedQuantity)); var recQty2 = Convert.ToDecimal(gridPutAwayNonPalletizedView.GetRowCellValue(e.RowHandle2, colReceivedQuantity)); e.Merge = itemName1.Equals(itemName2) && unit1 == unit2 && manufacturer1 == manufacturer2 && batchNo1.Equals(batchNo2) && expDate1.Equals(expDate2) && recQty1 == recQty2; e.Handled = true; }
private void gridViewInvoiceDetail_CellMerge(object sender, CellMergeEventArgs e) { if (!(e.Column == colItemName || e.Column == colUnit || e.Column == colManufacturer || e.Column == colOrderdQuantity)) return; var guid1 = gridViewInvoiceDetail.GetRowCellValue(e.RowHandle1, colguid).ToString(); var guid2 = gridViewInvoiceDetail.GetRowCellValue(e.RowHandle2, colguid).ToString(); e.Merge = guid1 == guid2; e.Handled = true; }
private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { var value1 = gridViewDetail.GetRowCellValue(e.RowHandle1, ColVet); var value2 = gridViewDetail.GetRowCellValue(e.RowHandle2, ColVet); if (!value1.Equals(value2)) { e.Merge = false; e.Handled = true; } }
/// <summary> /// 合并子阵开关 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { }
private void gridViewOrderDetailsForApproval_CellMerge(object sender, CellMergeEventArgs e) { if (e.Column != colRequestedQuantity) return; var itemName1 = gridOrderDetailView.GetRowCellValue(e.RowHandle1, colItemName).ToString(); var unit1 = gridOrderDetailView.GetRowCellValue(e.RowHandle1, colUnit).ToString(); var itemName2 = gridOrderDetailView.GetRowCellValue(e.RowHandle2, colItemName).ToString(); var unit2 = gridOrderDetailView.GetRowCellValue(e.RowHandle2, colUnit).ToString(); e.Merge = itemName1.Equals(itemName2) && unit1.Equals(unit2); e.Handled = true; }
private void brvQrySummary_CellMerge(object sender, CellMergeEventArgs e) { BandedGridView editor = sender as BandedGridView; //if (e.Column.FieldName.Equals("ITEM_GROUP")) //{ // decimal num1 = (decimal)editor.GetRowCellValue(e.RowHandle1, e.Column); // decimal num2 = (decimal)editor.GetRowCellValue(e.RowHandle2, e.Column); // if (num1.Equals(num2)) // { // e.Merge = true; // } // else // { // e.Merge = false; // } //} //else //{ // e.Merge = false; //} decimal num1 = (decimal)editor.GetRowCellValue(e.RowHandle1, "ITEM_GROUP"); decimal num2 = (decimal)editor.GetRowCellValue(e.RowHandle2, "ITEM_GROUP"); switch (e.Column.Name) { case "col_ITEM_GROUP": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_MIXED_DATE": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_MC_NO": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_PRODUCT_NO": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_TOTAL_WEIGHT": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_ACT_PERCEN": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_MIXED_STD_PERCEN": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_CHK_OK": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_CHK_TANK": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; case "col_MIXER": if (num1 == num2) { e.Merge = true; } else { e.Merge = false; } break; default: e.Merge = false; break; } e.Handled = true; }