frindlink.cs

最好用的站点内容管理系统 全部源代码都有

        }
        public int _DelPClass2(string boxs)
        {
            string Str_Fri_child_Sql = "Delete From " + Pre + "friend_class where ParentID in('" + boxs + "') and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_Fri_child_Sql, null);
        }
        public int _DelAllClass()
        {
            string Str_Fri_Sql = "Delete From " + Pre + "friend_class where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_Fri_Sql, null);
        }
        public int _LockP_Link(string boxs)
        {
            string F_Link_Sql = "Update " + Pre + "friend_link  Set Lock=1 where id in(" + boxs + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, F_Link_Sql, null);
        }
        public int _unLockP_Link(string boxs)
        {
            string F_Link_Sql = "Update " + Pre + "friend_link  Set Lock=0 where id in(" + boxs + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, F_Link_Sql, null);
        }
        public int _delP_Link(string boxs)
        {
            string F_Link_Sql = "Delete From " + Pre + "friend_link  where id in(" + boxs + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, F_Link_Sql, null);
        }
        public int _delAll_Link()
        {
            string Str_Fri_Sql = "Delete From " + Pre + "friend_link where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_Fri_Sql, null);
        }
        public int ExistName_Link(string Str_Name)
        {
            SqlParameter param = new SqlParameter("@Name", Str_Name);
            string Str_CheckSql = "Select count(Name) From " + Pre + "friend_link Where Name=@Name and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Str_CheckSql, param);
        }
        public int _LinkSave(string Str_Class, string Str_Name, string Str_Type, string Str_Url, string Str_Content, string Str_PicUrl, string Str_Author, string Str_Mail, string Str_ContentFor, string Str_LinkContent, string Str_Addtime, int Isuser, int isLok)
        {

            SqlParameter[] param = new SqlParameter[13];
            param[0] = new SqlParameter("@Str_Class", SqlDbType.NVarChar, 12);
            param[0].Value = Str_Class;
            param[1] = new SqlParameter("@Str_Name", SqlDbType.NVarChar, 50);
            param[1].Value = Str_Name;
            param[2] = new SqlParameter("@Str_Type", SqlDbType.Int, 1);
            param[2].Value = Convert.ToInt32(Str_Type);
            param[3] = new SqlParameter("@Str_Url", SqlDbType.NVarChar, 250);
            param[3].Value = Str_Url+"";
            param[4] = new SqlParameter("@Str_Content", SqlDbType.NText);
            param[4].Value = Str_Content+"";
            param[5] = new SqlParameter("@Str_PicUrl", SqlDbType.NVarChar, 250);
            param[5].Value = Str_PicUrl+"";
            param[6] = new SqlParameter("@Str_Author", SqlDbType.NVarChar, 50);
            param[6].Value = Str_Author+"";
            param[7] = new SqlParameter("@Str_Mail", SqlDbType.NVarChar, 150);
            param[7].Value = Str_Mail+"";
            param[8] = new SqlParameter("@Str_ContentFor", SqlDbType.NText);
            param[8].Value = Str_ContentFor+"";
            param[9] = new SqlParameter("@Str_LinkContent", SqlDbType.NText);
            param[9].Value = Str_LinkContent+"";
            param[10] = new SqlParameter("@Str_Addtime", SqlDbType.DateTime, 8);
            param[10].Value = DateTime.Now;
            param[11] = new SqlParameter("@Isuser", SqlDbType.Int, 4);
            param[11].Value = Isuser;
            param[12] = new SqlParameter("@isLok", SqlDbType.Int, 4);
            param[12].Value = isLok;
            string Str_InSql = "Insert into " + Pre + "friend_link (ClassID,Name,Type,Url,Content,PicUrl,Lock,IsUser,Author,Mail,ContentFor,LinkContent,Addtime,isAdmin,SiteID) Values(@Str_Class,@Str_Name,@Str_Type,@Str_Url,@Str_Content,@Str_PicUrl,@isLok,@Isuser,@Str_Author,@Str_Mail,@Str_ContentFor,@Str_LinkContent,@Str_Addtime,1,'" + NetCMS.Global.Current.SiteID + "')";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_InSql, param);
        }
        public DataTable Start_Link(int fid)
        {
            SqlParameter param = new SqlParameter("@ID", fid);
            string Str_FriSql = "Select id,Name,Type,Url,Content,PicUrl,Lock,IsUser,Author,Mail,ContentFor,LinkContent,Addtime,ClassID From " + Pre + "friend_link where ID=@ID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Str_FriSql, param);
        }
        public DataTable Edit_Link_Di()
        {
            string Sql = "Select ClassID,ClassCName,ParentID From " + Pre + "friend_class Where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
        }
        public int Update_Link(string Str_Class, string Str_Name, string Str_Type, string Str_Url, string Str_Content, string Str_PicUrl, int Isuser, int isLok, string Str_Author, string Str_Mail, string Str_ContentFor, string Str_LinkContent, string Str_Addtime, int FID)
        {
            SqlParameter[] param = new SqlParameter[14];
            param[0] = new SqlParameter("@Str_Class", SqlDbType.NVarChar, 12);
            param[0].Value = Str_Class;
            param[1] = new SqlParameter("@Str_Name", SqlDbType.NVarChar, 50);
            param[1].Value = Str_Name;
            param[2] = new SqlParameter("@Str_Type", SqlDbType.Int, 1);
            param[2].Value = Convert.ToInt32(Str_Type);
            param[3] = new SqlParameter("@Str_Url", SqlDbType.NVarChar, 250);
            param[3].Value = Str_Url;
            param[4] = new SqlParameter("@Str_Content", SqlDbType.NText);
            param[4].Value = Convert.ToString(Str_Content);
            param[5] = new SqlParameter("@Str_PicUrl", SqlDbType.NVarChar, 250);
            param[5].Value = Str_PicUrl;
            param[6] = new SqlParameter("@Str_Author", SqlDbType.NVarChar, 50);
            param[6].Value = Str_Author;
            param[7] = new SqlParameter("@Str_Mail", SqlDbType.NVarChar, 150);
            param[7].Value = Str_Mail;
            param[8] = new SqlParameter("@Str_ContentFor", SqlDbType.NText);
            param[8].Value = Str_ContentFor;
            param[9] = new SqlParameter("@Str_LinkContent", SqlDbType.NText);
            param[9].Value = Convert.ToString(Str_LinkContent);
            param[10] = new SqlParameter("@Str_Addtime", SqlDbType.DateTime, 8);
            param[10].Value = Str_Addtime;
            param[11] = new SqlParameter("@Isuser", SqlDbType.Int, 4);
            param[11].Value = Isuser;
            param[12] = new SqlParameter("@isLok", SqlDbType.Int, 4);
            param[12].Value = isLok;
            param[13] = new SqlParameter("@FID", SqlDbType.Int, 4);
            param[13].Value = FID;
            string Str_UpdateSql = "Update " + Pre + "friend_link  Set ClassID=@Str_Class,Name=@Str_Name,Type=@Str_Type,Url=@Str_Url,Content=@Str_Content,PicUrl=@Str_PicUrl,Lock=@isLok,IsUser=@Isuser,Author=@Str_Author,Mail=@Str_Mail,ContentFor=@Str_ContentFor,LinkContent=@Str_LinkContent where ID=@FID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Str_UpdateSql, param);
        }
        public DataTable UserNumm()
        {
            string Str_FriSql = "Select UserNum From " + Pre + "sys_User where UserNum='" + NetCMS.Global.Current.UserNum + "' and isAdmin=1 and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Str_FriSql, null);
        }
        public DataTable CClas(string ClassID)
        {
            SqlParameter param = new SqlParameter("@ClassID", ClassID);
            string Class_Sql = "Select ClassCName From " + Pre + "friend_class where ClassID=@ClassID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Class_Sql, param);
        }
        public DataTable USerSess(string Authorr)
        {
            SqlParameter param = new SqlParameter("@Authorr", Authorr);
            string Str_UserNum_Sql = "Select UserName,isAdmin From " + Pre + "sys_User where userNum=@Authorr and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteTable(CommandType.Text, Str_UserNum_Sql, param);
        }
    }
}