public ActionResult OnPostSave()
{
MemoryStream memoryStream = new MemoryStream();
Request.Body.CopyTo(memoryStream);
memoryStream.Position = 0;
using (StreamReader reader = new StreamReader(memoryStream))
{
string result = reader.ReadToEnd();
if (result.Length > 0 || !result.Trim().Equals(""))
{
PageEntry = JsonConvert.DeserializeObject <Entry>(result);
}
else
{
return(new JsonResult(JsonConvert.SerializeObject(0)));
}
}
//变量验证
if (BasicClasses.Find(basicClassObj => basicClassObj.ID == PageEntry.BasicClassID) == null)
{
PageEntry.BasicClassID = 0;
}
else
{
if (IsBasicEntry(PageEntry))
{
PageEntry.BasicClassID = BasicClasses.Find(basicClassObj => basicClassObj.UniqueTitle == PageEntry.UniqueTitle).ID;
}
}
PageEntry.PageContent = PageEntry.PageContent.Replace("\\", "\\\\");
PageEntry.PageContent = PageEntry.PageContent.Replace("\'", "\\\'");
string[] keySelect = { "title_unique" };
MySqlIntegration postInteg = new MySqlIntegration(Configuration.GetConnectionString("MySqlConnection"));
postInteg.MySqlSelect("entries", keySelect, "title_unique=" + MySqlIntegration.QuoteStr(PageEntry.UniqueTitle));
string[] keysSave = { "title_unique", "basic_class_ID", "title_display", "content" };
int lineAffected;
if (postInteg.IntegratedResult.Count > 0)
{
lineAffected = postInteg.MySqlUpdate("entries", keysSave, "title_unique=" + MySqlIntegration.QuoteStr(PageEntry.UniqueTitle), PageEntry.UniqueTitle, PageEntry.BasicClassID, PageEntry.DisplayTitle, PageEntry.PageContent);
}
else
{
lineAffected = postInteg.MySqlInsert("entries", keysSave, PageEntry.UniqueTitle, PageEntry.BasicClassID, PageEntry.DisplayTitle, PageEntry.PageContent);
}
return(new JsonResult(JsonConvert.SerializeObject(lineAffected)));
}
public bool IsBasicEntry(Entry entry)
{
return(BasicClasses.Find(basicClassObj => basicClassObj.UniqueTitle == entry.UniqueTitle) != null);
}