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