private void ShowDetailsManual(AFreeformAnalysisRow ARow)
{
if (ARow == null)
{
txtDetailAnalysisValue.Clear();
return;
}
}
private void NewRowManual(ref AFreeformAnalysisRow ARow)
{
string newName = Catalog.GetString("NEWVALUE");
Int32 countNewDetail = 0;
if (FMainDS.AFreeformAnalysis.Rows.Find(new object[] { FLedgerNumber, FTypeCode, newName }) != null)
{
while (FMainDS.AFreeformAnalysis.Rows.Find(new object[] { FLedgerNumber, FTypeCode, newName + countNewDetail.ToString() }) != null)
{
countNewDetail++;
}
newName += countNewDetail.ToString();
}
ARow.AnalysisValue = newName;
ARow.LedgerNumber = FLedgerNumber;
ARow.AnalysisTypeCode = FTypeCode;
}
private void NewRowManual(ref AFreeformAnalysisRow ARow)
{
string newName = Catalog.GetString("NEWVALUE");
Int32 countNewDetail = 0;
if (FMainDS.AFreeformAnalysis.Rows.Find(new object[] { FLedgerNumber, FTypeCode, newName }) != null)
{
while (FMainDS.AFreeformAnalysis.Rows.Find(new object[] { FLedgerNumber, FTypeCode, newName + countNewDetail.ToString() }) != null)
{
countNewDetail++;
}
newName += countNewDetail.ToString();
}
ARow.AnalysisValue = newName;
ARow.LedgerNumber = FLedgerNumber;
ARow.AnalysisTypeCode = FTypeCode;
}
private void AnalysisAttributesGrid_RowSelected(System.Object sender, RangeRegionChangedEventArgs e)
{
if (grdAnalAttributes.Selection.ActivePosition.IsEmpty() || (grdAnalAttributes.Selection.ActivePosition.Column == 0))
{
return;
}
if ((GetSelectedAttributeRow() == null) || (FPSAttributesRow == GetSelectedAttributeRow()))
{
return;
}
FPSAttributesRow = GetSelectedAttributeRow();
FMainDS.AFreeformAnalysis.DefaultView.RowFilter = String.Format("{0}='{1}' AND {2}=true",
AFreeformAnalysisTable.GetAnalysisTypeCodeDBName(),
FPSAttributesRow.AnalysisTypeCode,
AFreeformAnalysisTable.GetActiveDBName());
//Refresh the combo values
int analTypeCodeValuesCount = FMainDS.AFreeformAnalysis.DefaultView.Count;
if (analTypeCodeValuesCount == 0)
{
MessageBox.Show(Catalog.GetString(
"No attribute values are defined!"), FPSAttributesRow.AnalysisTypeCode, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
string[] analTypeValues = new string[analTypeCodeValuesCount];
FMainDS.AFreeformAnalysis.DefaultView.Sort = AFreeformAnalysisTable.GetAnalysisValueDBName();
int counter = 0;
foreach (DataRowView dvr in FMainDS.AFreeformAnalysis.DefaultView)
{
AFreeformAnalysisRow faRow = (AFreeformAnalysisRow)dvr.Row;
analTypeValues[counter++] = faRow.AnalysisValue;
}
cmbAnalAttribValues.StandardValuesExclusive = true;
cmbAnalAttribValues.StandardValues = analTypeValues;
}
/// <summary>
/// if the value changes check if the new value is active
/// </summary>
private void ValueChanged(object sender, EventArgs e)
{
Object selectedItem = cmbDetailAnalysisAttributeValue.SelectedItem;
int selectedIndex = cmbDetailAnalysisAttributeValue.SelectedIndex;
if ((selectedIndex < 0) || (selectedItem == null))
{
return;
}
AFreeformAnalysisRow freeFormAnalRow = null;
String selectedItemString = selectedItem.ToString();
bool AccessOk = false;
try
{
Object[] PrimaryKey = new Object[] {
FLedgerNumber, txtReadonlyAnalysisTypeCode.Text, selectedItemString
};
freeFormAnalRow = (AFreeformAnalysisRow)FCacheDS.AFreeformAnalysis.Rows.Find(PrimaryKey);
AccessOk = true;
}
catch (Exception)
{
cmbDetailAnalysisAttributeValue.ForeColor = System.Drawing.Color.Red;
}
if (AccessOk)
{
if (freeFormAnalRow.Active)
{
cmbDetailAnalysisAttributeValue.ForeColor = System.Drawing.Color.Black;
cmbDetailAnalysisAttributeValue.Font = System.Windows.Forms.Control.DefaultFont;
}
else
{
cmbDetailAnalysisAttributeValue.ForeColor = System.Drawing.Color.Gray;
cmbDetailAnalysisAttributeValue.Font = new System.Drawing.Font(System.Windows.Forms.Control.DefaultFont,
System.Drawing.FontStyle.Strikeout);
}
}
}
private void GetDetailDataFromControlsManual(AFreeformAnalysisRow ARow)
{
// TODO
}
private static bool DetailLineAttributesRequired(ref bool AllPresent, AccountsPayableTDS Atds, AApDocumentDetailRow DetailRow)
{
Atds.AAnalysisAttribute.DefaultView.RowFilter =
String.Format("{0}='{1}'", AAnalysisAttributeTable.GetAccountCodeDBName(), DetailRow.AccountCode);
if (Atds.AAnalysisAttribute.DefaultView.Count > 0)
{
bool IhaveAllMyAttributes = true;
//
// It's possible that my TDS doesn't even have an AnalAttrib table...
if (Atds.AApAnalAttrib == null)
{
Atds.Merge(new AApAnalAttribTable());
}
foreach (DataRowView rv in Atds.AAnalysisAttribute.DefaultView)
{
AAnalysisAttributeRow AttrRow = (AAnalysisAttributeRow)rv.Row;
Atds.AApAnalAttrib.DefaultView.RowFilter =
String.Format("{0}={1} AND {2}='{3}'",
AApAnalAttribTable.GetDetailNumberDBName(), DetailRow.DetailNumber,
AApAnalAttribTable.GetAccountCodeDBName(), AttrRow.AccountCode);
if (Atds.AApAnalAttrib.DefaultView.Count == 0)
{
IhaveAllMyAttributes = false;
break;
}
foreach (DataRowView rv2 in Atds.AApAnalAttrib.DefaultView)
{
AApAnalAttribRow AttribValueRow = (AApAnalAttribRow)rv2.Row;
if (AttribValueRow.AnalysisAttributeValue == "")
{
IhaveAllMyAttributes = false;
break;
}
// Is the referenced AttribValue active?
AFreeformAnalysisRow referencedRow = (AFreeformAnalysisRow)Atds.AFreeformAnalysis.Rows.Find(
new Object[] { AttribValueRow.LedgerNumber, AttribValueRow.AnalysisTypeCode, AttribValueRow.AnalysisAttributeValue }
);
if ((referencedRow == null) || !referencedRow.Active)
{
IhaveAllMyAttributes = false;
break;
}
}
if (IhaveAllMyAttributes == false) // because of the test above..
{
break;
}
}
AllPresent = IhaveAllMyAttributes;
return(true);
}
else
{
AllPresent = true; // This detail line is fully specified
return(false); // No attributes are required
}
}
private void ShowDetailsManual(AFreeformAnalysisRow ARow)
{
if (ARow == null)
{
txtDetailAnalysisValue.Clear();
return;
}
}
private void GetDetailDataFromControlsManual(AFreeformAnalysisRow ARow)
{
// TODO
}
private void AnalysisAttributesGrid_RowSelected(System.Object sender, RangeRegionChangedEventArgs e)
{
TSgrdDataGridPaged Grid = sender as TSgrdDataGridPaged;
if (Grid == null)
{
Grid = (TSgrdDataGridPaged)((SourceGrid.Selection.RowSelection)sender).Grid;
}
if (Grid.Selection.ActivePosition.IsEmpty() || (Grid.Selection.ActivePosition.Column == 0))
{
return;
}
if ((TAnalysisAttributes.GetSelectedAttributeRow(Grid) == null) || (FPSAttributesRow == TAnalysisAttributes.GetSelectedAttributeRow(Grid)))
{
return;
}
FPSAttributesRow = TAnalysisAttributes.GetSelectedAttributeRow(Grid);
string currentAnalTypeCode = FPSAttributesRow.AnalysisTypeCode;
FCacheDS.AFreeformAnalysis.DefaultView.RowFilter = String.Format("{0}='{1}' AND {2}=true",
AFreeformAnalysisTable.GetAnalysisTypeCodeDBName(),
currentAnalTypeCode,
AFreeformAnalysisTable.GetActiveDBName());
int analTypeCodeValuesCount = FCacheDS.AFreeformAnalysis.DefaultView.Count;
if (analTypeCodeValuesCount == 0)
{
MessageBox.Show(Catalog.GetString(
"No attribute values are defined!"), currentAnalTypeCode, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
string[] analTypeValues = new string[analTypeCodeValuesCount];
FCacheDS.AFreeformAnalysis.DefaultView.Sort = AFreeformAnalysisTable.GetAnalysisValueDBName();
int counter = 0;
foreach (DataRowView dvr in FCacheDS.AFreeformAnalysis.DefaultView)
{
AFreeformAnalysisRow faRow = (AFreeformAnalysisRow)dvr.Row;
analTypeValues[counter] = faRow.AnalysisValue;
counter++;
}
//Refresh the combo values
if (Grid.Name == grdFromAnalAttributes.Name)
{
FcmbFromAnalAttribValues.StandardValuesExclusive = true;
FcmbFromAnalAttribValues.StandardValues = analTypeValues;
}
else
{
FcmbToAnalAttribValues.StandardValuesExclusive = true;
FcmbToAnalAttribValues.StandardValues = analTypeValues;
}
}
