public List <AppApi> GetByAppId(int appId)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["connectStr"];
string conStr = SysInfoManage.DENString(settings.ConnectionString);
using (ULinker.Common.DB.DBHelper db = new Common.DB.DBHelper(conStr))
{
List <AppApi> list = new List <AppApi>();
try
{
string strCmd = @" SELECT * FROM `appapi` WHERE `AppId`=@AppId";
DataTable dt = db.GetDataSet(strCmd);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
AppApi item = RowToObject(row);
list.Add(item);
}
}
}
catch (Exception ex)
{
Log4Helper.Error(this.GetType(), String.Format("AppApiDao.GetAll.{0}", ex.Message), new Exception("error"));
}
return(list);
}
}
public async Task Setup()
{
if (TestConfig.IsReportingEnabled)
{
await ReportManager.CreateTestAsync().ConfigureAwait(false);
}
CurrentTenant = TenantTitle.upload1;
CurrentUser = TestConfig.AdminUser;
await BackgroundTaskApi.DeleteAllTasksAsync(TestConfig.AdminUser).ConfigureAwait(false);
AppApi.DeleteApps(true,
new[]
{
AppTitle.Haribo,
AppTitle.ComposerHq1,
AppTitle.ComposerHq2,
AppTitle.SapPorsche,
AppTitle.Player
},
TenantTitle.upload1);
AppApi.DeleteApps(true,
new[] { AppTitle.Haribo, AppTitle.ComposerHq1, AppTitle.ComposerHq2 }, TenantTitle.upload2);
// page ready without "upload spinner" element check
IsUseAllPageReadyChecks = false;
}
public bool Create(AppApi model)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["connectStr"];
string conStr = SysInfoManage.DENString(settings.ConnectionString);
using (ULinker.Common.DB.DBHelper db = new Common.DB.DBHelper(conStr))
{
try
{
string strCmd = @"INSERT INTO `appapi` (`AppId`,`ApiId`,`IsUse`,`CreateTime`,`ModifyTime`)
VALUES(@AppId,@ApiId,@IsUse,NOW(),NOW())";
MySqlParameter[] paramters = new MySqlParameter[]
{
new MySqlParameter("@AppId", MySqlDbType.Int32),
new MySqlParameter("@ApiId", MySqlDbType.Int32),
new MySqlParameter("@IsUse", MySqlDbType.Binary)
};
paramters[0].Value = model.Id;
paramters[1].Value = model.Description;
paramters[2].Value = model.IsUse;
int count = db.ExecuteNonQuery(strCmd, paramters);
return(count > 0 ? true : false);
}
catch (Exception ex)
{
Log4Helper.Error(this.GetType(), String.Format("AppApiDao.Create.{0}", ex.Message), new Exception("error"));
return(false);
}
}
}
/// <summary>
/// 查询用户钱包
/// </summary>
/// <param name="param">请求的参数</param>
/// <returns>请求结果</returns>
public object MB(HttpContext context)
{
string Account = context.Request.Form["account"];
string B = context.Request.Form["b"];
return(new AjaxResult(B + "余额=" + AppApi.MB(Account, B)));
}
public JsonResult GetSubDepartment(string id, string departlist)
{
string accessToken = WeChatCommonService.GetWeiXinToken(AppId);
//修改Department数据源 先根据AppId获取应用信息 allowPartys Pending
var config = WeChatCommonService.GetWeChatConfigByID(AppId);
var app = AppApi.GetAppInfo(accessToken, int.Parse(config.WeixinAppId));
GetAppInfo_AllowPartys allowPartys = app.allow_partys;
// TODO: async/await执行较长等待的task
var subdepartList = MailListApi.GetDepartmentList(accessToken, Int32.Parse(id)).department;//.Where(x => allowPartys.partyid.Contains(x.id)).ToList()
var listReturn = EasyUITreeData.GetTreeData(subdepartList, "id", "name", "parentid");
listReturn.ForEach(a =>
{
a.state = "closed";
});
if (!string.IsNullOrEmpty(departlist))
{
var departids = departlist.Split('|');
EasyUITreeData.SetChecked <string>(departids.ToList(), listReturn);
}
return(Json(listReturn, JsonRequestBehavior.AllowGet));
}
private async UniTask LoadPlayerData()
{
var userHash = PlayerPrefs.GetString(UserData.USER_HASH_KEY);
RunTimeData.PlayerData = await AppApi.GetUserData(userHash);
SceneLoadManager.Instance.LoadScene(Scenes.Home);
}
public void GetAppInfoTest()
{
var accessToken = AccessTokenContainer.GetToken(_corpId);
var result = AppApi.GetAppInfo(accessToken, 2);
Assert.IsNotNull(result.agentid);
Assert.AreEqual(result.agentid, "2");
}
/// <summary>
/// 找回密码
/// </summary>
/// <param name="account">会员帐号</param>
/// <param name="pwd">会员密码</param>
/// <param name="identifyingCode">注册验证码</param>
/// <param name="type">密码类型 2-登录 3=支付</param>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">结果提示</para>
/// <remarks>
/// 2017-08-18 林建生
/// </remarks>
public ActionResult RetrievePWD(string account, string pwd, string identifyingCode, string type)
{
if (string.IsNullOrEmpty(account) || string.IsNullOrEmpty(pwd) || string.IsNullOrEmpty(identifyingCode))
{
return(View());
}
else
{
if (account.Length == 11 && account.Substring(0, 1) == "1" && pwd.Length > 5)
{
using (EFDB db = new EFDB())
{
//判断该手机号十分钟之内是否有验证码
var sms = db.SMS.Where(l => l.PhoneNumber == account && l.Content == identifyingCode).OrderByDescending(l => l.AddTime).FirstOrDefault();
if (sms != null)
{
TimeSpan ts = DateTime.Now - sms.AddTime;
if (ts.TotalMinutes <= 10)
{
string pwdMD5 = MD5.GetMD5ljsheng(pwd);
var b = db.Member.Where(l => l.Account == account).FirstOrDefault();
if (type == "3")
{
b.PayPWD = pwdMD5;
}
else
{
b.PWD = pwdMD5;
}
b.LoginIdentifier = LCommon.TimeToUNIX(DateTime.Now);
if (db.SaveChanges() == 1)
{
LCookie.DelALLCookie();
AppApi.PWD(account, pwd, type);
return(Helper.Redirect("成功！", "/Home/Login", "修改密码成功,请点确定重新登录!"));
}
else
{
return(Helper.Redirect("失败！", "history.go(-1);", "帐号不存在,点确定返回重新修改!"));
}
}
else
{
return(Helper.Redirect("失败！", "history.go(-1);", "验证码已失效,请重新获取"));
}
}
else
{
return(Helper.Redirect("失败！", "history.go(-1);", "短信验证码错误"));
}
}
}
else
{
return(Helper.Redirect("失败！", "history.go(-1);", "必须是11位的手机号,密码最少需要6位"));
}
}
}
/// <summary>
/// 建议走缓存
/// </summary>
/// <param name="iAppID"></param>
/// <returns></returns>
public static GetAppInfoResult GetAppInfo(int iWeChatID)
{
var objConfig = GetWeChatConfigByID(iWeChatID);
string strToken = AccessTokenContainer.TryGetToken(objConfig.WeixinCorpId, objConfig.WeixinCorpSecret);
return(AppApi.GetAppInfo(strToken, int.Parse(objConfig.WeixinAppId)));
// Ret.allow_userinfos
}
public static GetAppInfoResult GetUserOrDept(int iAppID)
{
var objConfig = WeChatCommonService.GetWeChatConfig(iAppID);
string strToken = AccessTokenContainer.TryGetToken(objConfig.WeixinCorpId, objConfig.WeixinCorpSecret);
return(AppApi.GetAppInfo(strToken, iAppID));
// Ret.allow_userinfos
}
public async Task EndFixtureTests()
{
if (TestContext.Parameters.Count == 0)
{
PlaceApi.DeletePlaces();
AppApi.DeleteApps();
ItemApi.DeleteItems();
}
await _mm.InboxHousekeepingAsync(_mm.ClientCxM).ContinueWith(task => _mm.Dispose());
}
public virtual void PrepareEditData()
{
string accessToken = WeChatCommonService.GetWeiXinToken(AppId);
//修改tag数据源 先根据AppId获取应用信息 allowTag Pending
var app = AppApi.GetAppInfo(accessToken, AppId);
GetAppInfo_AllowTags allowTags = app.allow_tags;
var tagList = MailListApi.GetTagList(accessToken).taglist;//.Where(x=> allowTags.tagid.Contains(int.Parse(x.tagid))).ToList()
ViewBag.taglist = tagList;
}
public void EndFixtureTests()
{
if (IsEachFixtureInNewBrowser)
{
ClosePrimaryBrowser();
}
if (TestContext.Parameters.Count == 0)
{
AppApi.DeleteApps();
}
}
private async UniTask <List <UserData> > GetUserData()
{
var list = await AppApi.GetRankUserData();
foreach (var d in list)
{
Debug.Log($"Name:{d.Name} 最大勝利数:{d.MaxClearCount}");
}
return(list);
}
public void EndFixtureTests()
{
if (IsEachFixtureInNewBrowser)
{
ClosePrimaryBrowser();
}
if (TestContext.Parameters.Count == 0)
{
AppApi.DeleteApps();
PlaceApi.DeletePlaces(PlaceType.NoType);
PlaceApi.DeletePlaces(PlaceType.Ibeacon);
}
}
public void EndFixtureTests()
{
IsUseAllPageReadyChecks = true; // use normal set of page readiness checks
if (IsEachFixtureInNewBrowser)
{
ClosePrimaryBrowser();
}
if (TestContext.Parameters.Count == 0)
{
PlaceApi.DeletePlaces();
AppApi.DeleteApps();
ItemApi.DeleteItems();
}
}
/// <summary>
/// 设置企业号应用
/// </summary>
/// <param name="data"></param>
//[AllowAnonymous]
//[HttpPost]
public ActionResult SetAppInfo(SetAppPostData data, string Id)
{
//更新SysWechatConfig数据库
//验证错误
if (!BeforeAddOrUpdate(data, Id) || !ModelState.IsValid)
{
return(Json(GetErrorJson(), JsonRequestBehavior.AllowGet));
}
var objModel = sys.Repository.GetByKey(int.Parse(Request["ConfigID"]));
objModel.WeixinCorpId = Request["CorpID"];
objModel.WeixinCorpSecret = Request["Secret"];
objModel.WelcomeMessage = Request["Welcome"];
sys.Repository.Update(objModel, new List <string>()
{
"WeixinCorpId", "WeixinCorpSecret", "WelcomeMessage"
});
var strToken = rtntoken(int.Parse(data.agentid));
if (!string.IsNullOrEmpty(Request["MediaID"]))
{
data.logo_mediaid = Request["MediaID"];
}
if (string.IsNullOrEmpty(data.redirect_domain))
{
data.redirect_domain = string.Empty;
}
AppApi.SetApp(strToken, data);
//清理缓存
if (WeChatCommonService.lstDepartment != null)
{
cacheManager.Remove("DepartmentList");
}
if (WeChatCommonService.lstTag != null)
{
cacheManager.Remove("TagItem");
}
if (WeChatCommonService.lstUser != null)
{
cacheManager.Remove("UserItem");
}
if (CommonService.lstSysWeChatConfig != null)
{
cacheManager.Remove("SysWeChatConfig");
}
return(Json(doJson(null)));
}
private async UniTask Settlement(bool isWin)
{
if (isWin)
{
RunTimeData.PlayerData.WinCount++;
Debug.Log("勝ち");
}
else
{
RunTimeData.PlayerData.LoseCount++;
}
await AppApi.SaveUserData(RunTimeData.PlayerData);
}
///// <summary>
///// 获取所有App信息
///// </summary>
///// <param name="appid"></param>
///// <returns></returns>
public List <GetAppInfoResult> GetListInfo(int iPage, int iCount, ref int iTotal)
{
List <GetAppInfoResult> lst = new List <GetAppInfoResult>();
string aPPList = Request["APPList"];
var strToken = rtntoken();
//获取所有app
//var applist = AppApi.GetAppList(strToken);
var corpId = CommonService.GetSysConfig("WeixinCorpId", string.Empty);
var applist = CommonService.lstSysWeChatConfig.Where(a => a.WeixinCorpId == corpId).ToList();
GetAppInfoResult result = new GetAppInfoResult();
//获取所有app信息
if (string.IsNullOrEmpty(aPPList))
{
foreach (var rst in applist)
{
try
{
result = AppApi.GetAppInfo(strToken, int.Parse(rst.WeixinAppId));
}
catch
{
continue;
}
lst.Add(result);
}
}
else
{
try
{
result = AppApi.GetAppInfo(strToken, int.Parse(aPPList));
lst.Add(result);
}
catch
{
}
}
if (lst.Count != 0)
{
iTotal = lst.Count();
return(lst.OrderBy(a => int.Parse(a.agentid)).Skip((iPage - 1) * iCount).Take(iCount).ToList());
}
return(null);
}
private async UniTask SetUserData()
{
var userData = new UserData()
{
Name = _inputName.text,
};
var userHash = await AppApi.CreateUserData(userData);
var key = UserData.USER_HASH_KEY;
PlayerPrefs.SetString(key, userHash);
PlayerPrefs.Save();
RunTimeData.PlayerData = userData;
SceneLoadManager.Instance.LoadScene(Scenes.Game);
}
///// <summary>
///// 判断用户是否在APP的可见范围内
///// </summary>
///// <param name="appId"></param>
///// <param name="currentUserId"></param>
///// <param name="AccountManageID"></param>
///// <returns></returns>
//public bool IsValidateUser(string appId, string currentUserId, int AccountManageID)
//{
// if (HttpRuntime.Cache.Get("validateUsers") != null)
// {
// var obj = HttpRuntime.Cache.Get("validateUsers");
// List<String> allVisiblePerson = (List<String>)obj;
// return allVisiblePerson.Contains(currentUserId);
// }
// else
// {
// var appInfo = lstSysWeChatConfig.SingleOrDefault(a => a.AccountManageId == AccountManageID);
// var token = CommonApi.GetToken(appInfo.WeixinCorpId, appInfo.WeixinCorpSecret);
// var results = AppApi.GetAppInfo(token.access_token, Int32.Parse(appId));
// List<string> allVisiblePerson = new List<string>();
// foreach (var user in results.allow_userinfos.user)
// {
// allVisiblePerson.Add(user.userid);
// }
// foreach (var groupId in results.allow_partys.partyid)
// {
// var members = MailListApi.GetDepartmentMemberInfo(token.access_token, groupId, 1, 1);
// foreach (var user in members.userlist)
// {
// allVisiblePerson.Add(user.userid);
// }
// }
// HttpRuntime.Cache.Insert("validateUsers", allVisiblePerson, null, DateTime.Now.AddHours(2), TimeSpan.Zero);
// return allVisiblePerson.Contains(currentUserId);
// }
//}
/// <summary>
/// 判断用户是否在APP的可见范围内
/// </summary>
/// <param name="appId"></param>
/// <param name="objUser"></param>
/// <param name="AccountManageID"></param>
/// <returns></returns>
public static bool IsValidateUser(int appId, SysAddressBookMember objUser, int AccountManageID)
{
var AppInfo = cacheManager.Get <GetAppInfoResult>(string.Format("APP_{0}_{1}", AccountManageID, appId), () =>
{
Logger.Debug("cache is empty, creating cache....");
var appInfo = GetWeChatConfigByID(appId);
var token = CommonApi.GetToken(appInfo.WeixinCorpId, appInfo.WeixinCorpSecret);
var results = AppApi.GetAppInfo(token.access_token, int.Parse(appInfo.WeixinAppId));
return(results);
});
//部门
if (!string.IsNullOrWhiteSpace(objUser.Department))
{
string strParty = objUser.Department.Insert(objUser.Department.Length - 1, ",").Insert(1, ",");
if (AppInfo.allow_partys.partyid.Count(a => strParty.IndexOf("," + a.ToString() + ",") >= 0) > 0)
{
return(true);
}
var departments = lstDepartment(AccountManageID);
List <int> allDepartments = new List <int>();
FindAllParentDepartments(strParty, departments, allDepartments);
if (AppInfo.allow_partys.partyid.Any(a => allDepartments.Contains(a)))
{
return(true);
}
}
//tag
if (!string.IsNullOrWhiteSpace(objUser.TagList))
{
string strTag = objUser.TagList.Insert(objUser.TagList.Length - 1, ",").Insert(1, ",");
if (AppInfo.allow_tags.tagid.Count(a => strTag.IndexOf("," + a.ToString() + ",") >= 0) > 0)
{
return(true);
}
}
//user
if (AppInfo.allow_userinfos.user.Exists(a => objUser.UserId == a.userid))
{
return(true);
}
return(false);
}
public void GetAppInfoAsyncTest()
{
var finishedCount = 0;
{
Task.Factory.StartNew(async() =>
{
//使用AppKey测试
//常规AccessToken测试
var appKey = AccessTokenContainer.BuildingKey(_corpId, base._corpSecret);
var result = await AppApi.GetAppInfoAsync(appKey, 2);
Assert.IsNotNull(result.agentid);
Assert.AreEqual(result.agentid, "2");
Console.WriteLine("1.Ticket:" + DateTime.Now.Ticks);
Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(result));
finishedCount++;
});
while (finishedCount < 1)
{
}
}
{
Task.Factory.StartNew(async() =>
{
//常规AccessToken测试
var accessToken = AccessTokenContainer.GetToken(_corpId, base._corpSecret);
var result = await AppApi.GetAppInfoAsync(accessToken, 2);
Assert.IsNotNull(result.agentid);
Assert.AreEqual(result.agentid, "2");
Console.WriteLine("2.Ticket:" + DateTime.Now.Ticks);
Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(result));
finishedCount++;
});
while (finishedCount < 2)
{
}
}
}
/// <summary>
/// 获取企业号应用集合
/// </summary>
public List <GetAppInfoResult> GetCorpInfos()
{
var pList = new List <GetAppInfoResult>();
this.ExecuteTryCatch(() =>
{
//获取AccessToken
string strAccessToken = Senparc.Weixin.MP.CommonAPIs.WeiXinSDKExtension.GetCurrentAccessTokenQY();
WeiXinConfiguration.corpInfos.ForEach((pCorp) =>
{
var papps = AppApi.GetAppInfo(strAccessToken, pCorp.aid);
pList.Add(papps);
pCorp.aname = papps.name;
pCorp.round_logo_url = papps.round_logo_url;
});
});
return(pList);
}
public void SetAppTest()
{
var accessToken = AccessTokenContainer.GetToken(_corpId);
SetAppPostData date = new SetAppPostData()
{
agentid = "1",
description = "test",
isreportenter = 0,
isreportuser = 0,
logo_mediaid = "1muvdK7W8cjLfNqj0hWP89-CEhZNOVsktCE1JHSTSNpzTf7cGOXyDin_ozluwNZqi",
name = "Test",
redirect_domain = "www.weiweihi.com"
};
var result = AppApi.SetApp(accessToken, date);
Assert.AreEqual(result.errcode, ReturnCode_QY.请求成功);
}
/// <summary>
/// 获取应用详情
/// </summary>
/// <param name="QyID">企业ID</param>
/// <returns></returns>
public GetAppListResult GetAppList(string QyID)
{
GetAppListResult result = null;
try
{
result = AppApi.GetAppList(GetAccessToken(QyID));
}
catch (Exception ex)
{
LogWriter.Error(ex, string.Format("获取QyID为{0}的应用列表失败", QyID));
result = AppApi.GetAppList(GetAccessToken(QyID, true));
}
if (result.errcode != ReturnCode_QY.请求成功)
{
LogWriter.Info(string.Format("获取QyID为{0}的应用列表失败，原因：{1}", QyID, result.errmsg));
}
return(result);
}
public void SetAppTest()
{
var accessToken = AccessTokenContainer.GetToken(_corpId, base._corpSecret);
SetAppPostData date = new SetAppPostData()
{
agentid = "2",//"100" + DateTime.Now.ToString("yyMMddHHMM"),
report_location_flag = "1",
//logo_mediaid = "1muvdK7W8cjLfNqj0hWP89-CEhZNOVsktCE1JHSTSNpzTf7cGOXyDin_ozluwNZqi",
name = "单元测试添加" + DateTime.Now.ToString("yyMMddHHMM"),
description = "test",
redirect_domain = "https://sdk.weixin.senparc.com",
//isreportenter = 0,
isreportuser = 1,
home_url = "weixin.senparc.com"
};
var result = AppApi.SetApp(accessToken, date);
Assert.AreEqual(result.errcode, ReturnCode_Work.请求成功);
}
public async void Start()
{
Logger.OnWarningMessageUpdated("初期化中...");
Logger.Info("観測点情報を読み込んでいます。");
var points = MessagePackSerializer.Deserialize <ObservationPoint[]>(Properties.Resources.ShindoObsPoints, MessagePackSerializerOptions.Standard.WithCompression(MessagePackCompression.Lz4BlockArray));
WebApi = new WebApi()
{
Timeout = TimeSpan.FromSeconds(2)
};
AppApi = new AppApi(points)
{
Timeout = TimeSpan.FromSeconds(2)
};
Points = points;
Logger.Info("走時表を準備しています。");
TrTimeTableService.Initalize();
await TimerService.StartMainTimerAsync();
Logger.OnWarningMessageUpdated($"初回のデータ取得中です。しばらくお待ち下さい。");
}
public void GetAppInfoTest()
{
{
//使用AppKey测试
//常规AccessToken测试
var appKey = AccessTokenContainer.BuildingKey(_corpId, base._corpSecret);
var result = AppApi.GetAppInfo(appKey, 2);
Assert.IsNotNull(result.agentid);
Assert.AreEqual(result.agentid, "2");
Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
{
//常规AccessToken测试
var accessToken = AccessTokenContainer.GetToken(_corpId, base._corpSecret);
var result = AppApi.GetAppInfo(accessToken, 2);
Assert.IsNotNull(result.agentid);
Assert.AreEqual(result.agentid, "2");
Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(result));
}
}
/// <summary>
/// 重新向APP注册
/// </summary>
/// <param name="param">请求的参数</param>
/// <returns>请求结果</returns>
public object MR(HttpContext context)
{
using (EFDB db = new EFDB())
{
Guid Gid = Guid.Parse(context.Request["gid"]);
var b = db.Member.Where(l => l.Gid == Gid).FirstOrDefault();
if (AppApi.AppMR(b.RealName, "123456", "123456", b.Account, b.MID.ToString()))
{
b.APP = 2;
b.PWD = MD5.GetMD5ljsheng("123456");
b.PayPWD = MD5.GetMD5ljsheng("123456");
if (db.SaveChanges() == 1)
{
return(new AjaxResult("同步成功"));
}
else
{
return(new AjaxResult(300, "同步成功,本地更新数据失败!"));
}
}
return(new AjaxResult(300, "同步失败"));
}
}
protected WebAppApiWrapper(AppApi source, IServiceProvider sp)
: base(source)
{
User = new UserGroup
(
source.AddGroup
(
nameof(User),
ModifierCategoryName.Default,
ResourceAccess.AllowAuthenticated()
)
);
UserCache = new UserCacheGroup
(
source.AddGroup
(
nameof(UserCache),
ModifierCategoryName.Default,
ResourceAccess.AllowAuthenticated()
.WithAllowed(AppRoleName.ManageUserCache)
),
sp
);
}
