public static T SqlExecuteGet <T>(string procName, DynamicParameters parms, string outParamName, string connectionName)
{
using (SqlConnection connection = MsSqlMapperHepler.GetOpenConnection(connectionName))
{
var x = connection.Execute(procName, (object)parms, commandType: CommandType.Text, commandTimeout: commandTimeout);
return(parms.Get <T>("@" + outParamName));
}
}
public static U StoredProcInsertWithID <T, U>(string procName, DynamicParameters parms, string connectionName)
{
using (SqlConnection connection = MsSqlMapperHepler.GetOpenConnection(connectionName))
{
var x = connection.Execute(procName, (object)parms, commandType: CommandType.StoredProcedure, commandTimeout: commandTimeout);
return(parms.Get <U>("@ID"));
}
}
/// <summary>
/// 批量更新 zr
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entityList"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public static bool UpdateBatch <T>(IEnumerable <T> entityList, IDbTransaction transaction = null) where T : class
{
bool isOk = false;
foreach (T item in entityList)
{
MsSqlMapperHepler.Update(item, transaction);
}
isOk = true;
return(isOk);
}
/// <summary>
/// 获取角色id集合,逗号隔开
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public static string GetUserRoles(string userid)
{
List <string> aa = MsSqlMapperHepler.SqlWithParams <string>("select ROLE_Id from vw_AccountRole where staffid ='" + userid + "'", null, DBKeys.PRX);
return(string.Join(",", aa.ToArray()));;
}
