谢谢你帮我看下select a.Quantity,bb.colorTyp-Name,a.ship-date,c.sp-n

谢谢你帮我看下select a.Quantity,bb.colorTyp_Name,a.ship_date,c.sp_name,a.Remark,a.bcp_ydFinishTime,a.cy_ydFinishTime,b.PapType_Name from dbo.p_Order a left join PaperType b on a.pap_typeId=b.PapType_id left join dbo.tb_colorTyp bb on bb.colorTyp_id=a.colorTyp_id left join dbo.Commodity c on a.sp_id=c.sp_ID where a.orderNo in (44) 这样是对的public static DataSet webData(string orderNo) {string strSql = "select a.Quantity,bb.colorTyp_Name,a.ship_date,c.sp_name,a.Remark,a.bcp_ydFinishTime,a.cy_ydFinishTime,b.PapType_Name from dbo.p_Order a left join PaperType b on a.pap_typeId=b.PapType_id left join dbo.tb_colorTyp bb on bb.colorTyp_id=a.colorTyp_id left join dbo.Commodity c on a.sp_id=c.sp_ID where a.orderNo in (orderNo)";strSql = string.Format(strSql,orderNo);DataSet ds = DBHelper.ExcuteDataSet(strSql,CommandType.Text,null);return ds;}可是我这个 where 怎么写才是对的阿 in（0）也不对