/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.Orders model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Orders set ");
strSql.Append("OrderDate=@OrderDate,");
strSql.Append("UserId=@UserId,");
strSql.Append("TotalPrice=@TotalPrice,");
strSql.Append("PostAddress=@PostAddress,");
strSql.Append("state=@state");
strSql.Append(" where OrderId=@OrderId ");
SqlParameter[] parameters = {
new SqlParameter("@OrderDate", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@TotalPrice", SqlDbType.Decimal,9),
new SqlParameter("@PostAddress", SqlDbType.NVarChar,255),
new SqlParameter("@state", SqlDbType.Int,4),
new SqlParameter("@OrderId", SqlDbType.NVarChar,50)};
parameters[0].Value = model.OrderDate;
parameters[1].Value = model.UserId;
parameters[2].Value = model.TotalPrice;
parameters[3].Value = model.PostAddress;
parameters[4].Value = model.state;
parameters[5].Value = model.OrderId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MyBookShop.Model.VidoFile model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into VidoFile(");
strSql.Append("Title,FivPath,Status,FileExt)");
strSql.Append(" values (");
strSql.Append("@Title,@FivPath,@Status,@FileExt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,50),
new SqlParameter("@FivPath", SqlDbType.NVarChar,255),
new SqlParameter("@Status", SqlDbType.NVarChar,50),
new SqlParameter("@FileExt", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Title;
parameters[1].Value = model.FivPath;
parameters[2].Value = model.Status;
parameters[3].Value = model.FileExt;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.BookComment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update BookComment set ");
strSql.Append("Msg=@Msg,");
strSql.Append("CreateDateTime=@CreateDateTime,");
strSql.Append("BookId=@BookId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Msg", SqlDbType.NVarChar,-1),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@BookId", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Msg;
parameters[1].Value = model.CreateDateTime;
parameters[2].Value = model.BookId;
parameters[3].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyBookShop.Model.Orders model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Orders(");
strSql.Append("OrderId,OrderDate,UserId,TotalPrice,PostAddress,state)");
strSql.Append(" values (");
strSql.Append("@OrderId,@OrderDate,@UserId,@TotalPrice,@PostAddress,@state)");
SqlParameter[] parameters = {
new SqlParameter("@OrderId", SqlDbType.NVarChar,50),
new SqlParameter("@OrderDate", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@TotalPrice", SqlDbType.Decimal,9),
new SqlParameter("@PostAddress", SqlDbType.NVarChar,255),
new SqlParameter("@state", SqlDbType.Int,4)};
parameters[0].Value = model.OrderId;
parameters[1].Value = model.OrderDate;
parameters[2].Value = model.UserId;
parameters[3].Value = model.TotalPrice;
parameters[4].Value = model.PostAddress;
parameters[5].Value = model.state;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MyBookShop.Model.BookComment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into BookComment(");
strSql.Append("Msg,CreateDateTime,BookId)");
strSql.Append(" values (");
strSql.Append("@Msg,@CreateDateTime,@BookId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Msg", SqlDbType.NVarChar,-1),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@BookId", SqlDbType.Int,4)};
parameters[0].Value = model.Msg;
parameters[1].Value = model.CreateDateTime;
parameters[2].Value = model.BookId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.Cart model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Cart set ");
strSql.Append("UserId=@UserId,");
strSql.Append("BookId=@BookId,");
strSql.Append("Count=@Count");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@BookId", SqlDbType.Int,4),
new SqlParameter("@Count", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.BookId;
parameters[2].Value = model.Count;
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(MyBookShop.Model.Cart model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Cart(");
strSql.Append("UserId,BookId,Count)");
strSql.Append(" values (");
strSql.Append("@UserId,@BookId,@Count)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@BookId", SqlDbType.Int,4),
new SqlParameter("@Count", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.BookId;
parameters[2].Value = model.Count;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.VidoFile model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update VidoFile set ");
strSql.Append("Title=@Title,");
strSql.Append("FivPath=@FivPath,");
strSql.Append("Status=@Status,");
strSql.Append("FileExt=@FileExt");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,50),
new SqlParameter("@FivPath", SqlDbType.NVarChar,255),
new SqlParameter("@Status", SqlDbType.NVarChar,50),
new SqlParameter("@FileExt", SqlDbType.NVarChar,50),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.FivPath;
parameters[2].Value = model.Status;
parameters[3].Value = model.FileExt;
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(MyBookShop.Model.Settings model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Settings set ");
strSql.Append("Name=@Name,");
strSql.Append("Value=@Value");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Value", SqlDbType.NVarChar,50),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Name;
parameters[1].Value = model.Value;
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(MyBookShop.Model.OrderBook model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderBook(");
strSql.Append("OrderID,BookID,Quantity,UnitPrice)");
strSql.Append(" values (");
strSql.Append("@OrderID,@BookID,@Quantity,@UnitPrice)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OrderID", SqlDbType.NVarChar,50),
new SqlParameter("@BookID", SqlDbType.Int,4),
new SqlParameter("@Quantity", SqlDbType.Int,4),
new SqlParameter("@UnitPrice", SqlDbType.Decimal,9)};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.BookID;
parameters[2].Value = model.Quantity;
parameters[3].Value = model.UnitPrice;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.CheckEmail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update CheckEmail set ");
strSql.Append("Actived=@Actived,");
strSql.Append("ActiveCode=@ActiveCode,");
strSql.Append("UserId=@UserId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Actived", SqlDbType.Bit,1),
new SqlParameter("@ActiveCode", SqlDbType.NVarChar,50),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Actived;
parameters[1].Value = model.ActiveCode;
parameters[2].Value = model.UserId;
parameters[3].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.OrderBook model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update OrderBook set ");
strSql.Append("OrderID=@OrderID,");
strSql.Append("BookID=@BookID,");
strSql.Append("Quantity=@Quantity,");
strSql.Append("UnitPrice=@UnitPrice");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@OrderID", SqlDbType.NVarChar,50),
new SqlParameter("@BookID", SqlDbType.Int,4),
new SqlParameter("@Quantity", SqlDbType.Int,4),
new SqlParameter("@UnitPrice", SqlDbType.Decimal,9),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.BookID;
parameters[2].Value = model.Quantity;
parameters[3].Value = model.UnitPrice;
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(MyBookShop.Model.CheckEmail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CheckEmail(");
strSql.Append("Actived,ActiveCode,UserId)");
strSql.Append(" values (");
strSql.Append("@Actived,@ActiveCode,@UserId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Actived", SqlDbType.Bit,1),
new SqlParameter("@ActiveCode", SqlDbType.NVarChar,50),
new SqlParameter("@UserId", SqlDbType.Int,4)};
parameters[0].Value = model.Actived;
parameters[1].Value = model.ActiveCode;
parameters[2].Value = model.UserId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.SysFun model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update SysFun set ");
strSql.Append("DisplayName=@DisplayName,");
strSql.Append("NodeURL=@NodeURL,");
strSql.Append("DisplayOrder=@DisplayOrder,");
strSql.Append("ParentNodeId=@ParentNodeId");
strSql.Append(" where NodeId=@NodeId ");
SqlParameter[] parameters = {
new SqlParameter("@DisplayName", SqlDbType.NVarChar,50),
new SqlParameter("@NodeURL", SqlDbType.NVarChar,50),
new SqlParameter("@DisplayOrder", SqlDbType.Int,4),
new SqlParameter("@ParentNodeId", SqlDbType.Int,4),
new SqlParameter("@NodeId", SqlDbType.Int,4)};
parameters[0].Value = model.DisplayName;
parameters[1].Value = model.NodeURL;
parameters[2].Value = model.DisplayOrder;
parameters[3].Value = model.ParentNodeId;
parameters[4].Value = model.NodeId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyBookShop.Model.SysFun model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysFun(");
strSql.Append("NodeId,DisplayName,NodeURL,DisplayOrder,ParentNodeId)");
strSql.Append(" values (");
strSql.Append("@NodeId,@DisplayName,@NodeURL,@DisplayOrder,@ParentNodeId)");
SqlParameter[] parameters = {
new SqlParameter("@NodeId", SqlDbType.Int,4),
new SqlParameter("@DisplayName", SqlDbType.NVarChar,50),
new SqlParameter("@NodeURL", SqlDbType.NVarChar,50),
new SqlParameter("@DisplayOrder", SqlDbType.Int,4),
new SqlParameter("@ParentNodeId", SqlDbType.Int,4)};
parameters[0].Value = model.NodeId;
parameters[1].Value = model.DisplayName;
parameters[2].Value = model.NodeURL;
parameters[3].Value = model.DisplayOrder;
parameters[4].Value = model.ParentNodeId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.Articel_Words model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Articel_Words set ");
strSql.Append("WordPattern=@WordPattern,");
strSql.Append("IsForbid=@IsForbid,");
strSql.Append("IsMod=@IsMod,");
strSql.Append("ReplaceWord=@ReplaceWord");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@WordPattern", SqlDbType.NVarChar,50),
new SqlParameter("@IsForbid", SqlDbType.Bit,1),
new SqlParameter("@IsMod", SqlDbType.Bit,1),
new SqlParameter("@ReplaceWord", SqlDbType.NVarChar,50),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.WordPattern;
parameters[1].Value = model.IsForbid;
parameters[2].Value = model.IsMod;
parameters[3].Value = model.ReplaceWord;
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(MyBookShop.Model.Articel_Words model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Articel_Words(");
strSql.Append("WordPattern,IsForbid,IsMod,ReplaceWord)");
strSql.Append(" values (");
strSql.Append("@WordPattern,@IsForbid,@IsMod,@ReplaceWord)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@WordPattern", SqlDbType.NVarChar,50),
new SqlParameter("@IsForbid", SqlDbType.Bit,1),
new SqlParameter("@IsMod", SqlDbType.Bit,1),
new SqlParameter("@ReplaceWord", SqlDbType.NVarChar,50)};
parameters[0].Value = model.WordPattern;
parameters[1].Value = model.IsForbid;
parameters[2].Value = model.IsMod;
parameters[3].Value = model.ReplaceWord;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MyBookShop.Model.Users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Users(");
strSql.Append("LoginId,LoginPwd,Name,Address,Phone,Mail,UserStateId)");
strSql.Append(" values (");
strSql.Append("@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserStateId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@LoginId", SqlDbType.NVarChar,50),
new SqlParameter("@LoginPwd", SqlDbType.NVarChar,50),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Address", SqlDbType.NVarChar,200),
new SqlParameter("@Phone", SqlDbType.NVarChar,100),
new SqlParameter("@Mail", SqlDbType.NVarChar,100),
new SqlParameter("@UserStateId", SqlDbType.Int,4)};
parameters[0].Value = model.LoginId;
parameters[1].Value = model.LoginPwd;
parameters[2].Value = model.Name;
parameters[3].Value = model.Address;
parameters[4].Value = model.Phone;
parameters[5].Value = model.Mail;
parameters[6].Value = model.UserStateId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MyBookShop.Model.Books model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Books(");
strSql.Append("Title,Author,PublisherId,PublishDate,ISBN,WordsCount,UnitPrice,ContentDescription,AurhorDescription,EditorComment,TOC,CategoryId,Clicks)");
strSql.Append(" values (");
strSql.Append("@Title,@Author,@PublisherId,@PublishDate,@ISBN,@WordsCount,@UnitPrice,@ContentDescription,@AurhorDescription,@EditorComment,@TOC,@CategoryId,@Clicks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,200),
new SqlParameter("@Author", SqlDbType.NVarChar,200),
new SqlParameter("@PublisherId", SqlDbType.Int,4),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@ISBN", SqlDbType.NVarChar,50),
new SqlParameter("@WordsCount", SqlDbType.Int,4),
new SqlParameter("@UnitPrice", SqlDbType.Money,8),
new SqlParameter("@ContentDescription", SqlDbType.NVarChar,-1),
new SqlParameter("@AurhorDescription", SqlDbType.NVarChar,-1),
new SqlParameter("@EditorComment", SqlDbType.NVarChar,-1),
new SqlParameter("@TOC", SqlDbType.NVarChar,-1),
new SqlParameter("@CategoryId", SqlDbType.Int,4),
new SqlParameter("@Clicks", SqlDbType.Int,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Author;
parameters[2].Value = model.PublisherId;
parameters[3].Value = model.PublishDate;
parameters[4].Value = model.ISBN;
parameters[5].Value = model.WordsCount;
parameters[6].Value = model.UnitPrice;
parameters[7].Value = model.ContentDescription;
parameters[8].Value = model.AurhorDescription;
parameters[9].Value = model.EditorComment;
parameters[10].Value = model.TOC;
parameters[11].Value = model.CategoryId;
parameters[12].Value = model.Clicks;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MyBookShop.Model.Publishers model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Publishers(");
strSql.Append("Name)");
strSql.Append(" values (");
strSql.Append("@Name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,200)};
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 bool Update(MyBookShop.Model.Users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Users set ");
strSql.Append("LoginPwd=@LoginPwd,");
strSql.Append("Name=@Name,");
strSql.Append("Address=@Address,");
strSql.Append("Phone=@Phone,");
strSql.Append("UserStateId=@UserStateId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@LoginPwd", SqlDbType.NVarChar,50),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Address", SqlDbType.NVarChar,200),
new SqlParameter("@Phone", SqlDbType.NVarChar,100),
new SqlParameter("@UserStateId", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4),
new SqlParameter("@LoginId", SqlDbType.NVarChar,50),
new SqlParameter("@Mail", SqlDbType.NVarChar,100)};
parameters[0].Value = model.LoginPwd;
parameters[1].Value = model.Name;
parameters[2].Value = model.Address;
parameters[3].Value = model.Phone;
parameters[4].Value = model.UserStateId;
parameters[5].Value = model.Id;
parameters[6].Value = model.LoginId;
parameters[7].Value = model.Mail;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">增加的数据</param>
/// <param name="userId">返回的Id</param>
/// <returns>返回受影响行数</returns>
public object Add(MyBookShop.Model.Users model, out int userId)
{
string sql = "insert into Users(LoginId,LoginPwd,Name,Address,Phone,Mail,UserStateId) output inserted.Id values (@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserStateId)";
SqlParameter[] parameters = {
new SqlParameter("@LoginId", SqlDbType.NVarChar,50),
new SqlParameter("@LoginPwd", SqlDbType.NVarChar,50),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Address", SqlDbType.NVarChar,200),
new SqlParameter("@Phone", SqlDbType.NVarChar,100),
new SqlParameter("@Mail", SqlDbType.NVarChar,100),
new SqlParameter("@UserStateId", SqlDbType.Int,4)};
parameters[0].Value = model.LoginId;
parameters[1].Value = model.LoginPwd;
parameters[2].Value = model.Name;
parameters[3].Value = model.Address;
parameters[4].Value = model.Phone;
parameters[5].Value = model.Mail;
parameters[6].Value = model.UserState.Id;
userId = Convert.ToInt32(DbHelperSQL.GetSingle(sql, parameters));
return userId > 0 ? 1 : 0;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.Publishers model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Publishers set ");
#warning 系统发现缺少更新的字段，请手工确认如此更新是否正确！
strSql.Append("Id=@Id,");
strSql.Append("Name=@Name");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.NVarChar,200)};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.Orders model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyBookShop.Model.Orders model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">增加的数据</param>
/// <param name="userId">返回的Id</param>
/// <returns>返回受影响行数</returns>
public int Add(MyBookShop.Model.Users model, out int userId)
{
return Convert.ToInt32(dal.Add(model, out userId));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.Settings model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MyBookShop.Model.Settings model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyBookShop.Model.SysFun model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyBookShop.Model.SysFun model)
{
return dal.Add(model);
}
