2023年6月21日发(作者：)
Datable添加到Dataset并且重新命名 View Code1 string strSql = " SELECT * from vSelShipModeAUGReporting Where 1 = 1 " ;2 string strWhere = string .Empty;3
4 if ( > 0 )5 {6 if ( ().ToUpper() == ())7 {8 strWhere += " AND RTRIM([ShipMode]) = " + " ' " + ().ToUpper() + " ' " ;9 }10 else
11 {12 strWhere += " AND ISNULL(IsNew, 0) = 0 " ;13 strWhere += " AND RTRIM([ShipMode]) <> " + " ' " + () + " ' " ;14 }15 }16 if (().Length > 0 )17 {18 strWhere += " AND CONVERT(VARCHAR(12),PickupDate,110) >= CONVERT(VARCHAR(12),' " + ()+ " ',110) " ;19 }20 if (().Length > 0 )21 {22 strWhere += " AND CONVERT(VARCHAR(12),PickupDate,110) <= CONVERT(VARCHAR(12),' " + () + "',110) " ;23 }
24 strSql += strWhere + " ORDER BY AppointID ASC " ;25
26 DataSet _result = new DataSet();27 taSet(strSql,_result, " tb_AUGReport " );
28
29 // For same appointment, if container no is same, then use average value. (FCL)
30 if ( ().ToUpper() == () )31 {32 string strSqlFCL = " SELECT APPOINTID,CONTAINERNO,COUNT(CONTAINERNO) AS COUNTNUM FROMvSelShipModeAUGReporting WHERE 1 = 1 " ;33 strSqlFCL += strWhere + " GROUP BY APPOINTID,CONTAINERNO " ;34
35 ble dtCalculateSumContainerNO = new DataTable();36 dtCalculateSumContainerNO = ectData(strSqlFCL).Tables[ 0 ].Copy();37 ame = " dtCalculateSumContainerNO " ;
38 _(dtCalculateSumContainerNO);39 }40 // calculate trucking fee by LCL OR FCL
41 ble dtCalculateSumTruckFee = new DataTable();42 DateTime dtReceiveFrom = DateIfEmpty(strPickupFrom);43 DateTime dtReceiveTo = DateIfEmpty(strPickupTo);44 SqlParameter[] objParameters = {45 new SqlParameter( " @StartDate " ,ateTime),46 new SqlParameter( " @EndDate " ,ateTime),47 new SqlParameter( " @ShippingMode " ,r, 5 )48 };49 50 if (dtReceiveFrom != ue )51 objParameters[ 0 ].Value = dtReceiveFrom;52 if (dtReceiveTo != ue )53 objParameters[ 1 ].Value = dtReceiveTo;54 objParameters[ 2 ].Value = ();
55 dtCalculateSumTruckFee = rodure( " CCC_P_SelShipModeAUGReporting " ,objParameters, "tb_CalculateSumTruckFee " ).Tables[ 0 ].Copy();56
57 ble dtCalculateSumCONSOTruckFee = new DataTable();58
59 if ( ().ToUpper() == () )60 {61 // calculate trucking fee by CONSO
62 SqlParameter[] objParameters2 = {63 new SqlParameter( " @StartDate " ,ateTime),64 new SqlParameter( " @EndDate " ,ateTime),65 new SqlParameter( " @ShippingMode " ,r, 5 )66 };67 if (dtReceiveFrom != ue )68 objParameters2[ 0 ].Value = dtReceiveFrom;69 if (dtReceiveTo != ue )70 objParameters2[ 1 ].Value = dtReceiveTo;71 objParameters2[ 2 ].Value = ();
72 dtCalculateSumCONSOTruckFee = rodure( " CCC_P_SelShipModeAUGReporting " ,objParameters2, "tb_CalculateSumCONSOTruckFee " ).Tables[ 0 ];73 }74
75 if ( > 0 )76 {77 foreach ( DataRow dr in )78 {79 (ray);80 }81 }82
83 _(dtCalculateSumTruckFee);
84
85 // _result = ectData(strSql);
86 return _result;
2023年6月21日发(作者：)
Datable添加到Dataset并且重新命名 View Code1 string strSql = " SELECT * from vSelShipModeAUGReporting Where 1 = 1 " ;2 string strWhere = string .Empty;3
4 if ( > 0 )5 {6 if ( ().ToUpper() == ())7 {8 strWhere += " AND RTRIM([ShipMode]) = " + " ' " + ().ToUpper() + " ' " ;9 }10 else
11 {12 strWhere += " AND ISNULL(IsNew, 0) = 0 " ;13 strWhere += " AND RTRIM([ShipMode]) <> " + " ' " + () + " ' " ;14 }15 }16 if (().Length > 0 )17 {18 strWhere += " AND CONVERT(VARCHAR(12),PickupDate,110) >= CONVERT(VARCHAR(12),' " + ()+ " ',110) " ;19 }20 if (().Length > 0 )21 {22 strWhere += " AND CONVERT(VARCHAR(12),PickupDate,110) <= CONVERT(VARCHAR(12),' " + () + "',110) " ;23 }
24 strSql += strWhere + " ORDER BY AppointID ASC " ;25
26 DataSet _result = new DataSet();27 taSet(strSql,_result, " tb_AUGReport " );
28
29 // For same appointment, if container no is same, then use average value. (FCL)
30 if ( ().ToUpper() == () )31 {32 string strSqlFCL = " SELECT APPOINTID,CONTAINERNO,COUNT(CONTAINERNO) AS COUNTNUM FROMvSelShipModeAUGReporting WHERE 1 = 1 " ;33 strSqlFCL += strWhere + " GROUP BY APPOINTID,CONTAINERNO " ;34
35 ble dtCalculateSumContainerNO = new DataTable();36 dtCalculateSumContainerNO = ectData(strSqlFCL).Tables[ 0 ].Copy();37 ame = " dtCalculateSumContainerNO " ;
38 _(dtCalculateSumContainerNO);39 }40 // calculate trucking fee by LCL OR FCL
41 ble dtCalculateSumTruckFee = new DataTable();42 DateTime dtReceiveFrom = DateIfEmpty(strPickupFrom);43 DateTime dtReceiveTo = DateIfEmpty(strPickupTo);44 SqlParameter[] objParameters = {45 new SqlParameter( " @StartDate " ,ateTime),46 new SqlParameter( " @EndDate " ,ateTime),47 new SqlParameter( " @ShippingMode " ,r, 5 )48 };49 50 if (dtReceiveFrom != ue )51 objParameters[ 0 ].Value = dtReceiveFrom;52 if (dtReceiveTo != ue )53 objParameters[ 1 ].Value = dtReceiveTo;54 objParameters[ 2 ].Value = ();
55 dtCalculateSumTruckFee = rodure( " CCC_P_SelShipModeAUGReporting " ,objParameters, "tb_CalculateSumTruckFee " ).Tables[ 0 ].Copy();56
57 ble dtCalculateSumCONSOTruckFee = new DataTable();58
59 if ( ().ToUpper() == () )60 {61 // calculate trucking fee by CONSO
62 SqlParameter[] objParameters2 = {63 new SqlParameter( " @StartDate " ,ateTime),64 new SqlParameter( " @EndDate " ,ateTime),65 new SqlParameter( " @ShippingMode " ,r, 5 )66 };67 if (dtReceiveFrom != ue )68 objParameters2[ 0 ].Value = dtReceiveFrom;69 if (dtReceiveTo != ue )70 objParameters2[ 1 ].Value = dtReceiveTo;71 objParameters2[ 2 ].Value = ();
72 dtCalculateSumCONSOTruckFee = rodure( " CCC_P_SelShipModeAUGReporting " ,objParameters2, "tb_CalculateSumCONSOTruckFee " ).Tables[ 0 ];73 }74
75 if ( > 0 )76 {77 foreach ( DataRow dr in )78 {79 (ray);80 }81 }82
83 _(dtCalculateSumTruckFee);
84
85 // _result = ectData(strSql);
86 return _result;
发布评论