انجمن برنامه نویسان ایرانی

$queryInsert = "insert into SelOrderItems1 (id, OrderId ,RowIndex,stuffid,Value,ConfirmValue,GetValue,UnitId,ConvertRate,PriceId,UnitPrice, CurrencyId,CurrencyRate ,StorageId,DeliveryDate,IsFinish,des,CreatorUName,GetValueInProduct,ItemType,Price, NetPrice,VATBase,DbAccElaborative1ID,DbAccCodingID,cracccodingid ) values "; for ($x = 1; $x <= count(@=gridVar001); $x++) { $IDitem=executeQuery("select case when Max(ID) IS NULL then 1 else Max(Id)+1 end as MAXID from [Faradaneh].dbo.SelOrderItems1",$db); $IDitem1=$IDitem[1][MAXID]+$x-1; $stuffid= @=gridVar001[$x]['stuffid']; $unitid= @=gridVar001[$x]['unitid']; $Value= @=gridVar001[$x]['Value']; $priceID= @=gridVar001[$x]['priceID']; $Ddate= @=gridVar001[$x]['Ddate']; $Des= @=gridVar001[$x]['Des']; $text0000000002= @=gridVar001[$x]['text0000000002']; $text0000000001= @=gridVar001[$x][text0000000001]; $ConvertRate= @=gridVar001[$x][ConvertRate]; $StorageId=executeQuery("select StorageId from [Faradaneh].dbo.InvStuff_InvStorage where DefaultStorageInSelOrder=1 and StuffId=$stuffid",$db); $StorageId1=$StorageId[1][StorageId]; //// $Stuffacc=executeQuery("exec SelItemsAccountInfo_SELECT @StorageId=$StorageId1,@IsStuff=1,@ItemID=$stuffid",$db); $Stuffacc1=$Stuffacc[1][AccCodingId]; //// $query3 ="( $IDitem1, $MaxID1 ,$x, $stuffid, $Value, $Value, 0.000000, $unitid, $ConvertRate, $priceID, $text0000000002, 1, 1.000000000, $StorageId1, isnull([Faradaneh].[dbo].ShamsiToMiladi(BPMS.dbo.PersaintoEnglishNumber(N'$Ddate')),''), 0, '$Des', '$username', 0.000000, 1, $text0000000001, $text0000000001, 1, isnull($customer,NULL), isnull($acccoding1,NULL), isnull($Stuffacc1,Null) )"; if ($x!=count(@=gridVar001)){ $query3 = $query3.","; } $queryInsert=$queryInsert.$query3; //$result1=executeQuery($query3, $db); } $result1=sqlsrv_query( $conn, $queryInsert);

این کدهم مربوط به insert هست و جواب داده