arjmand67
پنج شنبه 24 اردیبهشت 1394, 16:35 عصر
سلام دوستان من می خوام این کوئری را به linq تبدیل کنم میشه کمکم کنید
SELECT Top 1 @Value = tblUserTopsisPercent.PercentEvaluation
FROM tblUserTopsisPercent INNER JOIN
tblGroupMembers ON tblUserTopsisPercent.TopsisID = tblGroupMembers.TopsisID AND tblUserTopsisPercent.UserID = tblGroupMembers.UserID INNER JOIN
tblTemplate INNER JOIN
tblDefinition ON tblTemplate.TemplateID = tblDefinition.TemplateID ON tblUserTopsisPercent.TopsisID = tblDefinition.TopsisID AND
tblGroupMembers.TopsisID = tblDefinition.TopsisID AND tblGroupMembers.CustomerID = tblDefinition.CustomerID INNER JOIN
tblMembers ON tblGroupMembers.CustomerID = tblMembers.CustomerID AND tblGroupMembers.UserID = tblMembers.UserID
WHERE (tblDefinition.TermGrant = @Term) AND (tblTemplate.tType = @tType) AND (tblUserTopsisPercent.TermPeriodID = - 1) AND
(tblMembers.GroupID = @GroupID) AND (tblDefinition.TopsisType = @Level) AND (tblUserTopsisPercent.PercentEvaluation IS NOT NULL)
SELECT Top 1 @Value = tblUserTopsisPercent.PercentEvaluation
FROM tblUserTopsisPercent INNER JOIN
tblGroupMembers ON tblUserTopsisPercent.TopsisID = tblGroupMembers.TopsisID AND tblUserTopsisPercent.UserID = tblGroupMembers.UserID INNER JOIN
tblTemplate INNER JOIN
tblDefinition ON tblTemplate.TemplateID = tblDefinition.TemplateID ON tblUserTopsisPercent.TopsisID = tblDefinition.TopsisID AND
tblGroupMembers.TopsisID = tblDefinition.TopsisID AND tblGroupMembers.CustomerID = tblDefinition.CustomerID INNER JOIN
tblMembers ON tblGroupMembers.CustomerID = tblMembers.CustomerID AND tblGroupMembers.UserID = tblMembers.UserID
WHERE (tblDefinition.TermGrant = @Term) AND (tblTemplate.tType = @tType) AND (tblUserTopsisPercent.TermPeriodID = - 1) AND
(tblMembers.GroupID = @GroupID) AND (tblDefinition.TopsisType = @Level) AND (tblUserTopsisPercent.PercentEvaluation IS NOT NULL)