private void LoadEntity(Model.KeyWords model, DataRow row)
{
model.Id = row["id"].ToString();
model.PaperId = row["paperId"].ToString();
model.KeyWord1 = row["keyWord1"].ToString();
model.KeyWord2 = row["keyWord2"].ToString();
model.KeyWord3 = row["keyWord3"].ToString();
model.KeyWord4 = row["keyWord4"].ToString();
model.KeyWord5 = row["keyWord5"].ToString();
model.KeyWord6 = row["keyWord6"].ToString();
}
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);
}
}
public List <Model.KeyWords> GetAllList()
{
string sql = "select * from KeyWords ";
DataTable dt = SqlHelp.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
List <Model.KeyWords> list = new List <Model.KeyWords>();
foreach (DataRow row in dt.Rows)
{
Model.KeyWords model = new Model.KeyWords();
LoadEntity(model, row);
list.Add(model);
}
return(list);
}
else
{
return(null);
}
}
public bool Add(Model.KeyWords model)
{
return(dal.Add(model));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
CommentMethods commentMethods = new CommentMethods();
string articleName = context.Request.Form["articleName"]; //文章名字
string authorName = context.Request.Form["authorName"]; //文章名字
string content = context.Request.Form["content"]; //base64字节
#region 切割base64
string str = "base64,";
int index = content.IndexOf(str) + str.Length;
int end = content.Length - index;
content = content.Substring(index, end);
#endregion
string path = context.Server.MapPath("../Papers/system/");
Random rd = new Random();
string fileName = DateTime.Now.ToString("yyyyMMddhhmmss") + "-" + rd.Next(100, 999).ToString() + "-" + articleName;
byte[] buff = Convert.FromBase64String(content);
if (commentMethods.ByteToFile(content, path, fileName))
{
Bll.AuthorBll authorBll = new Bll.AuthorBll();
var author = new Model.Author()
{
Id = Guid.NewGuid().ToString(),
Name = authorName,
Adress = "",
Email = ""
};
if (authorBll.Add(author))
{
Bll.PapersBll papersBll = new Bll.PapersBll();
var paper = new Model.Papers()
{
Id = Guid.NewGuid().ToString(),
AuthorId = author.Id,
Name = articleName,
Url = "../Papers/system/" + fileName,
Title = ""
};
if (papersBll.Add(paper))
{
var ketWords = commentMethods.GetKeyWord(commentMethods.GetAll(path + fileName));
Bll.KeyWordsBll keyWordsBll = new Bll.KeyWordsBll();
var keyWord = new Model.KeyWords()
{
Id = Guid.NewGuid().ToString(),
PaperId = paper.Id,
KeyWord1 = ketWords[0],
KeyWord2 = ketWords[1],
KeyWord3 = ketWords[2],
KeyWord4 = ketWords[3],
KeyWord5 = ketWords[4],
KeyWord6 = ketWords[5],
};
if (keyWordsBll.Add(keyWord))
{
context.Response.Write(JsonConvert.SerializeObject(new ReturnMessage()
{
Code = 1, Message = "添加成功"
}));
}
}
}
}
}
