public static bool AlbumsAdd(Model.AlbumsModel model)
{
int xuhao = (int)DBHelper.ExecuteScalar("Select Count(0) From Albums Where number='" + model.Number + "'");
string sql = @"Insert Into Albums(number,AlbumsName,Xuhao,CreateDate,CreateIp)
values(@number,@AlbumsName,@Xuhao,@CreateDate,@CreateIp)";
SqlParameter[] para =
{
new SqlParameter("@number", model.Number),
new SqlParameter("@AlbumsName", model.AlbumsName),
new SqlParameter("@Xuhao", (xuhao + 1)),
new SqlParameter("@CreateDate", model.CreateDate),
new SqlParameter("@CreateIp", model.CreateIP)
};
int count = (int)DBHelper.ExecuteNonQuery(sql, para, CommandType.Text);
if (count == 0)
{
return(false);
}
return(true);
}
public static bool AlbumsAdd(Model.AlbumsModel model)
{
return(DAL.PersonalSpace.Message.AlbumsAdd(model));
}
