public JsonResult doRegister(String mobile, String passowrd, String CompanyName) { var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"注册成功!\"}}"; giftcardEntities db = new giftcardEntities(); try { var u = db.Database.SqlQuery <t_user>("select * from t_user where mobile='" + mobile + "'").ToList(); var _message = ""; if (u.Count > 0) { _message = "手机号已存在!"; } var c = db.Database.SqlQuery <t_user>("select * from t_user where CompanyName='" + CompanyName + "'").ToList(); if (c.Count > 0) { _message = "公司已存在!"; } if (string.IsNullOrEmpty(_message)) { var isql = @"INSERT INTO t_user(username,password,mobile,registerdate,companyid,CompanyName) VALUES ('" + mobile + "', '" + MD5Encrypt(passowrd) + "', '" + mobile + "', '" + DateTime.Now.ToString("yyyy/MM/dd HH:mm") + "', null, '" + CompanyName + "');"; db.Database.ExecuteSqlCommand(isql); } else { result = "{\"response\": {\"issuccess\": \"0\",\"msg\": \"" + _message + "\"}}"; } }catch (Exception ex) { result = "{\"response\": {\"issuccess\": \"0\",\"msg\": \"" + ex.Message + "\"}}"; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public string getToken(string appcode) { string _kdt_id = ""; string _client_id = ""; string _client_secret = ""; giftcardEntities db = new giftcardEntities(); object[] obj = new object[1]; t_apps app = db.Database.SqlQuery <t_apps>("select * from t_apps where appcode='" + appcode + "'", obj).FirstOrDefaultAsync().Result; _kdt_id = app.kdt_id; _client_id = app.client_id; _client_secret = app.client_secret; if (System.Web.HttpContext.Current.Cache["AccessToken_" + _kdt_id] != null) { return((string)System.Web.HttpContext.Current.Cache["AccessToken_" + _kdt_id]); } else { string url = string.Format("https://open.youzan.com/oauth/token?client_id=" + _client_id + "&client_secret=" + _client_secret + "&grant_type=silent&kdt_id=" + _kdt_id); AccessToken curToken = AccessTokenRequest(url); if (curToken.access_token == null) { throw new Exception("token 获取异常!"); } var ms = Convert.ToDouble(curToken.expires_in) - 1000; System.Web.HttpContext.Current.Cache.Insert("AccessToken_" + _kdt_id, curToken.access_token, null, DateTime.Now.Add(System.TimeSpan.FromSeconds(ms)), System.TimeSpan.Zero); return(curToken.access_token); } }
public JsonResult cardinactive(String ids) { var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"禁用成功!\"}}"; string updatesql = "update giftcard set enabled=0 where id in (" + ids + ")and isused = 0"; giftcardEntities db = new giftcardEntities(); db.Database.ExecuteSqlCommand(updatesql); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult doAppLoad(String userid) { giftcardEntities db = new giftcardEntities(); var isql = @"select * from v_userapps where userid='" + userid + "'"; var apps = db.Database.SqlQuery <v_userapps>(isql).ToList(); var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"userapplist\":" + JsonConvert.SerializeObject(apps) + "}}"; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult doAppUpdate(String id, String AppName, String kdt_id, String client_id, String client_secret) { giftcardEntities db = new giftcardEntities(); var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"更新成功!\"}}"; var isql = @"update t_apps set client_id='" + client_id + "',client_secret='" + client_secret + "',kdt_id='" + kdt_id + "',appname='" + AppName + "' where id=" + id; db.Database.ExecuteSqlCommand(isql); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult getgiftcard(String PromoId) { string getsql = "select * from v_giftcard where PromoId='" + PromoId + "'"; giftcardEntities db = new giftcardEntities(); object[] obj = new object[1]; var cards = db.Database.SqlQuery <v_giftcard>(getsql, obj).ToList(); var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"giftcardlist\":" + JsonConvert.SerializeObject(cards) + "}}"; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult doAppDelete(String id) { giftcardEntities db = new giftcardEntities(); var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"更新成功!\"}}"; var isql = @"delete from t_user2app where appid='" + id + "'; " + "delete from t_apps where id='" + id + "';"; db.Database.ExecuteSqlCommand(isql); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult doAppCreate(String AppName, String kdt_id, String client_id, String client_secret) { var _guid = Guid.NewGuid().ToString().Replace("-", ""); giftcardEntities db = new giftcardEntities(); var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"创建成功!\"}}"; var isql = @"INSERT INTO t_apps(client_id,client_secret,kdt_id,appname,expireddate,status,appcode) VALUES ('" + client_id + "', '" + client_secret + "', '" + kdt_id + "','" + AppName + "', '" + DateTime.Now.AddMonths(3).ToString("yyyy/MM/dd") + " 23:59:59" + "', 'active', '" + _guid + "');"; db.Database.ExecuteSqlCommand(isql); var tp = db.Database.SqlQuery <t_apps>("select * from t_apps where appcode='" + _guid + "'").FirstOrDefault(); db.Database.ExecuteSqlCommand("insert into t_user2app(appid,userid) VALUES ('" + tp.id + "','" + CurrentUser.id + "')"); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult dologin(String mobile, String passowrd) { var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"注册成功!\"}}"; giftcardEntities db = new giftcardEntities(); var u = db.Database.SqlQuery <t_user>(@"select * from t_user where mobile='" + mobile + "' and " + " password='******'").ToList(); if (u.Count > 0) { CurrentUser = u[0]; } else { result = "{\"response\": {\"issuccess\": \"0\",\"msg\": \"用户名或密码错误!\"}}"; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GenerateGiftCode(String count, String amount, String expireddate, String forcompany, String PromoId, String jumpurl) { giftcardEntities db = new giftcardEntities(); object[] obj = new object[1]; //var cards = db.Database.SqlQuery<v_giftcard>(getsql, obj).ToList(); var result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\"}}"; var allcards = ""; try { for (int i = 0; i < Convert.ToInt32(count); i++) { string code = GetRandomString(12, true, false, false, false, ""); string insof = @"insert into giftcard(giftcardcode,amount,expireddate,forcompany,generatedate,PromoId,jumpurl) values({0},{1},{2},{3},{4},{5},{6}); "; insof = string.Format(insof, this.formatstring(code), this.formatstring(amount), this.formatstring(expireddate), this.formatstring(""), this.formatstring(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), this.formatstring(PromoId), this.formatstring(jumpurl) ); allcards += insof; } db.Database.ExecuteSqlCommand(allcards); } catch (Exception ex) { result = "{\"response\": {\"issuccess\": \"0\",\"msg\": \"" + ex.Message + "\"}}"; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetCustomer(string id) { giftcardEntities db = new giftcardEntities(); var app = db.Database.SqlQuery <t_apps>("select * from t_apps where appcode='" + id + "'").FirstOrDefault(); ViewBag.apphormurl = app.homeurl; Auth auth = new Token(getToken(id)); // Auth auth = new Sign("app_id", "app_secret"); YZClient yzClient = new DefaultYZClient(auth); Dictionary <string, object> dict = new System.Collections.Generic.Dictionary <string, object>(); dict.Add("page_no", 1); dict.Add("page_size", 50); var result = yzClient.Invoke("youzan.scrm.customer.search", "3.1.0", "POST", dict, null); JObject obj = (JObject)JsonConvert.DeserializeObject(result); string recordlist = ""; int total = Convert.ToInt32(((Newtonsoft.Json.Linq.JValue)obj["response"]["total"]).Value); recordlist = obj["response"]["record_list"].ToString().Replace("[", "").Replace("]", ""); int pagecount = total / 50 + 1; for (var i = 2; i <= pagecount; i++) { Dictionary <string, object> dict1 = new System.Collections.Generic.Dictionary <string, object>(); dict1.Add("page_no", i); dict1.Add("page_size", 50); string result1 = yzClient.Invoke("youzan.scrm.customer.search", "3.1.0", "POST", dict1, null); JObject obj1 = (JObject)JsonConvert.DeserializeObject(result1); recordlist += "," + obj1["response"]["record_list"].ToString().Replace("[", "").Replace("]", ""); } ViewBag.result = recordlist; var resultreturn = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"record_list\":[" + recordlist + "]}}"; return(Json(resultreturn, JsonRequestBehavior.AllowGet)); }
public JsonResult GetYouZanCards(string id) { giftcardEntities db = new giftcardEntities(); var app = db.Database.SqlQuery <t_apps>("select * from t_apps where appcode='" + id + "'").FirstOrDefault(); ViewBag.apphormurl = app.homeurl; Auth auth = new Token(getToken(id)); // Auth auth = new Sign("app_id", "app_secret"); YZClient yzClient = new DefaultYZClient(auth); Dictionary <string, object> dict; dict = new System.Collections.Generic.Dictionary <string, object>(); dict.Add("page_no", 1); dict.Add("page_size", 100); //dict.Add("status", "ON"); dict.Add("group_type", "PROMOCODE"); var result = yzClient.Invoke("youzan.ump.coupon.search", "3.0.0", "POST", dict, null); ViewBag.result = result; var result1 = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"giftcardlist\":" + result + "}}"; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult giftcardtake(String appcode, String openid, String mobile, String name, String cardcode) { string result = "{\"result\":\"failed\"}"; int _PROMOCODEid; string getsql = "select * from giftcard where giftcardcode = '" + cardcode + "'"; Auth auth = new Token(getToken(appcode)); // Auth auth = new Sign("app_id", "app_secret"); YZClient yzClient = new DefaultYZClient(auth); Dictionary <string, object> dict; giftcardEntities db = new giftcardEntities(); object[] obj = new object[1]; var cards = db.Database.SqlQuery <AllTrustUs.Data.giftcard>(getsql, obj).ToList(); if (cards.Count > 0) { if (cards[0].enabled == "0") { result = "{\"response\": {\"issuccess\": 0,\"msg\": \"该礼品卡暂不可用,请联系公司负责人!\"}}"; } else if (cards[0].isused == "1") { result = "{\"response\": {\"issuccess\": 0,\"msg\": \"该礼品卡已被领用,不能重复注册!\"}}"; } else { try { _PROMOCODEid = Convert.ToInt32(cards[0].PromoId); dict = new System.Collections.Generic.Dictionary <string, object>(); dict.Add("mobile", mobile); dict.Add("coupon_group_id", _PROMOCODEid); result = yzClient.Invoke("youzan.ump.coupon.take", "3.0.0", "POST", dict, null); InvokeResponse Response = JsonUtility.Deserialize <InvokeResponse>(result); if (Response.error_response == null && Response.response != null && Response.response.coupon_type == "PROMOCODE") { var updatecard = "update giftcard set isused='1',useddate='" + DateTime.Now.ToString("yyyy-MM-dd") + "',usedmobile='" + mobile + "',usedopenid='" + openid + "',usedname='" + name + "' where giftcardcode='" + cardcode.Replace("-", "") + "'"; db.Database.ExecuteSqlCommand(updatecard); //MySqlHelp.ExecuteNonQuery(updatecard); //string _sql="select jumpurl from giftcard where giftcardcode='" + cardcode.Replace("-", "") + "'"; //var returncards = db.Database.SqlQuery<giftcard>(_sql, obj).ToList(); result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"jumpurl\":\"" + cards[0].jumpurl + "\"}}"; } else { result = "{\"response\": {\"issuccess\": \"0\",\"msg\": \"" + Response.error_response.msg + "\"}}"; } } catch (Exception ex) { result = "{\"response\": {\"issuccess\": 0,\"msg\": \"" + ex.Message + "!\"}}"; } } } else { result = "{\"response\": {\"issuccess\": 0,\"msg\": \"礼品卷不存在,请验证礼品卷码是否填写正确!\"}}"; } return(Json(result, JsonRequestBehavior.AllowGet)); }