| | |
|---|
| | | resultOrderBy = query.Criteria[maxParamIndex].Value.ToString();//= 1 == orderbys.Length ? resultOrderBy : orderbys[1]; |
|---|
| | | } |
|---|
| | | string fromSouce = string.Format("{0}{1}{2}", FROMSOUCEBEFORE, query.Criteria[0].Value, FROMSOUCEEND);//拼装条件 |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 查询来源 |
|---|
| | | /// </summary> |
|---|
| | | string fromss = " [OA_Kaipiaoshenqing] ok inner join [OA_CorporateClients] oe on oe.Keyid = ok.[BuyerId] " + |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | " where 0=0 "+ query.Criteria[0].Value; |
|---|
| | | var ssss = _dataBase.SelectModel<Model.OA_Kaipiaoshenqing>(" sum(ok.kpmoney) as kpmoney,sum(ok.Huikuanmoney) as Huikuanmoney,sum(ok.Zengjianmoney) as Zengjianmoney ", fromss); |
|---|
| | | if (ssss.Count>0) |
|---|
| | | { |
|---|
| | | var aaaaa = ssss.First(); |
|---|
| | | pagination.heji1 = aaaaa.kpmoney; |
|---|
| | | pagination.heji2 = aaaaa.Zengjianmoney; |
|---|
| | | pagination.heji3 = aaaaa.Huikuanmoney; |
|---|
| | | } |
|---|
| | | |
|---|
| | | return _dataBase.SelectModelPage<Model.OA_Kaipiaoshenqing>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy); |
|---|
| | | } |
|---|
| | | |
|---|
