//循环查询的结果
foreach (DataRow row in oDataTableGuidePrice.Rows)
{
//将结果按,风格成数组
IList<string> olist = row["A"].ToString().ToUpper().Split(',').ToList<string>();
flag = true;
//判断是否有重复值
foreach (string str1 in args)
if (!olist.Contains(str1.ToUpper()))
{
flag = false;
break;
}
if (flag)
{
object objVal = GGlobal.G.ConnectionManager.GetSingleValueWithParams("SELECT Price FROM CRMGuidePrice WHERE DELETED=0 AND SID=@SID AND Priced=1 ", new SqlParameter("@SID", row["CRMGuidePriceSID"]));
if (objVal != DBNull.Value)
{
priceInfo.priced = true;
priceInfo.IsGuidePrice = true;
priceInfo.price = decimal.Parse(objVal.ToString());
}
break;
}
}