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;
}
