url处理类(备注)

        public string url_str_return() {
            string httpname = "";
            string http_host = System.Web.HttpContext.Current.Request.ServerVariables["Http_Host"];
            string[] urlstrr = http_host.Split('/');
            string[] strarr = urlstrr[0].Split('.');
            if (strarr[0].ToString() != "www") {
                for (int i = 0; i < strarr.Length; i++) {
                    httpname += strarr[i].ToString() + ".";
                }
                httpname = httpname.Substring(0, httpname.Length - 1);
            }
            else {
                for (int i = 1; i < strarr.Length; i++) {
                    httpname += strarr[i].ToString() + ".";
                }
                httpname = httpname.Substring(0, httpname.Length - 1);
            }
            int intcompanyid = mysqlstr.intT_Companyid(httpname.ToString());
            string[] httpname_ = httpname.Split('.');
            if (intcompanyid == 0) {
                httpname = "";
                for (int i = 1; i < httpname_.Length; i++) {
                    httpname += httpname_[i].ToString();
                }
            }
            return httpname;
        }

        public int intT_Companyid(string F_Domain) {
            return Re("select * from T_Companyid where F_Domain = '" + F_Domain + "'");
        }

        public static int Re(string Sql_Str) {
            int i_ = 0;
            SqlCommand mycom = new SqlCommand();
            SqlConnection mycon = new SqlConnection(connectionString);
            mycom.Connection = mycon;
            mycon.Open();
            Sql_Str = xiugaiSqlStr(Sql_Str);
            mycom.CommandText = Sql_Str;
            SqlDataReader myDr = mycom.ExecuteReader();
            while (myDr.Read()) {
                i_++;
            }
            mycon.Close();
            return i_;
        }

        public static string xiugaiSqlStr(string sqlstr) {
            denglu mydenglu = new denglu();
            if (!sqlstr.Contains("T_Companyid") && !sqlstr.Contains("T_City") && !sqlstr.Contains("T_Provincial") && !sqlstr.Contains("T_TreeView")) {
                if ((sqlstr.Contains("where") || sqlstr.Contains("Where") || sqlstr.Contains("WHERE")) && !sqlstr.Contains("insert")) {
                    if (sqlstr.Contains(" order")) {
                        int i = sqlstr.IndexOf(" order");
                        string str1 = "";
                        string str2 = " and F_Companyid = " + mydenglu.commderid() + " ";
                        string str3 = "";
                        for (int i_ = 0; i_ < i; i_++) {
                            str1 += sqlstr[i_].ToString();
                        }
                        for (int i_ = i; i_ < sqlstr.Length; i_++) {
                            str3 += sqlstr[i_].ToString();
                        }
                        sqlstr = str1 + str2 + str3;
                    }
                    else {
                        sqlstr += " and F_Companyid = " + mydenglu.commderid() + " ";
                    }
                }
                else {
                    if (sqlstr.Contains(" order")) {
                        int i = sqlstr.IndexOf(" order");
                        string str1 = "";
                        string str2 = " where F_Companyid = " + mydenglu.commderid() + " ";
                        string str3 = "";
                        for (int i_ = 0; i_ < i; i_++) {
                            str1 += sqlstr[i_].ToString();
                        }
                        for (int i_ = i; i_ < sqlstr.Length; i_++) {
                            str3 += sqlstr[i_].ToString();
                        }
                        sqlstr = str1 + str2 + str3;
                    }
                    else {
                        if (!sqlstr.Contains("insert")) {
                            sqlstr += " where F_Companyid = " + mydenglu.commderid() + " ";
                        }
                    }
                }
                if (sqlstr.Contains("insert")) {
                    string[] sqlstr1 = sqlstr.Split(')');
                    sqlstr = "";
                    sqlstr = sqlstr1[0].ToString() + ",F_Companyid)";
                    for (int i = 1; i < sqlstr1.Length; i++) {
                        if (i == sqlstr1.Length - 2) {
                            sqlstr += sqlstr1[i].ToString() + ",1)";
                        }
                        else {
                            sqlstr += sqlstr1[i].ToString() + ")";
                        }
                    }
                    sqlstr = sqlstr.Substring(0, sqlstr.Length - 1);
                }
            }//order
            return sqlstr;
        }

数据库