private void gvDetail_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDetail.IsNewItemRow(e.RowHandle))
{
int poId = (int)gvPO.GetFocusedDataRow()[colId.FieldName];
DataRowView row = e.Row as DataRowView;
row[colDetailId.FieldName] = FieldPODetail.SqlInsert(poId, (int)row[colDetailPOLine.FieldName], (string)row[colDetailDescription.FieldName],
ConvertEx.ToNullable <int>(row[colDetailLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel2Code.FieldName]),
ConvertEx.ToNullable <int>(row[colDetailLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel4Code.FieldName]),
ConvertEx.CharToEnum <EnumComponentType>(row[colDetailComponent.FieldName]), (bool)row[colDetailBillable.FieldName], (decimal)row[colDetailAmount.FieldName]);
SetSubmitStatus(EnumSubmitStatus.Open);
}
}
private void SequenceDetails()
{
for (int i = 0; i < gvDetail.RowCount; i++)
{
int handle = gvDetail.GetRowHandle(i);
DataRow row = gvDetail.GetDataRow(handle);
if (handle >= 0)
{
if ((int)row[colDetailPOLine.FieldName] != handle + 1)
{
row[colDetailPOLine.FieldName] = handle + 1;
FieldPODetail.SqlUpdateLineNum((int)row[colDetailId.FieldName], handle + 1);
}
}
else
{
row[colDetailPOLine.FieldName] = i + 1;
}
}
}
private void gvDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
DataRow row = gvDetail.GetDataRow(e.RowHandle);
if (e.Column == colDetailLevel1Code)
{
row[colDetailLevel2Code.FieldName] = DBNull.Value;
row[colDetailLevel3Code.FieldName] = DBNull.Value;
row[colDetailLevel4Code.FieldName] = DBNull.Value;
}
else if (e.Column == colDetailLevel2Code)
{
row[colDetailLevel3Code.FieldName] = DBNull.Value;
row[colDetailLevel4Code.FieldName] = DBNull.Value;
}
else if (e.Column == colDetailLevel3Code)
{
row[colDetailLevel4Code.FieldName] = DBNull.Value;
}
else if (e.Column == colDetailAmount)
{
UpdatePOAmount();
}
if (!gvDetail.IsNewItemRow(e.RowHandle))
{
if (new GridColumn[] { colDetailDescription, colDetailLevel1Code, colDetailLevel2Code, colDetailLevel3Code, colDetailLevel4Code, colDetailComponent, colDetailBillable, colDetailAmount }.Contains(e.Column))
{
FieldPODetail.SqlUpdate((int)row[colDetailId.FieldName], (string)row[colDetailDescription.FieldName],
ConvertEx.ToNullable <int>(row[colDetailLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel2Code.FieldName]),
ConvertEx.ToNullable <int>(row[colDetailLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel4Code.FieldName]),
ConvertEx.CharToEnum <EnumComponentType>(row[colDetailComponent.FieldName]), (bool)row[colDetailBillable.FieldName], (decimal)row[colDetailAmount.FieldName]);
SetSubmitStatus(EnumSubmitStatus.Open);
}
}
}
private void gvDetail_RowDeleting(object sender, DevExpress.Data.RowDeletingEventArgs e)
{
DataRow row = gvDetail.GetDataRow(e.RowHandle);
FieldPODetail.SqlDelete((int)row[colDetailId.FieldName]);
}