| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据编号获得信息 |
| | | /// </summary> |
| | | /// <param name="Keyid">编号</param> |
| | | /// <returns></returns> |
| | | public OA_WorkPlan GetModelByFukuanshenqid(string PlanComplany, string RewardType) |
| | | { |
| | | try |
| | | { |
| | | string condi = ""; |
| | | if (!string.IsNullOrEmpty(PlanComplany)) |
| | | { |
| | | condi = " a.PlanComplany = '"+ PlanComplany + "' "; |
| | | } |
| | | else if (!string.IsNullOrEmpty(RewardType)) |
| | | { |
| | | condi = " a.RewardType = '" + RewardType + "' "; |
| | | } |
| | | else |
| | | { |
| | | return null; |
| | | } |
| | | |
| | | IList<OA_WorkPlan> result = _dataBase.SelectModel<OA_WorkPlan>(" a.* ", " OA_WorkPlan a ", condi) as IList<OA_WorkPlan>;//执行查询 |
| | | |
| | | return (null == result || result.Count == 0) ? null : result[0];//返回结果 |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 分页查询 |
| | | /// </summary> |