判断两个集合包含关系

    //是否开发票
    public string getInvoice(string SaleID, string ClientID, string TeamID, string LatencyClientID)
    {
        string Rtn = "";
        string signLists = getSignNum(SaleID, ClientID, TeamID, LatencyClientID);
        if (signLists != "")
        {
            string sql1 = "select * from invoicetable where InvoiceState='1' and  invoiceno<>'0' and SignID in (" + signLists + ")";
            DataSet ds = SysCommon.DbSql.Query(sql1);
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                string[] arraySign = signLists.Split(',');
                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//小集合
                {
                  
                    if (sb.ToString() == "")
                    {
                        sb.Append(ds.Tables[0].Rows[i]["SignID"].ToString());
                    }
                    else
                    {
                        sb.Append(","+ds.Tables[0].Rows[i]["SignID"].ToString());
                    }
                }
                for (int j = 0; j < arraySign.Length; j++)//大集合
                {
                    if (sb.ToString().IndexOf(arraySign[j]) < 0)
                    {
                        Rtn = "部分开票";
                        break;
                    }
                    else
                    {
                        Rtn = "全部开票";
                    }
                }

            }
            else
            {
                Rtn = "未开";
            }
            ds.Dispose();
        }

        return Rtn;
    }