字串处理

private bool CheckSameData(string str)
        {
            for (int i = 0; i < dgGoodsUpDownType.Rows.Count; i++)
            {
                if (str == dgGoodsUpDownType["TypeName",i].FormattedValue.ToString())
                {
                    return true;
                }
            }
            return false;
        }

 

 

#region 查询人员菜单权限FindPersonalPopedom
  /// <summary>
  /// 查询人员菜单
  /// </summary>
  /// <param name="iMenuID"></param>
  /// <param name="iPersonalID"></param>
  /// <returns></returns>
  public DataTable FindPersonalPopedom(int iMenuID,int iPersonalID)
  {
   //查询人员角色中的菜单
   string sSql="";
   WindICFrameNet.Data.DataHelper dataHelper=new WindICFrameNet.Data.DataHelper("TravelLine");
   
   DataTable dtMenuPopedom=new DataTable();
   dtMenuPopedom.Columns.Add("PopedomID",Type.GetType("System.String"));
   dtMenuPopedom.Columns.Add("PopedomName",Type.GetType("System.String"));
   dtMenuPopedom.Columns.Add("ExtendList",Type.GetType("System.String"));
   dtMenuPopedom.Columns.Add("MenuID",Type.GetType("System.String"));

   //查询人员角色列表
   //   sSql+="select * from TL_Popedom_RolesIndex where RoleID in (/r/n";
   //   sSql+="select RoleID from TL_Popedom_MembersIndex where MembersID="+iPersonalID.ToString()+") and MenuID="+iMenuID.ToString()+"/r/n";
   sSql+="declare @RoleList varchar(200)/r/n";
   sSql+="select @RoleList=RoleID from TL_Popedom_MembersIndex where MembersID="+iPersonalID.ToString()+"/r/n";//获取用户角色
   sSql+="if @RoleList is null or @RoleList=''/r/n";
   sSql+="begin/r/n";
   sSql+="select @RoleList='0'/r/n";
   sSql+="end/r/n";
   sSql+="declare @Sql  varchar(1000)/r/n";
   sSql+="select @Sql='select * from TL_Popedom_RolesIndex where RoleID in ('+@RoleList+') and MenuID="+iMenuID.ToString()+"'/r/n";//角色的菜单权限
   sSql+="exec(@Sql)/r/n";
   DataTable dtRole=dataHelper.ExecuteDataSet(sSql).Tables[0];
   //用户的角色组
   string sRoleList="";
   foreach(DataRow dr in dtRole.Rows)
   {
    sRoleList+=dr["RoleID"].ToString()+",";
   }
   if(sRoleList!="")
   {
    sRoleList=sRoleList.Substring(0,sRoleList.Length-1);
   }
   else
   {
    sRoleList="0";
   }
   //合并所有角色的权限
   string sRolePopedom="";
   foreach(DataRow dr in dtRole.Rows)
   {
    if(sRolePopedom=="")
    {
     sRolePopedom=","+dr["PopedomIDList"].ToString()+",";
    }
    else
    {
     string [] strList=dr["PopedomIDList"].ToString().Split(',');
     foreach(string str in strList)
     {
      if(str!="")
      {
       if(sRolePopedom.IndexOf(","+str+",")<0)
       {
        sRolePopedom+=str+",";
       }
      }
     }

    }
   }
   if(sRolePopedom!="")
   {
    sRolePopedom=sRolePopedom.Substring(0,sRolePopedom.Length-1);
    sRolePopedom=sRolePopedom.Substring(1,sRolePopedom.Length-1);
   }
   else
   {
    sRolePopedom="0";
   }

   //查询扩展权限
   DataTable dtmenuExtendPopedom=FindRolePopedomExtend(sRoleList,sRolePopedom);
   //合并扩展权限
   string [] strPopedomList=sRolePopedom.Split(',');
   foreach(string str in strPopedomList)
   {
    if(str!="")
    {
     string sExtendPopedom="";
     foreach(DataRow dr in dtmenuExtendPopedom.Rows)
     {
      if(dr["PopedomID"].ToString()==str)
      {
       if(sExtendPopedom=="")
       {
        sExtendPopedom=","+dr["ExtendPopedomIDList"].ToString()+",";
       }
       else
       {
        string [] strList=dr["ExtendPopedomIDList"].ToString().Split(',');
        foreach(string strr in strList)
        {
         if(str!="")
         {
          if(sExtendPopedom.IndexOf(","+strr+",")<0)
          {
           sExtendPopedom+=strr+",";
          }
         }
        }
       }
      }
     }
     //记录合并后数据
     DataRow drPo=dtMenuPopedom.NewRow();
     drPo["PopedomID"]=str;
     drPo["PopedomName"]="";
     drPo["ExtendList"]=sExtendPopedom;
     drPo["MenuID"]=iMenuID.ToString();
     dtMenuPopedom.Rows.Add(drPo);
    }
   }
   //查询人员菜单
   sSql="select * from TL_Popedom_MembersExtend where MembersID="+iPersonalID.ToString()+" and MenuID="+iMenuID.ToString()+"";
   DataTable dtPersonalPopedom=dataHelper.ExecuteDataSet(sSql).Tables[0];
   string sPersonalPopedomList="";
   if(dtPersonalPopedom.Rows.Count>0)
   {
    string sPopedomList=dtPersonalPopedom.Rows[0]["PopedomIDList"].ToString();
    string[] strList=sPopedomList.Split(',');
    foreach(string str in strList)
    {
     if(str!="")
     {
      DataRow subDr=null;
      if(str.IndexOf("-")>-1)
      {
       foreach(DataRow dr in dtMenuPopedom.Rows)
       {
        if(dr["PopedomID"].ToString()==str.Replace("-",""))
        {
         subDr=dr;
         break;
        }
       }
       if(subDr!=null)
       {
        dtMenuPopedom.Rows.Remove(subDr);
       }
      }
      else
      {
       DataRow drPo=dtMenuPopedom.NewRow();
       drPo["PopedomID"]=str;
       drPo["PopedomName"]="";
       drPo["ExtendList"]="";
       drPo["MenuID"]=iMenuID.ToString();
       dtMenuPopedom.Rows.Add(drPo);
       sPersonalPopedomList+=str+",";                      //记录要查询的真正权限
      }
     }
    }
    //查询人员的扩展权限
    DataTable personlExtendPopedom=FindPersonalPopedomExtend(iPersonalID,sPersonalPopedomList+0);
    //合并人员角色权限
    string [] strPersonalList=sPersonalPopedomList.Split(',');
    foreach(string str in strPersonalList)
    {
     if(str!="")
     {
      //查询人员当前权限的扩展权限
      DataRow[] drcurrently=personlExtendPopedom.Select("PopedomID='"+str+"'");
      //查询当前权限是否在角色中存在
      DataRow[] drRoleCurrently=dtMenuPopedom.Select("PopedomID='"+str+"'");
      if(drRoleCurrently.Length<=0 && drcurrently.Length>0)
      {
       //不存在
       DataRow drPo=dtMenuPopedom.NewRow();
       drPo["PopedomID"]=str;
       drPo["PopedomName"]="";
       if(drcurrently.Length>0)
       {
        drPo["ExtendList"]=","+drcurrently[0]["MemberPopedomList"].ToString();
       }
       else
       {
        drPo["ExtendList"]="";
       }
       drPo["MenuID"]=iMenuID.ToString();
       dtMenuPopedom.Rows.Add(drPo);
      }
      else
      {
       //存在
       if(drcurrently.Length>0 && drRoleCurrently.Length>0)
       {
        string sOldExtendPopedom=drRoleCurrently[0]["ExtendList"].ToString();
        string sExtendPopedom=drcurrently[0]["MemberPopedomList"].ToString();
        string[] sExtendList=sExtendPopedom.Split(',');
        foreach(string strr in sExtendList)
        {
         if(str!="")
         {
          sOldExtendPopedom=this.ReplaceString(sOldExtendPopedom,strr);
         }
        }
        drRoleCurrently[0]["ExtendList"]=sOldExtendPopedom;
       }
      }
     }
    }
   }
   
   return dtMenuPopedom;
  }
  #endregion 查询人员菜单权限FindPersonalPopedom