| | |
|---|
| | | public IEnumerable<OA_CorporateClients> GetModelPageList(Pagination pa, Guid FirmId, string UserName, DateTime? beginTime, |
|---|
| | | DateTime? endTime, string AccountManagerId, string BusinessManagerId, string CustomerIndustriesId, string CustomerTypeId, string DegreeImportanId,string LastOrderTime, string selOrderCount, string selOrderMoney, string SourcesInfoId, string TurnoverIntentionId, |
|---|
| | | string OrderCount, string OrderMoney, string UserNum, string selLastOrderTime, string Province, string City, string County, bool IsStaff, Guid StaffMemberId,int? StaffId,string Shifouwanjie=null, |
|---|
| | | bool? NeedWeifu=null,bool?NeedJiejiaRiWeiFu=null) |
|---|
| | | bool? NeedWeifu=null,bool?NeedJiejiaRiWeiFu=null, string selHetongshangchuan = null) |
|---|
| | | { |
|---|
| | | string Condition = " and a.FirmId ='" + FirmId + "'"; |
|---|
| | | |
|---|
| | |
|---|
| | | if (!string.IsNullOrEmpty(selOrderMoney) && !string.IsNullOrEmpty(OrderMoney)) |
|---|
| | | Condition += string.Format(" and OrderMoney{0}'{1}'", selOrderMoney, OrderMoney); |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(selHetongshangchuan)) |
|---|
| | | { |
|---|
| | | if (selHetongshangchuan == "1") |
|---|
| | | { |
|---|
| | | Condition += string.Format(" and a.Keyid in ( select CorporateClientsid from [dbo].[OA_CorporateClientContract] ) "); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | Condition += string.Format(" and a.Keyid not in ( select CorporateClientsid from [dbo].[OA_CorporateClientContract] ) "); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(selLastOrderTime) && !string.IsNullOrEmpty(LastOrderTime)) |
|---|
| | | Condition += string.Format(" and CAST(LastOrderTime AS DATE) {0} CAST(getdate()-{1} AS date)", LastOrderTime, selLastOrderTime); |
|---|
| | | |
|---|
