DAL/link.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System; 
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic; 
using System.Data;
using Seven.Common;
using MySql.Data.MySqlClient;
namespace DAL  
{
	 	//link
		public partial class link
	{
   		     
		public bool Exists(int id)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from link");
			strSql.Append(" where ");
			                                       strSql.Append(" id = @id  ");
                            			MySqlParameter[] parameters = {
					new MySqlParameter("@id", MySqlDbType.Int16,9 )
			};
			parameters[0].Value = id;

			return DbHelperMySQL.Exists(strSql.ToString(),parameters);
		}
		
				
		
		/// <summary>
		/// 增加一条数据
		/// </summary>
		public bool Add(MODEL.link model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into link(");			
            strSql.Append("linkname,linkmemo,linkurl,linkimgurl,addtime,orderby");
			strSql.Append(") values (");
            strSql.Append("@linkname,@linkmemo,@linkurl,@linkimgurl,@addtime,@orderby");            
            strSql.Append(") ");            
            strSql.Append(";select @@IDENTITY");		
			MySqlParameter[] parameters = {
			            new MySqlParameter("@linkname", MySqlDbType.VarChar,200) ,            
                        new MySqlParameter("@linkmemo", MySqlDbType.VarChar,300) ,            
                        new MySqlParameter("@linkurl", MySqlDbType.VarChar,500) ,            
                        new MySqlParameter("@linkimgurl", MySqlDbType.VarChar,500) ,            
                        new MySqlParameter("@addtime", MySqlDbType.DateTime) ,            
                        new MySqlParameter("@orderby", MySqlDbType.Int16,9)             
              
            };
			            
            parameters[0].Value = model.linkname;                        
            parameters[1].Value = model.linkmemo;                        
            parameters[2].Value = model.linkurl;                        
            parameters[3].Value = model.linkimgurl;                        
            parameters[4].Value = model.addtime;                        
            parameters[5].Value = model.orderby;
            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {