//循环查询的结果
        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;
          }
        }

posted on 2013-02-26 15:46  我的地盘,我做主  阅读(279)  评论(0编辑  收藏  举报