| | |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="pa"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public IEnumerable<Adm_tongxunlu> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string danwei_name,bool IsChangyongziliao,int? staffid) |
|---|
| | | public IEnumerable<Adm_tongxunlu> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string danwei_name,bool IsChangyongziliao,int? staffid, string selquanxin) |
|---|
| | | { |
|---|
| | | string Condition = " and ok.FirmId ='" + FirmId + "' and ok.rec_status = 'A' "; |
|---|
| | | |
|---|
| | |
|---|
| | | Condition += " and ok.type_id = " + type_id + ""; |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(selquanxin)) |
|---|
| | | { |
|---|
| | | if (selquanxin == "1") |
|---|
| | | { |
|---|
| | | Condition += " and ( ok.[Jusequanxian] = '' or ok.[Jusequanxian] = ',,' )"; |
|---|
| | | } |
|---|
| | | else if (selquanxin == "2") |
|---|
| | | { |
|---|
| | | Condition += " and (ok.[Jusequanxian] != '' and ok.[Jusequanxian] != ',,' )"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(danwei_name)) |
|---|
| | | { |
|---|
| | | Condition += " and ok.danwei_name like '%" + danwei_name + "%'"; |
|---|
