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 = "添加成功" })); } } } } }