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);
}
}