| | |
|---|
| | | /// <param name="pa"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public IEnumerable<OA_Kaipiaoshenqing> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd, |
|---|
| | | string Kaipiaoshenqing, string Kehuqianshou, string BusinessManagerId, string CustormerName, string PayStates, string HuikuanStates) |
|---|
| | | string Kaipiaoshenqing, string Kehuqianshou, string BusinessManagerId, string CustormerName, string PayStates, string HuikuanStates,string Fapiaohao) |
|---|
| | | { |
|---|
| | | string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 "; |
|---|
| | | |
|---|
| | |
|---|
| | | Condition += " and ( ( ok.Shenqingleixing ='订单开票' and EXISTS ( select eoe.[KaipiaoshenqingId] from [EC_OrderExtend] eoe inner join [EC_OrderBasic] eob on eob.Keyid = eoe.Keyid where ok.Keyid = eoe.[KaipiaoshenqingId] and eob.PayState !=-1 ) ) or ( ok.Shenqingleixing ='预付款开票' and ok.[Kehumoney] < ok.[kpmoney] ) )"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(Fapiaohao)) |
|---|
| | | Condition += " and ok.Fapiaohao like '%" + Fapiaohao + "%'"; |
|---|
| | | |
|---|
| | | Query query = new Query(); |
|---|
| | | IList<Criterion> criterias = new List<Criterion>() |
|---|
