//推荐链接解码 public ActionResult decoderRecommendUrl() { string recommendId = FilterTools.FilterSpecial(DESProvider.Decrypt(Request["param"], ConstantList.ENCRYPT_KEY)); string type = FilterTools.FilterSpecial(Request["type"]); if (type.Equals("recommend")) { if (GetUData == null) { GetUData = new Models.UserData(); } GetUData.User_Id = getUserIdByRecommendId(recommendId); return(Redirect(redirctUrl("home"))); } return(View()); }
//添加用户到表 private void addUser(LoginModel model, DateTime now, Guid guid) { User newUser = new User(); newUser.UserId = guid; //特殊字符过滤 newUser.LoginName = FilterTools.FilterSpecial(model.Phone); newUser.Password = DESProvider.Encrypt(FilterTools.FilterSpecial(model.FirstPassword), ConstantList.PASSWORD_ENCRYPT); newUser.WeiXinId = GetUData.OpenId; newUser.TrueName = ""; newUser.CreateTime = now; newUser.UpdateTime = now; newUser.isDeleted = false; UserBiz userBiz = new UserBiz(); userBiz.Add(newUser); }
public static string GetSql(string sqlSet) { string[] data = sqlSet.Split('█'); string sql = " 1=1 "; if (!string.IsNullOrEmpty(sqlSet)) { for (int i = 0; i < data.Length; i++) { int index = data[i].IndexOf(":"); var nameData = data[i].Substring(0, index); string[] name = nameData.Split('_'); string value = FilterTools.FilterSpecial(data[i].Substring(index + 1)); sql += " and " + GetOP(name[0], name[1], value); } } return(sql); }
////获取用户头像 //private string getUserImg() //{ // string imgUrl = GetUData.Head_Img_Url; // if (imgUrl != null) // { // return imgUrl; // } // else // { // AppUserInfoBiz userInfoBiz = new AppUserInfoBiz(); // DataSet result = userInfoBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserInfoByWeiXinId] '" + GetUData.OpenId + "'"); // if (result.Tables[0].Rows.Count > 0) // { // imgUrl = result.Tables[0].Rows[0]["ImgeUrl"].ToString(); // } // } // return imgUrl; //} //添加用户到推荐表 private void addUserReferences(Guid userId, Guid toUserId) { ReferencesBiz referencesBiz = new ReferencesBiz(); DataSet result = referencesBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetIdByUserId] '" + userId + "'"); string recommendId = result.Tables[0].Rows[0]["Id"].ToString(); References references = new References(); references.UserId = userId; references.ToUserId = toUserId; references.InvitationCode = FilterTools.FilterSpecial(recommendId); references.States = ConstantList.INVITE_SUCCESS; references.CategoryId = ConstantList.NORMAL_USER; references.AddTime = DateTime.Now; references.isDeleted = false; referencesBiz.Add(references); }
//添加用户信息到表 private void addUserInfo(DateTime now, Guid guid, LoginModel model) { AppUserInfo userInfo = new AppUserInfo(); userInfo.AppUserInfoId = Guid.NewGuid(); userInfo.UserId = guid; //特殊字符过滤 userInfo.Phone = FilterTools.FilterSpecial(model.Phone); userInfo.Nickname = FilterTools.FilterSpecial(GetUData.Nick_Name); userInfo.ImgeUrl = GetUData.Head_Img_Url; userInfo.ReferencesId = GetUData.User_Id; userInfo.AddTime = now; userInfo.UpdateTime = now; userInfo.isDeleted = false; AppUserInfoBiz userInfoBiz = new AppUserInfoBiz(); userInfoBiz.Add(userInfo); }
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(); }
public string GetData(HttpContext context) { HttpReSultMode resultMode = new HttpReSultMode(); try { int pageIndex = int.Parse(context.Request["Pageindex"]); int pageSize = int.Parse(context.Request["Pagesize"]); DataSet ds; #region 条件 StringBuilder Where = new StringBuilder(); Where.Append(" isDeleted=0 and States>0"); if (context.Request["keyWords"] != null)//关键词 { string KeyWords = FilterTools.FilterSpecial(context.Request["keyWords"].ToString()); Where.Append(" and( TName like '%" + KeyWords + "%'"); Where.Append(" or Address like '%" + KeyWords + "%' "); Where.Append(" or Details like '%" + KeyWords + "%') "); } if (context.Request["Category"] != null)//分类 { string Category = FilterTools.FilterSpecial(context.Request["Category"].ToString()); Where.Append(" and ( Category like '" + Category + "%')"); } #endregion #region 坐标 有距离 if (context.Request["Lng"] != null && context.Request["Lat"] != null)//传有坐标按距离排序 { string Longitude = context.Request["Lng"].ToString(); string Latitude = context.Request["Lat"].ToString(); //分页 按距离排序 string geohashWhere = Geohash.getsqlGeoHash(5, Latitude, Longitude, "geohash"); string sqlWhere = Where.ToString() + " and " + geohashWhere;//条件加geohash ds = OPBiz.GetPagingOrderByLL(sqlWhere, pageIndex, pageSize, Longitude, Latitude); } else //简单分页无排序 { ds = OPBiz.GetPagingDataSet(Where.ToString(), pageIndex, pageSize, "CreateTime desc"); } #endregion 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 = "[]"; } } catch (Exception ex) { resultMode.Code = -11; resultMode.Data = ex.ToString(); } string result = JsonHelper.ToJson(resultMode, true); return(result); ; }
public void ProcessRequest(HttpContext context) { string action = context.Request["action"]; context.Response.ContentType = "text/plain"; // context.Response.Write("Hello World"); string Id = ""; int res = 0;//返回结果行数 HttpReSultMode resultMode = new HttpReSultMode(); switch (action) { case "GetData": context.Response.Write(GetData(context)); context.Response.End(); break; case "ClickCount": //点击量 Id = FilterTools.FilterSpecial(context.Request["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "Clicks"); if (res > 0) { resultMode.Code = 11; resultMode.Data = res.ToString(); resultMode.Msg = "统计成功"; } else { resultMode.Code = -13; resultMode.Data = "0"; resultMode.Msg = "统计失败!"; } break; case "PraiseCount": //点赞量加1 Id = FilterTools.FilterSpecial(context.Request["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; case "CallCount": //呼叫量加1 Id = FilterTools.FilterSpecial(context.Request["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "CallCount"); if (res > 0) { resultMode.Code = 11; resultMode.Data = res.ToString(); resultMode.Msg = "统计成功"; } else { resultMode.Code = -13; resultMode.Data = "0"; resultMode.Msg = "统计失败!"; } break; } }
// 请求例子 /httpSever/TS_TransactionHandler.ashx?json={"jsonEntity":{"Category":"09","Longitude":"110.22587","Latitude":"25.272585"},"pageIndex":"1","pageSize":"20","action":"GetByCategory"} 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"]); switch (httpObject["action"].ToString()) { case "GetById": #region Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); var mqlG = TS_TransactionSet.SelectAll().Where(TS_TransactionSet.Id.Equal(Id)); TS_Transaction 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 "GetByCategory": this.GetByCategory(context, httpObject, resultMode); break; case "add": #region TS_Transaction Rmodel = JsonHelper.FromJson <TS_Transaction>(httpObject["jsonEntity"].ToString()); Rmodel.Id = Guid.NewGuid(); Rmodel.CreateTime = DateTime.Now; Rmodel.CreateTime = DateTime.Now; Rmodel.isDeleted = false; Rmodel.isValid = 1; Rmodel.Clicks = 0; Rmodel.Praises = 0; Rmodel.CallCount = 0; Rmodel.States = 0; Rmodel.isTop = 0; if (Rmodel.Longitude != null && Rmodel.Latitude != null) //geohash编码 { double Latitude = double.Parse(Rmodel.Latitude.ToString()); double Longitude = double.Parse(Rmodel.Longitude.ToString()); Rmodel.geohash = Geohash.Encode(Latitude, Longitude); } OPBiz.Add(Rmodel); resultMode.Code = 11; resultMode.Msg = "添加成功"; resultMode.Data = Rmodel.Id.ToString(); #endregion break; case "update": #region TS_Transaction Rmodel2 = JsonHelper.FromJson <TS_Transaction>(httpObject["jsonEntity"].ToString()); var mqlu = TS_TransactionSet.SelectAll().Where(TS_TransactionSet.Id.Equal(Rmodel2.Id)); TS_Transaction modelu = OPBiz.GetEntity(mqlu); Rmodel2.CreateTime = modelu.CreateTime; Rmodel2.CreateTime = DateTime.Now; Rmodel2.isDeleted = modelu.isDeleted; Rmodel2.isValid = modelu.isValid; Rmodel2.Clicks = modelu.Clicks; Rmodel2.Praises = modelu.Praises; Rmodel2.CallCount = modelu.CallCount; Rmodel2.States = modelu.States; if (Rmodel2.Longitude != null && Rmodel2.Latitude != null) //geohash编码 { double Latitude = double.Parse(Rmodel2.Latitude.ToString()); double Longitude = double.Parse(Rmodel2.Longitude.ToString()); Rmodel2.geohash = Geohash.Encode(Latitude, Longitude); } Rmodel2.WhereExpression = TS_TransactionSet.Id.Equal(Rmodel2.Id); Rmodel2.UpdateTime = DateTime.Now; if (OPBiz.Update(Rmodel2) > 0) { resultMode.Code = 11; resultMode.Msg = "更新成功"; resultMode.Data = ""; } else { resultMode.Code = -13; resultMode.Msg = "更新失败"; resultMode.Data = ""; } #endregion break; case "ClickCount": //点击量 Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "Clicks"); if (res > 0) { resultMode.Code = 11; resultMode.Data = res.ToString(); resultMode.Msg = "统计成功"; } else { resultMode.Code = -13; resultMode.Data = "0"; resultMode.Msg = "统计失败!"; } 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; case "CallCount": //呼叫量加1 Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "CallCount"); 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(); }
/// <summary> /// 分类分页获取 /// </summary> /// <param name="context"></param> /// <param name="httpObject"></param> /// <param name="resultMode"></param> private void GetByCategory(HttpContext context, JObject httpObject, HttpReSultMode resultMode) { int pageIndex = 1; int pageSize = 10000; DataSet ds; #region if (httpObject["pageIndex"] != null) { pageIndex = int.Parse(httpObject["pageIndex"].ToString()); } if (httpObject["pageSize"] != null) { pageSize = int.Parse(httpObject["pageSize"].ToString()); } #region 条件 StringBuilder Where = new StringBuilder(); Where.Append(" isDeleted=0 and States>=0 "); if (httpObject["jsonEntity"]["KeyWords"] != null)//关键词 { string KeyWords = FilterTools.FilterSpecial(httpObject["jsonEntity"]["KeyWords"].ToString()); Where.Append(" and( Title like '%" + KeyWords + "%'"); Where.Append(" or Address like '%" + KeyWords + "%') "); } if (httpObject["jsonEntity"]["Category"] != null)//分类 { string Category = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Category"].ToString()); Where.Append(" and ( Category like '" + Category + "%')"); } if (httpObject["jsonEntity"]["MinPrice"] != null)//最低价 { string MinPrice = FilterTools.FilterSpecial(httpObject["jsonEntity"]["MinPrice"].ToString()); Where.Append(" and ( Price >" + MinPrice + ")"); } if (httpObject["jsonEntity"]["MaxPrice"] != null)//最高价 { string MaxPrice = FilterTools.FilterSpecial(httpObject["jsonEntity"]["MaxPrice"].ToString()); Where.Append(" and ( Price <" + MaxPrice + ")"); } if (httpObject["jsonEntity"]["ProvinceCode"] != null)//省 { string ProvinceCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["ProvinceCode"].ToString()); Where.Append(" and ( ProvinceCode like '" + ProvinceCode + "%')"); } if (httpObject["jsonEntity"]["CityCode"] != null)//城市 { string CityCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["CityCode"].ToString()); Where.Append(" and ( CityCode like '" + CityCode + "%')"); } if (httpObject["jsonEntity"]["AreaCode"] != null)//区 { string AreaCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["AreaCode"].ToString()); Where.Append(" and ( AreaCode like '" + AreaCode + "%')"); } #endregion #region 坐标 有距离 if (httpObject["jsonEntity"]["Longitude"] != null && httpObject["jsonEntity"]["Latitude"] != null)//传有坐标按距离排序 { string Longitude = httpObject["jsonEntity"]["Longitude"].ToString(); string Latitude = httpObject["jsonEntity"]["Latitude"].ToString(); string geohashWhere = Geohash.getsqlGeoHash(5, Latitude, Longitude, "geohash"); string sqlWhere = Where.ToString() + " and " + geohashWhere; //条件加geohash if (httpObject["jsonEntity"]["minKM"] != null && httpObject["jsonEntity"]["maxKM"] != null) //有最小最大距离约定,按距离排序, 不分页 { float minKM = float.Parse(httpObject["jsonEntity"]["minKM"].ToString()); float maxKM = float.Parse(httpObject["jsonEntity"]["maxKM"].ToString()); ds = OPBiz.GetByDistancesOrderByLL("v_TS_Transaction", sqlWhere, minKM, maxKM, Longitude, Latitude); } else //分页 按距离排序 { ds = OPBiz.GetPagingOrderByLL("v_TS_Transaction", sqlWhere, pageIndex, pageSize, Longitude, Latitude); } } else //简单分页无排序 { ds = OPBiz.GetPagingDataSet("v_TS_Transaction", Where.ToString(), pageIndex, pageSize, "CreateTime desc"); } #endregion 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 context.Response.Write(JsonHelper.ToJson(resultMode, true)); context.Response.End(); }
// 请求例子 /httpSever/TS_ServiceHandler.ashx?json={"jsonEntity":{"Category":"07","CityCode":"4502","Longitude":"110.22587","Latitude":"25.272585"},"pageIndex":"1","pageSize":"20","action":"GetByCategory"} 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"]); switch (httpObject["action"].ToString()) { case "GetByCategory": this.GetByCategory(context, httpObject, resultMode); break; case "GetById": #region Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); var mqlG = TS_ServiceSet.SelectAll().Where(TS_ServiceSet.Id.Equal(Id)); TS_Service 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 "ClickCount": //点击量 Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "Clicks"); if (res > 0) { resultMode.Code = 11; resultMode.Data = res.ToString(); resultMode.Msg = "统计成功"; } else { resultMode.Code = -13; resultMode.Data = "0"; resultMode.Msg = "统计失败!"; } 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; case "CallCount": //呼叫量加1 Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "CallCount"); 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(); }
// 请求例子 /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(); }
public JsonResult GetSetInfo() { int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); string Where = " (isDeleted=0) and (States>0)"; if (Request["KeyWords"] != null)//关键词 { string KeyWords = FilterTools.FilterSpecial(Request["KeyWords"].ToString()); Where += " and( TName like '%" + KeyWords + "%'"; Where += " or UserName like '%" + KeyWords + "%' "; Where += " or TrueName like '%" + KeyWords + "%' "; Where += " or Phone like '%" + KeyWords + "%') "; } string types = Request["types"].ToString(); //类型 string table = ""; //数据表 switch (types) { case "1": //店铺 table = "v_TS_Shop"; break; case "2": //便民服务 table = "v_TS_Service"; break; case "3": //维修店 table = "v_TS_RepairShop"; break; case "4": //便民信息 table = "v_TS_ServiceNew"; break; } ////字段排序 String sortField = Request["sort"]; String sortOrder = Request["order"]; PageClass pc = new PageClass(); pc.sys_Fields = "*"; pc.sys_Key = "Id"; pc.sys_PageIndex = pageIndex; pc.sys_PageSize = pageSize; pc.sys_Table = table; pc.sys_Where = Where; pc.sys_Order = " " + sortField + " " + sortOrder; Dictionary <string, object> dic = new Dictionary <string, object>(); switch (types) //四种数据类型 { case "1": //店铺 List <v_TS_Shop> list1 = OPBiz.GetPagingData <v_TS_Shop>(pc); dic.Add("rows", list1); break; case "2": //便民服务 List <v_TS_Service> list2 = OPBiz.GetPagingData <v_TS_Service>(pc); dic.Add("rows", list2); break; case "3": //维修店 List <v_TS_RepairShop> list3 = OPBiz.GetPagingData <v_TS_RepairShop>(pc); dic.Add("rows", list3); break; case "4": //便民信息 List <v_TS_ServiceNew> list4 = OPBiz.GetPagingData <v_TS_ServiceNew>(pc); dic.Add("rows", list4); break; } dic.Add("total", pc.RCount); return(MyJson(dic, JsonRequestBehavior.AllowGet)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); string action = context.Request["action"]; HttpReSultMode jmsg = new HttpReSultMode(); switch (action) { case "addImg": //上传单图片 返回文件信息json jmsg = addImg(context); context.Response.Write(JsonHelper.ToJson(jmsg)); context.Response.End(); break; case "addFile": //上传文件 返回文件信息json jmsg = addFile(context); context.Response.Write(JsonHelper.ToJson(jmsg)); context.Response.End(); break; case "GetFileList": //根据id集获取文件列表 #region string id = context.Request["ToId"]; string SourceTable = context.Request["SourceTable"]; if (!string.IsNullOrEmpty(id)) { var mql = TT_FilesInsuranSet.SelectAll().Where(TT_FilesInsuranSet.ToId.Equal(id).And(TT_FilesInsuranSet.SourceTable.Equal(SourceTable))); List <TT_FilesInsuran> list = OPBiz.GetOwnList(mql); context.Response.Write(JsonHelper.ToJson(list, true)); } else { context.Response.Write("[]"); } context.Response.End(); #endregion break; case "SaveToid": //保存更改ToID #region string Tid = FilterTools.FilterSpecial(context.Request["ToId"]); string IdSet = FilterTools.FilterSpecial(context.Request["IdSet"]); if (!string.IsNullOrEmpty(context.Request["ToId"]) && !string.IsNullOrEmpty(context.Request["IdSet"])) { string sql = " update TT_FilesInsuran set ToId='" + Tid + "' where FileId in (" + IdSet + ")"; int i = OPBiz.ExecuteSqlWithNonQuery(sql); if (i > 0) { jmsg.Code = 11; jmsg.Data = i.ToString(); jmsg.Msg = "上传成功"; } else { jmsg.Code = -11; jmsg.Data = "0"; jmsg.Msg = "上传失败"; } } else { jmsg.Code = -11; jmsg.Data = "0"; jmsg.Msg = "数据为空"; } context.Response.Write(JsonHelper.ToJson(jmsg, true)); context.Response.End(); #endregion break; case "Delfile": //删除文件 #region if (!string.IsNullOrEmpty(context.Request["IdSet"])) { string[] IDSet = context.Request["IdSet"].ToString().Split(','); var mql2 = TT_FilesInsuranSet.FileId.In(IDSet); var selectm = TT_FilesInsuranSet.SelectAll().Where(mql2); List <TT_FilesInsuran> listDel = OPBiz.GetEntities(selectm); //数据库删除 int f = OPBiz.Remove <TT_FilesInsuranSet>(mql2); if (f > 0) { jmsg.Code = 11; jmsg.Data = f.ToString(); jmsg.Msg = "删除成功"; #region 文件删除 try { string HttpFileRoute = ConfigurationManager.AppSettings["HttpFileRoute"].ToString(); //文件保存本地路径根目录 for (int i = 0; i < listDel.Count; i++) { string path = HttpFileRoute + listDel[i].RelativePath; ZFiles.FilePicDelete(path); } } catch (Exception ex) { //jmsg.Code = -13; //jmsg.Data = ex.Message; //jmsg.Msg = "删除失败"; } #endregion } else { jmsg.Code = -11; jmsg.Data = "0"; jmsg.Msg = "删除失败"; } } else { jmsg.Code = -11; jmsg.Data = "0"; jmsg.Msg = "数据为空"; } context.Response.Write(JsonHelper.ToJson(jmsg, true)); context.Response.End(); #endregion break; case "Download": #region if (!string.IsNullOrEmpty(context.Request["Url"])) { // 检查请求下载文件的有效性 string filePath = System.Web.HttpContext.Current.Server.MapPath(context.Request["Url"]); if (!System.IO.File.Exists(filePath)) { throw new ArgumentException("无效文件,文件不存在!"); } //WriteFile实现下载 string fileName = context.Request["fileName"]; //客户端保存的文件名 FileInfo fileInfo = new FileInfo(filePath); context.Response.Clear(); context.Response.ClearContent(); context.Response.ClearHeaders(); context.Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName); context.Response.AddHeader("Content-Length", fileInfo.Length.ToString()); context.Response.AddHeader("Content-Transfer-Encoding", "binary"); context.Response.ContentType = "application/octet-stream"; context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); context.Response.WriteFile(fileInfo.FullName); context.Response.Flush(); context.Response.End(); } #endregion break; } }
// 请求例子 /httpSever/TS_ClientUserHandler.ashx?json={"jsonEntity":{"UserName":"******","Pwd":"123456"},"action":"Login"} // 请求例子 /httpSever/TS_ClientUserHandler.ashx?json={"jsonEntity":{"UserName":"******","Pwd":"123456"},"action":"Register"} public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; // context.Response.Write("Hello World"); HttpReSultMode resultMode = new HttpReSultMode(); try { JObject httpObject = JsonHelper.FromJson(context.Request["json"]); // JObject ObjectParameter = (JObject)JsonConvert.DeserializeObject(httpObject["jsonEntity"].ObjToStr()); string jsonData = httpObject["jsonEntity"].ToString(); string UserName = ""; string Pwd = ""; switch (httpObject["action"].ToString()) { case "Register": UserName = FilterTools.FilterSpecial(httpObject["jsonEntity"]["UserName"].ToString()); var registermql = TS_ClientUserSet.SelectAll().Where(TS_ClientUserSet.UserName.Equal(UserName)); TS_ClientUser registermodel = OPBiz.GetEntity(registermql); if (registermodel != null) { resultMode.Code = -13; resultMode.Msg = "用户已经存在"; resultMode.Data = ""; } else { TS_ClientUser Rmodel = JsonHelper.FromJson <TS_ClientUser>(jsonData); Rmodel.Id = Guid.NewGuid(); Rmodel.AddTime = DateTime.Now; Rmodel.UpdateTime = DateTime.Now; Rmodel.LocationUpdateTime = DateTime.Now; Rmodel.isDeleted = false; Rmodel.States = 0; if (Rmodel.Longitude != null && Rmodel.Latitude != null) //geohash编码 { double Latitude = double.Parse(Rmodel.Latitude.ToString()); double Longitude = double.Parse(Rmodel.Longitude.ToString()); Rmodel.geohash = Geohash.Encode(Latitude, Longitude); } OPBiz.Add(Rmodel); resultMode.Code = 11; resultMode.Msg = "注册成功"; resultMode.Data = Rmodel.Id.ToString(); } break; case "Login": UserName = FilterTools.FilterSpecial(httpObject["jsonEntity"]["UserName"].ToString()); Pwd = httpObject["jsonEntity"]["Pwd"].ToString(); var Loginmql = TS_ClientUserSet.SelectAll().Where(TS_ClientUserSet.UserName.Equal(UserName).And(TS_ClientUserSet.Pwd.Equal(Pwd))); TS_ClientUser Loginmodel = OPBiz.GetEntity(Loginmql); if (Loginmodel != null) { resultMode.Code = 11; resultMode.Msg = "登录成功"; resultMode.Data = JsonHelper.ToJson(Loginmodel, true); } else { resultMode.Code = -13; resultMode.Msg = "用户或密码错误"; resultMode.Data = ""; } break; case "ChangePassword": UserName = FilterTools.FilterSpecial(httpObject["jsonEntity"]["UserName"].ToString()); Pwd = httpObject["jsonEntity"]["Pwd"].ToString(); var mqlG = TS_ClientUserSet.SelectAll().Where(TS_ClientUserSet.UserName.Equal(UserName)); TS_ClientUser modelG = OPBiz.GetEntity(mqlG); if (modelG != null) { modelG.Pwd = Pwd; modelG.UpdateTime = DateTime.Now; modelG.WhereExpression = TS_ClientUserSet.Id.Equal(modelG.Id); if (OPBiz.Update(modelG) > 0) { resultMode.Code = 11; resultMode.Msg = "修改密码成功"; resultMode.Data = ""; } else { resultMode.Code = -13; resultMode.Msg = "修改失败"; resultMode.Data = ""; } } else { resultMode.Code = -13; resultMode.Msg = "用户不存在"; resultMode.Data = ""; } break; case "update": this.update(context, httpObject); break; } } catch (Exception ex) { resultMode.Code = -1; resultMode.Data = ex.ToString(); } context.Response.Write(JsonHelper.ToJson(resultMode, true)); context.Response.End(); }
/// <summary> /// 分类分页获取 /// </summary> /// <param name="context"></param> /// <param name="httpObject"></param> /// <param name="resultMode"></param> private void GetByCategory(HttpContext context, JObject httpObject, HttpReSultMode resultMode) { int pageIndex = 1; int pageSize = 10000; DataSet ds; #region if (httpObject["pageIndex"] != null) { pageIndex = int.Parse(httpObject["pageIndex"].ToString()); } if (httpObject["pageSize"] != null) { pageSize = int.Parse(httpObject["pageSize"].ToString()); } #region 条件 StringBuilder Where = new StringBuilder(); Where.Append(" isDeleted=0 "); if (httpObject["jsonEntity"]["KeyWords"] != null)//关键词 { string KeyWords = FilterTools.FilterSpecial(httpObject["jsonEntity"]["KeyWords"].ToString()); Where.Append(" and( TName like '%" + KeyWords + "%'"); Where.Append(" or Address like '%" + KeyWords + "%') "); } if (httpObject["jsonEntity"]["Category"] != null)//分类 { string Category = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Category"].ToString()); Where.Append(" and ( Category like '" + Category + "%')"); } if (httpObject["jsonEntity"]["ProvinceCode"] != null)//省 { string ProvinceCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["ProvinceCode"].ToString()); Where.Append(" and ( ProvinceCode like '" + ProvinceCode + "%')"); } if (httpObject["jsonEntity"]["CityCode"] != null)//城市 { string CityCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["CityCode"].ToString()); Where.Append(" and ( CityCode like '" + CityCode + "%')"); } if (httpObject["jsonEntity"]["AreaCode"] != null)//区 { string AreaCode = FilterTools.FilterSpecial(httpObject["jsonEntity"]["AreaCode"].ToString()); Where.Append(" and ( AreaCode like '" + AreaCode + "%')"); } #endregion ds = OPBiz.GetPagingDataSet(Where.ToString(), 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 context.Response.Write(JsonHelper.ToJson(resultMode, true)); context.Response.End(); }
// 请求例子 /httpSever/CommentHandler.ashx?json={"jsonEntity":{"GetByPostId":""},"action":"GetByPostId"} public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; // context.Response.Write("Hello World"); HttpReSultMode resultMode = new HttpReSultMode(); try { JObject httpObject = JsonHelper.FromJson(context.Request["json"]); int pageIndex = 1; int pageSize = 10000; int res = 0; switch (httpObject["action"].ToString()) { case "add": #region Comment Rmodel = JsonHelper.FromJson <Comment>(httpObject["jsonEntity"].ToString()); Rmodel.Id = Guid.NewGuid(); Rmodel.AddTime = DateTime.Now; Rmodel.States = 0; Rmodel.isValid = true; Rmodel.isDeleted = false; OPBiz.Add(Rmodel); resultMode.Code = 11; resultMode.Msg = "添加成功"; resultMode.Data = Rmodel.Id.ToString(); #endregion break; case "delete": #region string Id = httpObject["jsonEntity"]["Id"].ToString(); //var mqlD = CommentSet.Id.Equal(Id); //int f = OPBiz.Remove<CommentSet>(mqlD); int f = OPBiz.DelForSetDelete("Id", Id); if (f > 0) { resultMode.Code = 11; resultMode.Msg = "删除成功"; resultMode.Data = ""; } else { resultMode.Code = -13; resultMode.Msg = "删除失败"; resultMode.Data = ""; } #endregion break; case "GetById": #region Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); var mqlG = CommentSet.SelectAll().Where(CommentSet.Id.Equal(Id)); Comment 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 "GetByPostId": #region string IdG = httpObject["jsonEntity"]["PostId"].ToString(); var mqlG2 = CommentSet.SelectAll().Where(CommentSet.PostId.Equal(IdG).And(CommentSet.isDeleted.Equal(0)).And(CommentSet.isValid.Equal(1))); List <Comment> modelG2 = OPBiz.GetEntities(mqlG2); if (modelG2 != null) { resultMode.Code = 11; resultMode.Msg = "获取成功"; resultMode.Data = JsonHelper.ToJson(modelG2, true); } else { resultMode.Code = -13; resultMode.Msg = "数据不存在"; resultMode.Data = ""; } #endregion break; case "GetByPostIdPage": #region if (httpObject["pageIndex"] != null) { pageIndex = int.Parse(httpObject["pageIndex"].ToString()); } if (httpObject["pageSize"] != null) { pageSize = int.Parse(httpObject["pageSize"].ToString()); } string PostId = httpObject["jsonEntity"]["PostId"].ToString(); int sum = 0; int page = 0; var sqlp = CommentSet.SelectAll().Where(CommentSet.PostId.Equal(PostId).And(CommentSet.isDeleted.Equal(0)).And(CommentSet.isValid.Equal(1))); DataSet listp = OPBiz.GetPagingDataSet(sqlp, out page, out sum, pageIndex, pageSize, "AddTime"); if (listp != null) { resultMode.Code = 11; resultMode.Msg = "获取成功"; resultMode.Data = JsonHelper.ToJson(listp, true); } else { resultMode.Code = -13; resultMode.Msg = "数据不存在"; resultMode.Data = ""; } #endregion break; case "GetByUserId": #region string Idu = httpObject["jsonEntity"]["UserId"].ToString(); var mqlu = CommentSet.SelectAll().Where(CommentSet.UserId.Equal(Idu).And(CommentSet.isDeleted.Equal(0)).And(CommentSet.isValid.Equal(1))); List <Comment> listu = OPBiz.GetEntities(mqlu); if (mqlu != null) { resultMode.Code = 11; resultMode.Msg = "获取成功"; resultMode.Data = JsonHelper.ToJson(listu, true); } else { resultMode.Code = -13; resultMode.Msg = "数据不存在"; resultMode.Data = ""; } #endregion break; case "GetByUserIdPage": #region if (httpObject["pageIndex"] != null) { pageIndex = int.Parse(httpObject["pageIndex"].ToString()); } if (httpObject["pageSize"] != null) { pageSize = int.Parse(httpObject["pageSize"].ToString()); } string UserId = httpObject["jsonEntity"]["UserId"].ToString(); int sum2 = 0; int page2 = 0; var sqlp2 = CommentSet.SelectAll().Where(CommentSet.UserId.Equal(UserId).And(CommentSet.isDeleted.Equal(0)).And(CommentSet.isValid.Equal(1))); DataSet listp2 = OPBiz.GetPagingDataSet(sqlp2, out page2, out sum2, pageIndex, pageSize, "AddTime"); if (listp2 != null) { resultMode.Code = 11; resultMode.Msg = "获取成功"; resultMode.Data = JsonHelper.ToJson(listp2, 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; case "ReportsCount": //举报加1 Id = FilterTools.FilterSpecial(httpObject["jsonEntity"]["Id"].ToString()); res = OPBiz.SetCout("Id", Id, "Reports"); 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(); }