public string AddArticle(string jsons) { int code = 1; int status = 200; string message = "成功"; ResponseInfo responseInfo = new Models.ResponseInfo(); Data data = new Data(); if (string.IsNullOrEmpty(jsons)) { code = 1; status = 200; message = "传递参数不能为空"; // data.data = "{\"Message\":\"传递参数不能为空!\"}"; data.data = message; data.code = code; responseInfo.status = status; responseInfo.data = data; responseInfo.message = message; // return "{\"status\":\"-1\",\"Message\":\"传递参数不能为空!\"}"; return(JsonConvert.SerializeObject(responseInfo)); } try { ArticleInfo info = JsonConvert.DeserializeObject <ArticleInfo>(jsons); string sql = string.Format(@"insert into Article(Title,Summary,Contents,Images,Keywords,Description,ClassifyID,SiteID,UserID,Status,Label,CreateTime) VALUES ('{0}','{1}','{2}','{3}'.'{4}','{5}',{6},{7},{8},{9},'{10}',now())", info.Title, info.Summary, info.Contents, info.Images, info.Keywords, info.Description, info.ClassifyID, info.SiteID, info.ClassifyID, info.SiteID, 1, info.Label); MySqlParameter[] sqlparams = { new MySqlParameter("Title", info.Title), new MySqlParameter("Summary", info.Summary), new MySqlParameter("Contents", info.Contents), new MySqlParameter("Images", info.Images), new MySqlParameter("Keywords", info.Keywords), new MySqlParameter("Description", info.Description), new MySqlParameter("ClassifyID", info.ClassifyID), new MySqlParameter("SiteID", info.SiteID), new MySqlParameter("UserID", info.UserID), new MySqlParameter("Status", info.Status), new MySqlParameter("Label", info.Label), new MySqlParameter("CreateTime", info.CreateTime) }; int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, sqlparams); if (i > 0) { message = "成功"; //return "{\"status\":\"1\",\"Message\":\"添加成功!\"}"; } else { code = 0; status = 200; message = "添加失败"; // return "{\"status\":\"0\",\"Message\":\"添加失败!\"}"; } } catch (Exception ex) { code = 0; status = 500; message = "服务器内部错误:" + ex.Message; //return "{\"status\":\"-2\",\"Message\":\"异常:\"" + ex.Message + "}"; //throw; } data.code = code; data.data = message; responseInfo.status = status; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); }
public string Add(string jsons) { int code = 1; int status = 200; string message = "成功"; ResponseInfo responseInfo = new Models.ResponseInfo(); Data data = new Data(); if (string.IsNullOrEmpty(jsons)) { code = 1; status = 200; message = "传递参数不能为空"; // data.data = "{\"Message\":\"传递参数不能为空!\"}"; data.data = message; data.code = code; responseInfo.status = status; responseInfo.data = data; responseInfo.message = message; // return "{\"status\":\"-1\",\"Message\":\"传递参数不能为空!\"}"; return(JsonConvert.SerializeObject(responseInfo)); } try { SiteInfo info = JsonConvert.DeserializeObject <SiteInfo>(jsons); string sql = string.Format(@"insert into Site(SiteName,CreateTime) VALUES ('{0}',now())", info.SiteName, info.CreateTime); MySqlParameter[] sqlparams = { new MySqlParameter("SiteName", info.SiteName), new MySqlParameter("CreateTime", info.CreateTime) }; int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, sqlparams); if (i > 0) { message = "成功"; // return "{\"status\":\"1\",\"Message\":\"添加成功!\"}"; } else { code = 0; status = 200; message = "添加失败"; // return "{\"status\":\"0\",\"Message\":\"添加失败!\"}"; } } catch (Exception ex) { code = 0; status = 500; message = "服务器内部错误:" + ex.Message; //return "{\"status\":\"-2\",\"Message\":\"异常:\"" + ex.Message + "}"; //throw; } data.code = code; data.data = message; responseInfo.status = status; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); }
public string Add(string jsons) { int code = 1; int status = 200; string message = "成功"; ResponseInfo responseInfo = new Models.ResponseInfo(); Data data = new Data(); if (string.IsNullOrEmpty(jsons)) { code = 1; status = 200; message = "传递的参数不能为空"; //return "{\"status\":\"-1\",\"Message\":\"传递的参数不能为空!\"}"; } else { try { ClassifyInfo info = JsonConvert.DeserializeObject <ClassifyInfo>(jsons); string sql = string.Format(@"insert into Classify(ClassifyName,CreateTime)values('{0}',now())", info.ClassifyName); MySqlParameter parameters = new MySqlParameter("ClassifyName", info.ClassifyName); int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, parameters); if (i > 0) { code = 1; status = 200; message = "添加分类成功"; // return "{\"status\":\"1\",\"Message\":\"添加分类成功!\"}"; } else { code = 0; status = 200; message = "添加分类失败"; // return "{\"status\":\"0\",\"Message\":\"添加分类失败!\"}"; } } catch (Exception ex) { code = 0; status = 500; message = "服务器内部错误:" + ex.Message; //return "{\"status\":\"-2\",\"Message\":\"异常:\"" + ex.Message + "}"; //throw; } } data.code = code; data.data = message; responseInfo.status = status; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); }
public string Edit(string jsons) { int code = 1; int status = 200; string message = "成功"; ResponseInfo responseInfo = new Models.ResponseInfo(); Data data = new Data(); if (string.IsNullOrEmpty(jsons)) { message = "传递的参数不能为空"; // return "{\"status\":\"-1\",\"Message\":\"传递的参数不能为空!\"}"; } else { try { ClassifyInfo info = JsonConvert.DeserializeObject <ClassifyInfo>(jsons); string sql = string.Format(@"update Classify set ClassifyName='{1}' where ClassifyID={0}", info.ClassifyID, info.ClassifyName); MySqlParameter[] mySqlParameters = { new MySqlParameter("ClassifyID", info.ClassifyID), new MySqlParameter("ClassifyName", info.ClassifyName) }; int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, mySqlParameters); if (i > 0) { code = 1; status = 200; message = "编辑分类成功"; // return "{\"status\":\"1\",\"Message\":\"编辑分类成功!\"}"; } else { code = 0; status = 200; message = "编辑分类失败"; // return "{\"status\":\"0\",\"Message\":\"编辑分类失败!\"}"; } } catch (Exception ex) { code = 0; status = 500; message = "服务器内部错误:" + ex.Message;; //return "{\"status\":\"-2\",\"Message\":\"异常:\"" + ex.Message + "}"; //throw; } } data.code = code; data.data = message; responseInfo.status = status; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); }
public string UpdateArticleStatus(int id, int status) { int code = 1; int statusStr = 200; string message = "成功"; ResponseInfo responseInfo = new Models.ResponseInfo(); Data data = new Data(); if (string.IsNullOrEmpty(id.ToString())) { code = 1; statusStr = 200; message = "传递参数不能为空"; data.data = "{\"Message\":\"传递参数不能为空!\"}"; data.code = code; responseInfo.status = statusStr; responseInfo.data = data; responseInfo.message = message; // return "{\"status\":\"-1\",\"Message\":\"传递参数不能为空!\"}"; return(JsonConvert.SerializeObject(responseInfo)); //return "{\"status\":\"-1\",\"Message\":\"传递的参数不能为空!\"}"; } base.HttpContext.Response.Headers.Add("Access-Control-Allow-Origin", "*");//允许跨域 string idParam = base.HttpContext.Request.Query["id"]; string sql = string.Format(@"update Article set Status={1} where ArticleID={0}", id, status); MySqlParameter[] sqlParameters = { new MySqlParameter("Status", status), new MySqlParameter("ArticleID", id) }; int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, sqlParameters); if (i > 0) { code = 1; statusStr = 200; message = "更改文章状态成功"; // return "{\"status\":\"1\",\"Message\":\"更改文章状态成功!\"}"; } else { code = 0; statusStr = 200; message = "更改文章状态失败"; // return "{\"status\":\"0\",\"Message\":\"更改文章状态失败!\"}"; } data.code = code; data.data = message; responseInfo.status = statusStr; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); }
public string Delete(string jsons) { int code = 1; int statusStr = 200; string message = "成功"; ResponseInfo responseInfo = new Models.ResponseInfo(); Data data = new Data(); if (string.IsNullOrEmpty(jsons.ToString())) { code = 1; statusStr = 200; message = "传递参数不能为空"; data.data = "{\"Message\":\"传递参数不能为空!\"}"; data.code = code; responseInfo.status = statusStr; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); } SiteInfo info = JsonConvert.DeserializeObject <SiteInfo>(jsons); string sql = string.Format(@"delete Site where SiteID={0}", info.SiteID); MySqlParameter[] sqlParameters = { new MySqlParameter("SiteID", info.SiteID) }; int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, sqlParameters); if (i > 0) { code = 1; statusStr = 200; message = "删除站点成功"; // return "{\"status\":\"1\",\"Message\":\"更改文章状态成功!\"}"; } else { code = 0; statusStr = 200; message = "删除站点失败"; // return "{\"status\":\"0\",\"Message\":\"更改文章状态失败!\"}"; } data.code = code; data.data = message; responseInfo.status = statusStr; responseInfo.data = data; responseInfo.message = message; return(JsonConvert.SerializeObject(responseInfo)); }