| | |
|---|
| | | searchSql=" CONVERT(VARCHAR(10),ServiceOrd_CC_Time,120)=CONVERT(VARCHAR(10),'"&Year(now())&"-"&Right("0"&Month(now()),2)&"-"&Mid(searchTXT,1,2)&"',120) and Right('00'+convert(varchar(3),ServiceOrdNo),3)='"&Right(searchTXT,3)&"' "
|
|---|
| | | ElseIf Len(searchTXT)=14 And Not IsNumeric(Left(searchTXT,2)) And IsNumeric(Mid(searchTXT,3,8)) And IsNumeric(Right(searchTXT,3)) And Mid(searchTXT,11,1)="-" Then
|
|---|
| | | searchSql=" ServiceOrdClass='"&Left(searchTXT,2)&"' and CONVERT(VARCHAR(10),ServiceOrd_CC_Time,120)=CONVERT(VARCHAR(10),'"&Mid(searchTXT,3,4)&"-"&Mid(searchTXT,7,2)&"-"&Mid(searchTXT,9,2)&"',120) and Right('00'+convert(varchar(3),ServiceOrdNo),3)='"&Right(searchTXT,3)&"' "
|
|---|
| | | ElseIf Len(searchTXT)=10 And IsNumeric(searchTXT) Then
|
|---|
| | | searchSql=" ServiceOrdID="&Right(searchTXT,10)&" "
|
|---|
| | | ElseIf Mid(searchTXT,1,4)="out|" Then ' and DispatchOrdState in (8)
|
|---|
| | | ElseIf Len(searchTXT)=14 And Mid(searchTXT,11,1)="-" Then
|
|---|
| | | searchSql=" Old_ServiceOrdID_TXT='"&searchTXT&"' "
|
|---|
| | | ElseIf Len(searchTXT)=10 And IsNumeric(searchTXT) Then
|
|---|
| | | searchSql=" ServiceOrdID="&Right(searchTXT,10)&" "
|
|---|
| | | ElseIf Mid(searchTXT,1,4)="out|" Then ' and DispatchOrdState in (8)
|
|---|
| | | searchSql=" (ServiceOrdPtOutHosp in (select vid from dictionary where vType=1 and vtitle='HospName' and vtext='"&Mid(searchTXT,5)&"')) and ServiceOrd_CC_Time "&SqlOrdDateType
|
|---|
| | | ElseIf Mid(searchTXT,1,3)="in|" Then
|
|---|
| | | searchSql=" (ServiceOrdPtInHosp in (select vid from dictionary where vType=1 and vtitle='HospName' and vtext='"&Mid(searchTXT,4)&"')) and ServiceOrd_CC_Time "&SqlOrdDateType
|
|---|
| | |
|---|
| | | '组成计算总页数SQL
|
|---|
| | | total_sql = "select ServiceOrdID "&sqlWhere
|
|---|
| | | '组成显示结果SQL
|
|---|
| | | Result_sql = "select ServiceOrdID,ServiceOrdNo,ServiceOrdClass,ServiceOrdAreaType,ServiceOrdType,ServiceOrdState,ServiceOrdStartDate,ServiceOrdApptDate,ServiceOrdCoName,ServiceOrdCoPhone,ServiceOrdPtAge,ServiceOrdPtSex,ServiceOrdTraProvince,ServiceOrdTraCity,ServiceOrdTraStreet,ServiceOrdTraEnd,ServiceOrdTraVia,ServiceOrdTraDistance,ServiceOrdTraSDTime,ServiceOrdTraTxnPrice,ServiceOrd_CC_ID,ServiceOrd_CC_Time,ServiceOrd_NS_ID,ServiceOrd_NS_Time,ServiceOrd_AP_Check,ServiceOrd_AP_ID,ServiceOrd_AP_Time,ServiceOrdVIP,ServiceOrdUnitID,ServiceOrdUnitRemarks,ServiceOrdIntroducer,ServiceOrdOperationRemarks,ServiceOrdPtOutHospID,ServiceOrdPtOutHosp,ServiceOrdPtInHospID,ServiceOrdPtInHosp,ServiceOrdCancelReasonTXT,ServiceOrdCancelReason,FromHQ_is,ServiceOrd_Sale_ID,ServiceOrdPoints,row_number() over (order by ServiceOrdID desc) n "&sqlWhere
|
|---|
| | | Result_sql = "select ServiceOrdID,ServiceOrdNo,ServiceOrdClass,ServiceOrdAreaType,ServiceOrdType,ServiceOrdState,ServiceOrdStartDate,ServiceOrdApptDate,ServiceOrdCoName,ServiceOrdCoPhone,ServiceOrdPtAge,ServiceOrdPtSex,ServiceOrdTraProvince,ServiceOrdTraCity,ServiceOrdTraStreet,ServiceOrdTraEnd,ServiceOrdTraVia,ServiceOrdTraDistance,ServiceOrdTraSDTime,ServiceOrdTraTxnPrice,ServiceOrd_CC_ID,ServiceOrd_CC_Time,ServiceOrd_NS_ID,ServiceOrd_NS_Time,ServiceOrd_AP_Check,ServiceOrd_AP_ID,ServiceOrd_AP_Time,ServiceOrdVIP,ServiceOrdUnitID,ServiceOrdUnitRemarks,ServiceOrdIntroducer,ServiceOrdOperationRemarks,ServiceOrdPtOutHospID,ServiceOrdPtOutHosp,ServiceOrdPtInHospID,ServiceOrdPtInHosp,ServiceOrdCancelReasonTXT,ServiceOrdCancelReason,FromHQ_is,ServiceOrd_Sale_ID,ServiceOrdPoints,Old_ServiceOrdID_TXT,row_number() over (order by ServiceOrdID desc) n "&sqlWhere
|
|---|
| | | '附加结果SQL
|
|---|
| | | Additional_sql = ",StretcherMoney=isnull((select sum(StretcherMoney) from DispatchOrd where ServiceOrdIDDt=ServiceOrdID),0),ContractMode_is=isnull((select COUNT(id) from ServiceOrd_TransferMode where ServiceOrdTMID=ServiceOrdID and TransferModeID=7),0),UserPointsCost=isnull((select sum(Points_Score) from UserPoints where Points_State<>4 and Points_Type=1 and ServiceOrdIDDt=ServiceOrdID),0)"
|
|---|
| | |
|
|---|
| | |
|---|
| | | ServiceOrdCancelReason= rs("ServiceOrdCancelReason")
|
|---|
| | | FromHQ_is = rs("FromHQ_is") '是否有转内部转发
|
|---|
| | | ContractMode_is = rs("ContractMode_is") '是否承包组任务
|
|---|
| | | If isDepartment("010401")=0 Then
|
|---|
| | | ServiceOrdNo = ServiceOrdClass& year(rs("ServiceOrd_CC_Time"))&Right("0"&month(rs("ServiceOrd_CC_Time")),2)&Right("0"&day(rs("ServiceOrd_CC_Time")),2) & "-"&Right("00"&rs("ServiceOrdNo"),3)
|
|---|
| | | Else
|
|---|
| | | ServiceOrdNo = ServiceOrdClass&ServiceOrdID
|
|---|
| | | End If
|
|---|
| | | Old_ServiceOrdID_TXT = rs("Old_ServiceOrdID_TXT") '旧服务单号
|
|---|
| | | If isDepartment("010401")=0 Then
|
|---|
| | | ServiceOrdNo = ServiceOrdClass& year(rs("ServiceOrd_CC_Time"))&Right("0"&month(rs("ServiceOrd_CC_Time")),2)&Right("0"&day(rs("ServiceOrd_CC_Time")),2) & "-"&Right("00"&rs("ServiceOrdNo"),3)
|
|---|
| | | Else
|
|---|
| | | ServiceOrdNo = ServiceOrdClass&ServiceOrdID
|
|---|
| | | End If
|
|---|
| | |
|
|---|
| | | i=i+1
|
|---|
| | |
|
|---|
