/// <summary>
/// 更新Formid-用于后期推送消息给用户
/// [POST] /open/user/formid.do
/// @authcode
/// @formid
/// </summary>
public void user_formid_do()
{
var postdata = ReadBodyData();
string authcode = postdata.authcode ?? string.Empty;
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
string formid = postdata.formid ?? string.Empty;
if (string.IsNullOrEmpty(formid))
{
EchoFailJson("formid is null or empty");
return;
}
dbh.ExecuteNoneQuery("update [user] set formid=@0,formiddate=@1 where id=@2", formid, DateTime.Now, userid);
var rsp = new Common.DB.NVCollection();
rsp["code"] = 0;
rsp["status"] = "succ";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
public bool InitOrder(OrderInfo info)
{
var db = Common.DB.Factory.CreateDBHelper();
if (ExistsOrderNo(info.OrderNo, db))
{
return(false);
}
DateTime now = DateTime.Now;
var nvc = new Common.DB.NVCollection();
nvc["orderno"] = info.OrderNo;
nvc["project"] = info.Project;
nvc["status"] = OrderStatus.Begin.GetStringValue();
nvc["date"] = now;
nvc["created"] = now;
nvc["amount"] = info.Amount;
nvc["paytype"] = info.PayType;
nvc["paych"] = info.PayCH;
int num = db.ExecuteNoneQuery("insert into [orderinfo](orderno,project,status,date,created,amount,paytype,paych) values(@orderno,@project,@status,@date,@created,@amount,@paytype,@paych)", nvc);
if (num > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 更新用户基本信息
/// [POST] /open/user/info.do
/// @authcode
/// @name
/// @avatar
/// @gender
/// @age
/// </summary>
public void user_info_do()
{
var postdata = ReadBodyData();
string authcode = postdata.authcode ?? string.Empty;
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var rsp = new Common.DB.NVCollection();
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
string name = postdata.name ?? string.Empty;
string avatar = postdata.avatar ?? string.Empty;
string gender = postdata.gender ?? string.Empty;
string age = postdata.age ?? string.Empty;
dbh.ExecuteNoneQuery("update [user] set name=@0,avatar=@1,gender=@2,age=@3 where id=@4", name, avatar, gender, age, userid);
rsp["code"] = 0;
rsp["status"] = "succ";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
/// <summary>
/// 获得用户收益流水记录
/// [GET] /open/cash/list.json
/// @authcode
/// @ts
/// </summary>
public void cash_list_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
long ts = Convert.ToInt64(Request.QueryString["ts"]);
int pagesize = 30;
var data = dbh.GetDataList("select top " + pagesize + " amount,date,datets,amountNow,amountPrev,amountTotal,[type],info from [user.cash] where userid=@0" + (ts > 0 ? " and datets<@1 order by datets desc" : ""), userid, ts);
foreach (var d in data)
{
d["date"] = Convert.ToDateTime(d["date"]).ToString("yyyy-MM-dd");
}
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = data;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
/// <summary>
/// 获得用户基本信息
/// [GET] /open/user/info.json
/// @authcode
/// </summary>
public void user_info_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
var user = dbh.GetData("select name,avatar,gender,age from [user] where id=@0", userid);
if (userid <= 0)
{
EchoFailJson("user not exists");
return;
}
else
{
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = user;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
}
/// <summary>
/// 获取模块配置
/// [GET] /open/module/data.json
/// @authcode
/// </summary>
public void module_data_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
var modules = dbh.GetDataList("select * from [sys.module]");
var module = new Common.DB.NVCollection();
foreach (var m in modules)
{
string key = m["key"].ToString();
m.Remove("key");
module[key] = m;
}
module["code"] = 0;
module["status"] = "succ";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(module));
}
/// <summary>
/// 获得门店基本信息
/// [GET] /open/sys/shop/info.json
/// @authcode
/// </summary>
public void sys_shop_info_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
var config = dbh.GetData("select top 1 name,px,py,address,contact,pics,content,logo,qrcode from [sys.config] where enabled=1");
if (config == null)
{
rsp["code"] = -1;
rsp["status"] = "fail";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
config["pics"] = Convert.ToString(config["pics"]).Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = config;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
/// <summary>
/// 系统代金券列表
/// [GET] /open/sys/coupon/list.json
/// @authcode
/// </summary>
public void sys_coupon_list_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
var rules = dbh.GetDataList("select id,name,amount,amountLimit,daysBegin,daysEnd from [sys.couponRule] where [type]='sys' and [status]=1 " + (Request.QueryString["type"] == "money" ? " and id=1" : "") + " order by sort desc");
foreach (var d in rules)
{
d["dateBegin"] = DateTime.Now.AddDays(Convert.ToInt32(d["daysBegin"])).ToString("yyyy-MM-dd");
d["dateEnd"] = DateTime.Now.AddDays(Convert.ToInt32(d["daysEnd"])).ToString("yyyy-MM-dd");
d.Remove("daysBegin");
d.Remove("daysEnd");
}
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = rules;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
/// <summary>
/// 获得用户当前账户收益信息
/// [GET] /open/cash/now.json
/// @authcode
/// @id
/// </summary>
public void cash_now_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
int id = Convert.ToInt32(Request.QueryString["id"]);
if (id == 0)
{
var data = dbh.GetData("select top 1 amount,date,datets,amountNow,amountPrev,amountTotal,[type],info from [user.cash] where userid=@0 order by datets desc", userid);
if (data == null)
{
//error
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = null;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
data["date"] = Convert.ToDateTime(data["date"]).ToString("yyyy-MM-dd");
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = data;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
else
{
var data = dbh.GetData("select top 1 amount,date,datets,amountNow,amountPrev,amountTotal,[type],info from [user.cash] where id=@0", id);
if (data == null)
{
//error
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = null;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
data["date"] = Convert.ToDateTime(data["date"]).ToString("yyyy-MM-dd");
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = data;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
}
/// <summary>
/// 获得单条代金券基本信息
/// [GET] /open/coupon/info.json
/// @authcode
/// @authcodefriend
/// @couponid
/// </summary>
public void coupon_info_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
string authcodefriend = Request.QueryString["authcodefriend"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
int pid = 0;
if (!TryGetUserId(authcodefriend, out pid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
int couponid = int.Parse(Request.QueryString["couponid"] ?? "0");
if (couponid <= 0)
{
EchoFailJson("couponid is null or empty");
return;
}
var coupon = dbh.GetData("select top 1 c.id,c.amount,c.dateBegin,c.dateEnd,c.status,cr.amountLimit from [user.coupon] as c left join [sys.couponRule] as cr on c.ruleid=cr.id where c.id=@0", couponid);
if (coupon == null)
{
EchoFailJson("coupon is null");
return;
}
if (((Constant.CouponStatus)coupon["status"] == Constant.CouponStatus.Enabled || (Constant.CouponStatus)coupon["status"] == Constant.CouponStatus.Giving) && (Convert.ToDateTime(coupon["dateBegin"]) < DateTime.Now) && (Convert.ToDateTime(coupon["dateEnd"]) > DateTime.Now))
{
coupon["status"] = "enable";
}
else
{
coupon["status"] = "disable";
}
coupon["dateBegin"] = Convert.ToDateTime(coupon["dateBegin"]).ToString("yyyy-MM-dd");
coupon["dateEnd"] = Convert.ToDateTime(coupon["dateEnd"]).ToString("yyyy-MM-dd");
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = coupon;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
/// <summary>
/// 查询用户当前绑定的银行卡
/// [GET] /open/user/bankcard/bind.json
/// @authcode
/// </summary>
public void user_bankcard_bind_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
var banks = new Dictionary <string, string>();
banks["1002"] = "工商银行";
banks["1005"] = "农业银行";
banks["1026"] = "中国银行";
banks["1003"] = "建设银行";
banks["1001"] = "招商银行";
banks["1066"] = "邮储银行";
banks["1020"] = "交通银行";
banks["1004"] = "浦发银行";
banks["1006"] = "民生银行";
banks["1009"] = "兴业银行";
banks["1010"] = "平安银行";
banks["1021"] = "中信银行";
banks["1025"] = "华夏银行";
banks["1027"] = "广发银行";
banks["1022"] = "光大银行";
banks["1032"] = "北京银行";
banks["1056"] = "宁波银行";
var bank = dbh.GetData("select top 1 number,bank from [user.bankcard] where userid=@0", userid);
if (bank == null)
{
EchoFailJson("bankcard is null");
return;
}
var data = new Common.DB.NVCollection();
var type = new Common.DB.NVCollection();
type["key"] = Convert.ToString(bank["bank"]);
type["name"] = banks[type["key"].ToString()];
data["type"] = type;
data["code"] = bank["number"];
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = data;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
public static Common.DB.NVCollection GetOpenIDByCode(string code)
{
var config = Config.XCX;
string appid = config.AppID;
string appSecret = config.AppSecret;
var client = new RestSharp.RestClient("https://api.weixin.qq.com");
var request = new RestSharp.RestRequest("sns/jscode2session", RestSharp.Method.GET);
request.AddParameter("appid", appid);
request.AddParameter("secret", appSecret);
request.AddParameter("js_code", code);
request.AddParameter("grant_type", "authorization_code");
var response = client.Execute(request);
response.ContentEncoding = "utf-8";
string content = response.Content;
if (string.IsNullOrEmpty(content))
{
return(null);
}
dynamic data = JsonConvert.DeserializeObject <dynamic>(content);
if (data == null)
{
return(null);
}
if (data.errcode != null)
{
int errcode = data.errcode;
if (errcode > 0)
{
return(null);
}
}
string openid = data.openid ?? string.Empty;
string session_key = data.session_key ?? string.Empty;
string unionid = data.unionid ?? string.Empty;
var nvc = new Common.DB.NVCollection();
nvc["openid"] = openid;
nvc["sessionKey"] = session_key;
nvc["unionid"] = unionid;
return(nvc);
}
void school_special_score_list_json()
{
int schoolid = int.Parse(Request.QueryString["schoolid"] ?? "0");
string provinceid = Request.QueryString["provinceid"];
string examieeid = Request.QueryString["examieeid"];
string specialname = Request.QueryString["specialname"];
int year = int.Parse(Request.QueryString["year"] ?? "0");
var db = Common.DB.Factory.CreateDBHelper();
var query = new Common.DB.NVCollection();
string sqlwhere = " schoolid=@schoolid";
query["schoolid"] = schoolid;
if (!string.IsNullOrEmpty(provinceid))
{
sqlwhere += " and provinceid=@provinceid";
query["provinceid"] = provinceid;
}
if (!string.IsNullOrEmpty(examieeid))
{
sqlwhere += " and examieeid=@examieeid";
query["examieeid"] = examieeid;
}
if (!string.IsNullOrEmpty(specialname))
{
sqlwhere += " and specialname like '%" + GetSQLSafeStr(specialname) + "%'";
}
if (year > 0)
{
sqlwhere += " and [year]=@year";
query["year"] = year;
}
string sql = "select [schoolid],[provinceid],[examieeid],[specialname],[year],[maxfs],[varfs],[minfs],[pc],[stype] from [school.special] where " + sqlwhere + " order by year desc";
var datalist = db.GetDataList(sql, query);
if (datalist == null)
{
EchoFailJson("error data is null");
return;
}
EchoSuccJson(datalist);
}
void school_score_list_json()
{
int schoolid = int.Parse(Request.QueryString["schoolid"] ?? "0");
string provinceid = Request.QueryString["provinceid"];
string examieeid = Request.QueryString["examieeid"];
string batchid = Request.QueryString["batchid"];
int year = int.Parse(Request.QueryString["year"] ?? "0");
var db = Common.DB.Factory.CreateDBHelper();
var query = new Common.DB.NVCollection();
string sqlwhere = " schoolid=@schoolid";
query["schoolid"] = schoolid;
if (!string.IsNullOrEmpty(provinceid))
{
sqlwhere += " and provinceid=@provinceid";
query["provinceid"] = provinceid;
}
if (!string.IsNullOrEmpty(examieeid))
{
sqlwhere += " and examieeid=@examieeid";
query["examieeid"] = examieeid;
}
if (!string.IsNullOrEmpty(batchid))
{
sqlwhere += " and batchid=@batchid";
query["batchid"] = batchid;
}
if (year > 0)
{
sqlwhere += " and [year]=@year";
query["year"] = year;
}
string sql = "select [schoolid],[provinceid],[examieeid],[batchid],[year],[maxScore],[minScore],[avgScore],[ps],[fc],[rb],[rs],[ph] from [school.score] where " + sqlwhere + " order by year desc";
var datalist = db.GetDataList(sql, query);
if (datalist == null)
{
EchoFailJson("error data is null");
return;
}
EchoSuccJson(datalist);
}
public UserInfo(Common.DB.NVCollection nvc)
{
id = ConvertHelper.ToInt32(nvc["id"]);
openid = ConvertHelper.ToString(nvc["openid"]);
formid = ConvertHelper.ToString(nvc["formid"]);
name = ConvertHelper.ToString(nvc["name"]);
avatar = ConvertHelper.ToString(nvc["avatar"]);
gender = ConvertHelper.ToString(nvc["gender"]);
age = ConvertHelper.ToInt32(nvc["age"]);
pid = ConvertHelper.ToInt32(nvc["pid"]);
date = Convert.ToDateTime(nvc["date"]);
olduser = Convert.ToBoolean(nvc["olduser"]);
}
void EchoFailJson(string msg = null)
{
var rsp = new Common.DB.NVCollection();
rsp["code"] = -1;
rsp["status"] = "fail";
if (!string.IsNullOrEmpty(msg))
{
rsp["msg"] = msg;
}
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
void EchoSuccJson(object data)
{
var rsp = new Common.DB.NVCollection();
rsp["code"] = 0;
rsp["status"] = "succ";
if (data != null)
{
rsp["data"] = data;
}
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
public OrderInfo(Common.DB.NVCollection nvc)
{
userid = ConvertHelper.ToInt32(nvc["userid"]);
orderno = ConvertHelper.ToString(nvc["orderno"]);
status = ConvertHelper.ToString(nvc["status"]);
statusdate = Convert.ToDateTime(nvc["statusdate"]);
amountCoupon = ConvertHelper.ToInt32(nvc["amountCoupon"]);
amount = ConvertHelper.ToInt32(nvc["amount"]);
couponid = ConvertHelper.ToInt32(nvc["couponid"]);
amountTotal = ConvertHelper.ToInt32(nvc["amountTotal"]);
couponid = ConvertHelper.ToInt32(nvc["couponid"]);
date = Convert.ToDateTime(nvc["date"]);
}
void EchoFailJson(string msg = null)
{
var rsp = new Common.DB.NVCollection();
rsp["code"] = -1;
rsp["status"] = "fail";
if (!string.IsNullOrEmpty(msg))
{
rsp["msg"] = msg;
}
CallbackData(rsp);
}
void EchoSuccJson(object data)
{
var rsp = new Common.DB.NVCollection();
rsp["code"] = 0;
rsp["status"] = "succ";
if (data != null)
{
rsp["data"] = data;
}
CallbackData(rsp);
}
/// <summary>
/// 订单状态
/// [GET] /open/order/info.json
/// @authcode
/// @orderno
/// </summary>
public void order_info_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
string orderno = Request.QueryString["orderno"];
if (string.IsNullOrEmpty(orderno))
{
EchoFailJson("orderno is null");
return;
}
var order = dbh.GetData("select top 1 * from [user.order] where orderno=@0", orderno);
if (order == null)
{
EchoFailJson("order is null");
return;
}
if ((Constant.OrderStatus)Convert.ToInt32(order["status"]) == Constant.OrderStatus.Finish)
{
rsp["code"] = 0;
rsp["status"] = "succ";
}
else
{
rsp["code"] = 0;
rsp["status"] = "fail";
}
rsp["orderno"] = orderno;
rsp["amount"] = order["amount"];
rsp["amountCoupon"] = order["amountCoupon"];
rsp["amountTotal"] = order["amountTotal"];
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
/// <summary>
/// 银行卡类型
/// [GET] /open/user/bankcard/types.json
/// @authcode
/// </summary>
public void user_bankcard_types_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
Response.Write(System.IO.File.ReadAllText(HttpContext.Current.Server.MapPath("/bankcode.json")));
}
void special_info_json()
{
int id = int.Parse(Request.QueryString["id"] ?? "0");
string name = Request.QueryString["name"] ?? string.Empty;
string sqlwhere = null;
var nvc = new Common.DB.NVCollection();
if (!string.IsNullOrEmpty(name))
{
sqlwhere = "name=@name";
nvc["name"] = name;
}
if (id > 0)
{
sqlwhere = "id=@id";
nvc["id"] = id;
}
if (string.IsNullOrEmpty(sqlwhere))
{
EchoFailJson("error data is null");
return;
}
var db = Common.DB.Factory.CreateDBHelper();
var entity = db.GetData("select id,name,code,zycengci,zytype,bnum,znum,zyid,ranking,rankingType,des,data from [special.data] where " + sqlwhere, nvc);
if (entity == null)
{
EchoFailJson("error data is null");
return;
}
string jsonData = entity["data"] as string ?? string.Empty;
if (!string.IsNullOrEmpty(jsonData))
{
entity["data"] = JsonConvert.DeserializeObject <dynamic>(jsonData);
}
EchoSuccJson(entity);
}
/// <summary>
/// 历史订单列表
/// [GET] /open/order/list.json
/// @authcode
/// @ts
/// </summary>
public void order_list_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
long ts = 0;
if (!string.IsNullOrEmpty(Request.QueryString["ts"]))
{
ts = Convert.ToInt64(Request.QueryString["ts"]);
}
int pagesize = 20;
var datas = new List <Common.DB.NVCollection>();
if (ts == 0)
{
datas = dbh.GetDataList("select top " + pagesize + " orderno,status,date,amount from [user.order] where userid=@0 order by date desc", userid);
}
else
{
datas = dbh.GetDataList("select top " + pagesize + " orderno,status,date,amount from [user.order] where userid=@0 and date<@1 order by date desc", userid, Common.Helpers.TimeHelper.GetDateTimeFrom1970Ticks(ts));
}
rsp["code"] = 0;
rsp["status"] = "succ";
foreach (var data in datas)
{
data["datets"] = Common.Helpers.TimeHelper.GetTimeStamp(Convert.ToDateTime(data["date"]), 10);
data["date"] = Convert.ToDateTime(data["date"]).ToString("yyyy-MM-dd");
data["status"] = ((Constant.OrderStatus)Convert.ToInt32(data["status"])).ToString();
}
rsp["data"] = datas;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
/// <summary>
/// 代金券单条信息查询
/// [GET] /open/sys/coupon/info.json
/// @authcode
/// @ruleid
/// </summary>
public void sys_coupon_info_json()
{
var rsp = new Common.DB.NVCollection();
string authcode = Request.QueryString["authcode"];
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
int ruleid = int.Parse(Request.QueryString["ruleid"] ?? "0");
if (ruleid <= 0)
{
EchoFailJson("ruleid<=0");
return;
}
var rule = dbh.GetData("select id,name,amount,amountLimit,daysBegin,daysEnd from [sys.couponRule] where [type]='sys' and [status]=1 and id=@0", ruleid);
if (rule == null)
{
EchoFailJson("ruleid not exists");
return;
}
rule["dateBegin"] = DateTime.Now.AddDays(Convert.ToInt32(rule["daysBegin"])).ToString("yyyy-MM-dd");
rule["dateEnd"] = DateTime.Now.AddDays(Convert.ToInt32(rule["daysEnd"])).ToString("yyyy-MM-dd");
rule.Remove("daysBegin");
rule.Remove("daysEnd");
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["data"] = rule;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
/// <summary>
/// 用户父关系建立
/// [POST] /open/friend/pid.do
/// @authcode
/// @authcodefriend
/// </summary>
public void friend_pid_do()
{
var postdata = ReadBodyData();
string authcode = postdata.authcode ?? string.Empty;
string authcodefriend = postdata.authcodefriend ?? string.Empty;
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
int pid = 0;
if (!TryGetUserId(authcodefriend, out pid))
{
EchoFailJson("!TryGetUserId");
return;
}
if (userid == pid)
{
EchoFailJson("pid == userid");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
dbh.ExecuteNoneQuery("update [user] set pid=@0 where id=@1", pid, userid);
SetFirstCouponPid(userid, pid);
var rsp = new Common.DB.NVCollection();
rsp["code"] = 0;
rsp["status"] = "succ";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
/// <summary>
/// 获得用户安全码
/// [GET] /open/user/auth.json
/// @code
/// </summary>
public void user_auth_json()
{
var rsp = new Common.DB.NVCollection();
string code = Request.QueryString["code"] ?? string.Empty;
if (string.IsNullOrEmpty(code))
{
EchoFailJson("code is null");
return;
}
else
{
var nvc = Services.UserService.GetOpenIDByCode(code);
if (nvc == null)
{
EchoFailJson("GetOpenIDByCode is null");
return;
}
var obj = new
{
openid = nvc["openid"] as string ?? string.Empty,
sessionKey = nvc["sessionKey"] as string ?? string.Empty,
unionid = nvc["unionid"] as string ?? string.Empty
};
int userid = 0;
if (Services.UserService.SaveUserOpenId(obj.openid, out userid, InitUserGiveCoupon))
{
string authcode = Services.UserService.GenUserAuthCode(obj.openid, userid);
rsp["code"] = 0;
rsp["status"] = "succ";
rsp["authcode"] = authcode;
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
return;
}
}
}
/// <summary>
/// 用户绑定银行卡,用户更改银行卡
/// [POST] /open/user/bankcard/bind.do
/// @authcode
/// @name
/// @bank
/// @code
/// </summary>
public void user_bankcard_bind_do()
{
var postdata = ReadBodyData();
string authcode = postdata.authcode ?? string.Empty;
int userid = 0;
if (!TryGetUserId(authcode, out userid))
{
EchoFailJson("!TryGetUserId");
return;
}
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
string name = postdata.name;
string bank = postdata.bank;
string code = postdata.code;
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(bank) || string.IsNullOrEmpty(code))
{
EchoFailJson();
return;
}
int n = dbh.ExecuteNoneQuery("update [user.bankcard] set bank=@0,number=@1,name=@2,date=@3,statusdate=@4 where userid=@5", bank, code, name, DateTime.Now, DateTime.Now, userid);
if (n < 1)
{
dbh.ExecuteNoneQuery("insert into [user.bankcard] (userid,bank,number,name,date,statusdate,status) values (@0,@1,@2,@3,@4,@5,@6)", userid, bank, code, name, DateTime.Now, DateTime.Now, 1);
}
var rsp = new Common.DB.NVCollection();
rsp["code"] = 0;
rsp["status"] = "succ";
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rsp));
}
public static bool SaveUserOpenId(string openid, out int userid, Action <int> userinit = null)
{
userid = 0;
var dbh = Common.CommonService.Resolve <Common.DB.IDBHelper>();
var nvc = new Common.DB.NVCollection();
nvc["openid"] = openid;
nvc["date"] = DateTime.Now;
object exo = dbh.ExecuteScalar <object>("select top 1 1 from [user] where openid=@0", openid);
if (exo == null || exo == DBNull.Value)
{
userid = dbh.ExecuteScalar <int>("insert into [user](openid,date) values(@openid,@date);select @@IDENTITY", nvc);
if (userinit != null)
{
userinit(userid);
}
}
else
{
userid = dbh.ExecuteScalar <int>("update [user] set date=@date where openid=@openid;select id from [user] where openid=@openid;", nvc);
}
if (userid > 0)
{
return(true);
}
else
{
return(false);
}
}
void school_list_json()
{
var db = Common.DB.Factory.CreateDBHelper();
string schoolname = Request.QueryString["schoolname"] ?? string.Empty;
string province = Request.QueryString["province"] ?? string.Empty;
string schooltype = Request.QueryString["schooltype"] ?? string.Empty;
string f985 = Request.QueryString["f985"] ?? string.Empty;
string f211 = Request.QueryString["f211"] ?? string.Empty;
string level = Request.QueryString["level"] ?? string.Empty;
string schoolnature = Request.QueryString["schoolnature"] ?? string.Empty;
string specialname = Request.QueryString["specialname"] ?? string.Empty;
string schoolproperty = Request.QueryString["schoolproperty"] ?? string.Empty;
string zhongdian = Request.QueryString["zd"] ?? string.Empty;
string zhuoyue = Request.QueryString["zy"] ?? string.Empty;
int rankingbegin = int.Parse(Request.QueryString["rankingbegin"] ?? "-1");
int rankingend = int.Parse(Request.QueryString["rankingend"] ?? "-1");
int page = int.Parse(Request.QueryString["page"] ?? "1");
int pagesize = int.Parse(Request.QueryString["pagesize"] ?? "10");
var query = new Common.DB.NVCollection();
string sqlwhere = string.Empty;
if (!string.IsNullOrEmpty(schoolname))
{
sqlwhere += " and schoolname like '%" + GetSQLSafeStr(schoolname) + "%'";
}
if (!string.IsNullOrEmpty(province))
{
if (province == "北上广")
{
sqlwhere += " and (province='北京' or province='上海' or province='广东')";
}
else
{
sqlwhere += " and province=@province";
query["province"] = province;
}
}
if (!string.IsNullOrEmpty(schooltype))
{
sqlwhere += " and schooltype=@schooltype";
query["schooltype"] = schooltype;
}
if (!string.IsNullOrEmpty(f985))
{
sqlwhere += " and f985=@f985";
query["f985"] = f985;
}
if (!string.IsNullOrEmpty(f211))
{
sqlwhere += " and f211=@f211";
query["f211"] = f211;
}
if (zhongdian == "1")
{
sqlwhere += " and (f211=1 or f985=1)";
}
if (zhuoyue == "1")
{
sqlwhere += " and (f211=1 and f985=1)";
}
if (!string.IsNullOrEmpty(level))
{
sqlwhere += " and level=@level";
query["level"] = level;
}
if (!string.IsNullOrEmpty(schoolnature))
{
sqlwhere += " and schoolnature=@schoolnature";
query["schoolnature"] = schoolnature;
}
if (!string.IsNullOrEmpty(schoolproperty))
{
sqlwhere += " and schoolproperty=@schoolproperty";
query["schoolproperty"] = schoolproperty;
}
if (!string.IsNullOrEmpty(specialname))
{
sqlwhere += " and schoolid in(select schoolid from [school.special.data] where specialid in(select id from [special.data] where name like '%" + GetSQLSafeStr(specialname) + "%'))";
}
if (rankingbegin < 0)
{
rankingbegin = 0;
}
if (rankingend <= 0)
{
rankingend = int.MaxValue;
}
if (rankingbegin > 0 && rankingend > 0)
{
sqlwhere += " and ranking>=@rankingbegin and ranking<=@rankingend";
query["rankingbegin"] = rankingbegin;
query["rankingend"] = rankingend;
}
var psql = Common.DB.Factory.CreatePagerQuery();
psql.AbsolutePage = page;
psql.PageSize = pagesize;
psql.Table = "[school.data]";
psql.Fields = "[schoolid],[schoolname],[province],[schooltype],[schoolproperty],[edudirectly],[f985],[f211],[level],[autonomyrs],[library],[membership],[schoolnature],[shoufei],[jianjie],[schoolcode],[ranking],[rankingCollegetype],[guanwang],[oldname],[master],[num],[firstrate]";
psql.Sort = "ranking asc";
psql.Where = sqlwhere;
string csql = psql.GetCountQueryString();
int rc = db.ExecuteScalar <int>(csql, query);
int pc = Convert.ToInt32(Math.Ceiling((decimal)rc / (decimal)pagesize));
if (page > pc && pc > 0)
{
//psql.AbsolutePage = page = 1;
EchoFailJson("page>pagecount");
return;
}
string qsql = psql.GetQueryString();
var datalist = db.GetDataList(qsql, query);
if (datalist == null)
{
EchoFailJson("error data is null");
return;
}
var data = new
{
code = 0,
status = "succ",
count = rc,
page = page,
pagesize = pagesize,
pagecount = pc,
data = datalist
};
string json = JsonConvert.SerializeObject(data);
Response.Write(json);
}
