protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from lt in DB.x_lottery_item
where lt.lottery_id == lot_id
select lt;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit).ToList().Select(o => new
{
o.chance,
id = o.lottery_item_id,
o.name,
o.pic,
o.count,
o.price,
o.remark,
type = getTp(o.type)
}).ToList();
r.count = q.Count();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from ag in DB.x_agent
select new
{
ag.id,
ag.name,
ag.tel,
zu = ag.x_coop.Count(o => o.status == 1),
ag.addr,
ag.logo,
ag.contract,
cu1 = ag.x_coop.Count(o => o.status == 1),
cu2 = ag.x_coop.Count(o => o.status == 2),
cu3 = ag.x_coop.Count(o => o.status == 3),
statusname = GetDictName("agent.st", ag.status),
yc = ag.x_reserve.Count(o => o.status == 1)
};
q = q.OrderByDescending(o => o.yc);
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.tel.Contains(key) || o.name.Contains(key) || o.contract.Contains(key) || o.addr.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from lt in DB.x_lottery_run
select lt;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.title.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit).ToList().Select(u => new
{
u.title,
u.open,
u.sum,
ctime = u.ctime?.ToString("yyyy-MM-dd HH:mm")
}).ToList();
r.count = q.Count();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from ad in DB.x_admin
orderby ad.time descending
select new
{
ad.id,
ad.uid,
ad.name,
ad.tel,
ad.status,
ad.status_name,
ad.pwd
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.tel.Contains(key) || o.name.Contains(key) || o.uid.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var q = from e in db.x_poi
where e.type == tp
select new
{
id = e.grid_id,
e.name,
e.img,
e.addr,
e.tel,
e.remark,
pts = Context.Server.HtmlDecode(e.x_grid.points),
st = Context.Server.HtmlDecode(e.x_grid.style),
gtp = e.x_grid.type,
e.type,
tpname = db.GetDictName("poi.type", e.type, ""),
lng = e.x_grid.lng,
lat = e.x_grid.lat
};
var r = new Resp_List()
{
items = q.ToList(),
count = q.Count()
};
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from d in GetDictList("user.sman", "0")
where d.f1 == cityid
select new
{
d.id,
d.name,
tel = d.f3,
d.img,
date = d.f4
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.items = GetDictList("goods.cate", pid).Select(o => new { o.value, o.name });
return(r);
}
protected override Web.Com.XResp Execute()
{
if (dist == 0)
{
dist = 5;
}
if (page == 0)
{
page = 1;
}
if (limit == 0)
{
limit = 1;
}
var q = from u in DB.x_user
select new
{
u.image,
u.name,
u.tel,
dist = DB.fnGetDistance((float?)lng, (float?)lat, (float?)u.last_lng, (float?)u.last_lat) / 1000
};
q = q.Where(o => o.dist <= dist);
q = q.OrderBy(o => o.dist);
var r = new Resp_List();
r.page = 1;
r.count = q.Count();
r.items = q.ToList();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from et in DB.x_article
select et;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.title.Contains(key));
}
r.items = q.OrderByDescending(o => o.mtime).Skip((page - 1) * limit).Take(limit).ToList().Select(et => new
{
id = et.article_id,
et.title,
cate = GetDictName("article.cate", et.cate),
et.tourl,
et.hits,
et.sort,
mtime = et.mtime.Value.ToString("yyyy-MM-dd HH:mm")
});
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var q = from e in db.x_grid
where e.lng >= xmin && e.lng <= xmax && e.lat >= ymin && e.lat <= ymax
select new
{
id = e.grid_id,
e.name,
pts = e.points,
e.lng,
e.lat,
e.style,
tp = e.type
};
if (page == 0)
{
page = 1;
}
//if (limit == 0) limit = 500;
if (limit > 0)
{
q = q.Skip((page - 1) * limit).Take(limit);
}
var r = new Resp_List()
{
items = q.ToList(),
count = q.Count()
};
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from u in DB.x_user
select u;
//if (city > 0) q = q.Where(o => o.city == (mg.x_role.power == "###" ? city : mg.city));
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key) || o.tel.Contains(key) || o.nickname.Contains(key));
}
var list = q.OrderByDescending(o => o.ctime).Skip((page - 1) * limit).Take(limit).ToList();
r.items = list.Select(u => new
{
u.id,
name = string.IsNullOrEmpty(u.name) ? u.name : u.name + "(" + u.sex + ")",
u.tel,
u.nickname,
city = GetDictName("sys.city", u.city),
u.headimg,
level = GetDictName("user.level", u.@group),
exp = u.exp + (u.used_exp > 0 ? "(" + u.used_exp + ")" : ""),
u.balance,
ctime = u.ctime.Value.ToString("yyyy-MM-dd HH:mm"),
etime = u.etime.Value.ToString("yyyy-MM-dd HH:mm")
}).ToList();
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
if (hasc == 1)
{
var tree = new XTree();
tree.LoadList += tree_LoadList;
var dt = DateTime.Now;
tree.InitTree("", 5);
Debug.WriteLine("tree.init:" + (DateTime.Now - dt).TotalMilliseconds);
dt = DateTime.Now;
r.items = tree.OutTree();
Debug.WriteLine("tree.out:" + (DateTime.Now - dt).TotalMilliseconds);
}
else
{
var q = from m in DB.x_dict
where m.code == code && m.upval == "0"
select new
{
name = m.name,
cid = m.value,
img = m.img
};
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
}
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
var q = from o in DB.x_order
select o;
//if (mg.x_role.power != "###") q = q.Where(o => o.city == mg.city);
if (st > 0)
{
if (st == 1)
{
q = q.Where(o => o.pay_way == 1);
}
if (st == 4)
{
q = q.Where(o => o.pay_way == 2 && o.status > 2 && !(o.pay_amount > 0));
}
else
{
q = q.Where(o => o.status == st);
}
}
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.no == key || o.user_remark.Contains(key) || o.rec_man.Contains(key) || o.rec_tel.Contains(key));
}
r.count = q.Count();
var sts = "|待付款|待确认|待发货|待签收|已完成|已取消".Split('|');
r.items = q.OrderByDescending(o => o.ctime).Skip((page - 1) * limit).Take(limit).ToList().Select(o => new
{
id = o.order_id,
uid = o.user_id,
un = o.x_user.nickname,
up = o.x_user.headimg,
gs = string.Join(" ", o.x_order_detail.Select(d => "<img src='" + d.cover + "' class='gd' title='" + d.name + "' />").ToArray()),
o.no,
way = o.pay_way == 1 ? "在线支付" : "货到付款",
o.rec_man,
o.rec_tel,
o.status,
st_name = o.status > 0 && o.status < 7 ? sts[o.status.Value] : "未知：" + o.status,
o.rec_addr,
o.yf_amount,
o.pay_amount,
send = o.send_man,
send_date = o.send_date.Value.ToString("yyyy-MM-dd"),
o.send_time,
ctime = o.ctime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
remark = o.user_remark
});
r.page = page;
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from d in GetDictList("goods.brand", "0")
select new
{
d.id,
d.name,
cate = GetDictName("goods.cate", d.f3),
d.f3,
d.sort,
d.img
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
if (!string.IsNullOrEmpty(cate))
{
var cids = DB.x_dict.Where(o => o.code == "goods.cate" && o.upval.Contains(cate) || o.value == cate).Select(o => o.value);
q = q.Where(o => cids.Contains(o.f3));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from et in DB.x_ad
select et;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
if (pos > 0)
{
q = q.Where(o => o.pos == pos);
}
r.items = q.OrderByDescending(o => o.ctime).Skip((page - 1) * limit).Take(limit).ToList().Select(et => new
{
id = et.ad_id,
et.name,
pos = GetDictName("ads.pos", et.pos),
et.pic,
et.url,
et.remark,
ctime = et.ctime.Value.ToString("yyyy-MM-dd HH;mm")
});
r.count = q.Count();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from d in DB.x_charge
orderby d.charge_id descending
select new {
id = d.charge_id,
amount = d.amount,
uid = d.x_user.user_id,
name = d.x_user.name,
un = d.x_user.nickname,
up = d.x_user.headimg,
ctime = d.ctime,
result = d.result,
status = d.audit_status,
statusDisplay = d.audit_status == 3 ? "已拒绝" : (d.audit_status == 2 ? "已同意" : "待审核")
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from lt in DB.x_lottery
select lt;
//if (city > 0) q = q.Where(o => o.city == (mg.x_role.power == "###" ? city : mg.city));
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.topic.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit).ToList().Select(u => new
{
id = u.lottery_id,
u.topic,
u.remark,
sum = u.sum < 1 ? u.sum?.ToString("F3") + "%" : u.sum?.ToString("F2"),
ctime = u.ctime.Value.ToString("yyyy-MM-dd<br>HH:mm"),
ltime = u.ltime?.ToString("yyyy-MM-dd<br>HH:mm:ss"),
status = getstatus(u.status),
tp = u.runtp == 1 ? "即时开奖" : getrules(u.rules),
}).ToList();
r.count = q.Count();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from ad in DB.x_mgr
where ad.city == cityid
select new
{
ad.mgr_id,
ad.uid,
ad.name,
ad.tel,
ad.city,
role = (ad.role_id == 3) ? "总管理员" : (ad.role_id == 2 ? "财务" : "客服"),
ad.email
//ad.pwd
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.tel.Contains(key) || o.name.Contains(key) || o.uid.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from se in DB.x_secode
select se;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.outcode == key);
}
if (bat > 0)
{
q = q.Where(o => o.batch == bat);
}
r.items = q.Skip((page - 1) * limit).Take(limit).ToList().Select(o => new
{
id = o.secode_id,
o.batch,
icode = o.incode.Value.ToString("00000000"),
ocode = o.outcode,
user = getuser(o.user_id),
stime = o.stime?.Date.ToString("yyyy-MM-dd")
});
r.count = q.Count();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from track in DB.x_track
join ag in DB.x_agent on track.agent_id equals ag.agent_id into ag_join
from agt in ag_join.DefaultIfEmpty()
join ad in DB.x_admin on track.user_id equals ad.admin_id into ad_join
from adm in ad_join.DefaultIfEmpty()
where track.agent_id == agid
orderby track.time descending
select new
{
track.id,
track.agent_id, //二房东
agent_name = agt.name, //二房东名称
track.user_id, //管理员
user_name = adm.name, //管理员名称
track.content, //跟踪内容
track.time, //跟踪时间
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.agent_id == int.Parse(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
if (up != "0")
{
var d = DB.x_dict.FirstOrDefault(o => o.code == "sys.city" && o.value == up);
if (d.upval != "0")
{
up = d.upval + "-" + d.value;
}
}
var q = DB.x_dict.Where(o => o.code == "sys.city" && o.upval == up);
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.jp.Contains(key) || o.name.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit).ToList();
r.page = page;
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var q = from v in DB.x_visit
where v.coop_id == cid
orderby v.ctime descending
select new
{
v.ctime,
v.ctime_name,
v.remark,
v.type,
v.type_name,
v.utype,
v.utype_name,
v.name,
v.tel,
uname = v.x_user.name,
utel = v.x_user.tel,
uimage = v.x_user.image
};
var r = new Resp_List();
r.page = page;
r.count = q.Count();
r.items = q.Skip((page - 1) * limit).Take(limit).ToList();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from d in DB.x_sale
orderby d.goods_id descending
select new {
id = d.sale_id,
goods_id = d.goods_id,
city_id = d.city_id,
limit = d.limit,
count = d.count,
price = d.price,
ctime = d.ctime,
etime = d.etime, //这里的etime等直接对应list.html里的cfg
name = d.x_goods.name //父子表可以直接读取
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
if (!string.IsNullOrEmpty(cate))
{
var cids = DB.x_dict.Where(o => o.code == "sale" && o.upval.Contains(cate) || o.value == cate).Select(o => o.value);
q = q.Where(o => cids.Contains(o.name));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from lt in DB.x_lottery_run
where lt.lottery_id == lot_id
select lt;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.title.Contains(key));
}
r.items = q.OrderByDescending(o => o.ctime).Skip((page - 1) * limit).Take(limit).ToList().Select(u => new
{
id = u.lottery_run_id,
u.title,
sum = u.sum?.ToString("F2"),
u.open,
ctime = u.ctime?.ToString("yyyy-MM-dd HH:mm")
}).ToList();
r.count = q.Count();
return(r);
}
protected override Web.Com.XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from ad in DB.x_goods
where ad.status != 4 && ad.type == tp
orderby ad.goods_id descending
select new
{
id = ad.goods_id,
cate = GetDictName("goods.cate", ad.cate_id),
ad.name,
ad.remark,
ad.cover,
ad.sort,
ad.stock,
ad.old_price,
ad.new_price,
time = ad.mtime,
tk = ad.refunded == true ? 1 : 0,
ps = ad.sended == true ? 1 : 0
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key) || o.remark.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from sm in DB.x_sms
orderby sm.ctime descending
select new
{
sm.content,
sm.ctime,
sm.result,
sm.tel
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.tel.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from d in GetDictList("user.level", "0")
select new
{
d.id,
d.name,
off = d.f1.Value + "%",
nd = d.f2,
d.sort
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit);
r.count = q.Count();
return(r);
}
protected override XResp Execute()
{
var q = from v in DB.x_visit
orderby v.ctime descending
select new
{
v.ctime,
v.ctime_name,
v.remark,
v.type_name,
v.utype_name,
v.name,
v.tel,
uname = v.x_user.name,
utel = v.x_user.tel,
cid = v.coop_id
};
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.name.Contains(key) || o.uname.Contains(key));
}
var r = new Resp_List();
r.page = page;
r.count = q.Count();
r.items = q.Skip((page - 1) * limit).Take(limit).ToList();
return(r);
}
protected override XResp Execute()
{
var r = new Resp_List();
r.page = page;
var q = from lt in DB.x_user_prize
select lt;
if (!string.IsNullOrEmpty(key))
{
q = q.Where(o => o.title.Contains(key));
}
r.items = q.Skip((page - 1) * limit).Take(limit).ToList().Select(u => new
{
name = u.x_user.nickname,
up = u.x_user.headimg,
u.title,
gtime = u.gtime?.ToString("yyyy-MM-dd<br>HH:mm"),
isget = u.isget == true ? "是" : "否",
u.prize,
u.remark,
u.val,
ctime = u.ctime?.ToString("yyyy-MM-dd<br>HH:mm")
}).ToList();
r.count = q.Count();
return(r);
}
