/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.CatroonInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CatroonInfo set ");
strSql.Append("CartoonName=@CartoonName,");
strSql.Append("CartoonIntroduce=@CartoonIntroduce,");
strSql.Append("CartoonImage=@CartoonImage,");
strSql.Append("CategoriesId=@CategoriesId,");
strSql.Append("AddDateTime=@AddDateTime");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@CartoonName", SqlDbType.VarChar,50),
new SqlParameter("@CartoonIntroduce", SqlDbType.VarChar,600),
new SqlParameter("@CartoonImage", SqlDbType.VarChar,100),
new SqlParameter("@CategoriesId", SqlDbType.Int,4),
new SqlParameter("@AddDateTime", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.CartoonName;
parameters[1].Value = model.CartoonIntroduce;
parameters[2].Value = model.CartoonImage;
parameters[3].Value = model.CategoriesId;
parameters[4].Value = model.AddDateTime;
parameters[5].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Announce model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Announce set ");
strSql.Append("Title=@Title,");
strSql.Append("AnnContent=@AnnContent,");
strSql.Append("AdminId=@AdminId,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.Char,50),
new SqlParameter("@AnnContent", SqlDbType.VarChar,-1),
new SqlParameter("@AdminId", SqlDbType.Int,4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.AnnContent;
parameters[2].Value = model.AdminId;
parameters[3].Value = model.AddTime;
parameters[4].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.CatroonInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CatroonInfo(");
strSql.Append("CartoonName,CartoonIntroduce,CartoonImage,CategoriesId,AddDateTime)");
strSql.Append(" values (");
strSql.Append("@CartoonName,@CartoonIntroduce,@CartoonImage,@CategoriesId,@AddDateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@CartoonName", SqlDbType.VarChar,50),
new SqlParameter("@CartoonIntroduce", SqlDbType.VarChar,600),
new SqlParameter("@CartoonImage", SqlDbType.VarChar,100),
new SqlParameter("@CategoriesId", SqlDbType.Int,4),
new SqlParameter("@AddDateTime", SqlDbType.DateTime)};
parameters[0].Value = model.CartoonName;
parameters[1].Value = model.CartoonIntroduce;
parameters[2].Value = model.CartoonImage;
parameters[3].Value = model.CategoriesId;
parameters[4].Value = model.AddDateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Link model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Link set ");
strSql.Append("linkTile=@linkTile,");
strSql.Append("uRl=@uRl");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@linkTile", SqlDbType.VarChar,50),
new SqlParameter("@uRl", SqlDbType.VarChar,200),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.linkTile;
parameters[1].Value = model.uRl;
parameters[2].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Announce model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Announce(");
strSql.Append("Title,AnnContent,AdminId,AddTime)");
strSql.Append(" values (");
strSql.Append("@Title,@AnnContent,@AdminId,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.Char,50),
new SqlParameter("@AnnContent", SqlDbType.VarChar,-1),
new SqlParameter("@AdminId", SqlDbType.Int,4),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.Title;
parameters[1].Value = model.AnnContent;
parameters[2].Value = model.AdminId;
parameters[3].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(shaoqi.Model.User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [User](");
strSql.Append("LoginName,Password,Phone,Email,UserState)");
strSql.Append(" values (");
strSql.Append("@LoginName,@Password,@Phone,@Email,@UserState)");
SqlParameter[] parameters = {
new SqlParameter("@LoginName", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50),
new SqlParameter("@Phone", SqlDbType.NChar,10),
new SqlParameter("@Email", SqlDbType.VarChar,50),
new SqlParameter("@UserState", SqlDbType.Int,4)};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.Password;
parameters[2].Value = model.Phone;
parameters[3].Value = model.Email;
parameters[4].Value = model.UserState;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Message model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Message set ");
strSql.Append("MgeContent=@MgeContent,");
strSql.Append("UserId=@UserId,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@MgeContent", SqlDbType.VarChar,500),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.MgeContent;
parameters[1].Value = model.UserId;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Message model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Message(");
strSql.Append("MgeContent,UserId,AddTime)");
strSql.Append(" values (");
strSql.Append("@MgeContent,@UserId,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MgeContent", SqlDbType.VarChar,500),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@AddTime", SqlDbType.DateTime)};
parameters[0].Value = model.MgeContent;
parameters[1].Value = model.UserId.Id;
parameters[2].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Admin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Admin(");
strSql.Append("LoginName,Password,Name,Phone)");
strSql.Append(" values (");
strSql.Append("@LoginName,@Password,@Name,@Phone)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@LoginName", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Phone", SqlDbType.Char,13)};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.Password;
parameters[2].Value = model.Name;
parameters[3].Value = model.Phone;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Admin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Admin set ");
strSql.Append("LoginName=@LoginName,");
strSql.Append("Password=@Password,");
strSql.Append("Name=@Name,");
strSql.Append("Phone=@Phone");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@LoginName", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50),
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Phone", SqlDbType.Char,13),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.Password;
parameters[2].Value = model.Name;
parameters[3].Value = model.Phone;
parameters[4].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Menu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Menu set ");
strSql.Append("pId=@pId,");
strSql.Append("className=@className,");
strSql.Append("classOrder=@classOrder,");
strSql.Append("ClassType=@ClassType,");
strSql.Append("isOpen=@isOpen,");
strSql.Append("isSystem=@isSystem,");
strSql.Append("Webtype=@Webtype,");
strSql.Append("OutLinkURL=@OutLinkURL,");
strSql.Append("classNameEn=@classNameEn");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@pId", SqlDbType.VarChar,50),
new SqlParameter("@className", SqlDbType.VarChar,200),
new SqlParameter("@classOrder", SqlDbType.Int,4),
new SqlParameter("@ClassType", SqlDbType.TinyInt,1),
new SqlParameter("@isOpen", SqlDbType.TinyInt,1),
new SqlParameter("@isSystem", SqlDbType.TinyInt,1),
new SqlParameter("@Webtype", SqlDbType.VarChar,10),
new SqlParameter("@OutLinkURL", SqlDbType.VarChar,200),
new SqlParameter("@classNameEn", SqlDbType.VarChar,200),
new SqlParameter("@id", SqlDbType.VarChar,50)};
parameters[0].Value = model.pId;
parameters[1].Value = model.className;
parameters[2].Value = model.classOrder;
parameters[3].Value = model.ClassType;
parameters[4].Value = model.isOpen;
parameters[5].Value = model.isSystem;
parameters[6].Value = model.Webtype;
parameters[7].Value = model.OutLinkURL;
parameters[8].Value = model.classNameEn;
parameters[9].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Categries model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Categries set ");
strSql.Append("Name=@Name");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(shaoqi.Model.Menu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Menu(");
strSql.Append("id,pId,className,classOrder,ClassType,isOpen,isSystem,Webtype,OutLinkURL,classNameEn)");
strSql.Append(" values (");
strSql.Append("@id,@pId,@className,@classOrder,@ClassType,@isOpen,@isSystem,@Webtype,@OutLinkURL,@classNameEn)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.VarChar,50),
new SqlParameter("@pId", SqlDbType.VarChar,50),
new SqlParameter("@className", SqlDbType.VarChar,200),
new SqlParameter("@classOrder", SqlDbType.Int,4),
new SqlParameter("@ClassType", SqlDbType.TinyInt,1),
new SqlParameter("@isOpen", SqlDbType.TinyInt,1),
new SqlParameter("@isSystem", SqlDbType.TinyInt,1),
new SqlParameter("@Webtype", SqlDbType.VarChar,10),
new SqlParameter("@OutLinkURL", SqlDbType.VarChar,200),
new SqlParameter("@classNameEn", SqlDbType.VarChar,200)};
parameters[0].Value = model.id;
parameters[1].Value = model.pId;
parameters[2].Value = model.className;
parameters[3].Value = model.classOrder;
parameters[4].Value = model.ClassType;
parameters[5].Value = model.isOpen;
parameters[6].Value = model.isSystem;
parameters[7].Value = model.Webtype;
parameters[8].Value = model.OutLinkURL;
parameters[9].Value = model.classNameEn;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Categries model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Categries(");
strSql.Append("Name)");
strSql.Append(" values (");
strSql.Append("@Name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.VarChar,50)};
parameters[0].Value = model.Name;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Link model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Link(");
strSql.Append("linkTile,uRl)");
strSql.Append(" values (");
strSql.Append("@linkTile,@uRl)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@linkTile", SqlDbType.VarChar,50),
new SqlParameter("@uRl", SqlDbType.VarChar,200)};
parameters[0].Value = model.linkTile;
parameters[1].Value = model.uRl;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.CatroonInfo model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.CatroonInfo model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Message model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Admin model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Admin model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.CartSon model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Comment model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Categries model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Message model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Link model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Comment model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(shaoqi.Model.Categries model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(shaoqi.Model.User model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.CartSon model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(shaoqi.Model.Link model)
{
return dal.Add(model);
}
