//是否开发票
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;
}