public DataSet GetSQLdataByApplyId(string strUserId, string strApplyNO)
{
string strSQL2 = "SELECT CONVERT(nvarchar, OverTimeHead.CreateDateTime, 111) AS CreateDateTime_short, OverTimeHead.OverTimeHeadId, OverTimeHead.UserId, aspnet_Users.UserName, OverTimeStatus.StatusName, OverTimeHead.ApplyNo, OverTimeHead.OrgName, OverTimeHead.OverTimeStatusId FROM OverTimeHead LEFT OUTER JOIN OverTimeStatus ON OverTimeHead.OverTimeStatusId = OverTimeStatus.OverTimeStatusId LEFT OUTER JOIN aspnet_Users ON OverTimeHead.UserId = aspnet_Users.UserId" +
"WHERE (OverTimeHead.ApplyNo LIKE '%{1}%') AND (OverTimeHead.UserId = '" + strUserId + "') ";//显示和自己部门相关的便可 strSQL2 = string.Format(strSQL2, strUserId.ToString(), strApplyNO); return new CommonData().ExeQuery(strSQL2);
}
{
string strSQL2 = "SELECT CONVERT(nvarchar, OverTimeHead.CreateDateTime, 111) AS CreateDateTime_short, OverTimeHead.OverTimeHeadId, OverTimeHead.UserId, aspnet_Users.UserName, OverTimeStatus.StatusName, OverTimeHead.ApplyNo, OverTimeHead.OrgName, OverTimeHead.OverTimeStatusId FROM OverTimeHead LEFT OUTER JOIN OverTimeStatus ON OverTimeHead.OverTimeStatusId = OverTimeStatus.OverTimeStatusId LEFT OUTER JOIN aspnet_Users ON OverTimeHead.UserId = aspnet_Users.UserId" +
"WHERE (OverTimeHead.ApplyNo LIKE '%{1}%') AND (OverTimeHead.UserId = '" + strUserId + "') ";//显示和自己部门相关的便可 strSQL2 = string.Format(strSQL2, strUserId.ToString(), strApplyNO); return new CommonData().ExeQuery(strSQL2);
}
"WHERE (OverTimeHead.ApplyNo LIKE '%{1}%') AND (OverTimeHead.UserId = '" + strUserId + "') ";这个字符串会被连接成....aspnet_Users.UserIdWHERE (OverTimeHead.ApplyNo LIKE '%{1}%')...
UserId 和 WHERE 之间要有空格。