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; }