public bool Add(Model.Author model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Author("); strSql.Append("id,name,adress,email)"); strSql.Append(" values ("); strSql.Append("@id,@name,@adress,@email)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.NVarChar, 100), new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@adress", SqlDbType.NVarChar, 100), new SqlParameter("@email", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Adress; parameters[3].Value = model.Email; int rows = SqlHelp.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Add(Model.Students model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Students("); strSql.Append("stuid,stuName,pwd,email,imgUrl,class)"); strSql.Append(" values ("); strSql.Append("@stuid,@stuName,@pwd,@email,@imgUrl,@class)"); SqlParameter[] parameters = { new SqlParameter("@stuid", SqlDbType.NVarChar, 100), new SqlParameter("@stuName", SqlDbType.NVarChar, 50), new SqlParameter("@pwd", SqlDbType.NVarChar, 50), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@imgUrl", SqlDbType.NVarChar, 200), new SqlParameter("@class", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.StuName; parameters[2].Value = model.Pwd; parameters[3].Value = model.Email; parameters[4].Value = model.ImgUrl; parameters[5].Value = model.Bj; int rows = SqlHelp.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Add(Model.Papers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Papers2("); strSql.Append("id,name,title,url,authorId)"); strSql.Append(" values ("); strSql.Append("@id,@name,@title,@url,@authorId)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.NVarChar, 100), new SqlParameter("@name", SqlDbType.NVarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@url", SqlDbType.NVarChar, 100), new SqlParameter("@authorId", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.Id; parameters[1].Value = model.Name; parameters[2].Value = model.Title; parameters[3].Value = model.Url; parameters[4].Value = model.AuthorId; int rows = SqlHelp.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Add(Model.KeyWords model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into KeyWords("); strSql.Append("id,paperId,keyWord1,keyWord2,keyWord3,keyWord4,keyWord5,keyWord6)"); strSql.Append(" values ("); strSql.Append("@id,@paperId,@keyWord1,@keyWord2,@keyWord3,@keyWord4,@keyWord5,@keyWord6)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.NVarChar, 100), new SqlParameter("@paperId", SqlDbType.NVarChar, 100), new SqlParameter("@keyWord1", SqlDbType.NVarChar, 50), new SqlParameter("@keyWord2", SqlDbType.NVarChar, 50), new SqlParameter("@keyWord3", SqlDbType.NVarChar, 50), new SqlParameter("@keyWord4", SqlDbType.NVarChar, 50), new SqlParameter("@keyWord5", SqlDbType.NVarChar, 50), new SqlParameter("@keyWord6", SqlDbType.NVarChar, 50), }; parameters[0].Value = model.Id; parameters[1].Value = model.PaperId; parameters[2].Value = model.KeyWord1; parameters[3].Value = model.KeyWord2; parameters[4].Value = model.KeyWord3; parameters[5].Value = model.KeyWord4; parameters[6].Value = model.KeyWord5; parameters[7].Value = model.KeyWord6; int rows = SqlHelp.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }