public DataSet GetTJYYList(string strLXRXM,string strKHMC)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT KHGL_TJYY.YYBH,KHMC,LXRXM");
strSql.Append(",(SELECT XMMC FROM XTGL_SJZDMX WHERE FLBH='S501-02' AND XMBH=KHXZ) AS KHXZ_Name");
strSql.Append(" FROM KHGL_TJYY");
strSql.Append(" INNER JOIN KHGL_KHXX ON KHGL_TJYY.KHBH=KHGL_KHXX.KHBH");
strSql.Append(" WHERE 1=1");
List<SqlParameter> paramList = new List<SqlParameter>();
if (strLXRXM != string.Empty)
{
strSql.Append(" AND LXRXM=@LXRXM");
paramList.Add(new SqlParameter("@LXRXM", strLXRXM));
}
if (strKHMC != string.Empty)
{
strSql.Append(" AND KHMC=@KHMC");
paramList.Add(new SqlParameter("@KHMC", strKHMC));
} SqlParameter[] sqlParams = paramList.ToArray();
return DbHelperSQL.Query(strSql.ToString(),sqlParams);
}去掉strLXRXM,strKHMC的空格,放在数据层,逻辑层,还是表示层好
strLXRXM.Trim(),strKHMC.Trim()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT KHGL_TJYY.YYBH,KHMC,LXRXM");
strSql.Append(",(SELECT XMMC FROM XTGL_SJZDMX WHERE FLBH='S501-02' AND XMBH=KHXZ) AS KHXZ_Name");
strSql.Append(" FROM KHGL_TJYY");
strSql.Append(" INNER JOIN KHGL_KHXX ON KHGL_TJYY.KHBH=KHGL_KHXX.KHBH");
strSql.Append(" WHERE 1=1");
List<SqlParameter> paramList = new List<SqlParameter>();
if (strLXRXM != string.Empty)
{
strSql.Append(" AND LXRXM=@LXRXM");
paramList.Add(new SqlParameter("@LXRXM", strLXRXM));
}
if (strKHMC != string.Empty)
{
strSql.Append(" AND KHMC=@KHMC");
paramList.Add(new SqlParameter("@KHMC", strKHMC));
} SqlParameter[] sqlParams = paramList.ToArray();
return DbHelperSQL.Query(strSql.ToString(),sqlParams);
}去掉strLXRXM,strKHMC的空格,放在数据层,逻辑层,还是表示层好
strLXRXM.Trim(),strKHMC.Trim()
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货