sql_sysquery
合同履约信息
../../Admin/Images/LabelIco/GetPicArticle.gif
SELECT TOP 1 CM.*, UT.*, UP.ProjectName FROM PE_PPI_CommonModel CM INNER JOIN PE_PPI_U_Contract UT ON (CM.ItemID = UT.ID AND CM.TableName='PE_PPI_U_Contract') INNER JOIN PE_PPI_U_Project UP ON (UT.ProjectNum = UP.ProjectNum) WHERE CM.GeneralID = @itemId AND CM.Status=1
<script language="JavaScript" type="text/JavaScript" src="Common/GetHits.aspx?id="></script>
<script language="JavaScript" type="text/JavaScript" src="
Common/GetHits.aspx?hitstype=1&id=
"></script>
<script language="JavaScript" type="text/JavaScript" src="
Common/GetHits.aspx?hitstype=2&id=
"></script>
<script language="JavaScript" type="text/JavaScript" src="
Common/GetHits.aspx?hitstype=3&id=
"></script>
]]>
itemId
1
公开信息ID
0