public JsonResult GetInfo(string ID)
{
Sys_AdvertisingXmlHelper xh = new Sys_AdvertisingXmlHelper(System.Web.HttpContext.Current.Server.MapPath("~/App_Data/"));
Sys_Advertising Rmodel = xh.GetItemById(ID);
// groupsBiz.Add(rol);
return(Json(Rmodel, JsonRequestBehavior.AllowGet));
}
public JsonResult GetInfo(string ID)
{
var mql2 = Sys_AdvertisingSet.SelectAll().Where(Sys_AdvertisingSet.Id.Equal(ID));
Sys_Advertising Rmodel = OPBiz.GetEntity(mql2);
// groupsBiz.Add(rol);
return(MyJson(Rmodel, JsonRequestBehavior.AllowGet));
}
public JsonResult EditInfo(Sys_Advertising Sys_AdvertisingModle)
{
HttpReSultMode ReSultMode = new HttpReSultMode();
bool IsAdd = false;
Sys_AdvertisingModle.UpdateTime = DateTime.Now;
if (Sys_AdvertisingModle.Id == 0)//id为空，是添加
{
IsAdd = true;
Sys_AdvertisingModle.AddTime = DateTime.Now;
}
if (IsAdd)
{
Sys_AdvertisingModle.isDeleted = false;
try
{
OPBiz.Add(Sys_AdvertisingModle);
ReSultMode.Code = 11;
ReSultMode.Data = Sys_AdvertisingModle.Id.ToString();
ReSultMode.Msg = "添加成功";
}
catch (Exception e)
{
ReSultMode.Code = -11;
ReSultMode.Data = e.ToString();
ReSultMode.Msg = "添加失败";
}
}
else
{
Sys_AdvertisingModle.WhereExpression = Sys_AdvertisingSet.Id.Equal(Sys_AdvertisingModle.Id);
Sys_AdvertisingModle.ChangedMap.Remove("id");//移除主键值
if (OPBiz.Update(Sys_AdvertisingModle) > 0)
{
ReSultMode.Code = 11;
ReSultMode.Data = "";
ReSultMode.Msg = "修改成功";
}
else
{
ReSultMode.Code = -13;
ReSultMode.Data = "";
ReSultMode.Msg = "修改失败";
}
}
return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据分类获取
/// </summary>
/// <returns></returns>
public List <Sys_Advertising> GetByCategory(string Category)
{
List <Sys_Advertising> list = new List <Sys_Advertising>();
if (xmlDoc != null && root != null)
{
XmlNodeList nodeList = xmlDoc.SelectSingleNode("root").ChildNodes;
// 遍历根节点下所有子节点
foreach (XmlNode node in nodeList)
{
if (node["Category"].InnerText == Category)
{
Sys_Advertising item = new Sys_Advertising();
item.Id = int.Parse(node["Id"].InnerText);
item.ImageUrl = node["ImageUrl"].InnerText;
item.Title = node["Title"].InnerText;
item.Category = node["Category"].InnerText;
if (node["UpdateTime"].InnerText != "")
{
item.UpdateTime = Convert.ToDateTime(node["UpdateTime"].InnerText);
}
else
{
item.UpdateTime = DateTime.Now;
}
if (node["AddTime"].InnerText != "")
{
item.AddTime = Convert.ToDateTime(node["AddTime"].InnerText);
}
else
{
item.AddTime = DateTime.Now;
}
item.Details = node["Details"].InnerText;
item.Url = node["Url"].InnerText;
if (node["States"].InnerText != "")
{
item.States = Convert.ToInt32(node["States"].InnerText);
}
list.Add(item);
}
}
}
return(list);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="item"></param>
public int Update(Sys_Advertising item)
{
int rs = 0;
if (xmlDoc != null && root != null)
{
try
{
XmlNodeList nodeList = xmlDoc.SelectSingleNode("root").ChildNodes;
for (int i = nodeList.Count - 1; i >= 0; i--)
{
XmlNode node = nodeList[i];
if (node["Id"].InnerText == item.Id.ToString().Trim())
{
node["ImageUrl"].InnerText = item.ImageUrl;
node["Title"].InnerText = item.Title;
node["Category"].InnerText = item.Category;
node["UpdateTime"].InnerText = item.UpdateTime.ToString();
node["Details"].InnerText = item.Details;
node["Url"].InnerText = item.Url;
node["States"].InnerText = item.States.ToString();
node["UpdateTime"].InnerText = item.UpdateTime.ToString();
//保存文件
xmlDoc.Save(filePath);
rs = 1;
break;
}
}
}
catch
{
rs = -1;
}
}
return(rs);
}
public JsonResult EditInfo(Sys_Advertising Sys_AdvertisingModle)
{
Sys_AdvertisingXmlHelper xh = new Sys_AdvertisingXmlHelper(System.Web.HttpContext.Current.Server.MapPath("~/App_Data/"));
bool IsAdd = false;
if (Sys_AdvertisingModle.Details != null)
{
Sys_AdvertisingModle.Details = Sys_AdvertisingModle.Details.Replace("<", "<").Replace(">", ">");
}
if (Sys_AdvertisingModle.States == null)
{
Sys_AdvertisingModle.States = 1;
}
if (Sys_AdvertisingModle.Id == 0)//id为空，是添加
{
IsAdd = true;
}
if (IsAdd)
{
Sys_AdvertisingModle.UpdateTime = DateTime.Now;
Sys_AdvertisingModle.AddTime = DateTime.Now;
xh.Add(Sys_AdvertisingModle);
return(Json("ok", JsonRequestBehavior.AllowGet));
}
else
{
Sys_AdvertisingModle.UpdateTime = DateTime.Now;
if (xh.Update(Sys_AdvertisingModle) > 0)
{
return(Json("ok", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Nok", JsonRequestBehavior.AllowGet));
}
}
}
/// <summary>
/// 添加一条信息
/// </summary>
/// <param name="item"></param>
/// <returns>1添加成功 否则添加失败</returns>
public int Add(Sys_Advertising item)
{
int rs = 0;
if (xmlDoc != null && root != null)
{
try
{
//创建一个节点
XmlNode node = xmlDoc.CreateElement("Data");
//创建各元素
XmlElement Id = xmlDoc.CreateElement("Id");
Id.InnerText = item.Id.ToString();
node.AppendChild(Id);
XmlElement ImageUrl = xmlDoc.CreateElement("ImageUrl");
ImageUrl.InnerText = item.ImageUrl;
node.AppendChild(ImageUrl);
XmlElement Category = xmlDoc.CreateElement("Category");
Category.InnerText = item.Category;
node.AppendChild(Category);
XmlElement Title = xmlDoc.CreateElement("Title");
Title.InnerText = item.Title;
node.AppendChild(Title);
XmlElement Details = xmlDoc.CreateElement("Details");
Details.InnerText = item.Details;
node.AppendChild(Details);
XmlElement Url = xmlDoc.CreateElement("Url");
Url.InnerText = item.Url;
node.AppendChild(Url);
XmlElement AddTime = xmlDoc.CreateElement("AddTime");
AddTime.InnerText = item.AddTime.ToString();
node.AppendChild(AddTime);
XmlElement UpdateTime = xmlDoc.CreateElement("UpdateTime");
UpdateTime.InnerText = item.UpdateTime.ToString();
node.AppendChild(UpdateTime);
XmlElement States = xmlDoc.CreateElement("States");
States.InnerText = item.States.ToString();
node.AppendChild(States);
//将节点添加到根节点
root.AppendChild(node);
//保存文件
xmlDoc.Save(filePath);
rs = 1;
}
catch
{
rs = -1;
}
}
return(rs);
}
/// <summary>
/// 获取一条记录
/// </summary>
/// <returns></returns>
public Sys_Advertising GetItemById(string Id)
{
Sys_Advertising item = null;
try
{
if (xmlDoc != null && root != null)
{
XmlNodeList nodeList = xmlDoc.SelectSingleNode("root").ChildNodes;
foreach (XmlNode node in nodeList)
{
if (string.IsNullOrEmpty(Id))
{
item = new Sys_Advertising();
item.Id = int.Parse(node["Id"].InnerText);
item.ImageUrl = node["ImageUrl"].InnerText;
item.Title = node["Title"].InnerText;
item.Category = node["Category"].InnerText;
if (node["UpdateTime"].InnerText != "")
{
item.UpdateTime = Convert.ToDateTime(node["UpdateTime"].InnerText);
}
else
{
item.UpdateTime = DateTime.Now;
}
if (node["AddTime"].InnerText != "")
{
item.AddTime = Convert.ToDateTime(node["AddTime"].InnerText);
}
else
{
item.AddTime = DateTime.Now;
}
item.Details = node["Details"].InnerText;
item.Url = node["Url"].InnerText;
if (node["States"].InnerText != "")
{
item.States = Convert.ToInt32(node["States"].InnerText);
}
break;
}
else if (node["Id"].InnerText == Id)
{
item = new Sys_Advertising();
item.Id = int.Parse(node["Id"].InnerText);
item.ImageUrl = node["ImageUrl"].InnerText;
item.Title = node["Title"].InnerText;
item.Category = node["Category"].InnerText;
if (node["UpdateTime"].InnerText != "")
{
item.UpdateTime = Convert.ToDateTime(node["UpdateTime"].InnerText);
}
else
{
item.UpdateTime = DateTime.Now;
}
if (node["AddTime"].InnerText != "")
{
item.AddTime = Convert.ToDateTime(node["AddTime"].InnerText);
}
else
{
item.AddTime = DateTime.Now;
}
item.Details = node["Details"].InnerText;
item.Url = node["Url"].InnerText;
if (node["States"].InnerText != "")
{
item.States = Convert.ToInt32(node["States"].InnerText);
}
break;
}
}
}
}
catch
{ }
return(item);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
// context.Response.Write("Hello World");
// /httpSever/AdvertisingHandler.ashx?json={"jsonEntity":{"Category":"0201"},"action":"GetByCategory"}
HttpReSultMode resultMode = new HttpReSultMode();
Sys_AdvertisingBiz OPBiz = new Sys_AdvertisingBiz();
try
{
JObject httpObject = JsonHelper.FromJson(context.Request["json"]);
switch (httpObject["action"].ToString())
{
case "GetByCategory":
#region
List <Sys_Advertising> list = new List <Sys_Advertising>();
if (httpObject["jsonEntity"]["Category"] != null) //分类
{
string Category = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Category"].ToString());
var sqlm = Sys_AdvertisingSet.SelectAll().Where(Sys_AdvertisingSet.Category.Equal(Category).And(Sys_AdvertisingSet.States.Equal(1)).And(Sys_AdvertisingSet.isDeleted.Equal(0)));
list = OPBiz.GetEntities(sqlm);
}
else
{
var sqlm = Sys_AdvertisingSet.SelectAll().Where(Sys_AdvertisingSet.States.Equal(1).And(Sys_AdvertisingSet.isDeleted.Equal(0)));
list = OPBiz.GetEntities(sqlm);
}
if (list.Count > 0)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(list, true);
}
else
{
resultMode.Code = 0;
resultMode.Msg = "没有数据";
resultMode.Data = "[]";
}
#endregion
break;
case "GetById":
#region
string IdG = httpObject["jsonEntity"]["Id"].ToString();
var sqlO = Sys_AdvertisingSet.SelectAll().Where(Sys_AdvertisingSet.Id.Equal(IdG));
Sys_Advertising modelG = OPBiz.GetEntity(sqlO);
if (modelG != null)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(modelG, true);
}
else
{
resultMode.Code = -13;
resultMode.Msg = "数据不存在";
resultMode.Data = "";
}
#endregion
break;
}
}
catch (Exception ex)
{
resultMode.Code = -11;
resultMode.Data = ex.ToString();
}
context.Response.Write(JsonHelper.ToJson(resultMode, true));
context.Response.End();
}