/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Manager model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Manager set ");
strSql.Append(" Name = @Name , ");
strSql.Append(" Limit = @Limit , ");
strSql.Append(" Password = @Password , ");
strSql.Append(" Des = @Des , ");
strSql.Append(" CreateTime = @CreateTime ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Limit", SqlDbType.NVarChar, 2048),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@Des", SqlDbType.NVarChar, 2048),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Limit;
parameters[3].Value = model.Password;
parameters[4].Value = model.Des;
parameters[5].Value = model.CreateTime;
int rows = DbHelperSQLMain.ExecuteSql(strSql.ToString(), parameters);
return(rows);
}
/// <summary>
/// 更新操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Core model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Core set ");
strSql.Append(" HContent = @HContent , ");
strSql.Append(" FrameLink = @FrameLink , ");
strSql.Append(" RedirectLink = @RedirectLink , ");
strSql.Append(" Title = @Title , ");
strSql.Append(" Intro = @Intro , ");
strSql.Append(" Cover = @Cover , ");
strSql.Append(" ShowTime = @ShowTime , ");
strSql.Append(" Author = @Author , ");
strSql.Append(" ViewCount = @ViewCount , ");
strSql.Append(" DingCount = @DingCount , ");
strSql.Append(" OriginalLink = @OriginalLink, ");
strSql.Append(" Imgs = @Imgs, ");
strSql.Append(" Type = @Type, ");
strSql.Append(" Status = @Status ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@HContent", SqlDbType.NVarChar, -1),
new SqlParameter("@FrameLink", SqlDbType.NVarChar, 2048),
new SqlParameter("@RedirectLink", SqlDbType.NVarChar, 2048),
new SqlParameter("@Title", SqlDbType.NVarChar, 512),
new SqlParameter("@Intro", SqlDbType.NVarChar, 2048),
new SqlParameter("@Cover", SqlDbType.NVarChar, 2048),
new SqlParameter("@ShowTime", SqlDbType.DateTime),
new SqlParameter("@Author", SqlDbType.NVarChar, 50),
new SqlParameter("@ViewCount", SqlDbType.Int, 4),
new SqlParameter("@DingCount", SqlDbType.Int, 4),
new SqlParameter("@OriginalLink", SqlDbType.NVarChar, 2048),
new SqlParameter("@Imgs", SqlDbType.NVarChar, -1),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
};
parameters[0].Value = model.Id;
parameters[1].Value = model.HContent;
parameters[2].Value = model.FrameLink;
parameters[3].Value = model.RedirectLink;
parameters[4].Value = model.Title;
parameters[5].Value = model.Intro;
parameters[6].Value = model.Cover;
parameters[7].Value = model.ShowTime;
parameters[8].Value = model.Author;
parameters[9].Value = model.ViewCount;
parameters[10].Value = model.DingCount;
parameters[11].Value = model.OriginalLink;
parameters[12].Value = model.Imgs;
parameters[13].Value = model.Type;
parameters[14].Value = model.Status;
int rows = DbHelperSQLMain.ExecuteSql(strSql.ToString(), parameters);
return(rows);
}
//增删改查业务逻辑
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Core model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Core(Title, Intro, Cover, ShowTime, Author, ViewCount, DingCount, OriginalLink, HContent, FrameLink, RedirectLink, Type, Status, Imgs)");
strSql.Append(" values (");
strSql.Append("@Title, @Intro, @Cover, @ShowTime, @Author, @ViewCount, @DingCount, @OriginalLink, @HContent, @FrameLink, @RedirectLink, @Type, @Status, @Imgs");
strSql.Append(" ) ");
strSql.Append(";select SCOPE_IDENTITY();");
SqlParameter[] parameters =
{
new SqlParameter("Title", SqlDbType.NVarChar, 255),
new SqlParameter("Intro", SqlDbType.NVarChar, 2048),
new SqlParameter("Cover", SqlDbType.NVarChar, 2048),
new SqlParameter("ShowTime", SqlDbType.DateTime),
new SqlParameter("Author", SqlDbType.NVarChar, 50),
new SqlParameter("ViewCount", SqlDbType.Int, 4),
new SqlParameter("DingCount", SqlDbType.Int, 4),
new SqlParameter("OriginalLink", SqlDbType.NVarChar, 2048),
new SqlParameter("HContent", SqlDbType.NVarChar, -1),
new SqlParameter("FrameLink", SqlDbType.NVarChar, 2048),
new SqlParameter("RedirectLink", SqlDbType.NVarChar, 2048),
new SqlParameter("Type", SqlDbType.Int, 4),
new SqlParameter("Status", SqlDbType.Int, 4),
new SqlParameter("Imgs", SqlDbType.NVarChar, -1)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Intro;
parameters[2].Value = model.Cover.IfNullToEmpty();
parameters[3].Value = model.ShowTime;
parameters[4].Value = model.Author.IfNullToEmpty();
parameters[5].Value = model.ViewCount;
parameters[6].Value = model.DingCount;
parameters[7].Value = model.OriginalLink.IfNullToEmpty();
parameters[8].Value = model.HContent;
parameters[9].Value = model.FrameLink.IfNullToEmpty();
parameters[10].Value = model.RedirectLink.IfNullToEmpty();
parameters[11].Value = model.Type;
parameters[12].Value = model.Status;
parameters[13].Value = model.Imgs.IfNullToThis("[]");
int coreId = int.Parse(DbHelperSQLMain.GetSingle(strSql.ToString(), parameters).ToString());
return(coreId);
}
/// <summary>
/// 更新密码
/// </summary>
/// <param name="id"></param>
/// <param name="pwd1"></param>
/// <returns></returns>
public int UpdatePwd(int id, string pwd)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Manager set ");
strSql.Append(" Password = @Password ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Password", SqlDbType.NVarChar, 50)
};
parameters[0].Value = id;
parameters[1].Value = pwd;
int rows = DbHelperSQLMain.ExecuteSql(strSql.ToString(), parameters);
return(rows);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Manager model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Manager(");
strSql.Append("Name,Limit,Password,Des,CreateTime");
strSql.Append(") values (");
strSql.Append("@Name,@Limit,@Password,@Des,@CreateTime");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY();");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Limit", SqlDbType.NVarChar, 2048),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@Des", SqlDbType.NVarChar, 2048),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Limit;
parameters[2].Value = model.Password;
parameters[3].Value = model.Des;
parameters[4].Value = model.CreateTime;
object obj = DbHelperSQLMain.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
