项目SQL语句备忘
以下是一些项目SQL语句,全用于备忘:
SELECT u.UserID, u.UserLoginName, u.UserDisplayName, u.UserPWD, u.DepartmentID,
d.DepartmentName, u.UserGroupID, g.UserGroupName
FROM UserInfo AS u INNER JOIN
UserGroupInfo AS g ON u.UserGroupID = g.UserGroupID
以下 SELECT语句来自DataAccess-->DAO-->ADOImpl-->IndicatorDAO.cs
SqlDataReader dr = GetDataReader(DataAccess.Properties.SqlResource.
SelectIndicatorAndGroupInfoWithAvailableDataType,tableNameStr);
一句
SELECT DISTINCT i.IndicatorID,
i.IndicatorCode, i.IndicatorCnName, i.IndicatorGroupID, g.IndicatorGroupName,
m.IndicatorDataTypeID, t.DataTypeDisplayName
FROM IndicatorDataTypes t CROSS JOIN
IndicatorGroup g CROSS JOIN
IndicatorBasicInfo i INNER JOIN
IndicatorMonthBase m ON i.IndicatorID = m.IndicatorID AND
g.IndicatorGroupID = i.IndicatorGroupID AND
t.IndicatorDataTypeID = m.IndicatorDataTypeID
ORDER BY i.IndicatorGroupID, i.IndicatorCode, m.IndicatorDataTypeID
以下 SELECT语句来自DataAccess-->DAO-->ADOImpl-->IndicatorDAO.cs
SqlDataReader dr = GetDataReader(DataAccess.Properties.SqlResource.SelectIndicatorByIDAndDataTypeID,
new string[] { indicator.IndicatorID.ToString(), indicator.IndicatorDataTypeID.ToString() });
一句
select i.IndicatorCode, i.IndicatorCnName, d.DataTypeDisplayName
from IndicatorBasicInfo i ,IndicatorDataTypes d
where IndicatorID={0} and indicatorDataTypeID ={1}