34,576
社区成员
发帖
与我相关
我的任务
分享
StringBuilder sql = new StringBuilder();
sql.Append(" select t_people.peopleName as pName , ");
sql.Append(" t_people.peopleId as pId, ");
sql.Append(" t_people.dutyId as pdutyId, ");
sql.Append(" t_duty.dutyName as pdutyName, ");
sql.Append(" peopleWVB.peopleTel as pPhone, ");
sql.Append(" t_deptnew.deptname as deptnamea ");
sql.Append(" from t_people,peopleWVB,t_duty ,t_deptnew ");
sql.Append(" where peopleWVB.peopleId=t_people.peopleId ");
sql.Append(" and t_duty.dutyId=t_people.dutyId ");
sql.Append(" and t_deptnew.deptid=t_people.deptid ");
sql.Append(" and t_people.deptId in (@deptCodeInfo) ");
SqlParameter[] par
= {
new SqlParameter("deptCodeInfo",SqlDbType.VarChar,2000)
};
par[0].Value = value;
using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql.ToString(), par))
{
///
}
--第一段话 能查询出信息 从asp。net中发出的语句 转化成字符串是这样
select t_people.peopleName as pName ,
t_people.peopleId as pId,
t_people.dutyId as pdutyId,
t_duty.dutyName as pdutyName,
peopleWVB.peopleTel as pPhone,
t_deptnew.deptname as deptnamea
from t_people,peopleWVB,t_duty ,t_deptnew
where peopleWVB.peopleId=t_people.peopleId
and t_duty.dutyId=t_people.dutyId
and t_deptnew.deptid=t_people.deptid
and t_people.deptId in ('chujilingdao','')
--第二段话 查不到数据 从探查器看到的信息
exec sp_executesql N' select t_people.peopleName as pName ,
t_people.peopleId as pId, t_people.dutyId as pdutyId,
t_duty.dutyName as pdutyName, peopleWVB.peopleTel as pPhone,
t_deptnew.deptname as deptnamea
from t_people,peopleWVB,t_duty ,t_deptnew
where peopleWVB.peopleId=t_people.peopleId
and t_duty.dutyId=t_people.dutyId
and t_deptnew.deptid=t_people.deptid
and t_people.deptId in
(@deptCodeInfo) ',N'@deptCodeInfo varchar(2000)',@deptCodeInfo='''chujilingdao'','''''
exec sp_executesql N' select t_people.peopleName as pName ,
t_people.peopleId as pId, t_people.dutyId as pdutyId,
t_duty.dutyName as pdutyName, peopleWVB.peopleTel as pPhone,
t_deptnew.deptname as deptnamea
from t_people,peopleWVB,t_duty ,t_deptnew
where peopleWVB.peopleId=t_people.peopleId
and t_duty.dutyId=t_people.dutyId
and t_deptnew.deptid=t_people.deptid
and t_people.deptId in
(@deptCodeInfo, '') ',N'@deptCodeInfo varchar(2000)',@deptCodeInfo='chujilingdao'
exec sp_executesql N' select t_people.peopleName as pName ,
t_people.peopleId as pId, t_people.dutyId as pdutyId,
t_duty.dutyName as pdutyName, peopleWVB.peopleTel as pPhone,
t_deptnew.deptname as deptnamea
from t_people,peopleWVB,t_duty ,t_deptnew
where peopleWVB.peopleId=t_people.peopleId
and t_duty.dutyId=t_people.dutyId
and t_deptnew.deptid=t_people.deptid
and t_people.deptId in
(''chujilingdao'',''gongweihanrenda'','''')'
sql.Append(" select t_people.peopleName as pName , ");
sql.Append(" t_people.peopleId as pId, ");
sql.Append(" t_people.dutyId as pdutyId, ");
sql.Append(" t_duty.dutyName as pdutyName, ");
sql.Append(" peopleWVB.peopleTel as pPhone, ");
sql.Append(" t_deptnew.deptname as deptnamea ");
sql.Append(" from t_people,peopleWVB,t_duty ,t_deptnew ");
sql.Append(" where peopleWVB.peopleId=t_people.peopleId ");
sql.Append(" and t_duty.dutyId=t_people.dutyId ");
sql.Append(" and t_deptnew.deptid=t_people.deptid ");
sql.Append(" and t_people.deptId in (@deptCodeInfo,'') ");
SqlParameter[] par
= {
new SqlParameter("deptCodeInfo",SqlDbType.VarChar,2000)
};
par[0].Value = value;
using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql.ToString(), par))