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));
}
