public IActionResult Index()
{
_ = new List <BioPrep>();
//string v = Request.Query.Count
string repMoFilter = Request.Query.FirstOrDefault(p => p.Key == "repMO").Value.ToString();
string VetPrepFilter = Request.Query.FirstOrDefault(p => p.Key == "VetPrep").Value.ToString();
int reportDtYear = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtYear").Value);
int reportDtMonth = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtMonth").Value);
//if(Request.Query.Count==0)
List <BioPrep> BioPrepList = BioPrepDAL.GetAll_BioPrepF(
User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value,
reportDtYear,
reportDtMonth,
repMoFilter,
VetPrepFilter
).ToList();
ViewBag.Page = "BioPrep";
ViewBag.RepList = spDAL.ReportToToday();
//SelectList l = FilterTools.repMOList(reportDtYear,reportDtMonth);
//foreach(var i in l)
// if(i.Value == repMoFilter) {i.Selected = true;break;}
ViewBag.repMOList = FilterTools.repMOList(reportDtYear, reportDtMonth, repMoFilter);
//SelectList vpl = FilterTools.VetPrepList(VetPrepFilter);
//foreach(var it in vpl)
// if(it.Value.Trim() == VetPrepFilter.Trim()){it.Selected = true; break;}
//ViewBag.VetPrepList = vpl;
ViewBag.VetPrepList = FilterTools.VetPrepList(VetPrepFilter);
ViewBag.RepList = spDAL.ReportToToday();
return(View(BioPrepList));
}
public IActionResult Index()
{
_ = new List <CtVet1b>();
int reportDtYear = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtYear").Value);
int reportDtMonth = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtMonth").Value);
string idRo = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value;
string repMoFilter = Request.Query.FirstOrDefault(p => p.Key == "repMO").Value.ToString();
string divFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDdiv").Value.ToString();
string spcFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDspc").Value.ToString();
string disFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDdis").Value.ToString();
List <CtVet1b> vet1aList = CtVet1bDAL.GetAll_CtVet1bF(
User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value,
reportDtYear,
reportDtMonth,
repMoFilter,
divFilter,
spcFilter,
disFilter
).ToList();
ViewBag.Page = "CtVet1b";
ViewBag.RepList = spDAL.ReportToToday();
ViewBag.repMOList = FilterTools.repMOList(reportDtYear,
reportDtMonth,
repMoFilter);
ViewBag.KIDdivList = FilterTools.KIDdivList(idRo, divFilter);
ViewBag.KIDspcList = FilterTools.KIDspcList(spcFilter);
ViewBag.KIDdisList = FilterTools.KIDdisList(disFilter);
return(View(vet1aList));
}
public IActionResult Index()
{
int reportDtYear = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtYear").Value);
int reportDtMonth = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtMonth").Value);
string KIDro = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value;
//string PlanYFilter = Request.Query.FirstOrDefault(p => p.Key == "PlanY").Value.ToString();
string divFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDdiv").Value.ToString();
string trtFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDtrt").Value.ToString();
string spcFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDspc").Value.ToString();
string disFilter = Request.Query.FirstOrDefault(p => p.Key == "KIDdis").Value.ToString();
List <CtVetPlan> l = ctVetPlanDAL.GetAll_CtVetPlan(KIDro, DateTime.Today.Year.ToString(),
divFilter, trtFilter, spcFilter, disFilter).ToList();
ViewBag.KIDdivList = FilterTools.KIDdivList(User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value, divFilter);
//ViewBag.PlanYearList = FilterTools.PlanYearList(PlanYFilter);
ViewBag.PlanYearList = spDAL.PlanYearList();
ViewBag.KIDtrtList = FilterTools.TrtList(trtFilter);
ViewBag.KIDspcList = FilterTools.KIDspcList(spcFilter);
ViewBag.KIDdisList = FilterTools.KIDdisList(disFilter);
ViewBag.Page = "CtVetPlan";
//ViewBag.RepList = spDAL.ReportToToday();
return(View(l));
}
public async Task <List <Place> > GetAllOrFilterPlace(FilterPlacesRequest filterPlaces)
{
var duplicatePlaces = new List <Place>();
int queryCount = 0;
if (FilterTools.AreIntsCorrect(filterPlaces.MinPlaceId, filterPlaces.MaxPlaceId))
{
var filterCapacity = _dataContext.Places.Where(c => c.MaximumCapacity >= filterPlaces.MinPlaceId &&
c.MaximumCapacity <= filterPlaces.MaxPlaceId);
foreach (var capacity in filterCapacity)
{
duplicatePlaces.Add(capacity);
}
queryCount++;
}
if (filterPlaces.Name != null)
{
var filterNames = _dataContext.Places.Where(c => c.Name == filterPlaces.Name);
foreach (var name in filterNames)
{
duplicatePlaces.Add(name);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterPlaces.MinMaxCapacity, filterPlaces.MaxCapacity))
{
var filterIds = _dataContext.Places.Where(c => c.PlaceId >= filterPlaces.MinMaxCapacity &&
c.PlaceId <= filterPlaces.MaxCapacity);
foreach (var id in filterIds)
{
duplicatePlaces.Add(id);
}
queryCount++;
}
var group = duplicatePlaces.GroupBy(i => i);
var filtered = new List <Place>();
if (queryCount == 0)
{
return(await _dataContext.Places.ToListAsync());
}
foreach (var item in group)
{
if (item.Count() == queryCount)
{
filtered.Add(item.Key);
}
}
return(filtered);
}
//推荐链接解码
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 Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
try
{
UIDocument uidoc = commandData.Application.ActiveUIDocument;
ElementId foundId = null;
//是否存在族
Boolean found = FilterTools.existFamliyByName(uidoc.Document, GlobalSettings.FamilyName.沉降测点.ToString(), out foundId);
Family family = null;
if (found == true)
{
//如果存在，获得文件该族
family = uidoc.Document.GetElement(foundId) as Family;
}
else
{
//如果不存在，载入族
Transaction trans = new Transaction(uidoc.Document, "trans");
trans.Start();
uidoc.Document.LoadFamily(Path.Combine(GlobalSettings.Path_family, GlobalSettings.FamilyName.沉降测点.ToString() + ".rfa"), out family);
trans.Commit();
}
//获得该族的族类型，并且放置族实例
FamilySymbol symbol = uidoc.Document.GetElement(family.GetFamilySymbolIds().ElementAt(0)) as FamilySymbol;
uidoc.PostRequestForElementTypePlacement(symbol);
}
catch (Exception e)
{
message = e.Message;
return(Autodesk.Revit.UI.Result.Failed);
}
return(Result.Succeeded);
}
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_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();
}
// 请求例子 /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();
}
public async Task <List <Event> > GetAllOrFilterEvent(FilterEventsRequest filterEvents)
{
var duplicateEvents = new List <Event>();
int queryCount = 0;
if (FilterTools.AreIntsCorrect(filterEvents.MinEventId, filterEvents.MaxEventId))
{
var eventId = _dataContext.Events.Where(c => c.EventId >= filterEvents.MinEventId &&
c.EventId <= filterEvents.MaxEventId);
foreach (var id in eventId)
{
duplicateEvents.Add(id);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterEvents.MinPlaceId, filterEvents.MaxPlaceId))
{
var placeId = _dataContext.Events.Where(c => c.PlaceId >= filterEvents.MinPlaceId &&
c.PlaceId <= filterEvents.MaxPlaceId);
foreach (var id in placeId)
{
duplicateEvents.Add(id);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterEvents.MinTypeId, filterEvents.MaxTypeId))
{
var typeId = _dataContext.Events.Where(c => c.PlaceId >= filterEvents.MinTypeId &&
c.PlaceId <= filterEvents.MaxTypeId);
foreach (var id in typeId)
{
duplicateEvents.Add(id);
}
queryCount++;
}
if (filterEvents.Name != null)
{
var eventName = _dataContext.Events.Where(c => c.Name == filterEvents.Name);
foreach (var name in eventName)
{
duplicateEvents.Add(name);
}
queryCount++;
}
if (filterEvents.Description != null)
{
var eventDescription = _dataContext.Events.Where(c => c.Description == filterEvents.Description);
foreach (var description in eventDescription)
{
duplicateEvents.Add(description);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterEvents.MinDate?.Year, filterEvents.MaxDate?.Year))
{
var eventDate = _dataContext.Events.Where(c => c.Date >= filterEvents.MinDate &&
c.Date <= filterEvents.MaxDate);
foreach (var item in eventDate)
{
duplicateEvents.Add(item);
}
queryCount++;
}
var result = new List <Event>();
var group = duplicateEvents.GroupBy(i => i);
if (queryCount == 0)
{
var events = await _dataContext.Events.ToListAsync();
foreach (var item in events)
{
_dataContext.Entry(item).Reference(e => e.Place).Load();
_dataContext.Entry(item).Collection(e => e.SeatStatuses).Load();
}
return(events);
}
foreach (var item in group)
{
if (item.Count() == queryCount)
{
result.Add(item.Key);
}
}
return(result.ToList());
}
// 请求例子 /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();
}
/// <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();
}
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 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/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();
}
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);
;
}
// 请求例子 /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();
}
public async Task <List <Seat> > GetAllOrFilterSeats(FilterSeatsRequest filterSeats)
{
var duplicateSeats = new List <Seat>();
int queryCount = 0;
if (FilterTools.AreIntsCorrect(filterSeats.MinSeatId, filterSeats.MaxSeatId))
{
var filterIds = _dataContext.Seats.Where(x => x.SeatId >= filterSeats.MinSeatId &&
x.SeatId <= filterSeats.MaxSeatId);
foreach (var id in filterIds)
{
duplicateSeats.Add(id);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterSeats.MinTypeId, filterSeats.MaxSeatId))
{
var filterTypes = _dataContext.Seats.Where(x => x.TypeId >= filterSeats.MinTypeId &&
x.TypeId <= filterSeats.MaxSeatId);
foreach (var type in filterTypes)
{
duplicateSeats.Add(type);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterSeats.MinSeatNumber, filterSeats.MaxSeatNumber))
{
var filterSeatNums = _dataContext.Seats.Where(x => x.SeatNumber >= filterSeats.MinSeatNumber &&
x.SeatNumber <= filterSeats.MaxSeatNumber);
foreach (var seatNum in filterSeatNums)
{
duplicateSeats.Add(seatNum);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterSeats.MinRowNumber, filterSeats.MaxRowNumber))
{
var filterRows = _dataContext.Seats.Where(x => x.RowNumber >= filterSeats.MinRowNumber &&
x.RowNumber <= filterSeats.MaxRowNumber);
foreach (var row in filterRows)
{
duplicateSeats.Add(row);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterSeats.MinSectorNumber, filterSeats.MaxSectorNumber))
{
var filterSectors = _dataContext.Seats.Where(x => x.SectorNumber >= filterSeats.MinSectorNumber &&
x.SectorNumber <= filterSeats.MaxSectorNumber);
foreach (var sector in filterSectors)
{
duplicateSeats.Add(sector);
}
queryCount++;
}
if (FilterTools.AreIntsCorrect(filterSeats.MinPlaceId, filterSeats.MaxPlaceId))
{
var filterPlaces = _dataContext.Seats.Where(x => x.PlaceId >= filterSeats.MinPlaceId &&
x.PlaceId <= filterSeats.MaxPlaceId);
foreach (var place in filterPlaces)
{
duplicateSeats.Add(place);
}
queryCount++;
}
var group = duplicateSeats.GroupBy(i => i);
var finalSeats = new List <Seat>();
if (queryCount == 0)
{
return(await _dataContext.Seats.ToListAsync());
}
foreach (var item in group)
{
if (item.Count() == queryCount)
{
finalSeats.Add(item.Key);
}
}
return(finalSeats);
}
