public Int32 GetNextSupervisorApprovalLimit(string EmployeeNumber)
{
Int32 returnValue = 0;
string cCon = ERMA.Properties.Settings.Default.WOW.ToString();
string strSchema = ERMA.Properties.Settings.Default.DB2Database.ToString();
TACDataRowType drt = new TACDataRowType();
string strSQL = SQL.GetNextSupervisorApprovalLimit(EmployeeNumber);
try
{
drt = Data.GetTACDataRow(strSQL, cCon);
if (drt.HasData)
{
returnValue = Convert.ToInt32(drt.Drow.ItemArray[0].ToString());
}
}
catch { }
return(returnValue);
}
public Int32 GetApprovalLimit(string JobClass, string Title)
{
Int32 returnValue = 0;
string cCon = ERMA.Properties.Settings.Default.WOW.ToString();
string strSchema = ERMA.Properties.Settings.Default.DB2Database.ToString();
TACDataRowType drt = new TACDataRowType();
string strSQL = SQL.GetApprovalLimit(JobClass, Title);
try
{
drt = Data.GetTACDataRow(strSQL, cCon);
if (drt.HasData)
{
returnValue = Convert.ToInt32(drt.Drow.ItemArray[0].ToString());
}
}
catch { }
return(returnValue);
}
