一张表如何关联另一张表中的两条数据!出现错误!代码和表如下!在线等

   public DataTable GetScrapTirePage(StringBuilder SqlWhere, IList<SqlParam> IList_param, int pageIndex, int pageSize, ref int count)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Base_ScrapTire.*,Organization_Name,ModifyUserName ,CreateUserName");
            strSql.Append(" from Base_ScrapTire  ");
            strSql.Append(" left join Base_Organization on Base_ScrapTire.Organization_ID=Base_Organization.Organization_ID ");
            strSql.Append("left join Base_UserInfo on Base_ScrapTire.ModifyUserId=Base_UserInfo.ModifyUserId ");
          strSql.Append("left join Base_UserInfo on Base_ScrapTire.CreateUserId=Base_UserInfo.CreateUserId ");

            strSql.Append("where Base_ScrapTire.Deletemark=1");

            strSql.Append(SqlWhere);
            return DataFactory.SqlDataBase().GetPageList(strSql.ToString(), IList_param.ToArray(), "Scrap_Number", "asc", pageIndex, pageSize, ref count);
        }

图片说明
图片说明

查看全部
x781711884
x781711884
2016/03/17 03:33
  • 数据
  • 点赞
  • 收藏
  • 回答
    私信
满意答案
查看全部

1个回复