public JsonResult GetInfo(string ID)
{
var mql2 = TS_CarSet.SelectAll().Where(TS_CarSet.Id.Equal(ID));
TS_Car Rmodel = OPBiz.GetEntity(mql2);
// groupsBiz.Add(rol);
return(MyJson(Rmodel, JsonRequestBehavior.AllowGet));
}
public JsonResult EditInfo(TS_Car TS_CarModle)
{
HttpReSultMode ReSultMode = new HttpReSultMode();
bool IsAdd = false;
if (TS_CarModle.Details != null)
{
TS_CarModle.Details = TS_CarModle.Details.Replace("<", "<").Replace(">", ">");
}
else
{
TS_CarModle.Details = "";
}
TS_CarModle.UpdateTime = DateTime.Now;
if (!(TS_CarModle.Id != null && !TS_CarModle.Id.ToString().Equals("00000000-0000-0000-0000-000000000000")))//id为空，是添加
{
IsAdd = true;
}
if (IsAdd)
{
TS_CarModle.isDeleted = false;
TS_CarModle.isValid = 1;
TS_CarModle.Id = Guid.NewGuid();
TS_CarModle.CreateTime = DateTime.Now;
TS_CarModle.States = 0;
TS_CarModle.CreateManId = UserData.Id;
TS_CarModle.Praises = 0;
try
{
OPBiz.Add(TS_CarModle);
ReSultMode.Code = 11;
ReSultMode.Data = TS_CarModle.Id.ToString();
ReSultMode.Msg = "添加成功";
}
catch (Exception e) {
ReSultMode.Code = -11;
ReSultMode.Data = e.ToString();
ReSultMode.Msg = "添加失败";
}
}
else
{
TS_CarModle.WhereExpression = TS_CarSet.Id.Equal(TS_CarModle.Id);
//TS_CarModle.ChangedMap.Remove("doctorid");//移除主键值
if (OPBiz.Update(TS_CarModle) > 0)
{
ReSultMode.Code = 11;
ReSultMode.Data = "";
ReSultMode.Msg = "修改成功";
}
else
{
ReSultMode.Code = -13;
ReSultMode.Data = "";
ReSultMode.Msg = "修改失败";
}
}
return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
}
public JsonResult EditInfo(TS_Car DitModle)
{
HttpReSultMode ReSultMode = new HttpReSultMode();
bool IsAdd = false;
if (DitModle.Details != null)
{
DitModle.Details = DitModle.Details.Replace("<", "<").Replace(">", ">");
}
else
{
DitModle.Details = "";
}
DitModle.UpdateTime = DateTime.Now;
if (!(DitModle.Id != null && !DitModle.Id.ToString().Equals("00000000-0000-0000-0000-000000000000")))//id为空，是添加
{
IsAdd = true;
}
if (IsAdd)
{
#region 初始化
DitModle.Id = Guid.NewGuid();
DitModle.CreateTime = DateTime.Now;
DitModle.CreateManId = UserData.Id;
DitModle.Praises = 0;
DitModle.States = 0;
DitModle.isDeleted = false;
DitModle.isValid = 1;
DitModle.Star = 1;
#endregion
try
{
OPBiz.Add(DitModle);
ReSultMode.Code = 11;
ReSultMode.Data = DitModle.Id.ToString();
ReSultMode.Msg = "添加成功";
}
catch (Exception e) {
ReSultMode.Code = -11;
ReSultMode.Data = e.ToString();
ReSultMode.Msg = "添加失败";
}
}
else
{
DitModle.WhereExpression = TS_CarSet.Id.Equal(DitModle.Id);
//DitModle.ChangedMap.Remove("doctorid");//移除主键值
var mqlO = TS_CarSet.SelectAll().Where(TS_CarSet.Id.Equal(DitModle.Id));
TS_Car modelOld = OPBiz.GetEntity(mqlO);//旧数据
#region 能修改的数据
DitModle.CreateTime = modelOld.CreateTime;
DitModle.CreateManId = modelOld.CreateManId;
DitModle.Praises = modelOld.Praises;
DitModle.States = modelOld.States;
DitModle.isDeleted = modelOld.isDeleted;
DitModle.isValid = modelOld.isValid;
DitModle.Star = modelOld.Star;
#endregion
if (OPBiz.Update(DitModle) > 0)
{
ReSultMode.Code = 11;
ReSultMode.Data = "";
ReSultMode.Msg = "修改成功";
}
else
{
ReSultMode.Code = -13;
ReSultMode.Data = "";
ReSultMode.Msg = "修改失败";
}
}
return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
}
// 请求例子 /httpSever/TS_CarHandler.ashx?json={"jsonEntity":{"Category":"08","ShopId":"d6807c66-c4fb-4350-83fd-afd19cb82693"},"pageIndex":"1","pageSize":"20","action":"Searh"}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
// context.Response.Write("Hello World");
HttpReSultMode resultMode = new HttpReSultMode();
string Id = "";
int res = 0;//返回结果行数
try
{
JObject httpObject = JsonHelper.FromJson(context.Request["json"]);
int pageIndex = 1;
int pageSize = 10000;
//string Longitude="";
//string Latitude="";
string ShopId = "";
DataSet ds = new DataSet();
switch (httpObject["action"].ToString())
{
case "Searh": //根据店铺分类分页获取
#region
if (httpObject["pageIndex"] != null)
{
pageIndex = int.Parse(httpObject["pageIndex"].ToString());
}
if (httpObject["pageSize"] != null)
{
pageSize = int.Parse(httpObject["pageSize"].ToString());
}
ShopId = FilterTools.FilterSpecial(httpObject["jsonEntity"]["ShopId"].ToString());
string Where = " ShopId='" + ShopId + "' and (isDeleted=0) ";
if (httpObject["jsonEntity"]["Category"] != null)
{
string Category = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Category"].ToString());
Where += " and ( Category like '" + Category + "%')";
}
ds = OPBiz.GetPagingDataSet(Where, pageIndex, pageSize, " CreateTime desc ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(ds.Tables[0], true);
}
else
{
resultMode.Code = 0;
resultMode.Msg = "没有数据";
resultMode.Data = "[]";
}
#endregion
break;
case "GetById":
#region
Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString());
var mqlG = TS_CarSet.SelectAll().Where(TS_CarSet.Id.Equal(Id));
TS_Car modelG = OPBiz.GetEntity(mqlG);
if (modelG != null)
{
resultMode.Code = 11;
resultMode.Msg = "获取成功";
resultMode.Data = JsonHelper.ToJson(modelG, true);
}
else
{
resultMode.Code = -13;
resultMode.Msg = "数据不存在";
resultMode.Data = "";
}
#endregion
break;
case "PraiseCount": //点赞量加1
Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString());
res = OPBiz.SetCout("Id", Id, "Praises");
if (res > 0)
{
resultMode.Code = 11;
resultMode.Data = res.ToString();
resultMode.Msg = "统计成功";
}
else
{
resultMode.Code = -13;
resultMode.Data = "0";
resultMode.Msg = "统计失败！";
}
break;
}
}
catch (Exception ex)
{
resultMode.Code = -11;
resultMode.Data = ex.ToString();
}
context.Response.Write(JsonHelper.ToJson(resultMode, true));
context.Response.End();
}
