public System.Data.DataTable GetData(PRPDCAP.CAPStatus Status)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", Status)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_PRPDCAP_By_Status", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetData(PRPDCAP.CAPStatus Status1, PRPDCAP.CAPStatus Status2)
{
tblPRPDCAPTableAdapter da = new tblPRPDCAPTableAdapter();
da.Connection = Connection;
try
{
return(da.GetDataByApprove(Convert.ToInt32(Status1), Convert.ToInt32(Status2)));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
da.Dispose();
}
}
