| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据编号获得信息 |
| | | /// </summary> |
| | | /// <param name="Keyid">编号</param> |
| | | /// <returns></returns> |
| | | public int GetCountByKeyid(Guid? BuyerId, string shoukuanshijian = "") |
| | | { |
| | | try |
| | | { |
| | | string condition = " "; |
| | | |
| | | condition = " BuyerId='" + BuyerId + "' and shoukuanshijian='" + shoukuanshijian + "'"; |
| | | |
| | | |
| | | // return null;//错误数据返会空 |
| | | |
| | | IList<OA_Cuikuanjilu> result = _dataBase.SelectModel<OA_Cuikuanjilu>(" count(*) as Count ", "OA_Cuikuanjilu", condition) as IList<OA_Cuikuanjilu>;//执行查询 |
| | | |
| | | return (null == result || result.Count == 0) ? 0 : result[0].Count.Value;//返回结果 |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 全部查询 |
| | | /// </summary> |
| | | /// <param name="query"></param> |