作业帮谢谢你帮我看下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.colorT
来源：学生作业帮助网 编辑：作业帮 时间：2024/05/07 12:07:19
谢谢你帮我看下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.colorT
谢谢你帮我看下
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）也不对
谢谢你帮我看下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.colorT
你用过在执行程序的时候进行调试,然后把strSql 中的字符提取出来在数据库中执行
也有可能是orderNo没有传递过来正确的值