/// <summary>
/// 获取调用凭证
/// </summary>
/// <param name="appId"></param>
/// <returns></returns>
public static TokenInfo Get(string appId)
{
var token = new TokenInfo {
AppId = appId
};
token = AppConnectEntityProcedure.GetEntityInstanceFromCacheByExtendedId(token);
if (token == null || token.IsEmpty)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
token = SafeProcedure.ExecuteAndGetInstance <TokenInfo>(db, "dbo.Token_Get", parameterMapper =>
{
parameterMapper.AddWithValue("@AppId", appId);
},
BuildInfo);
if (token != null)
{
token.IsEmpty = false;
AppConnectEntityProcedure.SaveEntityInstanceToCache(token);
}
}
return(token);
}
/// <summary>
/// 根据Code获取二维码登录
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public static QrCodeLoginInfo GetByCode(string code)
{
var info = new QrCodeLoginInfo {
Code = code
};
info = AppConnectEntityProcedure.GetEntityInstanceFromCacheByExtendedId(info);
if (info == null || info.IsEmpty)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
info = SafeProcedure.ExecuteAndGetInstance <QrCodeLoginInfo>(db, "dbo.QrCodeLogin_GetByCode", parameterMapper =>
{
parameterMapper.AddWithValue("@Code", new Guid(code));
},
BuildInfo);
if (info != null)
{
info.IsEmpty = false;
AppConnectEntityProcedure.SaveEntityInstanceToCache(info);
}
}
return(info);
}
internal static MenuInfo Get(string menuId)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
return(SafeProcedure.ExecuteAndGetInstance <MenuInfo>(db, "dbo.Menu_Get", parameterMapper =>
{
parameterMapper.AddWithValue("@MenuId", menuId);
}, BuildInfo));
}
/// <summary>
/// 根据类型获取公共开放平台帐号
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
internal static AppAccountInfo GetPubilicByType(int type)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
return(SafeProcedure.ExecuteAndGetInstance <AppAccountInfo>(db, "dbo.AppAccount_GetPubilicByType", parameterMapper =>
{
parameterMapper.AddWithValue("@Type", type);
},
BuildInfo));
}
/// <summary>
/// 根据batchId获取回调信息
/// </summary>
/// <param name="batchId"></param>
/// <returns></returns>
public static CallbackContentInfo GetByBatchId(string batchId)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
return(SafeProcedure.ExecuteAndGetInstance <CallbackContentInfo>(db, "dbo.CallbackContent_GetByBatchId", parameterMapper =>
{
parameterMapper.AddWithValue("@BatchId", new Guid(batchId));
},
BuildInfo));
}
internal static TemplateMappingInfo Get(string appId, string templateIdShort)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
return(SafeProcedure.ExecuteAndGetInstance <TemplateMappingInfo>(db, "dbo.TemplateMapping_Get", parameterMapper =>
{
parameterMapper.AddWithValue("@AppId", appId);
parameterMapper.AddWithValue("@TemplateIdShort", templateIdShort);
}, BuildInfo));
}
internal static MessageInfo Get(int tenantId, int id)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
return(SafeProcedure.ExecuteAndGetInstance <MessageInfo>(db, "dbo.Message_Get", parameterMapper =>
{
parameterMapper.AddWithValue("@TenantId", tenantId);
parameterMapper.AddWithValue("@Id", id);
}, BuildInfo));
}
internal static AppAccountInfo GetByTag(int tenantId, string tag)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
return(SafeProcedure.ExecuteAndGetInstance <AppAccountInfo>(db, "dbo.AppAccount_GetByTag", parameterMapper =>
{
parameterMapper.AddWithValue("@TenantId", tenantId);
parameterMapper.AddWithValue("@Tag", tag);
},
BuildInfo));
}
/// <summary>
/// 根据OpenId获取用户
/// </summary>
/// <param name="appId"></param>
/// <param name="openId"></param>
/// <returns></returns>
internal static AppUserAccountInfo GetByOpenId(string appId, string openId)
{
var db = Database.GetDatabase(DatabaseName.UserSecurity);
return(SafeProcedure.ExecuteAndGetInstance <AppUserAccountInfo>(db, "dbo.AppUserAccount_GetByOpenId", parameterMapper =>
{
parameterMapper.AddWithValue("@AppId", appId);
parameterMapper.AddWithValue("@OpenId", openId);
},
BuildInfo));
}
/// <summary>
/// 根据Id获取用户账户
/// </summary>
/// <param name="tenantId"></param>
/// <param name="id"></param>
/// <returns></returns>
internal static AppUserAccountInfo GetById(int tenantId, int id)
{
var db = Database.GetDatabase(DatabaseName.UserSecurity);
return(SafeProcedure.ExecuteAndGetInstance <AppUserAccountInfo>(db, "dbo.AppUserAccount_GetById", parameterMapper =>
{
parameterMapper.AddWithValue("@TenantId", tenantId);
parameterMapper.AddWithValue("@Id", id);
},
BuildInfo));
}
public static UserInfo GetDimensionOrder(int ID)
{
Database db = Database.GetDatabase("test");
//UserInfo result = new UserInfo();
UserInfo result = SafeProcedure.ExecuteAndGetInstance
(db, "dbo.GetUserInfo",
parameters =>
{
parameters.AddWithValue("@ID", ID.ToString());
},
(IRecord record, UserInfo item) =>
{
item.ID = record.GetOrDefault <int>("ID", 0);
item.UserName = record.GetOrDefault <string>("Name", string.Empty);
item.Password = record.GetOrDefault <string>("Password", string.Empty);
});
return(result);
}
