| | |
|---|
| | | Condition += " and ok.BusinessManagerId = '" + BusinessManagerId + "'"; |
|---|
| | | if (!string.IsNullOrEmpty(CustormerName)) |
|---|
| | | Condition += " and oe.CompanyName like '%" + CustormerName + "%'"; |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(PayStates)) |
|---|
| | | { |
|---|
| | | if (PayStates == "2") |
|---|
| | | { |
|---|
| | | Condition += " and not 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 ) "; |
|---|
| | | } |
|---|
| | | else if (PayStates == "1") |
|---|
| | | { |
|---|
| | | Condition += " 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 ) "; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(HuikuanStates)) |
|---|
| | | { |
|---|
| | | if (HuikuanStates == "2") |
|---|
| | | { |
|---|
| | | Condition += " and ok.Huikuanmoney >0 "; |
|---|
| | | Condition += " and ok.Huikuanmoney >= kpmoney "; |
|---|
| | | } |
|---|
| | | else if (HuikuanStates == "1") |
|---|
| | | { |
|---|
| | | Condition += " and ( ok.Huikuanmoney is null or ok.Huikuanmoney <=0) "; |
|---|
| | | Condition += " and ( ok.Huikuanmoney is null or ok.Huikuanmoney < kpmoney ) "; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(PayStates)) |
|---|
| | | { |
|---|
| | | if (PayStates == "2") |
|---|
| | | { |
|---|
| | | Condition += " and (( ok.Shenqingleixing ='订单开票' and not 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] ) )"; |
|---|
| | | } |
|---|
| | | else if (PayStates == "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] ) )"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | Query query = new Query(); |
|---|
| | | IList<Criterion> criterias = new List<Criterion>() |
|---|
