1){ $orderbydesc=""; $descTXT="↓"; }else{ $orderbydesc=" desc"; $descTXT="↑"; } If ($orderby=="") { $orderby="OA_DepartmentID,OA_User_ID"; $descTXT="↓"; } //查询开始 $SqlOrdDateType=empty($SqlOrdDateType)!=false ? "" : $SqlOrdDateType; $sql="select strItmID,strItmName,sumUseSituation=SUM(EquipmentUseSituation),sumPurchasePrice=SUM(EquipmentUseSituation*EquipmentPurchasePrice) from DispatchOrd_Equipment2,tblStItm,DispatchOrd where DispatchOrdID=DispatchOrdIDDt and strItmID=strItmIDPK and DispatchOrdClass in ('".$OrdClassListSql."') and EquipmentTime ".$SqlOrdDateType." GROUP BY strItmID,strItmName order by strItmName"; $data = sqlsrv_query($conn,$sql); if($data == true){ $FormArray=array(); //表头 $FormArray[0]=array("物品名称","使用数量","成本汇总"); $FormArrayX=count($FormArray[0]); if (sqlsrv_rows_affected($data)==0) { $SystemMessageType=2; $SystemMessageTXT="数据库中相关无数据!"; $y=0; } else { $i=1; while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { //读取数据 $strItmID = $rs['strItmID']; $strItmName = $rs['strItmName']; $sumUseSituation= $rs['sumUseSituation']; $sumPurchasePrice= $rs['sumPurchasePrice']; //读取数据--End //写入数组 if ($sumUseSituation>0) { $FormArray[$i][0]=$strItmName; $FormArray[$i][1]=$sumUseSituation; $FormArray[$i][2]=round($sumPurchasePrice,2);; $i++; } //写入数组--End } } } //echo print_r($FormArray); //exit; ?>