public static double So(BandedGridView gridView, int i, GridColumn column)
{
string str = gridView.GetRowCellValue(i, column).ToString();
try
{
double so = Convert.ToDouble(str);
return(so);
}
catch
{
return(0);
}
}
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;
}
private void bandedGridView1_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
BandedGridView view = sender as BandedGridView;
if (view == null)
{
return;
}
btnSaveChanged.Visible = true;
string staffCode = view.GetRowCellValue(e.RowHandle, view.Columns[0]).ToString();
if (e.Column == gridLevelDateI)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[10], str);
}
}
if (e.Column == gridLevelDateII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[10], str);
}
}
if (e.Column == gridLevelDateIII)
{
if (e.Value != null)
{
string cellValue = null;
if (Ultils.IsNull(e.Value.ToString()))
{
cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[10], str);
}
}
}
if (e.Column == gridTestDateActual)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[10], str);
}
}
if (e.Column == gridLevelI)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[9], cellValue);
}
}
if (e.Column == gridLevelII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[9], cellValue);
}
}
if (e.Column == gridLevelIII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[9], cellValue);
}
}
}
private void bandedGridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
BandedGridView view = sender as BandedGridView;
if (view == null)
{
return;
}
btnSaveChanged.Visible = true;
string staffCode = view.GetRowCellValue(e.RowHandle, view.Columns[0]).ToString();
if (e.Column == gridLevelDateI)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[8], str);
}
}
if (e.Column == gridLevelDateII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[8], str);
}
}
if (e.Column == gridDateLevelIII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[8], str);
}
}
if (e.Column == gridTestDateActual)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
DateTime changeValue = DateTime.Parse(cellValue).AddDays(365);
string str = changeValue.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[8], str);
}
}
if (e.Column == gridCapDo)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[7], cellValue);
}
}
if (e.Column == gridLevelII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[7], cellValue);
}
}
if (e.Column == gridLevelIII)
{
if (e.Value != null)
{
string cellValue = e.Value.ToString();
view.SetRowCellValue(e.RowHandle, view.Columns[7], cellValue);
}
}
}
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;
}
