public DataTable ViewMemo(int nEmployeeID, ViewMemoType aType)
{
DataTable dtblMessage;
SqlParameter param1 = new SqlParameter("@nEmployeeID", nEmployeeID);
if (aType == ViewMemoType.All)
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectAllBynEmployeeID", param1);
}
else if (aType == ViewMemoType.BranchBulletin)
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectBranchBulletinBynEmployeeID", param1);
}
else if (aType == ViewMemoType.PersonalMail)
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectPersonalMailBynEmployeeID", param1);
}
else
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectSentMailBynEmployeeID", param1);
}
return(dtblMessage);
}
public DataTable ViewMemo(int nEmployeeID, ViewMemoType aType)
{
DataTable dtblMessage;
SqlParameter param1 = new SqlParameter("@nEmployeeID", nEmployeeID);
if (aType == ViewMemoType.All)
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectAllBynEmployeeID", param1);
}
else if (aType == ViewMemoType.BranchBulletin)
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectBranchBulletinBynEmployeeID", param1);
}
else if (aType == ViewMemoType.PersonalMail)
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectPersonalMailBynEmployeeID", param1);
}
else
{
dtblMessage = SqlHelperUtils.ExecuteDataTableSP("pr_tblMemo_SelectSentMailBynEmployeeID", param1);
}
return dtblMessage;
}
