| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | var sql = "select top(10) m.HMakeDate as 日期, m.HLevel as 紧急程度, m.HContext as 主题 " + |
|---|
| | | " , m.HSendMan as 发送人, s.HReceiveMan as 接收人, d.HName as 发送部门 " + |
|---|
| | | var sql = "select top(10) m.HInterID,s.HEntryID,m.HMakeDate as 日期, m.HLevel as 状况, m.HContext as 主题 " + |
|---|
| | | ", m.HContext as 内容" + |
|---|
| | | ", m.HSendMan as 发送人, s.HReceiveMan as 接收人, d.HName as 发送部门 " + |
|---|
| | | " from OA_InformBillMain as m" + |
|---|
| | | " inner join OA_InformBillSub as s on m.HInterID = s.HInterID" + |
|---|
| | | " left join Gy_Department d on m.HDeptID = d.HItemID" + |
|---|
