strSql.Append(@"Select N.NotificationOptionId,

                                   S.FullName,

                                   No.Title,

                                   N.SortCode,

                                   N.Content,

                                   N.CreateDate,

                                   N.CreateUserId,

                                   N.CreateUserName,

                                   N.ModifyDate,

                                   N.ModifyUserId,

                                   N.ModifyUserName

                              From (NotificationOption As N

                                   Inner Join Sys_Company AS S On S.CompanyId=N.SchoolCode)

                                   Inner Join Notifications AS No On No.NotificationId=N.NotificationId

                                   Where 1=1");