/// <summary>
/// 设置Grid单元格合并
/// </summary>
private void gridViewWNowInfo_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.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);
ExceptionHandler.HandleException(this.Text + "--" + f.tsmiSzgriddyghbcw.Text, ex);
}
}
/// <summary>
/// 设置Grid单元格合并
/// </summary>
private void gridViewDeliveryDetail_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
try
{
GridView view = sender as GridView;
string firstColumnFieldName = "AutoId";
switch (e.Column.FieldName)
{
case "DeliveryText":
case "FunctionDesc":
case "Unit":
case "DeliveryQty":
case "Amount":
case "Creator":
{
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 gridViewStnSummaryList_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
try
{
GridView view = sender as GridView;
string firstColumnFieldName = "AutoId";
switch (e.Column.FieldName)
{
case "StnNo":
case "StnDesc":
case "GetTime":
case "Prepared":
{
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 gridViewUserWorkFlow_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
try
{
GridView view = sender as GridView;
string firstColumnFieldName = "DataNo";
switch (e.Column.FieldName)
{
case "CurrentState":
case "CurrentNodeId":
case "ApproverLevel":
{
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 gridViewStnSummaryList_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
//try
//{
// GridView view = sender as GridView;
// string firstColumnFieldName = "AutoId";
// switch (e.Column.FieldName)
// {
// case "StnNo":
// case "StnDesc":
// case "GetTime":
// case "Creator":
// {
// 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 gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
if ((this.gridView1.GetDataRow(e.RowHandle1)["iID"].ToString() != this.gridView1.GetDataRow(e.RowHandle2)["iID"].ToString()))
{
e.Handled = true;
}
}
private void gvProduction_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
GridView view = sender as GridView;
if (e.Column.FieldName == "ProductionQty")// || e.Column.FieldName == "BillQty" || e.Column.FieldName == "RemQty" || e.Column.FieldName == "Rack" || e.Column.FieldName == "Quantity")
{
string val1 = e.CellValue1.ToString();
string val2 = e.CellValue2.ToString();
string value3 = view.GetRowCellValue(e.RowHandle1, view.Columns["ProductID"]).ToString();
string value4 = view.GetRowCellValue(e.RowHandle2, view.Columns["ProductID"]).ToString();
e.Merge = (val1 == val2 && value3 == value4);
e.Handled = true;
return;
}
else if (e.Column.FieldName == "ProductUnit")// || e.Column.FieldName == "BillQty" || e.Column.FieldName == "RemQty" || e.Column.FieldName == "Rack" || e.Column.FieldName == "Quantity")
{
string val1 = e.CellValue1.ToString();
string val2 = e.CellValue2.ToString();
string value3 = view.GetRowCellValue(e.RowHandle1, view.Columns["ProductID"]).ToString();
string value4 = view.GetRowCellValue(e.RowHandle2, view.Columns["ProductID"]).ToString();
e.Merge = (val1 == val2 && value3 == value4);
e.Handled = true;
return;
}
}
private void dgv_Main_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
GridView view = sender as GridView;
GridColumn colCreatorID = dgv_Main.Columns["CompanyName"];
if (view == null)
{
return;
}
if (e.Column == colCreatorID)
{
string text1 = view.GetRowCellDisplayText(e.RowHandle1, colCreatorID);
string text2 = view.GetRowCellDisplayText(e.RowHandle2, colCreatorID);
e.Merge = (text1 == text2);
e.Handled = true;
}
//if (e.Column.FieldName == "CompanyName")
//{
// GridView view = sender as GridView;
// DateTime val1 = (DateTime)view.GetRowCellValue(e.RowHandle1, e.Column);
// DateTime val2 = (DateTime)view.GetRowCellValue(e.RowHandle2, e.Column);
// e.Merge = val1.Date == val2.Date;
// e.Handled = true;
//}
}
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
if (e.Column == colTenNV)
{
string text1 = gridView1.GetRowCellDisplayText(e.RowHandle1, colTenNV);
string text2 = gridView1.GetRowCellDisplayText(e.RowHandle2, colTenNV);
e.Merge = (text1 == text2);
e.Handled = true;
}
}
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
//if (e.Column.FieldName == "Name")
//{
// GridView view = sender as GridView;
// string val1 = (string)view.GetRowCellValue(e.RowHandle1, e.Column);
// string val2 = (string)view.GetRowCellValue(e.RowHandle2, e.Column);
// e.Merge = val1 == val2;
// e.Handled = true;
//}
}
/// <summary>
/// 合并行
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gvPrjAmountPayRpt_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
PrjAmountPayRpt row1 = gvPrjAmountPayRpt.GetRow(e.RowHandle1) as PrjAmountPayRpt;
PrjAmountPayRpt row2 = gvPrjAmountPayRpt.GetRow(e.RowHandle2) as PrjAmountPayRpt;
if (row1 != null && row2 != null && (row1.Type != row2.Type && row1.Type != 1 || DataSource.IsNewData && row1.Type == 3))
{
e.Merge = false;
e.Handled = true;
}
}
private void bandedGridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
GridView view = sender as GridView;
if (e.Column.FieldName == "IDKhachHang" || e.Column.FieldName == "NVGiaoDich" || e.Column.FieldName == "NhaCungCap")
{
string _mark3 = (view.GetRowCellValue(e.RowHandle1, e.Column) ?? string.Empty).ToString();
string _mark4 = (view.GetRowCellValue(e.RowHandle2, e.Column) ?? string.Empty).ToString();
e.Merge = _mark3 == _mark4;
e.Handled = true;
}
}
/// <summary>
/// 合并单元格
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gvResult_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
//if (e.Column.FieldName != "Key")
//{
// e.Merge = false;
// e.Handled = true;
//}
//if (e.Column.FieldName != "Depth")
//{
// e.Merge = false;
// e.Handled = true;
//}
}
private void gvPrjAmountWbsBoiRpt_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
GridView view = sender as GridView;
string firstColumnFieldName = "ItemNo";
if (e.Column.FieldName == "IItemCoe" || e.Column.FieldName == "ItemName" ||
e.Column.FieldName == "Uom" || e.Column.FieldName == "Price")
{
string valueFirstColumn1 = Convert.ToString(view.GetRowCellValue(e.RowHandle1, view.Columns[firstColumnFieldName]));
string valueFirstColumn2 = Convert.ToString(view.GetRowCellValue(e.RowHandle2, view.Columns[firstColumnFieldName]));
e.Merge = valueFirstColumn1 == valueFirstColumn2;
e.Handled = true;
}
}
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
if (e.Column.FieldName == "orderPrice")
{
GridView gridView = sender as GridView;
if (gridView != null)
{
Decimal value1 = (Decimal)gridView1.GetRowCellValue(e.RowHandle1, e.Column);
Decimal value2 = (Decimal)gridView1.GetRowCellValue(e.RowHandle2, e.Column);
e.Merge = value1 == value2;
e.Handled = true;
}
}
}
private void GvExport_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
String result1 = GetPreValue(gvExport, e.Column, e.RowHandle1);
String result2 = GetPreValue(gvExport, e.Column, e.RowHandle2);
if (String.Equals(result1, result2))
{
e.Merge = true;
}
else
{
e.Merge = false;
}
}
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
int rowOne = e.RowHandle1;
int rowTwo = e.RowHandle2;
string valueOne = gridView1.GetDataRow(rowOne)["JZ007"].ToString( );
string valueTwo = gridView1.GetDataRow(rowTwo)["JZ007"].ToString( );
string valueTre = gridView1.GetDataRow(rowOne)["JZ008"].ToString( );
string valueFor = gridView1.GetDataRow(rowTwo)["JZ008"].ToString( );
string valueSix = gridView1.GetDataRow(rowOne)["JZ009"].ToString( );
string valueSev = gridView1.GetDataRow(rowTwo)["JZ009"].ToString( );
if (valueOne + valueTre + valueSix != valueTwo + valueFor + valueSev)
{
e.Handled = true;
}
}
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
GridView view = sender as GridView;
try
{
if ((e.Column.FieldName == "CategoryID"))
{
int value1 = Convert.ToInt32(view.GetRowCellValue(e.RowHandle1, e.Column));
int value2 = Convert.ToInt32(view.GetRowCellValue(e.RowHandle2, e.Column));
e.Merge = (value1 == value2);
e.Handled = true;
return;
}
}
catch (Exception ex)
{
}
}
private void GVHD_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
GridView view = sender as GridView;
if (e.Column.FieldName == "HanhTrinhVe" || e.Column.FieldName == "HanhTrinhDi" || e.Column.FieldName == "SoVe")
{
string _mark = (view.GetRowCellValue(e.RowHandle1, "MaCho") ?? string.Empty).ToString();
string _mark2 = (view.GetRowCellValue(e.RowHandle2, "MaCho") ?? string.Empty).ToString();
string _mark3 = (view.GetRowCellValue(e.RowHandle1, e.Column) ?? string.Empty).ToString();
string _mark4 = (view.GetRowCellValue(e.RowHandle2, e.Column) ?? string.Empty).ToString();
e.Merge = _mark == _mark2 && _mark3 == _mark4;
e.Handled = true;
}
else if (e.Column.FieldName == "CongTy")
{
string _mark = (view.GetRowCellValue(e.RowHandle1, "MaHD") ?? string.Empty).ToString();
string _mark2 = (view.GetRowCellValue(e.RowHandle2, "MaHD") ?? string.Empty).ToString();
string _mark3 = (view.GetRowCellValue(e.RowHandle1, e.Column) ?? string.Empty).ToString();
string _mark4 = (view.GetRowCellValue(e.RowHandle2, e.Column) ?? string.Empty).ToString();
e.Merge = _mark == _mark2 && _mark3 == _mark4;
e.Handled = true;
}
}
/// <summary>
/// 设置Grid单元格合并
/// </summary>
private void gridViewPrReqList_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e)
{
try
{
GridView view = sender as GridView;
string firstColumnFieldName = "AutoId";
switch (e.Column.FieldName)
{
case "PrReqNo":
case "ReqState":
case "ReqDate":
case "CodeFileName":
case "CodeName":
case "Qty":
case "ProjectNo":
case "StnNo":
case "ReqDep":
case "PurCategory":
{
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);
ExceptionHandler.HandleException(this.Text + "--" + tsmiSzgrid.Text, ex);
}
}